Oracle Virtualization and Cloud Consulting
view counter

MySQL Feed

Oracle MySQL resources, news, and support articles.

Auto caching tables

Is there a way to create a caching table, some sort of a materialized view, such that upon selecting from that table, its data is validated/invalidated?

Hint: yes.

Cool technology and usability in Tungsten Enterprise

When I joined Continuent, at the end of 2010, I was fascinated by the technology of its core products. Readers of this blog know that I have had my hands full with Tungsten Replicator, but what really turned me on was the flagship management suite, Tungsten Enterprise. After hammering at it for several months, and always marveling at the beauty of its technology, let me give a tour of the suite, so that you'll understand what's so exciting about it. First off, Tungsten Enterprise is not simply a replication tool.

MariaDB 5.3 is released as GA!

Congratulations to Monty Program and the many community contributors for releasing the GA version of MariaDB 5.3. We were in our annual all-staff meeting last week, so we are a little slow to blog about this and acknowledge the great work that has gone into MariaDB. Better late than never, I hope.

MySQL can ignore --relay-log-space-limit

Do you have replication slaves that ignore --relay-log-space-limit? This bug has been open for a while on the bug system that isn't I was forced to fix it myself to avert a mutiny. I am amused that the variable named ignore_log_space_limit is part of the problem.

Tungsten 2.0.5 with more power and ease of use

Tungsten Replicator 2.0.5 was released this week-end. The release notes have quite a long list of bug fixes. Thanks to all the ones who have submitted bug reports, and fixes! There are a couple of new features as well. The replicator includes now a slave prefetch service.

MySQL high availability comparison: service versus data

When people ask me about high availability, I often suggest that it’s helpful to understand whether you’re most interested in service availability, data availability, or both. Of course, you want both — but if cost is an object, you may end up relaxing your requirements.

The typical example of an application that needs service availability but doesn’t have strong data availability requirements is something that’s ad-supported. Who cares if the last few comments on funny cat photos are lost? What’s important is that the users can see the photos, and the ads next to them.

Don’t wait to book your Percona Live hotel

If you haven’t booked your hotel room yet, you should do it ASAP. The hotel is going to raise their rates at the same time the early-bird conference rate expires. This is a coincidence: Percona has no control over hotel prices. (There is a group discount rate, but we don’t call the shots on that.)

Vitess: Another interesting MySQL/NoSQL approach

Last week I was part of a discussion panel on SQL versus NoSQL. Many in the audience seemed to believe that you needed to be one or the other with an exclusive or. Then today I learned about Vitess, an idea to use MySQL as a data layer while providing easy scaling and control the roll out of a logical schema. Is there room for an inclusive or.

MySQL Tech Tours

MySQL Tech Tour Event – CO Springs
Monday, March 12, 2012
1:00 PM – 4:30 PM

MySQL Scaling breakfast seminar – London, April 25th

I’ll be presenting on/demoing MySQL Cluster 7.2 at this free breakfast seminar in

view counter