Tag Archives : replication

Purge MySQL Binary Logs periodically

Purge MySQL Binary Logs periodically

If you have binary logging enabled on your MySQL server (i.e. the log-bin parameter is set in the config file), then you may notice a bulk of large files in the MySQL data directory over time. Generally you only need to enable this binary logging if your server is acting as a relication master or if [...]
Tips for Rebuilding MySQL Replication

Tips for Rebuilding MySQL Replication

Let’s keep this post smart. It’s intended to help you rebuild a crashed MySQL replication. We assume that bin-log has been enabled at the master side. Basically what you need to do is to retrival a snapshot of your master database. It covers three types of information, a snapshot of your [...]
Repair MySQL Replication by SQL_SLAVE_SKIP_COUNTER

Repair MySQL Replication by SQL_SLAVE_SKIP_COUNTER

If you set up MySQL replication, you probably have ever faced this problem. there are invalid MySQL queries which cause the replication not to work anymore. Here I’ll explain how you can repair the replication on MySQL slave without rebuilding the whole repication environment. There are two steps [...]
© 2006-2010 Admon Home. All rights reserved.