Should I use MySQL?

Question

Typically, MySQL could be considered a good option for smaller businesses or organizations that don't have a large or sophisticated data team. This is because of its low costs and simple setup process, as well as the widespread support of a huge community.

When should you use MySQL?

MySQL is ideal for storing application data, specifically web application data. Additionally you should use MySQL if you need a relational database which stores data across multiple tables. As MySQL is a relational database, it's a good fit for applications that rely heavily on multi-row transactions.

Why you should not use MySQL?

Don't use MySQL if another DBMS is going to prove cheaper / better value. Other leading DBMSs like Oracle or SQL Server have many features that MySQL does not. Also if your employer already has a large investment in other DBMSs it may be prohibitively expensive and difficult to support MySQL without good reason.

Is MySQL a good choice?

As the world's most popular DBMS – with 39% of developers using it in 2019 – MySQL is a fast, reliable, general-purpose, relational database management system. Although it lacks the extensive features of PostgreSQL, it's an excellent match for a wide range of applications – especially web applications.

Is it safe to use MySQL?

MySQL provides robust data security to protect data including secure connections, authentication services, fine-grained authorization and controls, and data encryption.

Expert · Answer