…100% in sync, so MySQL doesn’t know anything is wrong. This isn’t the case with row-based replication. Only actual changes are… +———-+ | count(*) | +———-+ | 65536 | +———-+ 1 row in set (0.02 sec) My test setup includes a MySQL slave. After the above setup completes, I am going…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
…mysql> create trigger Copy_data AFTER INSERT on t FOR EACH ROW INSERT INTO t_copy VALUE(NEW.i); mysql…server/+bug/860910. In a master-master setup a master can show a wrong ‘SHOW…with statement based replication. Knowing in advances how MySQL works internally can help us to improve our replication …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…Solr only the rows that change. Feed third party replication systems. Provide …rows have changed. Because of this, FlexCDC requires that you use row-based binary logs (RBR). If you don’t have MySQL…setup_flexcdc.php –ini consumer.ini $ php setup_flexcdc.php setup starting setup completed If the setup…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…MySQL asynchronous replication. edit: PXC is really a bit like semi-synchronous replication…replicating vs SBR replication? RBR is faster than statement based, correct? A: Often that’s true, Row-Based Replication (RBR) can be faster than Statement-Based Replication… a Dual-Master Setup.” I encourage …
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
… this is NOT a HOWTO setup replication, but rather a howstuffworks type of thing. Replication events I say replication events in this article because… MySQL manual here. Put simply, the events can be one of two types: Statement based – in which case these are write queries Row based…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…output of hostname command. Based on that, for the…not permitted) at galera/src/replicator_str.cpp:prepare_for…rows affected (0.00 sec) Populate the table with data for the benchmark. # sysbench –test=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql…. However in the setup described in this post…
Post: read_buffer_size can break your replication
June 6, 2012 By 12 Comments
…replication. The setup is a master-master replication with the following values: max_allowed_packet = 32M read_buffer_size = 100M To break the replication… t; Query OK, 4510080 rows affected (26.89 sec… the data blocks are based on the read_…break your replication while importing data to MySQL. This …
Comment: Percona XtraDB Cluster Feature 1: High Availability
January 18, 2012 By 20 Comments
… could not scale this workload on a traditional master-slave setup, because there are no read-only transactions. However you can… because also writes compose of MySQL level tasks like sql parsing, optimization and such, whereas the row based replication events are cheap and consist…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… application can see any stale reads. My setup is 3 Percona XtraDB Cluster nodes talking … fully synchronous replication behavior: mysql> set global wsrep_causal_reads=1; Query OK, 0 rows affected (0.00… significant stalls. My base run on DPE1 is as follows: root@dpe01:/etc/mysql# sysbench –test=oltp…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
…. I tested against the following setups: Control The control environment was …created a table, inserted about 10 rows, and calculated an average time …based offers a much more realistic multi-datacenter system for high availability and disaster recovery than semi-synchronous replication in stock MySQL…
