…. 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 15 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…
Post: Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon
March 19, 2013 By Leave a Comment
… of replicating it across multiple datacenters. His talk entitled “High Performance Replication” will cover his field experiences of having high throughput replication requirements…
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
… basic test except we create a slave from the backup, replicating from the backed up server. After the initial setup, we ensure replication is set up ok, then we do additional work on…* crash testing of both xtrabackup and the server, enhancing / expanding replication tests by creating heavy randgen loads against the master during…
Post: Percona Server 5.1 with Galera replication
July 14, 2011 By 2 Comments
… I closely follow Galera replication development, and right now I am evaluating how it performs in our benchmarks. Of course my closest…, we are going to provide Percona Server binaries with Galera replication module. Follow @VadimTk
Post: Maximal write througput in MySQL
February 28, 2010 By 10 Comments
… 1 ) ? – do we use binary logs ( I used ROW based replication for 5.1) – do we have sync_binlog options. So… would not take these as variable parameters and run simple benchmark. I took sysbench update_key scenario ( update indexed field on… I used Percon-XtraDB-5.1.43-9.1 for benchmarks. All used partitions are formatted in XFS and mounted with…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… does support replication which could make some rather interesting architectures in the future. So lets look at some scalability benchmarks, my server… going to try and continue this series by exploring and benchmarking other NOSQL options and comparing them to database based solutions…
