Hi Jason,
Most other peoples responses are excellent as usual, however might I suggest
getting a copy of High Performance MySQL by Jeremy Zawodny (O'Reilly
publishers). This covers the exact scenario you are talking about.
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: Jason Williard [mailto:[EMAIL PROTECTED]
Sent: Saturday, 7 January 2006 9:32 AM
To: [email protected]
Subject: MySQL Replication
I am trying to understand exactly how replication works. So far, I see that
changes made on a master server are replicated to the slave server(s).
However, if a change is made on a slave server, is that replicated back to
the master as well as all other slaves?
I am asking this question as I try to develop a plan for more efficient web
servers. Here is what I am planning. Please let me know if this sounds
smart, or like a bad idea.
Server 1: Redhat MySQL Master
Servers 2 & 3: Load-Balanced Redhat Apache web servers w/MySQL Slaves
Servers 2 & 3 will be serving the same content and will need access to the
same data from the MySQL server(s). I am hoping that running MySQL on each
of the web servers will help to reduce the overall load on the servers.
----
Thank You,
Jason Williard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
