In my last post I described the motivation for the new NDB$EPOCH
conflict detection function in MySQL
Cluster. This function detects when a row has been
concurrently updated on two asynchronously replicating MySQL
Cluster databases, and takes steps to keep the databases in
alignment.
With NDB$EPOCH, conflicts are detected and handled on a row
granularity, as opposed to column granularity, as this is the
granularity of the epoch metadata used to detect conflicts.
Dealing with conflicts on a …
Oct
10
2011
Oct
07
2011
70x Higher Performance, Cross Data Center Scalability and New NoSQL Interface
Its been an exciting week for all involved with MySQL Cluster, with the announcement of the second Development Milestone Release (7.2.1) at Oracle Open World. Highlights include:
- Enabling next generation web services: 70x higher complex query performance, native memcached API and integration with the latest MySQL 5.5 server
- Enhancing cross data scalability: new multi-site clustering and enhanced active/active replication
- Simplified provisioning: consolidated user privileges.
You can download the DMR for evaluation now from: http://dev.mysql.com/downloads/cluster/ (select Development Milestone Release tab).
You …
[Read more]
Oct
07
2011
70x Higher Performance, Cross Data Center Scalability and New NoSQL Interface
Its been an exciting week for all involved with MySQL Cluster, with the announcement of the second Development Milestone Release (7.2.1) at Oracle Open World. Highlights include:
- Enabling next generation web services: 70x higher complex query performance, native memcached API and integration with the latest MySQL 5.5 server
- Enhancing cross data scalability: new multi-site clustering and enhanced active/active replication
- Simplified provisioning: consolidated user privileges.
You can download the DMR for evaluation now from: http://dev.mysql.com/downloads/cluster/ (select Development Milestone Release tab).
You …
[Read more]
Oct
06
2011
Oracle's turn-about announcement of a NoSQL product wasn't really surprising. When Oracle spends time and effort putting down a technology, you can bet that its secretly impressed, and trying to re-implement it in its back room. So Oracle's paper "Debunking the NoSQL Hype" should really have been read as a backhanded product announcement. (By the way, don't click that link; the paper appears to have been taken down. Surprise.)
I have to agree with DataStax and other developers in the NoSQL movement: Oracle's announcement is a …
[Read more]
Oct
06
2011
Join me for a webinar where I discuss how the recent changes and
trends in big data management effect the enterprise. This
event is sponsored by Red Rock and RockSolid.
Overview:
It is an exciting and interesting time to be involved in data.
More change of influence has occurred in the database management
in the last 18 months than has occurred in the last 18 years. New
technologies such as NoSQL & Hadoop and radical redesigns of
existing technologies, like NewSQL , will change dramatically how
we manage data moving forward.
These technologies bring with them possibilities both in terms of
the scale of data retained but also in how this data can be
utilized as an information asset. The ability to leverage Big
Data to …
Oct
06
2011
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.
…
[Read more]
Oct
04
2011
As you probably know, I have been doing RDBMS work for many
years, some 25+ years by now. At Recorded Future I am the
database architect, and although an RDBMS is used extensively,
MySQL in this case, we are looking at options, and are currently
doing more and more work using a NoSQL Solution, probably te most
popular one by now, namely MongoDB.
And before you complan: NoSQL is not a good term, but someone
with a longer NoSQL background should then find something better,
not yours truly. And for all intents and purposes, you know what
I am talking about, right?
I plan to post a few MongoDB posts here, how it looks like from
an RDBMS dudes (like myself) POV. This is the first installment,
but there will be more. I should also point out that I am no
expert in NoSQL technologies in general, nor specifically in
MongoDB, but I am trying, and our MongoDB setup is large and
complex enough to serve as a decent example: We have a …
Oct
03
2011
tl;dr : New 'automatic' optimistic conflict detection functions
available giving the best of both optimistic and pessimistic
replication on the same data
MySQL replication supports a number of topologies, and one of the
most interesting is an active-active, or master-master topology,
where two or more Servers accept read and write traffic, with
asynchronous replication between them.
This topology has a number of attractions, including :
- Potentially higher availability
- Potentially low impact on read/write latency
- Service availability insensitive to replication failures
- Conceptually simple
…
[Read more]
Sep
30
2011
Topics for this podcast:
*Cloud M&A potential around OpenStack
*Oracle’s commercial extensions for MySQL
*Puppet Labs rolls out Enterprise 2.0, hosts PuppetConf
*Basho bolsters Riak distributed data store in NoSQL race
*Our latest special CAOS report, ‘The Changing Linux Landscape’
iTunes or direct download (25:59, 4.4MB)
Sep
30
2011
Proof-of-concept Tungsten support for MongoDB arrived last
May, when I posted about our hackathon effort to replicate from MySQL to
MongoDB. That code then lay fallow for a few months
while we worked on other things like parallel replication, but
the period of idleness has ended. Earlier this week I
checked in fixes to Tungsten Replicator to add one-line installation support for MongoDB
slaves.
MySQL to MongoDB replication will be officially supported in the
Tungsten Replicator 2.0.5 build, which will be available in a few
weeks. However, you can try out MySQL to MongoDB …