… Cluster Feature 2: Multi-Master replication Create 3 nodes XtraDB Cluster in 3 minutes Benchmarking Galera replication overhead Percona Server 5.5.15 + Galera 21.1-beta2 State of the art: Galera – synchronous replication for…
Comment: Black-Box MySQL Performance Analysis with TCP Traffic
February 27, 2012 By 2 Comments
Baron Thanks for the white paper. I think this is definitely a useful tool to replicate prod load for benchmarking systems.
Post: Benchmarking Galera replication overhead
October 13, 2011 By 12 Comments
…in Galera cluster replication – result using 2 nodes under regular MySQL replication semisync – result using 2 nodes with semisync MySQL replication And … but not only on single. Scripts and raw results on Benchmarks Launchpad (function() { var po = document.createElement(‘script’); po.type = ‘text…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… today I decided to take a closer look at SpecJAppServer benchmarks results which were published by PostgreSQL recently and which as… is different – MySQL benchmark use Sun Fire X4100 available in Nov 2005 using Opteron 285 CPU, PostgreSQL benchmarks use Sun Fire X4200…, Multi Value inserts, Query Cache, Merge Tables, Archive Tables, Simple Replication. Most of these do not come implicitly, you’ve got…
Post: MySQL QA Team Benchmarks for MySQL 5.1.30
December 13, 2008 By 12 Comments
… us ? I do not think so. When you’re doing benchmarks you should be comparing best performance settings for given application… data at all. It is also very interesting to see benchmark run with innodb_thread_concurrency=1000 – This is exactly the… keep binary log enabled – most big installations of MySQL use replication or at least binary log to get point in time…
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
…. The benchmark is VoltDB’s “voter” benchmark, which is explained briefly at this blog post. VoltDB’s Tim Callaghan ran the benchmark three… server is synchronously replicated to all other copies in the cluster before the transaction completes. Running all these benchmarks is a lot… raw performance results from benchmarks at that scale — this is a mathematical model based on a smaller benchmark. Also note that these…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 13 Comments
…, and I am going to run my own benchmarks also. Also from benchmark you can see that communication overhead maybe significant for short writes. – Scale Reads. It can be done with regular replication… developments in computer science to produce fast and scalable synchronous replication solution that “just works” for databases and similar applications”, which…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… for multiple user load. See this post by Vadim for benchmark results. Solution with Battery Backed up RAID is great one…. I also should mention this covers only Master overhead of Replication. Slave is where you can expect more problems, especially on…. You still will practically have only One CPU to handle replication load. Furthermore if you have multiple disks they will not…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
… in time recovery from backup. I was testing high volume replication today using Sysbench: sysbench –test=oltp –oltp-table-size=10000000… accumulate the performance on Master will be high even with replication running, but it will slow down as soon as IO… very similar performance but there have been no degradation when replication is enabled. I have not checked in details why this…
Post: READ-COMMITED vs REPETABLE-READ in tpcc-like load
February 11, 2010 By 6 Comments
… level having small dataset. I used as usually tpcc-mysql benchmark with 16 and 32 (for 10w) concurrent users. Also I… RBR mode (as READ-COMMITED does not support STATEMENT based replication in 5.1), and everything was run under XtraDB-9… less-tested READ-COMMITED does not work with statement-based replication in 5.1 with READ-COMMITED you may have more…
