…: I did not research much yet, but I see that Galera strictly requires innodb_autoinc_lock_mode=2 and tries to… same areas. In fact you can see it from some Galera benchmarks.
Comment: State of the art: Galera - synchronous replication for InnoDB
October 29, 2009 By 15 Comments
… rather interesting question, but the answer is not so straightforward. Galera cluster performance overhead comes not only from group communication latencies… to extreme in a very synthetic mysqlslap benchmark here: http://www.codership.com/en/content/benchmarking-write-scalability. Curiously, one way to… yet. We don’t know of any benchmarks which can be used to benchmark performance of async master-slave cluster as a…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 11 Comments
… replication plugin for transactional applications. The Galera library is developed by Codership Oy company and Galera 2.x supports such new features… in 3 minutes Benchmarking Galera replication overhead Percona Server 5.5.15 + Galera 21.1-beta2 State of the art: Galera – synchronous replication for…
Post: Announcement of Percona XtraDB Cluster (alpha release)
January 9, 2012 By 30 Comments
… replication plugin for transactional applications. The Galera library is developed by Codership Oy company and Galera 2.x supports such new features… on this topic: Benchmarking Galera replication overhead Percona Server 5.5.15 + Galera 21.1-beta2 State of the art: Galera – synchronous replication for…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… mode 2 was chosen as it was simple to support. Galera has also automatic control of autoincerement tuning (increment, offset), based… setting the ‘log-bin’ option. (Then Galera node can operate as MySQL master as well) * Galera global transaction ID could be mapped… for that. Vadim, thanks for the nice article and happy benchmarking!
Comment: Percona Server 5.5.15 + Galera 21.1-beta2
October 4, 2011 By 18 Comments
… benchmarks: http://www.codership.com/content/synchronous-replication-loves-you-again http://openlife.cc/blogs/2011/august/running-sysbench-tests-against-galera-cluster http://linsenraum.de/erkules/2011/06/momentum-galera.html …or try it yourself!
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… it will be available. As for traditional replication – as now Galera uses binlog in ROW format, I do not see problem… to run benchmarks during summer ( and publish it). Benchmarks results and stable work will define if we want to add Galera to Percona…
Comment: Benchmarking Galera replication overhead
October 14, 2011 By 12 Comments
… overhead may coming from writing write sets to disk.” Does Galera fsync the write set to disk after every single transaction… write sets to disk? 5) I’m actually surprised that Galera is slower than regular replication. When binlog & sync_bonlog are…. Any idea why that’s not the case in this benchmark? Thanks
Post: Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
February 28, 2013 By 11 Comments
… 5851.73 mysql> SELECT BENCHMARK(10000000,ENCODE(‘hello’,'goodbye’)); +———————————————–+ | BENCHMARK(10000000,ENCODE(‘hello’,'goodbye’)) | +———————————————–+ | 0 … is another bug Can’t build galera on ARM architecture which should be fixed…
Comment: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 30, 2012 By 4 Comments
… Peter. You audience has interesting questions. Thanks for spreading the Galera knowledge! Q: How does write performance scale with an increasing… and maybe inserts and deletes. For example, in the sysbench benchmark all transactions are read-write, so you couldn’t do… a sysbench workloads b 4x simply by writing to more Galera masters. What you say is correct too, and both of…
