Overall Satisfaction with MySQL
MySQL is a great database that is used to store data from the users of our applications. It is very reliable and fast, and does not have any downtime. The software engineering department recommends to use MySQL as it is simple to implement and get started.
- It is open source and easily available
- MySQL went from 4 CPU threads to 64 CPU threads, which doubled the number of concurrent connections
- The simplicity in use and startup is great.
- MySQL 5.6, split one of the crucial locks in the MySQL Server, the LOCK_open, which improved the top performance.
- Big users for example Linux are moving to MariaDB which does not look good on MySQL
- There are no patches being released or public roadmaps provided for it.
- You may spend a lot of time and effort to get MySQL to do things that other systems do automatically, like create incremental backups.
- Being open source, ROI is a definite positive.
- The simplicity in use in applications is a great plus, and is a great plus to getting applications up and running fast
I prefer MySQL because of the simplicity of getting started and the ease of use. It has a very simple to use editor where one is able to input their SQL code and execute it from in application.