One of the best open source solutions in the market of relational database managers.
December 19, 2018

One of the best open source solutions in the market of relational database managers.

Carlos Alberto Pedron Espinett | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with MySQL

MySQL is the database manager used in the organization for the administration of all its databases. We use MySQL because of the need to implement an open source solution for the administration of the databases of the company, the receipt of client information and prompt and timely consultation of that info.
  • Precise queries without many ramifications or connections, queries that do not require a large amount of data processing
  • Allows the hierarchy of database through different schemes or environments which allows having more data to be hosted with conditions and particularities relevant to each one.
  • It provides an excellent option to preserve the protected information. It is reliable and offers a lot of security to its users.
  • Complex queries usually require many resources to obtain results. Other software does not present this situation.
  • MySQL has stopped its evolutionary process since its change of ownership, so the changes it presents have become irrelevant to the operation of the service.
  • Oracle has avoided releasing the code for the detection and correction of errors so the essence of open source has been disappearing
  • With a correct storage of the data and providing them at the time of making consultations generates an extremely positive impact on the line of business because of the speed that this merits in the handling of the information.
  • It is a free code database manager so in its implementation the costs of the same in terms of licensing were non-existent so I represent a significant savings for the company.
  • Regarding the negative aspect, we had to resort to other more powerful database managers to perform complex queries or to host databases that require different treatment.
The three are relational databases or managers for relational database (except for MariaDB whose approach is based on NoSQL models) with the ability to store large databases and respond to demanding business circumstances, however MySQL compared to Microsoft SQL Server represents a solution with an infinitely lower cost and in comparison with PostgreSQL it has a lower response capacity to complex queries and relationships, which ends up being an advantage in favor of PostgreSQL.
MySQL is appropriate in infrastructures that do not require so many relational queries between its databases. It is oriented to the web environment, to the big data environment where the objective should be mainly the storage of information. On the other hand, in projects that are going to require continuous relational queries and that also require transitions of important information or data, MySQL will not provide the necessary response.