Large cross-platform database for scalable applications
Updated April 29, 2021

Large cross-platform database for scalable applications

Jose Manuel Ortega | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with MySQL

We use MySQL mainly as a database management system for small applications oriented to the management of resources of the different projects that store information related to the employees, either for the management of tasks or to allocate the hours that each employee registers in the project. We generally use it together with the PHP programming language and Apache Web Server using the LAMP distribution (Linux + Apache + MySQL + PHP).
  • Easy integration with development tools and environments, as well as connection with different programming languages
  • The support for handling transactions allows recovering from failures in operations and thus maintain data integrity.
  • Efficient use of resources at the memory and CPU level
  • Cross-platform support for different operating systems
  • Lack of documentation for a large percentage of MySQL utilities, for example the aspect of data replication for certain cases there is no documentation.
  • Some experience is required to configure and tune it to the project requirements.
  • Migration from standard SQL is sometimes not automatic and requires manual migration.
  • As it is an open source solution through community solution, we can use it in a multitude of projects without cost license
  • The acquisition by Oracle makes you need to contract support for the enterprise version
  • If you have knowledge about oracle databases, you can get more out of the enterprise version
  • I have taken courses and certifications about Oracle and despite the price of some I recommend them since it allows you to be updated on how the market has evolved and how it will evolve in the coming years.
  • Certifications also give you the possibility to certify your knowledge in order to collaborate with clients and partners.
MongoDB is an application oriented solution with unstructured data. Percona Server for MySQL is a good solution when looking for performance peaks and the amount of data grows continuously over time. MySQL is the ideal solution when we have a data schema defined and we do not have great requirements at the performance level.

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

  • It is a suitable database for web applications where we have a large size of users. It is also easily scalable and provides good user management and access controls at the security level.
  • MySQL is a very fast database to read when using the non-transactional MyISAM engine, but it can cause integrity problems in high-concurrency environments when modifying. Thus, for applications with many parallel transactions and modifications, MySQL is probably not the best solution