We currently run MSSQL 2005 with updatable transactional replication. I
would like a compare MySQL to MSSQL when it comes to replication. I have
several people telling MySQL replication smokes MSSQL replication.

Does anyone know of any good articles on this subject?

Thanks in advance,

Bret

I worked with MySQL 4.1. It works and works well for certain types of work
loads. Yahoo (from what I understand) is the largest installation of MySQL
replication. Basically they only offer a form of transactional replication.
It seemed to me that it was not as fast as Microsoft SQL Server replication,
but this could have been due to the hardware.

So if you don't need the features of SQL Server replication, and if you have
no high throughput requirements you might want to look at MySQL.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]