Postgres vs MySQL: Which one is more difficult to scale out?

Question

From your experience, which database serve is more difficult to scale? MySQL or Postgres? I know MySQL has several out-of-the-box scaling/clustering features, but with Postgres there is none that comes out-of-the-box. CMIIW.

EDIT:

Sorry for the confusion here, my question is referring to scaling out (horizontal scaling), i.e clustering, sharding, etc. I know both can scale horizontally, but which one is easier to implement?

Thank you for sharing.

Answer 1

MySQL is A LOT easer to scale out, clustering and replication are both native and really easy to manage and implement (even for someone that doesn't really have databases knowledge).

PostgreSQL only supports basic replication for now, and nothing official about clustering (technically you can via 3rd party tools, but it becomes a hell to manage).

I would never choose Postgresql if I plan to scale out.

Answer 2

While this question appears to go against the "Avoid asking subjective or argumentative questions" tenet of the site I can't resist trying an answer.

It depends.

Are talking about a single server configuration that scales to very large datasets?
Both can work in this situation depending on the dataset, but neither will probably perform very well without custom configuration and proper planning. In my experience when working on large datasets with lots of writes I've found Postgres has fewer conditions that cause blocking and overall performance was better.

Are you talking about multi server configurations that scale to many slaves for many readers?
MySQL has historically been considered the leader in this space since it came with asynchronous replication built in. This is no longer the case if you're not opposed to using the newest DB software; Postgres now also has this built in with the release of 9.0. My experiences with MySQL's replication have been more than adequate to this point.

Are you talking about multi server configurations that scale to many masters for many writers?
This is by far the most difficult way to scale either product and many times can be avoided through the use of failover servers. If you really do need to scale out for high availability of master servers addons/alternate installs cannot be avoided. For MySQL there is MySQL Cluster NDB which has an open source option or a commercial version. For Postgres there are many addons that can get you varying levels of HA and pooling

In the long run the scaling of your database typically comes down to design planning. If your application is designed with scale in mind then the db system that matches best to your developers is often the best choice.

Answer 3

PostGre has more features and configuration options.

Thus it's likely it's more difficult to scale, but it's also likely that it will scale better, that is, if properly configured.

Generally, MySQL will probably still be faster, on the other hand, the real question is how much do you value data integrity, and what features do you need, and do you want to depend on Oracle (now owns MySQL) ?

Answer 4

Postgre is best to practice SQL queries but not for real use. It has got very limited support and resources. Postgre is not a good solution to implement a complex app.