… the amazing MySQL manual, especially the option and variable …slave_event_countblogpercona.commanual Aborted_clientsblogpercona.commanual Aborted_connectsblogpercona.commanual allow_suspicious_udfsblogpercona.commanual ansiblogpercona.commanual auto_increment_incrementblogpercona.commanual auto…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… have MySQL 5.1 or aren’t using RBR, then it is possible to set up a dedicated MySQL slave which has log_slave_updates=1 and binlog_format=row to process SBR changes from a MySQL master. I… that you can enable auto_changelog=true in the config file to automatically record changes for any table, starting from the first…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
…your MySQL replication …slave, has 5 slaves connected, is not read_only Filters Binary logging MIXED Slave status 0 seconds behind, running, no errors Slave mode IDEMPOTENT Auto…started 2011-10-06T17:04:57) Replication Is a slave, has 2 slaves connected, is read_only Filters Binary logging MIXED Slave…
Post: Conflict Avoidance with auto_increment_increment and auto_increment_offset
January 12, 2011 By 1 Comment
…of people are running MySQL Master-Master replication pairs in Active-Passive mode for… me start by saying these options help to avoid some conflicts – if you have insert in table with auto_… slave and replication will get silently out of sync. So back of our topic of auto_increment_increment and auto…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… dropped. It’s not really transactional — it just doesn’t auto-commit the transaction. The ROLLBACK will produce a warning that…_Master_Log_File: mysql-bin.000006 Slave_IO_Running: No Slave_SQL_Running: No …… omitted ……… slave1 > start slave until master_log_file=’mysql-bin.000007′, master…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…expect realtime. The trick here is that when you start out, realtime is possible because your data is small…. key as (day, ad). Don’t use an auto-increment primary key, and don’t put ad first….either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the work on a slave, …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… the application. > 2. Not using auto_increment functionality This is right. With some… background. > Things are different with MySQL. Good design will help dictate … are making it to the slave(s). Like any other decision in…. With database growth it will however start > to crawl. > So developing you …
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…. It works well when all you want is to remove auto_increment or change ENUM values. When it comes to changes…. on db2: start replication mysql> START SLAVE; On step #1 MMM should have stopped db1 => db2 replication so at this stage we start it to… only good way to go. 6.1 on db1: start replication mysql> START SLAVE; db1 will receive the updates that were executed by changes…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… = /tmp/mysql.sock #tmpdir =/mysql_tmp/ # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock bind… # start replication for the first time (even unsuccessfully, for example # if you mistyped the password in master-password and the slave fails…_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…slave – there is a theoretical possiblity for race conditions (depending on application design). However, it is more solid than MySQL…test the code where slaves approve transactions for commit. Are auto_increment and other gotchas… keep the current design but when starting a select, a marker is …
