<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:SimSun;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:SimSun;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\@SimSun";
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="white" lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Thank you, Magali. That’s very helpful.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Kind regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Luke<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"> dev-bounces@ensembl.org [mailto:dev-bounces@ensembl.org]
<b>On Behalf Of </b>mag<br>
<b>Sent:</b> 15 March 2016 08:42<br>
<b>To:</b> dev@ensembl.org<br>
<b>Subject:</b> Re: [ensembl-dev] Load homo_sapiens_core_83_37 and homo_sapiens_core_83_38 databases on same sql server?<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi Luke,<br>
<br>
The registry can only deal with one core database for one species and release at a time.<br>
It currently does not distinguish based on the assembly.<br>
So if you use the API with the registry ($registry->load_registry_from_db), you will not be able to have two versions of the same species database.<br>
<br>
However, if you explicitly connect to one database, it is possible.<br>
For example:<br>
my $dba = Bio::EnsEMBL::DBSQL::DBAdaptor->new(<br>
-HOST => 'ensembldb.ensembl.org',<br>
-PORT => 3306,<br>
-USER => 'anonymous',<br>
-SPECIES => 'homo_sapiens_38',<br>
-DBNAME => 'homo_sapiens_core_84_38',<br>
-GROUP => 'core'<br>
);<br>
will create a database adaptor for the GRCh38 human database.<br>
and <br>
my $dba = Bio::EnsEMBL::DBSQL::DBAdaptor->new(<br>
-HOST => 'ensembldb.ensembl.org',<br>
-PORT => 3337,<br>
-USER => 'anonymous',<br>
-SPECIES => 'homo_sapiens_37',<br>
-DBNAME => 'homo_sapiens_core_84_37',<br>
-GROUP => 'core'<br>
);<br>
will create a database adaptor for the GRCh37 human database.<br>
You can then use both databases within the same code.<br>
<br>
Note here that I named the species homo_sapiens_38 and homo_sapiens_38, otherwise the new adaptor will supersed the old one.<br>
Similarly, if you also have a load_registry_from_db call in your code, this will have already loaded a human core database and that will be the one used by default.<br>
<br>
If you do not use the two databases within the same code, you can simply keep the homo_sapiens species alias, although again, without another load_registry_from_db call.<br>
<br>
<br>
Hope that helps,<br>
Magali<o:p></o:p></p>
<div>
<p class="MsoNormal">On 14/03/2016 20:46, Luke Goodsell wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<pre>Hi,<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Is it possible to load both the same releases of the GRCh37 and GRCh38 EnsEMBL databases on the same server and choose which assembly to use in the Perl API? We currently have them running on different mysqld instances, but this is undesirable.<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>I understand I could keep release n of 38 and release n-1 of 37, and load the corresponding perl modules, but this would quickly become a nightmare to maintain as new releases come out.<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Kind regards,<o:p></o:p></pre>
<pre>Luke<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
<p class="MsoNormal"><br>
<br>
<br>
<o:p></o:p></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Dev mailing list <a href="mailto:Dev@ensembl.org">Dev@ensembl.org</a><o:p></o:p></pre>
<pre>Posting guidelines and subscribe/unsubscribe info: <a href="http://lists.ensembl.org/mailman/listinfo/dev">http://lists.ensembl.org/mailman/listinfo/dev</a><o:p></o:p></pre>
<pre>Ensembl Blog: <a href="http://www.ensembl.info/">http://www.ensembl.info/</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>