… work differently when replicating from an async master, for example like the one described on these two bugs. Galera use writesets to… if your async master can use ROW based binlog format as well to achieve better consistency, if you have an async master <= 5.0 though... the new cluster especially if you are planning to write on multiple nodes. Have PRIMARY KEYS If you still have tables…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… written in a row-based fashion instead of the actual statement which changed data, even when the global setting on the master is to write binary logs in statement mode. The row-based format does offer advantages particularly if…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…a temporary table on the master, inserted some rows into it, and dropped it: master > set autocommit=0; master > begin; master > create temporary table…row-based replication; I believe even row-based logging format is going to have some problems, because the CREATE TABLE is logged in statement format…
Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
February 2, 2012 By 1 Comment
…master/use test … master [localhost] {msandbox} (test) > SELECT @@binlog_format; +—————–+ | @@binlog_format | +—————–+ | ROW | +—————–+ 1 row in set (0.00 sec) master…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… basic requirements: MySQL 5.1+ row based logging (binlog_format=1) unique server_id in … *************************** 1. row *************************** server_id: 999 master_log_file: binary_log.000001 master_log_size: 214652 exec_master_…, and you want to track changes on all of them. You may have…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
…: Statement based – in which case these are write queries Row based – in this case these are changes to records, sort of row diffs if… replication formats, mostly because there’s very little that’s different when it comes to transporting the data changes. On the master So now let me start with what is happening on the master. For replication to work, first of all master needs…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… on the slave before INSERT… SELECT statement and possibly result in different data than on master. Locking rows … few other problems should be solved by row based replication. I’m however yet to give …no 180 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 30; hex …
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… execute the query on the master. This is because application of the changes on the master in parallel … if we get any significant stalls. My base run on DPE1 is as follows: root@dpe01:/etc…_method=xtrabackup wsrep_cluster_name=DPE binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_…
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 application… after committing the transaction and with the rows on the binary log. There are different solution…statements. Change the session value of binlog_format to STATEMENT just before the execution of…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…master_connect_retryblogpercona.commanual master_hostblogpercona.commanual master_info_fileblogpercona.commanual master_passwordblogpercona.commanual master_portblogpercona.commanual master_retry_countblogpercona.commanual master_sslblogpercona.commanual master_ssl_cablogpercona.commanual master…
