New public MySQL server

Alongside our website, ensembl provides direct access to our databases through our public MySQL server ensembldb.ensembl.org and as of today, we are pleased to announce the availability of a second MySQL mirror hosted on the east coast of the US. The new server is running on Amazon Cloud with the hostname

useastdb.ensembl.org

it can be directly direct accessed with the mysql client using port 5306 and username anonymous.
eg.

mysql -h useastdb.ensembl.org -u anonymous -P5306

It may also be accessed through our perl API with the following registry incantation:

use Bio::EnsEMBL::Registry;
my $registry = 'Bio::EnsEMBL::Registry';
$registry->load_registry_from_db( -host => 'useastdb.ensembl.org',
                                  -user => 'anonymous');

useastDB will provide the current ensembl release alongside the previous on a rolling basis. This means that useastdb is currently hosting release 63 with 62 databases only, this will then become release 64 with 63 databases after our next release. Our full set of older releases will continue to to be hosted on ensembldb.ensembl.org

We hope that our users enjoy the faster access to our data that this new MySQL mirror should provide.

4 thoughts on “New public MySQL server

  1. Pingback: New features in the Variant Effect Predictor | Ensembl Blog

  2. Pingback: Run a private Ensembl MySQL in the cloud | Ensembl Blog

  3. This server is about 4 times faster than the original for me! I had to modify the registry line to get it to work in my perl script, however (needed to specify the port change from 3306 to 5306):

    $registry->load_registry_from_db( -host => 'useastdb.ensembl.org',
    -user => 'anonymous',
    -port => 5306);

    • I’m glad to hear it’s so much faster for you Clint. The server is on the US east coast so you should get all the benefits of reduced latency.

      Stephen