Page 1 of 1

MySQL on 2 servers (mirroring)

Posted: Tue Aug 03, 2004 4:08 pm
by visionmaster
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

Posted: Tue Aug 03, 2004 4:19 pm
by feyd
look into replication at mysql's site.. we've had a few threads about it here too...

Posted: Tue Aug 03, 2004 4:20 pm
by JAM
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... ;)