Have you looked at PBXSync (or HAAst) from Telium? (https://telium.io)
These products will sync MySQL, SQLite, plus files, directories, etc. intelligently. (Differentials only) between PBX’s, reload configurations on the fly, etc. No need roll logs or recover from a base in case they get too far out of sync. HAAst will also prevent synchronizing if a node is in poor health (to avoiding sync’ing in corrupted data). I’m not sure what you are building but this might help. Aside from this, avoid block based synchronization of databases (eg: DRBD) for the obvious reasons. There are Master-Master sync tools out there, but if you are trying to wrap some intelligence around that then you are basically building your own sync product. -Raj- From: asterisk-users [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Dovid Bender Sent: Tuesday, July 30, 2019 9:55 PM To: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users@lists.digium.com> Subject: [asterisk-users] Lightweight ODBC DB Hi, I am running several Asterisk boxes with realtime around the world. Does anyone have a recommendation for a "light" db that would work with Asterisk that would also allow replication between all sites (so if I add an entry to one box it will work with the rest)? TIA. Dovid
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users