| asterisk2billing.org http://forum.asterisk2billing.org/ |
|
| Multi master Database http://forum.asterisk2billing.org/viewtopic.php?f=33&t=10714 |
Page 1 of 1 |
| Author: | dazza76 [ Thu Jan 30, 2014 5:52 am ] |
| Post subject: | Multi master Database |
Is a2billing designed well enough to work in a MySQL multi master environment, i.e no keys that use a serial or auto increment. Cheers |
|
| Author: | jroper [ Thu Jan 30, 2014 9:38 am ] |
| Post subject: | Re: Multi master Database |
Hi We've done Master Master replication for customers with a great deal of success. Although A2Billing does use auto-increment in many tables, you can easily configure MySQL to put auto-increment odd numbers on one database, and even numbers on the other. We would advise that only one database is referred to, using the second as a backup, just in case for any reason the replication breaks, as it's difficult to re-combine the data when the databases are out of sync, but you can easily switch from one to the other should your main MySQL server fail. Joe |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|