While most of the talk recently has mostly been around the new changes in MySQL 5.6 (and that is understandable), I have had lately some very interesting cases to deal with, with respect to the Metadata Locking related changes that were introduced in MySQL 5.5.3. It appears that the implications of Metadata Locking have not been covered well, and since there are still a large number of MySQL 5.0 and 5.1 installations that would upgrade or are in the process of upgrading to MySQL 5.5, I thought it necessary to discuss what these implications exactly are.
I just listened to a talk at the New England Database Summit and learned about a new DBMS that supports extremely high QPS for data in main memory sharded over several nodes with synchronous commit across multiple copies to support HA. Performance is much better when the custom API is used to batch transactions. It has begun to support data on disk.
Now that I think about it, was this a talk about MySQL Cluster?
When will it stop. These amateur programmers that simply cut/paste code really affect those good programmers in the ecosystem trying to make a decent living. I was reviewing a developed (but incomplete) PHP/MySQL system using a common framework (which in itself is irrelevant for this post).
In one source file there were 12 repetitions of the following code:
With our newest release of Percona XtraDB Cluster, I would like to highlight a very nice ability to recovery a node and bring it back to the cluster with an incremental transfer after a crash.
This feature was available even in previous release, but now I want to give some details.
So, MySQL crashes from time to time and this a fact of life. HA solution is exactly needed to deal with an one node failure and allowing whole cluster continuing to work.
MySQL Users Group, please let us know you schedule so we can help promote your events. And if you are interested in starting a MySQL — let us know as we can help.
The MySQL Community Team wants to make sure you do not miss out on upcoming shows.
Fosdem is this coming weekend and there will be a MySQL and Friends devroom. This show in Brussels features presentations from Lars Thalmann, Sveta Smirnova, Luis Soares, Giuseppe Maxia, Øystein Grøvlen, and many more.