“With MySQL 5.6, developers can now commingle the “best of both
worlds” with fast key-value look up operations and complex SQL
queries to meet user and application specific requirements”
–Tomas Ulin. On February 5, 2013, Oracle announced the general
availability of MySQL 5.6. I have interviewed Tomas Ulin, Vice
President for the MySQL Engineering team [...]

A few days back, reading the article on the Moore's law, I
thought it is not too difficult to extend this for an analogous
situation, e.g. the amount of data being cached by a search
engine like Google also grows exponentially. With changing times
we need to have solution that would adapt to the changing data
requirements and availability solutions like virtual
infinite scale-out like cloud. Even though virtualization
is not exactly a database concept, it's not long when we
will have it as a standard for RDBMS. This article is however
about using MySQL replication to scale out reads and make
it fault-tolerant.

MySQL replication is essentially asynchronous i.e. it
doesnot guarantee zero latency between the master and the
slave(s). This, by extension means that in case of a
master crash, data may be lost if we decide to promote one of the
slave to be the master and that is why while scaling …

Red Hat’s $136m acquisition of open source storage vendor
Gluster marks Red Hat’s biggest buy since JBoss and starts the
fourth quarter with a very intersting deal. The acquisition is
definitely good for Red Hat since it bolsters its Cloud Forms
IaaS and OpenShift PaaS technology and strategy with storage,
which is often the starting point for enterprise and service
provider cloud computing deployments. The acquisition also gives
Red Hat another weapon in its fight against VMware, Microsoft and
others, including OpenStack, of which Gluster is a member (more
on that further down). The deal is also good for Gluster given
the sizeable price Red Hat is paying for the provider of open
source, software-based, scale-out storage for unstructured data
and also as validation of both open source and software in
today’s IT and cloud computing storage.

Replication enables data from one MySQL server to be replicated
on one or more other MySQL servers. Replication is mostly used as
scale-out solution. In such a solution, all writes and updates
take place on the master server, while reads take place on one or
more slaves. This model is actually known as master-slave
replication and this is the kind of replication that I will be
setting up in this post.

Continuent is probably best known for its database clustering
technology for MySQL, as well as PostgreSQL, but the company has for some time
had its sights set on expanding beyond open source databases and
enabling horizontal database scalability.

It has just taken a major step towards delivering on both counts
with the launch of Tungsten, its new stack of open source
middleware technologies designed to enable low-cost databases to
scale horizontally for database failover and continuity.

Since I work with replication, these things got me thinking on
what the impact is for replication and how it affects usability,
efficiency, and scale-out. Being a RESTful guy, I started
thinking about URIs both when …

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.