MySQL: Good Old Database
December 27, 2018

MySQL: Good Old Database

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with MySQL

MySQL is being used across our entire organization for various databases. Various different teams use MySQL and rely on it to maintain their backend application. We implement monitoring and metrics for MySQL to ensure we are getting the best performance out of our databases.
  • Store Data
  • Easy Query Language
  • Simple to setup
  • Currently owned by Oracle
  • MySQL doesn’t support full outer joins
  • MySQL doesn’t support working with arrays
  • Open Source means lots of development and improvements from the community
  • Almost all developers know how to use MySQL
  • Easy to setup and configure
  • Lots of tooling
After Oracle bought MySQL, I have pivoted some projects to use MariaDB instead, which is a fork of MySQL and maintained by the community and original developers of MySQL. This is free under the GNU GPL, and is not impacted by decisions Oracle makes for MySQL. RDS has the ability to run managed MySQL instances which make it even easier to setup and configure a database. RDS also has support for MariaDB.

InfluxDB is a great Time Series DB Platform which was designed to collect measurements with timestamps, and works more efficiently than MySQL for this type of data. I would recommend InfluxDB for anyone who is on the fence about implementing a collection agent and having the stats go into MySQL or another Database system
MySQL is well suited to be a backend database to store data. Since MySQL has been around for many years, lots of people know how to set it up and use it, making it easy to get support or bring on new developers on a project using MySQL. Previously, I've seen MySQL being used as a queuing system, which was not really what it was designed for, and lead to stability issues when scaled up.