Easy to set up, maintain, and use. Can't beat MySQL.
Andrew Shell profile photo
February 14, 2017

Easy to set up, maintain, and use. Can't beat MySQL.

Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with MySQL

We use MySQL as the database for all of our products and websites. We have two software as a service (SaaS) products that are set up using master/slave replication and several WordPress sites that also use MySQL as a backend. We're very happy with how easy it is to set up, configure and operate MySQL databases. We use the MySQL Community Edition.
  • It's very dependable. I know how to get it running and keep it running. I don't have to worry about it going down in the middle of the night.
  • For our needs it's fast. Every new version seems to run faster.
  • Easy. MySQL has been around for a long time. There is a ton of documentation and tools to make using it effortless.
  • Setting up replication takes some effort. It's not bad once you've done it, but I still need to reference the documentation every time I need to set up a new slave.
  • Oracle owning MySQL means that they don't put everything into the community edition because they want to sell licenses to their commercial editions.
  • Might not be the best performance at very large scales.
  • The community edition is free so you can get up and running quickly.
  • It's easy to find developers who know how to use it.
  • It's quick and easy to install and use.
A colleague had recommended PostgreSQL to me but I found it was difficult to manage users. Perhaps I am just more familiar with the way MySQL works, but I quickly gave up since I also had no idea how I'd set up replication. MySQL is just incredibly easy to use with little or no experience.
MySQL is my go-to database for all of my PHP applications. I'm not sure how well it's supported in other environments. It would seem a lot of Python apps use PostgreSQL but I found it difficult to configure. If you're deploying a small to medium size app I doubt you could go wrong with MySQL. It's available in most shared hosting environments and all the big open source CMSs support it (WordPress, Drupal, Joomla).