… see a lot of people filtering replication with binlog-do-db, binlog-ignore-db, replicate-do-db, and replicate-ignore-db. Although there are uses…> delete from garbage.junk; mysql> use garbage; mysql> update production.users set disabled = 1 where user = “root”; You just broke replication, twice…
Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
February 2, 2012 By 1 Comment
…replicated. [revin@forge rsandbox_5_5_170]$ ./master/use test … master [localhost] {msandbox} (test) > SELECT @@binlog_format; +—————–+ | @@binlog…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… and binlog-ignore-db commands. This is there a lot of people stop reading documentation, specify databases they want to replicate (or… the data. There is replicate-do-db and replicate-ignore-db options which closely mirror behavior of their binlog-do-* counterparts and which… way to break such replication is also using multi-table update or delete statements, if you happen to replicate one table or another…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… GA versions of MySQL 5.1 is ‘MIXED’ STATEMENT*; The binlog_format variable can still be changed per sessions which means… row-based replication. Only actual changes are written to the database with row-based logs. Take as an example a DELETE statement… DELETE will be written to a statement based binary log. Since row-based logs only contain information about changed rows, a replication…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…replicate_do_dbblogpercona.commanual replicate_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate_rewrite_dbblogpercona.commanual replicate_same_server_idblogpercona.commanual replicate…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…example. We’re running a typical master-slave replication with ROW based binary log file. The …0 62390272 26 /tmp/ML19sFCA (deleted) There are lot of files in deleted status that are filling the…binary log cache. binlog_cache_size and binlog_stmt_cache_size. Before 5.5.9 binlog_cache_size was…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… not using replication and have my binary log disabled ? If replication is not used you can enable innodb_locks_unsafe_for_binlog option… it makes locks unsafe fore replication and point in time recovery, so use innodb_locks_unsafe_for_binlog option with caution. Note… sec, process no 29895, OS thread id 2894768 updating or deleting mysql tables in use 1, locked 1 LOCK WAIT 3…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…-networking # Replication Master Server (default) # binary logging is required for replication log-bin=db1-bin log-bin-index=db1-bin.index binlog-ignore-db=chrome_vin binlog-ignore-db=dummyData #binlog-ignore-db=edmunds #binlog… the master.info file, unless you shutdown # the slave server, delete master.info and restart the slaver server. # For that reason…
Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
December 19, 2012 By Leave a Comment
…binlog is either in use or was not closed properly. ROLLBACK/*!*/; BINLOG ‘ NHUCUA8BAAAAZwAAAGsAAAABAAQANS41LjI1LWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAA …replicator_smm.cpp:apply_wscoll():49 at galera/src/replicator…, you can manually delete them. This was…
Comment: Recovering from a bad UPDATE statement
October 23, 2012 By 5 Comments
… fact that row based binlog stores the before image of a modified (deleted or updated) row in the binlog. However this will soon… new variable binlog_row_image: http://dev.mysql.com/doc/refman/5.6/en/replication-options-binary-log.html#sysvar_binlog_row_image When this is set to “minimal”, the binlog will only contain…
