MySQL Forums
Forum List  »  NDB clusters

Re: Example of Cluster SLOWER than InnoDB -- help?
Posted by: John Muehlhausen
Date: December 08, 2004 03:55PM

Heikki Tuuri wrote:

> a power outage can crash all NDB nodes at the same
> location at the same time, unless you use an
> uninterrupted power system.

Thanks-- our nodes are on separate power drops in an Equinix facility with batteries and generators and fuel truck routes all planned out and everything. We've never lost power and I don't think we will.

> On the other hand, if you use a disk drive with a
> battery-backed disk cache, then fsync() is very
> fast and the penalty of running with
>
> innodb_flush_logs_at_trx_commit=1
>
> is small. Thousands of commits per second should
> then be possible.

Are you talking about something like http://www.superssd.com ? I've thought about that in the past but am a little concerned about scaling the system in terms of MySQL server load (parsing, query plans, etc, etc). The nice thing about cluster (on paper, anyway) is that I can add MySQL servers as needed on the same transactional storage engine.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

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.