OS: Linux w PHP: 5.2.17 MySQL: 5.1.56 Time: 18:41 Members: 14202 Hits: 1793764 News: 281 WebLinks: 15
Replication Tips and Tricks in MySQL
Contributed by Chad Brandt
Wednesday, 28 July 2004
This is an informative article that looks at the lesser known aspects of MySQL replication, including filtering and log inspection
There are times when you'd rather not replicate all the data from a master to its slave(s). For instance, your master database server may contain test or pre-production databases and typically these databases, much like the /tmp directory on Linux, really don't need to survive after a disaster. Rather than wasting the bandwidth and disk space to replicate them, you can tell MySQL to simply ignore them. You can accomplish this by adding one or more configuration directives to the my.cnf file on the master.
Home 
