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
MySQL on 2 servers (mirroring)
Moderator: General Moderators
-
visionmaster
- Forum Contributor
- Posts: 139
- Joined: Wed Jul 14, 2004 4:06 am
The introduction and following pages @ mysql.com are interesting to read, and should get you more up-to-date with various aspects of replication: http://dev.mysql.com/doc/mysql/en/Repli ... Intro.html
Personally, i have no direct experience with this, but I'll ask the sysops at work on how's and why's (if they have time to explain). They usually dont get to friendly, so don't expect anything tho... =/
Edit: To slow...
Personally, i have no direct experience with this, but I'll ask the sysops at work on how's and why's (if they have time to explain). They usually dont get to friendly, so don't expect anything tho... =/
Edit: To slow...