Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 1:55 pm
Predictive Dialer


All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Multi master Database
PostPosted: Thu Jan 30, 2014 5:52 am 
Offline

Joined: Tue Sep 05, 2006 4:58 am
Posts: 3
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


Top
 Profile  
 
 Post subject: Re: Multi master Database
PostPosted: Thu Jan 30, 2014 9:38 am 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 
Voice Broadcast System


All times are UTC


Who is online

Users browsing this forum: No registered users and 13 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group