4 ms·
My perception is also that replication was lately the only advantage Mysql had over Postgres in general. My main problem with mysql is that I have seen too man
by lazyant 16y ago
My perception is also that replication was lately the only advantage Mysql had over Postgres in general.
My main problem with mysql is that I have seen too many data corruptions and I can't find anyone who has worked with both systems and doesn't recommend in general pg over mysql.
- moe 16y agoFWIW, Dead-simple replication is in the current postgres beta and due to enter stable soon. Here are the docs: http://developer.postgresql.org/pgdocs/postgres/hot-standby.html http://developer.postgresql.org/pgdocs/postgres/hot-standby.... Oh, and unlike the MySQL replication this implementation can not silently lose or corrupt data. In fact the above document could also be considered "The missing Manual for MySQL replication". It tells you all the things that MySQL doesn't take care of.