I am in the process of implementing a master - slave configuration. It is actually a fairly easy process to set up. We are doing the replication as part of a disaster recovery plan. In a worse case scenario we could restore the database on a slave machine and get back into production in no time. The bad news is that you are not actually updating the working tables on the slave. You are updating an ibdata file in MySQL. Here are some instructions I found that are very good and will take you step-by-step through the process: http://www.howtoforge.com/mysql_database_replication John ________________________________ From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of rekhasaraswat Sent: Tuesday, November 17, 2009 5:11 AM To: Koha@lists.katipo.co.nz Subject: [Koha] Fw: can i integrate two koha installation in master slaveconfiguration What i need is to have a central database and this is required to be updated by more than one client. Right now i m having a single administrator, who is able to update the catalog using KOHA. I want to create multiple administrator accounts for updating the KOHA catalog, working at different locations in my network or out of network. How can i do the required job for updating it from multiple koha clients. ----- Original Message ----- From: nitesh rijal <mailto:rijal.it@gmail.com> To: rekhasaraswat <mailto:rekhasaraswat@cdacnoida.in> Sent: Tuesday, November 17, 2009 5:34 PM Subject: Re: [Koha] can i integrate two koha installation in master slave configuration please be more clear..... 2009/11/17 rekhasaraswat <rekhasaraswat@cdacnoida.in> hi, i need to update the koha catalog from multiple locations in my network. for that purpose would it be possible to create a master slave configuration of two koha installaions _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Nitesh Rijal BE IT email: rijal.it@gmail.com url: http://niteshrijal.com.np facebook: http://facebook.com/openrijal twitter: http://twitter.com/openrijal +9779841458173 ________________________________ This inbound email has been scanned for malicious software and transmitted safely to you using Webroot Email Security. ________________________________ Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System. ______________________________________________________________________ Confidentiality Notice: This e-mail,including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review,use,disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. This email has been scanned using Webroot Email Security. ______________________________________________________________________