MySQL on 2 servers (mirroring)
Posted: Tue Aug 03, 2004 4:08 pm
Hello,
Our database should be mirrored on 2 webservers. Our call agents will use a webinterface which just queries server1. server2 is just there for pure user queries.
Since the database is the same, how do I replicate or mirror the mysql database to all of the servers?
How often can I replicate without slowing down the server?
How do I mirror anyway?
Any newbie links out there?
What do we need technically (hardware resources) and on the software side?
Thanks
Our database should be mirrored on 2 webservers. Our call agents will use a webinterface which just queries server1. server2 is just there for pure user queries.
Since the database is the same, how do I replicate or mirror the mysql database to all of the servers?
How often can I replicate without slowing down the server?
How do I mirror anyway?
Any newbie links out there?
What do we need technically (hardware resources) and on the software side?
Thanks