>We purchased 2 new HP DL385 servers that will be used for MySQL 5 in a
replication environment.
Server 1 (Master) is connected gigabit to our Cisco 3550 core switch
The Cisco 3550 core switch is connected gigabit over fiber to a Cisco 3548
switch in another building.
Server 2 (Slave) is connected to the Cisco 3548 on a 100MB switched port.
My question is whether or not the 100MB connection is going to be good
enough to do replication, or if I have to invest in getting gigabit all the
way to the slave server?
So how much traffic in queries will the servers have? I can envision
a setup where replication by slow dialup modem is more than enough
(say, for the IP list of blocked mail servers). How up to date
must the slave be? There's a difference between my address book
(7 days for updates to take is not a big deal. I don't know if
anyone has implemented replication by postal service or carrier
pigeons, but it probably wouldn't be too slow.) and stock market
quotes (10 minutes delay may be a VERY big deal).
Replication tends to be more CPU-intensive than network-intensive.
If you update 10,000 rows, it doesn't send the 10,000 rows, it sends
the query that updated 10,000 rows (which is much shorter, but the
slave also has to go to the effort to figure out which 10,000 rows
need changing and how).
Gordon L. Burditt