MySQL Shines In The Right Situations
Use Cases and Deployment Scope
We use MySQL to run the database back end of our company websites and a handful of OLTP applications. It provides a lightweight relational database system that is easy to manage and low in cost. Because we use the free version, support can be iffy, but, generally, it just runs without issue.
Pros
- Read heavy operations
- Simple setup
- Cross-platform support
- Large community
- Cloud integration
Cons
- Write heavy workloads
- Horizontal scalability
- Analytic workloads
- Lack of advanced features
Likelihood to Recommend
<div>High read/low write applications such as websites is where MySQL's ease of setup and general usage really shine. It is open source and coupled with it's cross-platform availability allowing it to run on Linux makes for an extremely low-cost RDBMS solution.</div><div>
</div><div>Larger companies with higher budgets may want to look at more enterprise level solutions (SQL Server, Oracle, etc...) for larger OLTP and OLAP workloads for their scalability and support.</div>
