4 ms·

>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 obvi

>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.

resca79 12y ago
Shocked for what? Mysql is a good choice for many cases. Please you should explain why mysql is better than postgres?
- imanaccount247 12y ago
  >Mysql is a good choice for many cases Name one. Mysql is horribly broken.
  - taf2 12y ago
    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 12y ago
      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.
bascule 12y ago
Postgres has great developer ergonomics but can be extremely challenging operationally at scale. Also: finding good Postgres DBAs is difficult.
Killswitch 12y ago
MySQL is a very good database. Especially if you use MariaDB.
- imanaccount247 12y ago
  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 12y ago
    How is this correct, mysql has synchronous replication. does Postgres have something equivalent to galera?
    - imanaccount247 12y ago
      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.

resca79 12y ago

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

imanaccount247 12y ago
>Mysql is a good choice for many cases Name one. Mysql is horribly broken.
- taf2 12y ago
  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 12y ago
    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.

bascule 12y ago

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

Killswitch 12y ago

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

imanaccount247 12y ago
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 12y ago
  How is this correct, mysql has synchronous replication. does Postgres have something equivalent to galera?
  - imanaccount247 12y ago
    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.