May 25, 2012

Post: Introducing Zend DBi as a MySQL Replacement on IBM i

… difference in query syntax, client-server protocol, or data storage on disk. Anything that runs on MySQL will run identically on Zend… to Oracle’s MySQL on another platform, it will work seamlessly. Why is Percona involved? Because providing quality server builds is a… by providing our own Percona Server variant of the MySQL server. We have a history of improving the MySQL server and finding and solving bugs…

Post: Percona Server 5.5.23-25.3 released!

… Software Repositories). Based on MySQL 5.5.23, including all the bug fixes in it, Percona Server 5.5.23-25.3….5.23-25.3 milestone at Launchpad. Bugs Fixed: Percona Server would crash on a DDL statement if an XtraDB internal… table. Bug fixed #978036 (Laurynas Biveinis). Release notes for Percona Server 5.5.23-25.3 are available in our online…

Post: Percona Server 5.1.62-13.3 released!

Percona is glad to announce the release of Percona Server 5.1.62-13.3 on April 25, 2012 (Downloads … Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it, Percona Server 5.1.62-13.3… is encoded within the BINLOG ‘….’ statement. Release notes for Percona Server 5.1.62-13.3 are available in our online…

Post: Percona Server 5.5.22-25.2 released!

Percona is glad to announce the release of Percona Server 5.5.22-25.2 on April 25, 2012 (Downloads … Software Repositories). Based on MySQL 5.5.22, including all the bug fixes in it, Percona Server 5.5.22-25.2… keys. Bug fixed #892951 (Laurynas Biveinis). Release notes for Percona Server 5.5.22-25.2 are available in our online…

Post: Zero-Downtime Schema Changes In MySQL

…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would… to do and causes way too many bugs in the server and the tool, so there is no code in the…

Comment: Make your file system error resilient

…Number of blocks reserved for root. [...] MySQL server is only one doing writes on this partition anyway it … apply e2defrag regularily. Not a good idea for a database server.

Comment: Testing Fusion-io ioDrive - now with driver 3.1

… benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on the Fusion-IO card… am going to do some testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3.1…

Comment: How to change innodb_log_file_size safely

….cnf file. I renamed it and copied /usr/share/doc/mysql-server-5.0.95/my-medium.cnf to /etc/my.cnf…

Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

… boxs with MySQL 5.5 (Ubuntu Server 12.04 LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysql 5.5… my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS produce a completely output. Maybe not initial, but if you use the server… the test of “Slave_SQL_Running: Yes” fails, because the server is not running as a slave. So the 2nd start…

Post: Benchmarking single-row insert performance on Amazon EC2

… 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following… I am using “estimate” flushing method available only on Percona Server. The “estimate” method reduces the impact of traditional InnoDB log… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I…