…” \ no-quorum-policy=”ignore” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc… important setting is “log_slave_updates = OFF” (default value). In some cases, if slaves are logging replication updates, it may cause failover…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
Post: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
March 20, 2013 By 2 Comments
…. This led to a large increase in disk usage in cases when there are many small InnoDB tablespaces… corresponding to inaccessible datadir subdirectories to be ignored by XtraBackup without warning or error messages. … XtraBackup 2.0.6 for MySQL 5.6 are available in our online documentation. Bugs can …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… problems in INSERT IGNORE and ON DUPLICATE KEY UPDATE cases. Now In MySQL 5.1+ it is also possible to fix this problem for cases when number of rows in auto-increment… limit concurrency in many cases can be removed for READ-COMMITED isolation mode which will start offering more performance benefits in MySQL 5.1…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… into the database in a little meta-table. Then your script can figure out which files it can ignore. What… lifecycle of your application in advance. What about partitioning in MySQL 5.1? I know there are some cases when it can help… can save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the…
Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
September 9, 2012 By 9 Comments
…mysql_execute_command frame: (gdb) frame 21 #21 0x00000000005a30af in mysql…ignore))) 3137 { 3138 res= handle_select(thd, lex, sel_result, OPTION_SETUP_TABLES_DONE); 3139 /* 3140 Invalidate the table in…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they are, how to identify them… in case the replication of events with the current server_id didn’t fetch up. There is also the possibility to use IGNORE…] who helped me on the cases and to have reviewed this post. [1] http://dev.mysql.com/doc/refman/5.1/en…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…measuring scalability of the system as concurrency growths. In many cases however we’re facing a need to answer …or memory to store temporary table, but let us ignore them for a moment. The amount of resources …#15 here is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is …
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…over the years which could report different checksum in some cases. Rerunning check using BIT_XOR algorithm …MySQL to see what is different in the tables. It turned out one of the float columns stored “-0″ in MySQL… not the issue for application and could be ignored. So at this point we were sure the…
Post: Edge-case behavior of INSERT...ODKU
October 27, 2012 By 6 Comments
…in which they were defined, and the PRIMARY KEY is always going to be considered as being defined first. So, MySQL…, this isn’t the case. (root@localhost) [test]> select * from update_test; … all intents and purposes, ignored. For the customer whose…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 5 Comments
… inconsistent with data on the new Master. In MySQL world we can chose to either ignore this problem (or may be even replay… – it should be possible to apply the same concept to MySQL Replication, possibly with help of some tools like MMM. Row… Slave happened and they can be dumped to local file (in case one wants to synchronize them manually) and when fetched again…
