3 ms·
AWS WAF might be very useful, but there's only so much you can do when the database is mysql. Postgresql has been around for a while. There's literally no reas
by snvzz 5y ago
AWS WAF might be very useful, but there's only so much you can do when the database is mysql.
Postgresql has been around for a while. There's literally no reason to use mysql except legacy code in life support mode.
- mrweasel 5y ago> There's literally no reason to use mysql except legacy code in life support mode. Multi-master setups? I don't think Postgresql is capable of that yet. Does anyone actually use/depend on a WAF (AWS or others)? It feeling like a clever solution, but also remarkably like snake oil.
- dagw 5y agoMulti-master setups? I don't think Postgresql is capable of that yet. It doesn't support it "out of the box", but there at least two different third-party solutions that add multi-master replication to PostgreSQL.
- snvzz 5y agoThere's also Amazon's own Aurora in postgresql mode. Relevant because AWS context (AWS WAF was discussed).
- paulryanrogers 5y agoMySQL has undo logs while PostgreSQL has vacuum based MVCC. It's a significant difference for some workloads. And MySQL is closer to standard SQL on some things like PL/PSM. I personally still prefer PostgreSQL but can't deny the benefits of a well configured MySQL installation.