Good day. Above matter refers. I would like to have a deployment architecture where I have two Koha servers running the same version of Koha and periodically, the warm backup server's MySQL server is synchronised with the primary server. I would appreciate how such a setup could be implemented. Kind regards, Admire Mutsikiwa +447361470772 linkedin.com/in/admire-mutsikiwa-9b187937 <https://www.linkedin.com/in/admire-mutsikiwa-9b187937/>
Hi Admire, I think one way to do it would be schedule a cron job that dumps and exports your database from server A to B. I wrote a bash script to migrate databases between MySQL/MariaDB servers that might help - it's available on GitHub at https://github.com/grandmaestr/koha-scripts. You'll need to modify it a bit to suit your use case but feel free to clone the repo. Best regards, Lennon Mazonde KohaSupport lennon@kohasupport.com www.kohasupport.com 651 North Broad Street, Middletown, DE 19709, USA The content of this email is confidential and intended for the recipient specified in message only. It is strictly forbidden to share any part of this message with any third party, without a written consent of the sender. If you received this message by mistake, please reply to this message and follow with its deletion, so that we can ensure such a mistake does not occur in the future. On 7/19/22 12:30 PM, Admire Mutsikiwa wrote: Good day. Above matter refers. I would like to have a deployment architecture where I have two Koha servers running the same version of Koha and periodically, the warm backup server's MySQL server is synchronised with the primary server. I would appreciate how such a setup could be implemented. Kind regards, Admire Mutsikiwa +447361470772 linkedin.com/in/admire-mutsikiwa-9b187937 <https://www.linkedin.com/in/admire-mutsikiwa-9b187937/> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi You can do this with mysql independently from koha. Mysql has the possibility to automatically synchronize db between two, or more, mysql instances. Just be sure to have both servers with the same MySql, OS and koha versions to avoid issues. Regards, Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le mar. 19 juil. 2022 à 05:31, Admire Mutsikiwa <amutsikiwa@gmail.com> a écrit :
Good day. Above matter refers. I would like to have a deployment architecture where I have two Koha servers running the same version of Koha and periodically, the warm backup server's MySQL server is synchronised with the primary server. I would appreciate how such a setup could be implemented.
Kind regards,
Admire Mutsikiwa +447361470772 linkedin.com/in/admire-mutsikiwa-9b187937 <https://www.linkedin.com/in/admire-mutsikiwa-9b187937/> _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Admire Mutsikiwa -
Alvaro Cornejo -
Lennon Mazonde