I talked about parallel replication last month. Since then,
there has been a considerable interest for this feature. As far
as I know, Tungsten's is the only implementation of this much
coveted feature, so I can only compare with MySQL native
replication.
The most compelling question is "how fast is it?"
That's a tricky one. The answer is the same that I give when
someone asks me "how fast is MySQL". I always say: it
depends.
Running replication in a single thread is sometimes slower than
the operations in the master. Many users complain that the single
thread can't keep up with the master, and the slave lags behind.
True. There is, however, a hidden benefit of single threaded
replication: it requires less resources. There is no contention
for writing on disk, no need to worry about several users
blocking a …
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, …
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 …
|
I hope you liked the first part of this series of lessons. And
I really hope that you have followed the instructions and got
your little replication cluster up and working. |
If you haven't done that, thinking that you would spare your
energies for more juicy matters, I have news for you. What I
explained in the previous part is exactly what you need to do to
set up parallel replication. With just a tiny additional
detail.
For the sake of the diligent readers who have followed the
instructions with the first lessons, I won't repeat them, but
I'll invite you to set the environment as explained in the first
part.
Once you have a cluster up and …
|
MySQL DBAs and developers: oil your fingers and get ready to
experience a new dimension of data replication. I am pleased
to announce that Continuent has just released Tungsten Replicator 2.0, an open source
data replication engine that can replace MySQL native
replication with a set of advanced features. A note about the source code. The current version of Tungsten Replicator available in the web site is free to use, but it is not yet the open source version. We need a few weeks more to extract the code from the enterprise tree and make a new build. But we did not want to delay the user experience. So everything … |
Sometimes you know for sure. And sometimes you wonder: Is this
server part of a replication system? And, most specifically, is
it an active slave?
The completeness of the answer depends on how much visibility you
have on the server.
If you can ask the DBA, and possibly have access to the server
data directory and configuration file, you can get a satisfactory
answer. But if your access is limited to SQL access, things get a
bit more complicated.
If you have the SUPER or REPLICATION_CLIENT privilege, then it's
easy, at least in the surface.
SHOW SLAVE STATUS will tell you if the slave is running. An empty
set means that the server was not configured as a slave.
The answer is not absolute, though. You need to read the output
of SHOW SLAVE STATUS to understand if replication is under
way.
For example, what is the difference between these two
listings?
## listing 1 …[Read more]
On Thursday, February 10, at 10am PST, there is a free webinar
about Managing Big Data with Percona Server, XtraBackup
and Tungsten. Quoting from the announcement:
Big data is a big problem for growing SaaS businesses and large
web applications. In this webinar, we'll teach you how to set up
Percona Server, XtraBackup, and Tungsten to manage Terabyte+
databases and scale to millions of transactions a day. We'll
discuss the latest features for high transaction performance like
InnoDB buffer pool dump/restore and HandlerSocket, our favorite
tricks for backup, restore, and provisioning of large data sets,
and how to replicate scalably and safely using Tungsten
Replicator with parallel apply.
The presenters are representatives of both Percona and …
|
I have been traveling to many conferences in the last 10
years, and many times I have been asked to organize an event
in my native land, Sardinia. After delaying the inevitable for
long time, here I can announce it. The Open Database Camp
2011 will take place in Sardinia, hosted by the Sardinia Technology Park, a local scientific
and business institution with international links. Mark your calendars: the Open Database Camp will be held in Sardinia on May 6-7-8, 2011. I have already confirmed the venue, and I will have full cooperation from Sardegna Ricerche about the conference logistics. I will meet the organizers on … |
Download Tungsten Enterprise v. 1.2.3 (Release date March 16, 2010) This is a maintenance release that adds the following new features plus a number of important fixes: Completely updated documentation, including expanded description on cluster concepts, management procedures, and connectivity options New features for SaaS vendors include transparent session consistency for
Objectional statements on Oracle-Sun-MySQL. How Google uses Linux. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca
“Tracking the open source news wires, so you don’t have
to.”
Objectional statements
The European Commission communicated its Statement of Objections
to Oracle’s proposed acquisition of Sun Microsystems to those
involved, prompting Oracle to claim the EC has a profound misunderstanding of
database competition and open source, the US DoJ to reiterate its position
that Oracle’s acquisition of Sun is unlikely to be
anticompetitive and an EC spokesperson to explain that concern
over …