[davidp]

I like to trot out this old gem[1] when people wonder why there's so much hate for MySQL.

Nontransactional DDL alone is sufficient to classify it as a toy DB for me. Yes, I've been personally bitten by it.

[1]: https://grimoire.ca/mysql/choose-something-else

[misframer]

According to [1] Oracle doesn't have transactional DDL either.

[1] https://stackoverflow.com/questions/4711447/oracle-ddl-and-t...

[cdubzzz]

This talks a lot about 5.5 and mentions that 5.6 is “due out soon”. The current release series is 5.7. How much of this is outdated and how much has stayed the same?

[lstamour]

Some things are improving — for example: https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html

And https://mysqlserverteam.com/new-defaults-in-mysql-8-0/

Previously on HN: https://news.ycombinator.com/item?id=5122299

Personally, I only use MySQL and derivatives where I have to (basically WordPress.)

[dsp1234]

"Some statements cannot be rolled back. In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines." [0]

[0] - https://dev.mysql.com/doc/refman/5.7/en/cannot-roll-back.htm...

[baud147258]

I like the part "We used it because it was there. Please hire some fucking software developers and go back to writing elevator pitches and flirting with Y Combinator."

[jjeaff]

Well, you should school those fools at Google, Facebook, Twitter, Pinterest, Amazon... and tell them how they are wasting time with their toy MySQL databases.

[zimpenfish]

> those fools at Google, Facebook, Twitter, Pinterest, Amazon

... have dedicated hundreds of engineers and millions of dollars to nothing more than keeping MySQL up, running, and not crapping the bed every time someone looks at it funny. If you can afford that resource expenditure, by all means go nuts with MySQL. Most companies can't and would be far better served by something which doesn't need that amount of handholding to serve its basic purpose.