MySQL for non-critical workload needs
Updated April 26, 2020
MySQL for non-critical workload needs
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with MySQL
MySQL is used within the whole organization as one of the two primary RDMBS. It is the underlying RDBMS database for the internal and external company records, hosted on Oracle PaaS.
- Best in breed in open-source RDBMS databases.
- Portability with our secondary database Oracle Database without much scheme changes.
- Scales well with IaaS.
- Some restrictions on the table sizes and schemes (unlike IBM DB2, Oracle DB, etc).
- Issues with some of the SQL operations ( merge join, hash join, etc) that degrades the overall performance of the queries.
- Licensing from Oracle for MySQL use can be improved.
- Positive ROI due to reducing licensing cost for use internally.
- Since it is well known, support from a third party is cheap and available when needed.
MySQL provides the option to reduce support and maintenance cost when P0 Level 1 support is not really needed for databases used for noncritical use cases and workloads. Other versions that include Microsoft SQL, Amazon RDS, etc don't provide such options and are overkill. MySQL is also more widely used and easy to hire developers for it than the commercial versions ( Microsoft, Amazon, IBM).