Why read stale data from an asynchronous MySQL replica (slave)? Fetch it from a local cache instead! Good for the clusters overall load, good for your applications performance. And, possible with PECL/mysqlnd_ms 1.3, the replication and load balancing plugin for PHP MySQL users.

The idea is simple

Any application using asynchronous MySQL replication must be capable of handling stale results read from a slave (replica) that is lagging behind the master. The quality of service that the application needs from the database cluster is low. If an application explicitly states the minimum service quality it needs, the underlying systems can adopt to it. That’s a cool thing, because the underlying systems don’t need to do more work than necessary. In the case of a PHP MySQL user, the first underlying system is the database driver library, which is mysqlnd.

Tell mysqlnd …

Did you know that approximately 70% of Oracle customers are also using MySQL?  The use cases for each database are often different – and sometime overlap.  But the needs of a database are the same – among them are security, integration with other products, and strong monitoring.  One of the advantages of the MySQL / Oracle relationship is that Oracle is integrating MySQL with many of its other software products such as:

• Goldengate, for real time heterogeneous replication from/to MySQL and other databases.  Goldengate real life use cases include real time replication of selected MySQL data collected online to a data warehouse in Oracle, Teradata, Neteeza, etc; query offloading from a transactional system built on Oracle, DB2 Z series, SQL Server, etc to a MySQL query instance; and real time reporting by real time replication of a subset of data from corporate …

Following the success of our OTN MySQL Developer Day in London last October, we are running additional MySQL Developer Days in Europe!

Join us in:

• Germany: Frankfurt - February 9th - Check out the agenda and register here!
• France: Paris - March 21st - Check out the agenda and register here!

The MySQL Developer Day is a one-stop shop for you to learn all the essential MySQL skills. In this free, one-day seminar, we will cover everything you need to know to successfully design, develop, and manage your MySQL databases. You'll also learn the guidelines and best practices in performance tuning and scalability. Space is limited so register now!

Additionally, we …

Following the success of our OTN MySQL Developer Day in London last October, we are running additional MySQL Developer Days in Europe!

Join us in:

• Germany: Frankfurt - February 9th - Check out the agenda and register here!
• France: Paris - March 21st - Check out the agenda and register here!

The MySQL Developer Day is a one-stop shop for you to learn all the essential MySQL skills. In this free, one-day seminar, we will cover everything you need to know to successfully design, develop, and manage your MySQL databases. You'll also learn the guidelines and best practices in performance tuning and scalability. Space is limited so register now!

Additionally, we …

The binary version for MySQL Cluster 7.1.19 has now been made available at http://www.mysql.com/downloads/cluster/ (GPL version) or https://support.oracle.com/ (commercial version)

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.19 (compared to 7.1.18) will appear in the 7.1.19 Change log.

This is a cross-post of something I just put up on Google+. My username on G+ is Keith Murphy. If you are interested please search me out on G+ and comment on the post.  Thanks!! km

-------------------------

I have an idea that I wanted to see if there would be interested people who would like to pursue it. One of things I love to do is participate in MySQL Users groups. When I had the chance I was able to go to user groups in various places I have lived or been. However, my home for a long time has been in an area that isn't heavily populated so there is no actual user groups closer than six hours drive away. I did attempt to start a user group in the nearest city several years ago but it didn't get off the ground.

Anyways, I have been using G+ for some months now and I would like to expand my professional usage of it. One of the great new features that Google added recently was "hangouts". If you don't know …

Lately I have been working with a large pool of fairly hetrogeneous MySQL. Similar to a pool of web servers we have almost 100 MySQL servers across two data centers that are the same in terms of platform/schema etc. These aren't our only servers, just the largest group of them.  Previously everything I had done was with smaller numbers of server (30 or less) or larger numbers of servers but across multiple pools/customers. When you work on a single large pool of servers it brings some interesting challenges. While I certainly can apply everything I have learned up to this point, it brings on some new  problems/issues/headaches.

So, I wanted to take things in bit of a different direction and talk about some of problems that you see when managing large groups of servers like this. Over the next few months as time permits I want to discuss the issues that come up and how you can manage many servers like this. Time, unfortunately, has …

I’m about to head to Paris to present at the February meetup of the MySQL User Group in Paris, France. It happens 1st February from 6-8pm at the Patricks Irish Pub. Its free to attend, and I understand that SkySQL keeps this event afloat.

I’m also heading to my first FOSDEM right afterwards and will definitely hang out at the MySQL & Friends Devroom. There is an amazing lineup of speakers, with all talks being about 25-30 minutes, it looks like it is going to be a lot of fun. To boot, Michael “Monty” Widenius will also be there, so expect lots of Salmiakkikossu.

If you want to …

The first Central Virginia MySQL Meetup was a nice little howdy-do, and as a test flight, I think it showed that the bird can get off the ground quite nicely. So, with the generous help of our meeting host Meddius, we’re going to do it regularly on the 3rd Wednesday of every month. The next event is already scheduled – I will be talking about high availability options for MySQL.

MySQL Embedded Online Forum

Tuesday, January 31, 2012 9:00AM PST – 12:00 PM PST

Think You Know MySQL? Get the Facts.

MySQL is even better than you think. According to the experts, it’s easier to use and it’s more capable than most ISVs / OEMs realize, and by taking a few tried-and-tested steps before shipping your MySQL-embedded products, you can lower your product’s costs and increase its performance.

Join our expert-created and delivered MySQL Embedded Online Forum to learn:

Why MySQL is a great embedded database for startups as well as the largest software, hardware, and appliance vendors in the world, and how its features ensure costs remain low throughout an …