…replication, and remember that the execution is not serializable. PZ: Cool. This is one of little known new features in MySQL 5…Q18: Innodb Q: Is Group commit still busted in 5.0/5.1? HT: Yes. However, work has been …memory to disk) once every minute or two. This way we’d see a 3x performance boost …
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
…gcs.fc_limit = 256; gcs.fc_factor = 0.99; gcs.fc_master_slave = …on all 6 nodes across two datacenters in approximately the same amount…way to parallelize semi-synchronous replication (at least in 5.5), I could be missing something. PXC’s true parallel replication…synchronous replication in stock MySQL…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…5.0.xx, where xx >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5.0….“What is the good way to split memory between INNODB buffers…Mysql server for a client, upgrading their main database (from 16GB, 2 two…, maybe a replication slave. Can you make the reorganization run in a tolerable …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… 0.3 – 0…replication. In this case the cost of latency on commit will be 5 ms each time. Q: Can I change the replication…in PXC can be a master or a slave on asynchronous replication, galera and built-in mysql replication…in a 3 node cluster is synchronizing with the group, are the other two…this way (…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…replication, which is just like normal master-slave replication except that you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably the best general-purpose way…two…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
… have probably tune your schema in a way to reduce cross-node … Replication are two different ways of replicating data, from my experience, DRBD is more reliable than replication… your application servers and your MySQL servers? 2.9 Good point …patch to back port BKA to 5.0, it should not be rocket…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…replication…mysql> select sum(total_lines) from complete_example2 ; +——————+ | sum(total_lines) | +——————+ | 155186550 | +——————+ 1 row in set (0.68 sec) Conclusion Flexviews supports two…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…MySQL will fail to start on a micro instance, simply decrease the values in… 5.5.11 …two nodes. You should start two workers per core in…replication-delay=# innodb-rollback-on-timeout innodb-rollback-segments=16 innodb-stats-auto-update=0 innodb-stats-on-metadata=0…way you can verify the numbers in…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
…(31); Query OK, 1 row affected (0.00 sec) After running the … them in two different ways: 1- Change the ISOLATION level to READ COMMITTED. In this…repeatable reads) so in order to prevent problems with the replication you should …dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL …
Post: Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
…can be indistinguishable from one that’s at 5% of its capacity. So how can you tell…ways: One: watch for spikes of lag. If you have Cacti (and these Cacti templates for MySQL) you can see this in… 0 You can compare the BUSY_TIME to one-half the CONNECTED_TIME (because there are two replication threads…
