If you are reading this, it means that world moves on and
somebody somewhere was wrong in predicting the end of it. The
ageless Log Buffer Edition presents you yet again some cool blog
posts just before the holiday season to top up your excitement.
This Log Buffer #300 is as sweet as the holidays...

Yesterday I was asked by a customer for the reason why he had
failed to achieve scale with a state-of-the-art "shared-storage"
cluster. "It's a scale-out to 4 servers, but with a shared disk.
And I got, after tons of work and efforts, 130% throughput,
not even close to the expected 400%" he said.

Well, scale-out cannot be achieved with a shared storage and the
word "shared" is the key. Scale-out is done with
absolutely nothing shared or a "shared-nothing"
architecture. This what makes it linear and
unlimited. Any shared resource, creates a tremendous burden
on each and every database server in the cluster.

In a previous post, I identified database engine
activities such as buffer management, locking, thread
locks/semaphores, and recovery tasks - as the main bottleneck in
the OLTP …

Mike Hogan, CEO of ScaleDB spoke at the Boston MySQL User Group
in September 2009:

ScaleDB is a storage engine for MySQL that delivers shared-disk
clustering. It has been described as the Oracle RAC of MySQL.
Using ScaleDB, you can scale your cluster by simply adding nodes,
without partitioning your data. Each node has full read/write
capability, eliminating the need for slaves, while delivering
cluster-level load balancing. ScaleDB is looking for additional
beta testers, there is a sign up at http://www.scaledb.com.

I gave it during RAC Attack in Chicago and I’m
pretty satisfied with how it went, so there should be no
significant changes to the presentation. The session is in “User
Group Forum,” thanks to RAC SIG and Dan Norris.

Have you ever heard the one about throwing hardware at a software
problem? In one of my previous blog posts, I mentioned something
along the lines of?well I’ll just cut and paste . . . In my
experience, the solution to most problems (the ones the caller
refers to as “it’s running slow”) are not rooted in [...]

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.