<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<div dir="ltr">Hi Eli -
<div>As a side note further to Melanie's answer -- </div>
<div><br>
</div>
<div>If your intention is to test production-ready code updates on a current copy of your production data -- our practice as a Data Coordinating Centre is to set up a (third) "staging" environment to do this, in addition to production and development environments. </div>
<div>Typically this staging environment is refreshed with a dump of the production database as often as needed/automated. We set up this 3-pronged system for most projects when we serve as DCC and can advise further. <br>
</div>
<div><br>
</div>
<div>Best, </div>
<div>Christine </div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Nov 5, 2019 at 9:11 AM Melanie Legault, Mrs <<a href="mailto:melanie.legault2@mcgill.ca">melanie.legault2@mcgill.ca</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Hello Eli,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
There is no need to create a new database dump from production every time you start a new project.
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
If you do all you development on your dev instance before porting to production and keep this dev instance to the same release of LORIS as your prod, both database instance should have the same schema.
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
It is also a good idea to test a new release of LORIS elsewhere than you production instance first to ensure there is no compatibility problem with your internal development before upgrading you production.
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
As long as database schema modification are eventually applied to both instance, there is no need to use a datadump to re-synchronize. Of course the data itself would be out of date but it is normally not a problem for a development instance.<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div id="gmail-m_-2098918927063361491Signature">
<div id="gmail-m_-2098918927063361491divtagdefaultwrapper" dir="ltr" style="font-size:12pt;color:rgb(0,0,0);font-family:Calibri,Helvetica,sans-serif">
<p style="margin-top:0px;margin-bottom:0px">M<span>é</span>lanie Legault <span style="color:rgb(255,0,0)">
|</span> Software developer <span style="color:rgb(255,0,0)">|</span> Faculty of Medicine<span style="color:rgb(255,0,0)"> |</span>
<span style="color:rgb(255,0,0)">McGill University </span> <br>
</p>
<div>3801 University, Montr<span id="gmail-m_-2098918927063361491ms-rterangepaste-start"></span><span>é</span><span id="gmail-m_-2098918927063361491ms-rterangepaste-end"></span>al, QC H3A 2B4 </div>
<br>
<p style="margin-top:0px;margin-bottom:0px"></p>
</div>
</div>
<div id="gmail-m_-2098918927063361491appendonsend"></div>
<hr style="display:inline-block;width:98%">
<div id="gmail-m_-2098918927063361491divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b>
<a href="mailto:loris-dev-bounces@bic.mni.mcgill.ca" target="_blank">loris-dev-bounces@bic.mni.mcgill.ca</a> <<a href="mailto:loris-dev-bounces@bic.mni.mcgill.ca" target="_blank">loris-dev-bounces@bic.mni.mcgill.ca</a>> on behalf of Eli Johnson <<a href="mailto:joh17964@umn.edu" target="_blank">joh17964@umn.edu</a>><br>
<b>Sent:</b> November 4, 2019 14:53<br>
<b>To:</b> loris dev <<a href="mailto:loris-dev@bic.mni.mcgill.ca" target="_blank">loris-dev@bic.mni.mcgill.ca</a>><br>
<b>Subject:</b> [Loris-dev] LORIS Development Database Set Up</font>
<div> </div>
</div>
<div>
<div dir="ltr">Hi all,
<div><br>
</div>
<div>We are setting up a development server and database for our instance of LORIS. I am looking for advice on how to best set up and maintain a development database that replicates our production database. From discussion with Dave and Leigh at McGill, it
sounds like we will want to clone our production database. This could be done via a mysqldump from the production database which is loaded into the development database. </div>
<div><br>
</div>
<div><b>Several specific questions</b>:</div>
<div>1. I imagine cloning the production database via mysqldump every time would take a bit of time with a larger database. Any advice on this process? Is mysqldump the best method or is there a recommended alternative method to do this? </div>
<div><br>
</div>
<div>2. Does anyone have scripts or tools they could share to help automate this process? <br>
</div>
<div><br>
</div>
<div>3. Will I need to completely clone the production database every time I want to update the development database or is there some way to update it incrementally? </div>
<div><br>
</div>
<div>Any additional advice on best practices for this are appreciated! <br>
</div>
<div><br>
</div>
<div>Thanks,</div>
<div>Eli</div>
<div>
<div><br clear="all">
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div><span style="font-size:12.8px">Eli Johnson</span><br>
</div>
Researcher<br>
Institute of Child Development<br>
University of Minnesota
<div><a href="mailto:joh17964@umn.edu" target="_blank">joh17964@umn.edu</a></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Loris-dev mailing list<br>
<a href="mailto:Loris-dev@bic.mni.mcgill.ca" target="_blank">Loris-dev@bic.mni.mcgill.ca</a><br>
<a href="https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev" rel="noreferrer" target="_blank">https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev</a><br>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div><br>
<a href="mailto:christine.rogers@mcgill.ca" target="_blank">christine.rogers@mcgill.ca</a><br>
McGill Centre for Integrative Neuroscience | MCIN.ca</div>
<div>Montreal Neurological Institute</div>
<div>McGill University | Montreal | Canada</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>