…% in sync, so MySQL doesn’t know anything is wrong. This isn’t the case with row-based replication. Only actual changes are written to the database with row-based logs. Take as an…  65536 | +———-+ 1 row in set (0.02 sec) My test setup includes a MySQL slave. After the above setup completes, I am…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 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 11 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…
Comment: Percona XtraDB Cluster Feature 1: High Availability
January 18, 2012 By 18 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: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… 5.0 series compact row format was implemented which can…. This cache is DRAM based and so much faster than…size Q36: There have been several MySQL bugs opened about multi-core scalability…replication slave. Can you make the reorganization run in a tolerable time? PZ: Indeed using master-master setup…
Comment: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 16, 2009 By 16 Comments
…based increasing the dataset could/should decrease performance, however in my tests I went up to 6 million rows… part its as scalable or not as MySQL. Replication, sure… then? Sharding… if you plan for this…may not be the best solution for every setup, maybe its redis, or volemort, or cassandra, …
