February 22, 2012

Comment: MariaDB 5.3.4 benchmarks

MariaDB 5.3.4 runs ontop XtraDB 1.0.17-13.0 which in turn is based on InnoDB 1.0.17 from MySQL 5.1. So indeed MySQL 5.1 or Percona Server 5.1.59-13.0 would be proper targets for a comparison with MariaDB 5.3.4.

As pointed out by Peter, sysbench runs simple queries only where MariaDB cannot …

Comment: MariaDB 5.3.4 benchmarks

How do we know that it is not a regression in XtraDB? Too bad the latest Percona Server is not included in the benchmark.

Comment: MariaDB 5.3.4 benchmarks

To Davi Arnaut.

MariaDB 5.3 uses XtraDB engine which scales pretty well in both 5.1 and 5.5.

Now about fairness:
MariaDB 5.3 is RC for the next production ready MariaDB’s flagship database.

For MySQL the current pre-production product is 5.6.

So there we compare the future MariaDB with …

Post: My talks on PL MySQL Conference (+free book inside)

… first-hand information from the main architect and lead developer.

And two talks:

Percona XtraDB Cluster: New HA solution. There I will cover XtraDB …hall to chat on all kind of topics related to MySQL, XtraBackup, XtraDB Cluster, etc.

More interesting, by the time of conference we will …

Post: Announcing Percona XtraBackup 2.0 Beta 1

… the stable 1.6 series of Percona XtraBackup instead.

In this beta we’re proud to add:

support for Galera replication and the Percona XtraDB Cluster Alpha.
the Documentation is now bundled with the source tree and under a CC Attribution-ShareAlike 2.0 Generic license.
support for building…

Comment: How Does Semisynchronous MySQL Replication Work?

Thousands of people have many years of experience with MySQL replication. A few people have months of experience with Tungsten and Galera (a.k.a. Percona XtraDB Cluster), and I am sure we will learn a lot more after they mature more, but in principle they have fewer inherent obstacles to being …

Comment: Modeling InnoDB Scalability on Multi-Core Servers

…16:00:43 InnoDB: highest supported file format is Barracuda.
120131 16:00:43 InnoDB: Waiting for the background threads to start
120131 16:00:44 Percona XtraDB (http://www.percona.com) 1.1.8-20.1 started; log sequence number 1604009568
120131 16:00:44 [ERROR] /usr/local/mysql/bin/mysqld: unknown…

Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication

Vadim,

I use Percona Server 5.1 in a Two Master No Slave MMM configuration. The read write ratio of our application is 90/10. How do I distribute the reads and writes in a 3 Node Percona XtraDB Cluster? My method today is via MySQL MMM of Read & Write Roles virtual IP through a JDBC connection.

Comment: Percona XtraDB Cluster Feature 1: High Availability

…for short period of time. I am trying to convince Codership team that this is not needed at all.

2. With LRU dump/restore in Percona Server/XtraDB Cluster http://www.percona.com/doc/percona-server/5.5/management/innodb_lru_dump_restore.html the joiner will start with pre-loaded buffer pool, that …

Comment: Percona XtraDB Cluster Feature 1: High Availability

Thanks for your help!
I am currently testing galera; I suppose SST, IST and all clustering related components are the same in Percona XtraDB cluster.