… XtraDB Cluster. Percona XtraDB Cluster is a High Availability and Scalability solution for MySQL Users and is based on Percona Server… on all nodes or none. Multi-master replication. You can write to any node. Parallel applying events on slave. Real “parallel… Cluster is based on Percona Server with XtraDB and includes Write Set REPlication patches. It uses the Galera library, version 2…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… ALTER without any locking. Client applications can continue reading and writing the table with no interruption. With this new version of… upgrades I’ll show how to use it to forecast scalability and performance The new Percona Toolkit release is available for…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
…. The modeling I performed is Universal Scalability Law modeling, which can predict both software and hardware scalability, depending on how it is used. In brief, the benchmarks are sysbench’s read-only and read-write tests…. The following are plots of the read-only and read-write scalability models that I generated, based on these benchmarks. [caption id…
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
…. More disclaimers at the end. Short version: VoltDB is very scalable; it should scale to 120 partitions, 39 servers, and 1… Universal Scalability Law (USL) to model the cluster’s scalability. If you are not familiar with this model, probably the most succinct write… of VoltDB it does indeed match their claim, with good scalability to dozens of servers. For more information, or to download…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… right question. The answer depends on what you mean by “write scalability”. The published Galera benchmarks have been done with sysbench or…. Their transactions are roughly 20-25% writes, rest are selects. When using replication, only the writes need to be applied on the… huge expectations with Galera is not so much to get write scalability, rather than just better high-availability (better = easier to setup…
Comment: Another ingenious piece of Sun Marketing
March 24, 2009 By 20 Comments
… actively writing code to produce a highly scalable engine. So, I’d like to propose the following correction for Robert’s wall: “Writing SCALABLE code is harder than writing marketing…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… I wrote about InnoDB scalability on 24-core box, and we made research of scalability problems in sysbench write workload (benchmark emulates intensive…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… – the LRU for cache management is classics and there are scalable algorithms to deal with it. I would expect Monty to…/sec which is a great speed. We can note significant writes to the disk during this read-only benchmark. Why ? Because…
Comment: State of the art: Galera - synchronous replication for InnoDB
October 29, 2009 By 13 Comments
… mysqlslap benchmark here: http://www.codership.com/en/content/benchmarking-write-scalability. Curiously, one way to make for additional communication overhead is…^2 and is the major limiting factor for multi-master scalability. As for comparison with async master-slave – we don’t…
Post: Another scalability fix in XtraDB
January 23, 2009 By 13 Comments
Recent scalability fixes in InnoDB and also Google’s and your SMP … – and we replaced page_hash mutex to page_hash read-write lock. The new results you can see on graph. The…
