<html><body><div style="color:#000; background-color:#fff; font-family:tahoma, new york, times, serif;font-size:12pt"><div><span>Yes, easiest method, doing realtime updates, is mysql replication. Now, theres two methods of doing this, first is using mysql's own replication method, and second is using MySQL::Replication as found on cpan. Brilliant perl based replication system.</span></div><div><br></div> <div style="font-family: tahoma, 'new york', times, serif; font-size: 12pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> otuoma peter <otuomathegreat@yahoo.com><br> <b><span style="font-weight: bold;">To:</span></b> "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> <br> <b><span style="font-weight: bold;">Sent:</span></b> Saturday, 11 May 2013 10:57 PM<br> <b><span style="font-weight:
bold;">Subject:</span></b> [Koha] How to update two koha databases in different servers.<br> </font> </div> <div class="y_msg_container"><br>I have two koha installations. One on a production server and another on a standby back-up server. Is there a way I can have all the changes made to the database on the production server also updated to the standby back-up server? I am thinking of doing it using an entry in a cronjob file that runs once everyday at night. If possible, I only need to import the updates.<br><br>Thanks in advance.<br>_______________________________________________<br>Koha mailing list <a href="http://koha-community.org/" target="_blank">http://koha-community.org</a><br><a ymailto="mailto:Koha@lists.katipo.co.nz" href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br><a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br><br><br></div>
</div> </div> </div></body></html>