[imanaccount247]

>moving from redis

Yes. It is a very poor choice for your needs.

>to mysql

No. It is a very poor choice in general.

>What other databases

Postgresql obviously. I'm honestly shocked that people are still considering mysql in 2014.

[bascule]

Postgres has great developer ergonomics but can be extremely challenging operationally at scale. Also: finding good Postgres DBAs is difficult.

[resca79]

Shocked for what? Mysql is a good choice for many cases. Please you should explain why mysql is better than postgres?

[imanaccount247]

>Mysql is a good choice for many cases

Name one. Mysql is horribly broken.

[taf2]

Mysql is fast and easy to scale and make durable, what features of database do you really use that is not met by, fast, durable and scalable... Sounds more like perhaps some sort of belief rather than data?

[imanaccount247]

That does not answer the question. Postgresql is faster than mysql, easier to scale than mysql, and is already durable without having to do anything to it. Saying "it is almost as good as postgresql" does not mean it has a use case.

[Killswitch]

MySQL is a very good database. Especially if you use MariaDB.

[imanaccount247]

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.

[taf2]

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

[imanaccount247]

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.