I have several websites with a reasonable number of users running on both MySQL and Postgres. On the balance I think I prefer MySQL - I find the replication in

I have several websites with a reasonable number of users running on both MySQL and Postgres. On the balance I think I prefer MySQL - I find the replication in MySQL quite a lot simpler and the issues are not that big of a deal, and well known. Although I will say that both databases are fixing their faults as time goes on. For example Postgres is getting easier to configure replication and as of MySQL 5.7 the silent truncate default STRICT_TRANS_TABLES/STRICT_ALL_TABLES is fixed (although generally implementations I've used set SQL_MODE='STRICT_ALL_TABLES' by default, so it hasn't been an issue).