4 ms·
In my experience when people are able to "fix" performance issues by moving from sql database a to sql database b it's because they understand database b and ho
by jonnypotty 7y ago
In my experience when people are able to "fix" performance issues by moving from sql database a to sql database b it's because they understand database b and how to optimise for it. Not because the database is better or worse. My company was "saved" moving from postgress to mysql. The difference was the guy and his specific knowledge, not the database technology.
- INTPenis 7y agoYeah I agree. In practice now that I've accumulated my own experience I feel that Galera clustering is much better than anything I used in Postgres. So far I've only setup one master/slave cluster with pgpool-II in postgres and it's definitely an OK setup. But I much prefer the usability and stability of Galera/MariaDB for clustering.
- tpetry 7y agoAnd you now know better on how to structure your data because you have done plenty of migrations and changes but couldnt change everything you wanted to because the whole data access logic would need to be rewritten.
- mamcx 7y ago> As early as 2001-2002... from mysql to postgres. MySql was pretty bad in the first versions. I'm in the enterprise/erp development world, and when I look at mysql when it start to show in the radar, I can't believe the joke. MySql get good around 5? Now I can say all major DBs are good enough not matter what you chosee, (still think PG is the best around) but MySql was always the more risky proposition, the PHP of the db engines...