On March 21st I will be in Paris, to attend the OTN MySQL Developers Day. Oracle is organizing these events all over the world, and although the majority are in the US, some of them are touching the good old European continent. Previous events were an all-Oracle show. Recently, the MySQL Community team has been asking for cooperation from the community, and in such capacity I am also presenting at the event, on the topic of testing early releases of MySQL in a sandbox. Of course, this is one of my favorite topics, but it is quite appropriate in this period, when Oracle has released a whole lot of preview features in its MySQL Labs. Which is another favorite topic of mine, since I was the one who insisted for having the Labs when I was working in the …
[Read more]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. Unlike parallel replication, this feature works fine with a single database, and provides performance improvements that in many cases solve the slave lagging problems. This was a bitch of a feature to get right. Many have tried it, many have experienced various degrees of success, and several failures. We started with the bold assertiveness of the brave after an exciting talk at Percona Live in October, and I was …
[Read more]MySQL::Sandbox 3.0.24 was released yesterday, with many new features. More than vanilla MySQLIf you have missed my previous announcement, here's the gist of it. MySQL Sandbox can now deal with tarballs from either Percona Server or MariaDB. The main difference after this change is that you can now create a directory called <PREFIX>5.5.16 and make_sandbox will recognize it as well as the plain 5.5.16.
$ make_sandbox --export_binaries --add_prefix=ps \[Read more]
Percona-Server-5.5.11-rel20.2-114.Darwin.i386.tar.gz \
-- --sandbox_directory=msb_ps5_5_11
unpacking Percona-Server-5.5.11-rel20.2-114.Darwin.i386.tar.gz
[…]
installing with the following …
I will be a speaker at Percona Live - London 2011, and I am looking
forward to the event, which is packed with great content. A
whopping 40 session of MySQL content, plus 3 keynotes and 14
tutorials. It's enough to keep every MySQL enthusiast busy.
Continuent speakers will be particularly busy, as between me
and Robert Hodges, we will be on stage four times
on Tuesday, October 25th.
|
| We have been busy, at Continuent. In addition to our usual work with high performance replication, we have addressed usability issues, since we know that a hard-to-use problem, no matter how powerful, has low adoption. Thus, is with some personal satisfaction that I can announce the release of Tungsten Replicator 2.0.3, which comes with several huge improvements in matter of user friendliness. The new installation procedure is so user friendly, in fact, that I was able to build a sophisticated tungsten-sandbox with a 150-line shell script. (The corresponding features … |
In a few weeks, I will be on the road, for an intense set of
presentations in the USA.
San Francisco, April 7thI will start the tour at the San
Francisco MySQL User Group. On April 7, at 6pm I will talk about
Advanced MySQL replication for the masses. This
talk will explore topics such as bi-directional replication,
multiple sources, parallel replication, seamless failover, with
the help of Tungsten replicator.
Santa Clara, April 11, 12The MySQL conference starts on Monday,
April 11th, with several three-hour tutorials.
- April 11, 9:00amMySQL Replication Advanced Techniques. This will cover MySQL replication beyond the basics. Everything you can do with replication, …
| If you like fresh features, you should not miss this one. MySQL 5.6.2 includes, among other improvements, the implementation of Time delayed replication, a feature that lets you tell the slave not to apply changes from the master immediately, but to wait N seconds. |
The feature is documented in WL#344. (There was a manual online as well
together with the binaries for MySQL 5.6.0, but they were removed
after a few days for a good reason. I am confident that both the
manual and some binaries will eventually show up soon).
Since as of today there are no binaries for MySQL 5.6.x, you need
to get the code and …
A few days ago, a friend of mine asked me if I knew of a way of
filtering a bunch of binary logs, to extract only statements
related to a single table. The task was about filtering a few
hundred binary log files.
It's a tricky problem. Even with my experience with regular
expressions, I knew that using a script to extract statements
related to a single table was going to be a nasty business.
However, I know of an entity that can filter by table name
efficiently, and that's the MySQL replication system. So I
suggested using replication to a sandbox with a
replicate-wild-do-table statement to get the job done.
My friend was skeptical and did not want to go that way. I was
busy writing an article for an Italian magazine and did not
follow up immediately. But today, with the article safely in the
editor's hands, I did a quick test, and guess what? It
works!
Here is a step-by-step procedure to do it. I started …
A few days ago I saw an article about Semi-Synchronous Replication in MySQL 5.5. It
asks questions, and doesn't give answers beyond gut feeling. So I
thought that I would do some practical testing of this new
feature.
Before we go that way, though, let's revisit the theory.
How semi-synchronous replication works
Figure 1. A transaction with regular replication
With regular replication, you send a transaction to the master
(1). When the COMMIT is received, the master
executes it (2), and if successful it logs the transaction to the
binary log (3). The the master answers the client request (4)
with a successful result. In the meantime, the slaves replicate
the record (5).
What happens if the master crashes after point #4 and before a
slave has had a chance of getting the data in point #5?
…
|
If you have tried Quick start guides: MySQL cluster in 10
minutes, you may have realized that it is really quick
and easy. However, it leaves some typing to be done. Users of MySQL Sandbox have a horror of repetitive typing, and this got me thinking. "Could I integrate MySQL Sandbox and Cluster?" The answer was: "Sure." But then I started thinking of all the minor and major changes that I wanted to do to the Sandbox and have delayed for too long. What I need, is a radical refactoring. And then I remembered that it has been almost two years since I learned a new programming language and that perhaps I could expand my horizons … |