We have started to use Amazon Web Services (AWS) for a number of mini projects in the group. As part of this work we have created ChEMBL Amazon Machine Image (AMI), which we have decided to make publicly available. The ChEMBL AMI is based on the 64-bit Amazon Linux AMI, but additional comes installed with a MySQL server, which contains the ChEMBL_09 database. The benefit of making this available is that a user can have a MySQL instance up and running in a matter minutes and at almost no cost if the service is run on the AWS Free Usage Tier.
To create an instance based on the ChEMBL AMI, go through the following steps:
- Set up an AWS account (note you will need an existing Amazon account or credit card to do this).
- Login to the AWS Management Console
- Change Region to EU West (Ireland). Currently the ChEMBL AMI is only available to instances running in this region.
- Go to EC2 tab and click on Launch Instance button. The Create Instance Wizard should appear.
- On the CHOOSE AN AMI section select the Community AMIs tab and enter "chembl" in the search box. Only 1 public AMI should appear (ami-cf91a6bb), click the select button.
- On the INSTANCE DETAILS section, make sure you select Mirco instance type if you want to use the Free Usage Tier
- Proceed through CREATE KEY PAIR and CONFIGURE FIREWALL sections of the wizard and you are done
The MySQL instance will be up running and a user named chembluser (password:chembluser, we recommend you change this) has been setup with access to the chembl_09 database. So you should be able to connect to your MySQL database with the following command:
mysql -h xxxxxxxxxxxxxxxxx.compute.amazonaws.com -u chembluser -pchembluser chembl_09
(The command above assumes you have access to your instance on port 3306 from the ip range you are working from. This can be configured in the Security Groups section of the AWS Management Console).
If this proves to be a useful resource to the users of the ChEMBL data we will make publicly available AMIs for future ChEMBL database releases.