Item: MySQL
Rating: 9
Author: Verified User

Overall Satisfaction with MySQL

Use Cases and Deployment Scope

Our proprietary CRM software uses MySQL as one of the databases. Its relational capabilities allow us to maintain data coherently even on a large scale, and making it possible to create the complex representation that is a customer and all the relative data about addresses, billing, preferences and so on.

Pros and Cons

Pros

Connect several data through relations
Keep data coherent with constraint
Fast searches through indexes

Cons

Error debug: it's hard to track down problems with deadlocks or timeouts
Parameters: it's not always easy to understand what values should database parameters have
Storage and memory: indexes occupy a lot of data, and some searches require the DB to have a lot of memory to prevent out of memory errors

Usability

The core features are extremely easy, it's a SQL database and everything is as you'd expect. For advanced parameters though, the docs are pretty extensive and it's not always easy to understand them.

Alternatives Considered

Oracle Database, MongoDB, Google Cloud Datastore and PostgreSQL

MySQL was the first option due to the existing knowledge, and after using other databases, it also appeared to be the most predictable in terms of costs

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?

I wasn't involved with the selection/purchase process

Did implementation of MySQL go as expected?

Yes

Would you buy MySQL again?

Yes

Other Software Used

Google Cloud Datastore, Oracle Database, MongoDB

Likelihood to Recommend

Applications requiring persistent data that need to be related to other data are a perfect use cases for MySQL. On the other hand, when the amount of data is really high, and the "relation" or connected data is not always the same, or when the relations are not so strict, then other databases would be better suited.

Comments

Please log in to join the conversation

Exactly what I expected from a SQL database