… fixes only” mode with releases available for premium (Silver+) Support offerings. For MySQL Community users this means only releases within Active Life Cycle will be made. For example MySQL 4.1 had end of its Active… to note even though MySQL 5.0 successor (MySQL 5.1) is still not released as GA, MySQL 5.0 Active LifeCycle will end…
Post: Conflict Avoidance with auto_increment_increment and auto_increment_offset
January 12, 2011 By 2 Comments
A lot of people are running MySQL Master-Master replication pairs in Active-Passive mode for purpose of high availabilities using MMM or… be more or less picky. In default, slave_exec_mode=STRICT mode replication will stop if row to be updated or deleted… addition to duplicate key errors, if you set slave_exec_mode=IDEMPOTENT both duplicate key error and row not found errors…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
The MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL for scale out. Most of… load balancing without worrying about TTL and similar things. If Active server fails in the pair both its READER and WRITER…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… the AHI Lock the page in exclusive mode Remove all entries in the AHI pointing … –oltp-table-size=20000000 –mysql-table-engine=innodb –mysql-socket=/tmp/mysql_sandbox5524.sock –mysql-db=test –oltp-table-…that the server represents one that is in active use. The buffer pool was filled up …
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… deal with deadlocks or learn isolation modes. Perfect solution for absolute beginner. Now from queries design MySQL would support a lot of… the team. In many MySQL Projects there are not even dedicated MySQL people and Web developers simply use MySQL as they fit suitable… more interesting development I expect we might see is more active use of remote storage services. Amazon has S3 service which…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 24 Comments
…all replicas have also committed successfully. In MySQL‘s semi-synchronous replication, the commit completes…, the effect is that the client’s activity is throttled so that it cannot outpace… and everything defaults back to the traditional mode of replication. What does semi-synchronous replication…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…], and the difference is the doublewrite area. Doublewrite activity actually adds significant I/O activity. Basically, it doubles the amount of writes… Server based on 5.5.8 and ran it in MySQL mode (that is, using adaptive_flushing from InnoDB and with the… NOTPM. The throughput is about 1.33x better than in “MySQL compatible mode“, though it requires 10500MB for checkpoint age; that is…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… active masters) you should review your setup and this method won’t work. Example on MMM: 1. check the mmm mode and… the replication on the active master (server 1): mysql> stop slave; Step 2: there are writes on the active master, the loop statements… slave position on the active master (mysql 1) is changed to the position returned by SHOW MASTER STATUS on mysql 4 (this position…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… 72C, ACTIVE 755 sec 4 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 1 MySQL thread id…_CLUST_INDEX` of table `test`.`t` trx id 72C lock_mode X locks rec but not gap RECORD LOCKS space id…/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation level so it…
Post: When does Innodb Start Transaction ?
January 11, 2011 By 9 Comments
… transaction is started: —TRANSACTION F56AED, ACTIVE 4 sec, process no 23727, OS thread id 139753656395520 MySQL thread id 112, query id 411… If you’re running in AUTOCOMMIT=0 mode the same logic will apply – setting this mode will NOT start transaction however reading… creation – having transaction open is costly, especially in repeatable-read mode as it will require innodb not to purge any old…
