Sunday
Sep092007
Clustering Solution
Sunday, September 9, 2007 at 3:12PM
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
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
Reader Comments (2)
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?
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