Ask HN: Going from Redis to MySQL. Good idea?

Post by imanaccount247 » Wed, Oct 22, 2014, 5:09 AM UTC

taf2 wrote: post #47

imanaccount247 wrote: post #36

Earlier quoted context omitted.

No, it isn't. No amount of saying that will make it true. It is a database that is missing vital functionality, and which considers data integrity not to be important.

How is this correct, mysql has synchronous replication. does Postgres have something equivalent to galera?

It is correct because mysql is missing tons of important functionality, like I said. You even responded to my other comment listing a small portion of it. No, postgresql does not have an equivilent to galera. Postgresql's synchronous multi-master replication doesn't break constantly and require manual intervention like galera's buggy patch does.

Post by imanaccount247 » Wed, Oct 22, 2014, 5:11 AM UTC

taf2 wrote: post #46

imanaccount247 wrote: post #37

Earlier quoted context omitted.

Just the small list of flaws that we hit trying to use mysql (there's dozens more, and we're not including all the "mysql silently inserts invalid data" gotchas): no check constraints views with aggregates are too slow to be used no expression indexes triggers don't fire on cascaded actions no window functions can't set default values to be the result of a function no transactional DDL doesn't have multiple databases…

Mysql does have a much better durability solution -galera cluster IMO... Does Postgres have something similar?

Galera is not a durability solution. Yes, postgresql has multi-master synchronous replication. It is also not a durability solution.

Re: Ask HN: Going from Redis to MySQL. Good idea?

Re: Ask HN: Going from Redis to MySQL. Good idea?