May 25, 2012

Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release

… Cluster is a High Availability and Scalability solution for MySQL Users and is based on Percona Server 5.5.20. With this release we make clustering very easy and affordable for everyone. You can convert your existing MySQL replication… talks: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference Percona XtraDB Cluster: New…

Post: MariaDB 5.3 is released as GA!

5.3 isn’t the only exciting thing, however. MariaDB 5.3 is based on MySQL 5.1, but MariaDB 5.5 will be based on MySQL 5.5, so it will inherit a lot of the great improvements Oracle has made to the MySQL 5.5 release. This should help MariaDB be faster and more scalable, as well as adding a…

Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5

MySQL 5.5 and Percona Server 5.5 do not solve all scalability problems even for read only workloads. Workloads which got a …. This is why it is important to test performance and scalability for your application on your hardware if you really want… 12 physical cores and 24 threads, which is almost perfect scalability. So there are workloads where the problem is solved and…

Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)

… the following results: 13GB: MySQL 5.5.8 – 23,513 NOTPM, Percona Server – 30,436 NOTPM, advantage: 1.29x 52GB: MySQL 5.5.8 – 71,774 NOTPM, Percona Server – 88,792 NOTPM, advantage: 1.23x 144GB: MySQL 5.5.8 – 78,091 NOTPM… Disabled read-ahead logic: innodb_read_ahead=none Buffer pool scalability fixes (different from innodb_buffer_pool_instances) We recognize that…

Post: MySQL 5.5-m2 scalability

Oracle recently announcent MySQL-5.5.2-m2 milestone, and I have a predition that MySQL-5.5 will be announced as GA on MySQL UC 2010 in April. So let’s make quick on scalability characteristics we…

Post: Percona Server 5.5.15 + Galera 21.1-beta2

…/TESTING/Galera/Percona-XtraDB-Galera-5.5.15.tar.gz What difference between Percona Server+Galera and MySQL 5.5.15 ? First of course, Percona…. It is new High Availability + Scalability solution for MySQL. And this solution is radically different from regular MySQL replication. You can actually think…

Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency

… Workload. We did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were…% slower than MySQL 5.0 with two cores and just 2% slower with 8 cores, thus showing a bit better scalability. MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores and…

Post: Upgrading MySQL

… – Upgrade of MySQL 5.0.30 to 5.0.32 is generally likely to expose less issues than 5.0.30 to 5.0.86…. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL 5.0 database with MySQL 5.1… both MySQL does not crash under your load as well s it scales well. There have been number of scalability bugs in MySQL

Post: MySQL 5.1 is to reach GA state - all to arms !

… bugs in MySQL 5.1 or MySQL 5.0 (which are still unfixed in MySQL 5.1) make sure to report them on bugs.mysql.com. If… with 5.1 we’ve seen among the customers during last few months was higher than with 5.0, also Scalability of MySQL 5.1 is often subpar compared to MySQL 5.0 possibly due to this…

Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance

… from MySQL 5.4 and merry it with unique Percona patches (adaptive checkpoints, additional undo slots, profiling, etc) and integrate it with MySQL 5… plugin 1.0.3 got some Google changes for CPU scalability but not IO patches. I expected Innodb to announce plugin… instead we get MySQL 5.4 release with yet another set of Innodb changes. Why not to include plugin in MySQL 5.4 with…