Re: MySQL vs MS SQL Server clustering

[Stewart Smith]

Let's say you have a 200GB database.

Let's say four data nodes, two replicas

this means that you will need 400GB of memory across four machines - or 100GB in each.

This still costs a lot however. Likelyhood is that you don't need all of that data accessible all the time. Cluster what you really need and use replication for the rest (e.g. old data, images, blobs)

You should probably contact our sales team and they'll be able to help you work out a potential solution using MySQL and compare it to MSSQL

Stewart Smith, Software Engineer - MySQL Cluster
MySQL AB, www.mysql.com

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html