On January 15th, 2008 Piotr Kolaczkowski (not verified) says:
1. "MySQL is designed to scale out with replication. It has the best replication of any database I have used"
We did believe in it until we tried to create a project for a large network of music shops in Poland. A project where DB/2 or Oracle should have been used. MySQL replication is a toy not ready for any production environment. There are far too many serious bugs in it. The setup doesn't survive master or client's server's crash and requires bringing the whole system down to repair. This is ridiculous. Actually it causes more problems than it solves. The system that works "most of the time" is not what we mean "PRODUCTION READY". The same applies to anu other open source database system.
2. "That being said, MyISAM is great for WORM applications like data warehousing". You must be joking? Great? Maybe slightly better than InnoDB, but still far from what DB/2 or Oracle can do. Data warehousing WITHOUT materialized views and range indices? ROTFL. PostgreSQL and MySQL are no good for DW.
You mus be joking
1. "MySQL is designed to scale out with replication. It has the best replication of any database I have used"
We did believe in it until we tried to create a project for a large network of music shops in Poland. A project where DB/2 or Oracle should have been used. MySQL replication is a toy not ready for any production environment. There are far too many serious bugs in it. The setup doesn't survive master or client's server's crash and requires bringing the whole system down to repair. This is ridiculous. Actually it causes more problems than it solves. The system that works "most of the time" is not what we mean "PRODUCTION READY". The same applies to anu other open source database system.
2. "That being said, MyISAM is great for WORM applications like data warehousing". You must be joking? Great? Maybe slightly better than InnoDB, but still far from what DB/2 or Oracle can do. Data warehousing WITHOUT materialized views and range indices? ROTFL. PostgreSQL and MySQL are no good for DW.