What kind of traffic volume is generated with replication, our database has a pretty steady read/update volume throughout the day and its pretty much 50/50 read/write. I do plan to offload some of the reads (such as for daily reports and informational sites to the slave.
According to this, the network traffic over your replication path will be about half of the normal traffic to your master plus any duties you assigned to your slave. Think of it as every write to the master happening again to the slave, so if you have a 50/50 ratio then half of the traffic will be duplicated in the network.
In very high availability systems we typically use two networks. The first network provides access to services - this would be your current network. The second network (you were thinking of using a cross-over cable) would be used for administration and backups. Rather than using a cross-over cable for your replication, you should consider using a separate network that you can eventually build to all of your critical boxes. Plan to use this network for all of your admin, backup, and replication mechanisms.
that said, if your system is and will remain small, and if you currently could add half again as much traffic to your current network, then you will be fine to stay with the one network you have - just be sure you have a good switch in place (preferably only one) between your master and primary slave servers.
Hope this helps, _M
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
