Tag Archives : replication

MySQL: How Triggers act in Replication

MySQL: How Triggers act in Replication

Supposed you have a table that being updated by MySQL triggers and the DB is a master of replication, how do the triggers act in the environment? Here we might have a list of questions: Q1, Will the definition sql of the triggers be replicated? Q2, Will the data manipulation sqls triggered by triggers [...]
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-2012 Admon Home. All rights reserved.
Powered by Linode Japan