SQL Server Performance Forum – Threads Archive
Migration to MySQL?From a "price point of view" migrating from the actual platform (2 node cluster Windows server 2003 with SQL Server 2000 Enterprise Edition)to MySQL can be very attractive.
In fact our management starts to think that way…
My question is related to the faisability of this operation in a critical production cluster server. Is it recommanded?
Pros and Cons?
Why yes and why no.
If you ask this question on a MSSQL forums you would get <b>NO</b> as expected [<img src=’/community/emoticons/emotion-5.gif’ alt=’‘ />].<br />But your management should think about performance than to cost (budgeting), and you can run this on a test bed to mock the realtime load in order to check how good the both applications are performing.<br /><br />I cannot say ‘why’ No, as I don’t have any experience or need to work on MYSQL.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
You should make up your own mind on this. Check out the details of MySQL clustering over at the their site and compare them to SQL Server. But remember, not everything is about performance. And reliability and stability DO play a mayor role in the game. —
Microsoft SQL Server MVP