Hello, I am looking at MySQL as a possible upgrade to an in house system I am currently using.
I am interested in the replication functionality of MySQL. I would like to setup a master and two local slaves for offloading "select" commands as well as being able to stop one temporarily to perform backups. In addition, I would also like to setup a third slave in an offsite location using DSL to provide an offsite backup for disaster recovery purposes. I have read the Replication section of the MySQL manual and I think I have a basic understanding of how the replication is being handled, but one thing I am a bit concerned about on the two local servers is latency. A lot of our interactive GUI applications work in the following manner. A user clicks on a button to add some sort of entry. A screen pops up and the user enters the appropriate data and clicks on ok. At this point, the window is unloaded and the original screen the user was looking at requests an update from the server and refreshes the display. Assuming we are not using the delayed insert function if we execute the query against the master, the newly added item should be present on the refreshed screen. However, we would have no way of knowing if the slaves have been updated if my thinking is clear; would this be correct? If so, we would just have to write the server objects to query the master rather than a slave from interactive objects. But, is there any guideline for how long it may take for the local slaves to be updated? I am planning to run the servers on a Linux platform with dual 1.3ghz Pentium 3 processors. I plan to use a RAID0-1 setup on the master with 6 4GB hard drives. The slaves would be strictly a RAID0 with 3 4GB hard drives. Also, if anyone could recommend a good source for finding out about configurations that others have used for mission critical work I would appreciate it if you would share it with me. Thank You, Darrell --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
