Clustering Solution

Hi,

I'm interested in peoples thoughts on the best choice for a database clustering solution.

I have a database that is mostly varchars and numbers that doesn't store any binary data at all. It's used at about 70% read and 30% writes - though we're using memcached at the moment so it's not really hit that hard.

We're currently using mysql with m/cluster, but are interested in a new solution. Possible candidate so far are unicluster (which doesn't seem mature yet.) or DRBD.

Had anyone had a similar experience and can make any suggestions?

Thanks

Todd Hoff's picture

Re: Clustering Solution

If you are feeling experimental CouchDb at http://couchdb.org/CouchDB/CouchDBWeb.nsf/Home?OpenForm may be an interesting technology to watch.

I am curious what about mysql cluster has you looking elsewhere?

The simple approach is to just use a master slave approach with its asynchronous binary log replication. Will this not work for you?

Re: Clustering Solution

Hi,

We are also exploring unicluster and wondering how has your experience been so far with it? Have you explored any other options. The fact that unicluster is not stable might lead to problems later on. Please advise

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd><div ?=?><p ?=?> <img ?=?><h1 ?=?><h2 ?=?><h3 ?=?>
  • Lines and paragraphs break automatically.
  • Glossary terms will be automatically marked with links to their descriptions
  • You may link to webpages through the weblinks registry

More information about formatting options

To combat spam, please enter the code in the image.