I am interested in people's opinions on MySQL vs SQL Server. Our database is fairly simple; no stored procedures, and we use NHibernate as our ORM layer. I would like to make a case for switching from SQL Server to MySQL cluster on Linux. We need an enterprise level, clustered DB with failover and load balancing. Any opinions pro or con would be very much appreciated!
+1
A:
What scenario of failover/load balancing are you considering? Are you considering HAProxy?
Cade Roux
2010-07-04 13:27:26
Thanks! very useful link. We don't have a detailed scenario for how failover/load balancing will work, other than the basic: failover fried server, and balance load over multiple servers. The issue with master slave is replication latency, since it is asynchronous.Also, we would need to split the reads and writes. Which is possible, since we have NHibernate layer. MySQL cluster is synchronous, and load balanced, so this is why I am looking at it. SQL Server has no load balanced cluster solution.
Jacko
2010-07-05 02:01:37