Reliable and cost effective
June 02, 2016

Reliable and cost effective

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with MySQL

MySQL is being used in our organization for storing data in a relational model and also for metadata backends for various other types of operational software. MySQL is a great choice for us due to the simplicity of the environment, the ease of use, and the low cost to operate.

Pros

  • MySQL is very easy to install.
  • There are many third-party tools that can be added to the environment.
  • Cost can be low for storing data.

Cons

  • Scaling can become a problem and can affect performance.
  • A basic version of MySQL doesn't come with partitioning.
  • MySQL isn't 100% SQL-compliant, like SQL Server is.
  • MySQL keeps our operational software up and running for a low cost.
  • There's a good ROI on MySQL due to it's low cost. The basic version can be as low as 2K,
  • There's not a learning curve if you know SQL, so no training or consulting is required.
Another option instead of using MySQL would be to use Oracle. However, Oracle can be a pain to administrate, while MySQL is very easy to administrate. There are some functions that Oracle may do better in certain cases, but I would choose MySQL over Oracle 9/10 times due to the administrative hassle of Oracle.
My SQL is well suited for business type applications. In most business, you'll need a some type of area to store operational type data along with metadata. MySQL is a perfect tool for this. Areas where MySQL is less suited are in areas such as data warehousing, geographic applications, GIS data, or logging a high amount of traffic.

Comments

More Reviews of MySQL