Item: MySQL
Rating: 8
Author: Verified User

Overall Satisfaction with MySQL

Use Cases and Deployment Scope

MySQL is important to critical aspect of my organizations software product experience. It helps us with transaction management, account data management , know your customer verification documentations and auditing trails etc
Overall, MySQLas our RDBMS of choice for key applications goes beyond merely being a backend infrastructure tool, it helps shape a trustworthy and reliable experience for users of our products.

Pros and Cons

Pros

Strong Query performance as a result of its B-tree indexing capabilities.
MySQL functions with minimal maintenance
Large and active user community.
Proven ACID ( atomicity, consistency , isolation , durability ) compliance.

Cons

Limited JSON capabilities.
Basic text search capability.
Slow with complex joins and full table scans.

Return on Investment

For an organization like mine, it is always our goal to prevent financial data corruption situations whereby someone makes a transfer and the money doesn't get to the destination, meanwhile their cards have been debited. MySQL being ACID compliant eliminates this prospect.
Building with MySQL ensures that we are able to iterate features faster because it is a well known ecosystem, where we have easy access to an abundance of documentation , developers , libraries etc
MySQL is cost efficient because it is open source.

Usability

I find MySQL very usable. Perhaps, it is the RDBMS with the most familiarity with backend engineers globally. However, MySQL being highly usable comes with specific contexts , especially as it relates to use-case. MySQL is easy to setup, and its documentations are readily available and comprehensive.

Key Insights

Do you think MySQL delivers good value for the price?

Yes

Are you happy with MySQL's feature set?

Yes

Did MySQL live up to sales and marketing promises?

Yes

Did implementation of MySQL go as expected?

Yes

Would you buy MySQL again?

Other Software Used

Slack, GitLab, Atlassian Jira

Likelihood to Recommend

MySQL performs well with applications that require security of data which is critical for a finance organization like mine. For example, a core part of our backend infrastructure is built on MySQL, because of its strong ACID ( atomicity, consistency , isolation and durability ) compliance . Its InnoDB engine ensures that user initiated actions on our applications either finish or do not happen at all and this is very important for a platform like ours where people initiate financial transactions.
For scenarios where MySQL is not appropriate, I wouldn't recommend it for analytics-heavy applications or tasks because these require full table scans, which is not a strong part of MySQL and usually will lead to a halt of other concurrent workloads.

Comments

Please log in to join the conversation

MySQL is our reliable database choice.