MySQL built-in replication includes a concept called relay slave, which allows you to create hierarchical database clusters. You can do the same thing with Tungsten, and this can be done in more than one way. Let's start with two distinct clusters. We can follow the recipes in the Tungsten Cookbook to install a master / slave cluster in three separate hosts and a …[Read more]
« 10 Newer Entries
One lesson learned in more than two decades working in this industry is that most of the IT professionals are impatient, want to achieve results immediately, and, most importantly, they don't read documentation. Much as the average geek is happy to answer many requests with a dismissive RTFM, the same geeks are not as diligent when it comes to learning about new or updated technologies. For this reason, there is a kind of documentation that is very much appreciated by busy and impatient professionals: cookbooks. And I am not talking about food. Geeks are not known for being cooks (1) and they like fast food. I am talking about collection of technical recipes, short articles where a problem is briefly stated, and a direct solution is shown. Working with Tungsten Replicator, I am constantly amazed at all the things you can do with it, and at the same time, I am amazed at how so few …[Read more]
I have been working with MySQL replication for quite a while. I
have dealt with simple replication setups and I have experimented
with complex ones. Five years ago I wrote an article about advanced MySQL replication,
which was mostly a dream on what you could do with imagination
and skill, but the matter from that article is still not even
remotely ready for production. Yet, since that article, I have
been approached by dozens of people who wanted to know how to
make the multiple master dream become reality. To all of them, I
had to say, "sorry, this is just a proof of concept.Come back in
a few years, it may become possible". It still isn't.
Despite its latest great technological advance, MySQL native replication is is very poor of topologies. What you can do with MySQL native replication is master-to-slave (which also includes relayed …
After part I: the basics, and part II: parallel apply, we deal now with some
more mundane topic, or how to deploy replication services in a
way that they fit our business, covering from the basic
master/slave to the most advanced multi-source scheme.
Master/slaveThe most common topology is master/slave. One master, many slaves. This topology is equivalent to MySQL native replication. The differences are in the additional features. Tungsten supports seamless failover and parallel replication in all topologies.
Figure 1. Tungsten master/slave replication
Unlike MySQL, and unlike previous versions of Tungsten, the implementation of this topology uses a dedicated service for the …
« 10 Newer Entries