… anything you find in standard async MySQL replication. It is my belief …if you have fc_master_slave disabled (which it is by default). …transactions, which translates into number of unique key lookups into the certification index…two global status variables you can check to see what flow control is…
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
… a significant performance overhead.1,2 MySQL allows us to set FOREIGN_KEY_CHECKS=0 to disable enforcement of RI when the overhead… = ‘LineItems’, COLUMN_NAME = ‘order_id’, ORDINAL_POSITION = 1, POSITION_IN_UNIQUE_CONSTRAINT = 1, REFERENCED_TABLE_SCHEMA = ‘ecommerce’, REFERENCED_TABLE_NAME = ‘Orders…
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
…| | C | +——————–+ 3 rows in set (0.00 sec) mysql> select count(*) from A; +———-+ | count(*) | +———-+ |…C` WRITE; /*!40000 ALTER TABLE `C` DISABLE KEYS */; /*!40000 ALTER TABLE `C`…FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; …
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…=”Master” OCF_CHECK_LEVEL=”1″ \ op monitor interval=”2s” role=”Slave” OCF_CHECK_LEVEL=”1″ …MySQL p_mysql \ meta master-max=”1″ master-node-max=”1″ clone-max=”3″ clone-node-max=”1″ notify=”true” globally-unique…no stonith devices defined so stonith is disable. At the end of the configuration, you…
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
… across your environment, while keeping in check that each server does not break …unique directories. Lastly, running your MySQL server from pre-built binaries does not prevent you from installing other MySQL…patches, need to alter MySQL‘s default behavior i.e. disabling and totally disallowing use …
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… fast way to load data (especially if you disable unique key checks and foreign key checks), I recommended against this. There are several problems… file in one chunk: time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local…/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile…
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
… and copy it back in a binary form. MySQL Configuration Different storage engines have different settings which… as fast as possible as well, such as disabling indexes before the load and enabling them back -…. For Innodb SET UNIQUE_CHECKS=0 may be used to speed up load to tables with unique keys. So …
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…: [1] When you setup MySQL replication, you define the global variable server_id, this value must be unique for each host. In… work. Example on MMM: 1. check the mmm mode and put it to passive to disable any automatic failover during the process… been executed) and slave is restarted on mysql 1 Note: you can also check all the statements that were in the loop…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…mysql> SHOW PROFILE; +——————————+———–+ | Status | Duration | +——————————+———–+ | starting | 0.000054 | | checking permissions | 0.000004 | | checking…optimization disabled. OPTIMIZE …UNIQUE indexes in ALTER TABLE are ignored to enforce uniqueness…
