…to maintain. If you know you’ll get there, it can change the lifecycle of your application in advance. What about partitioning in MySQL… to think about how to avoid enormous tables that are hard to …in MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to the master…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…to be sure. In Innodb besides scalability changes in…in a tolerable time? PZ: Indeed using master-master setup and switching roles is a good way to get large data manageable. MySQL Master Master…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… enabled. Instead we need to know in which GTID is the master and set it on the slave. MySQL keeps two global variables …: slave1 > CHANGE MASTER TO MASTER_HOST=”127.0.0.1″, MASTER_USER=”msandbox”, MASTER_PASSWORD=”msandbox”, MASTER_PORT=18675, MASTER_AUTO_POSITION = 1; How to restore a slave in a …
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…how to make MySQL replication reliable, part of which is to eliminate temporary tables. The idea is this: if a slave…master > call test_temp(); master > select * from test.ins; +——+ | a | +——+ | 1 | +——+ Good. Let’s see what’s in the binary log: master > show binlog events in ‘mysql…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…Changing Slave Role Changing Slave role, such as swapping active and passive masters in Master-Master setup is often cause of the problem for similar reason as MySQL…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…to changes that really require table to be rebuilt – adding/dropping columns or indexes, changing data type, converting data to different character set – MySQL master-master…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… description of FlexCDC, the change data capture tool included with Flexviews. It continues with an overview of how to install and run FlexCDC… dedicated MySQL slave which has log_slave_updates=1 and binlog_format=row to process SBR changes from a MySQL master. I’ll talk more about that in…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 5 Comments
… and how MongoDB solves it. If you’re using MySQL Replication when your master goes down it is possible for some writes to be… master. When Master comes back up it has some updates done to it which cause it to be inconsistent with data on the new Master. In MySQL world we can chose to either ignore this problem (or may be even replay those changes on slaves and hope…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 7 Comments
… is consistent across the master and the slave with pt-table-checksum. Capture…in general how each fingerprint performs on the test servers. About 10% variation is tolerable and can be accounted for other MySQL…still no alternative to doing your research for incompatibilities, changes and bug fixes …
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 2 Comments
…mysql_slave > STOP SLAVE; mysql_slave > CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=1; mysql_slave > START SLAVE; MASTER_HEATBEAT_PERIOD is a value in seconds in the range between 0 to 4294967 with resolution in…
