MySQL on 2 servers (mirroring)

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
visionmaster
Forum Contributor
Posts: 139
Joined: Wed Jul 14, 2004 4:06 am

MySQL on 2 servers (mirroring)

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

look into replication at mysql's site.. we've had a few threads about it here too...
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post 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... ;)
Post Reply