We’re always testing the latest versions of MySQL with most of the environments to make sure that we can find the critical issues before it goes to production. This wasn’t different with the 5.6 MySQL neither. We already started to play with this version in the summer. The first news were very promising. The performance gain is significant. However we have run into couple of errors. One of them was the

mysql_install_db problem with replicating environment

[root@hostname ~]# mysql_install_db --user=mysql --datadir=/mysql/data/

------------------------------------------------------------------------------------
Installing MySQL system tables...
121217 10:02:20 InnoDB: The InnoDB memory heap is disabled
121217 10:02:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121217 10:02:20 InnoDB: Compressed tables use zlib 1.2.3
121217 10:02:20 InnoDB: Using Linux native AIO
121217 10:02:20 InnoDB: CPU supports crc32 instructions
121217 10:02:20 …

It is time for christmas presents: some sharding support and cache locality optimizations are coming with PECL/mysqlnd_ms 1.5. PECL/mysqlnd_ms is a plugin for the mysqlnd library. The plugin adds replication and load balancing support to any PHP MySQL API (mysql, mysqli, PDO_MySQL) if compiled to use the mysqlnd library.

As a MySQL user you can choose between a wide variety of clustering solutions to scale-out. Your options range from eventual consistent solutions to strong consistent ones, from built-in (MySQL Replication, MySQL Cluster) to third party or home-grown. PECL/mysqlnd_ms is a client side load balancer that aims to serve all. …

The old MySQL.com logins will go away on Wednesday, December 19th and will be replaced by the Oracle Single Sign On (SSO).

This Oracle SSO will replace the old MySQL.Com login starting December 20th.

So what do you do? Go to Oracle.com and login. If your account was migrated you will be able to login. But the crimson invalid login message will require you to set up a new account. Some may be wary of providing more personal information. But this is being done to bring the MySQL.com web sites into compliance with our corporate rules and provide a better flow for those of you using more than one Oracle product.

Q: Will this affect voting statistics on Plant.MySQL.Com?
A: Probably. The run away leaders have been Giuseppe Maxia and …

So lots of folks are talking about the newly announced MariaDB Foundation. Some folks are confused as to what happened to the Open Database Alliance?

The MariaDB Foundation members include Monty Program, SkySQL, David Axmark, and Allan Larsson.

The Open Database Alliance members include Monty Program, FromDual, Open query, Percona and SoftMethod. [SkySQL was not founded when the ODBA was announced.]

The mission of the MariaDB Foundation…well, it’s not on the MariaDB Foundation web page yet, but the blog announcement says:

In its mission statement, the MariaDB Foundation exists to improve database technology, including standards …

There’s some media coverage about Wikipedia switching to MariaDB, I just wanted to point out that performance figures cited are somewhat incorrect and don’t attribute gains to correct authors.

Proper performance evaluation should include not just MariaDB 5.5 but Oracle’s MySQL 5.5 version too, because thats where most of performance development happened (multiple buffer pools, rollback segments, change buffering et al).

5.5 is faster for some workloads, 5.1-fb can outperform 5.5 in other workloads (ones with lots of IO), it is good to know that there’s beneficial impact from upgrading (though I’d wait for 5.6), but it is important to state that it is an effort from Oracle as well, not just MariaDB developers.

…

Die MySQL & MariaDB Datenbank Roadshow kommt nach Deutschland: - Stuttgart 25. Januar 2013, 9.00-16.00 Uhr, Sodexo STEP/Engineering Park
- Hamburg 1. Februar 2013, 9.00-16.00 Uhr, Quality Ambassador Hotel

Ab Januar 2013 sind SkySQL und Monty Program unterwegs mit unseren ersten gemeinsamen - kostenfreien - Roadshows in Deutschland: In Stuttgart und Hamburg wird Monty Widenius seine Zukunfts-Vision der MySQL-Datenbank via MariaDB vorstellen (Vortrag in Englisch). Zudem werden Sprecher von Codership/Galera erwartet sowie SkySQL Kunden-Berichte.

…

This is just a reminder: Call for papers for MySQL & Friends devroom at FOSDEM 2013 is open until December 21st, which is this Friday. Please hurry up and submit your proposal. Possible topics include everything related to MySQL.

MariaDB 10.0 has got another new feature: Sanja Byelkin has pushed EXISTS-to-IN rewrite feature. It is an optimization targeted at EXISTS subqueries. The idea behind it is simple. EXISTS subqueries often have form:

EXISTS (SELECT …  FROM … WHERE outer_col=inner_col AND inner_where)

where outer_col=inner_col is the only place where the subquery has references to outside. In this case, the subquery can be converted into an uncorrelated IN:

outer_col IN (SELECT inner_col FROM … WHERE inner_where)

The conversion opens new opportunities for the optimizer. Correlated EXISTS subquery has only one execution strategy. Uncorrelated IN subquery has two:

1. re-run the subquery every time the subquery is evaluated (the same as in EXISTS)
2. Materialize the subquery output …

Some weeks ago I had to migrate some independent MySQL servers (some standard MySQL masters, and some just standalone) to a Percona XtraDB Cluster of 3 nodes.

So the easiest way would be to configure each node to become also an asynchronous slave of one of the production servers.
Like illustrated here:

But in this case there was one major issue, the tables where MyISAM and this is not really recommended with Galera replication even if it’s now supported.

Preparing the slaves would then become a loop :

for each production server
   restoring the dump on the node that will be the dedicated slave
   convert the table in InnoDB
   configure and start the replication 
   finally perform SST on the other nodes....

So in this case that should have be done 3 times… that could take some …

[...] Redis, Memcached, Tokyo Tyrant and MySQL comparision http://ruturaj.net/redis-memcached-tokyo-tyrant-and-mysql-comparision/ [...]