…Master. To discover the difference between Master and Slave you can use excellent Maatkit tool though if you you just need to resync small single table…to process request; So you can do following instead: mysql> rename table rep to rep_maint; Query OK, 0 rows affected (0.01 sec) mysql> select * from…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…TABLES WITH READ LOCK actually waits for all statements to complete, even selects…Copy database to the slave database directory. 10) Start MySQL Server. Wait for it to perform recovery. 11) Use CHANGE MASTER TO to point slave to…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…table: $ mysql -e ‘select * from flexviews.binlog_consumer_status\G’ -uroot *************************** 1. row *************************** server_id: 999 master_log_file: binary_log.000001 master_log_size: 214652 exec_master…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…to maintain the consistency of your data is necessary to define the same Triggers in Master and Slave servers. Example: mysql> create trigger Copy…slave. Example: mysql> SELECT YEAR(CURDATE()) INTO @this_year; mysql…
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 6 Comments
…SELECT into this memory table for this to work. Be careful using data on the Slave in this case as table…tables using MySQLDump; Restart the MySQL As planned; Load Dumped tables; run SLAVE START; Remove skip-slave-start from config file. Be careful using it with MASTER-MASTER…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
… using Maatkit’s mk-table-checksum to check his slave data was indeed a fair copy of that of the master. mk-table-checksum –algorithm=BIT… audit table for changes to the Foo table. The trail is kept using two triggers on that table. select trigger_name, event_object_table, Event_Manipulation from…
