master slave config for mysql, have one master 2 slaves, and I would do all the querying from the slaves, and updates and web interaction with the master, that way u dont load the master server with all the queries.
Iqbal
Felipe Martins wrote:
Hi everybody,
In order to increase the security, performance, reliability and scalability of my VoIP Service I'm putting SER and Mysql at two separate Servers. I'm a kind of worried about my mysql server, because, if its comes to stop one day, none of my Users will connect. In order to solve this problem, I'm thinking of doing a Redundant MySQL DB Server. I'm not sure how am I going to do that. Has anyone done it already, that could share some information ? I'm trying to make all my 3 Sip Server use my Local Mysql DB Server Machine to auth, but another Mysql Server Machine to do the redudance.
Any help will be great
Best Regards Thanks in Advance