Try our new research platform with insights from 80,000+ expert users
reviewer2599590 - PeerSpot reviewer
Student at a university with 10,001+ employees
Real User
Top 20
Extensive resources and advanced indexing drive large-scale database success
Pros and Cons
  • "It is an established open-source database with a vast array of resources available, ensuring you can learn everything needed."
  • "There could be improvements, particularly in Firebird, where the indexing is limited to just a single B-tree index, leading to poor performance for large-scale queries."

What is our primary use case?

My primary use case of MySQL has been in a project during my college studies.

What is most valuable?

The InnoDB engine in MySQL is quite advanced, especially in terms of indexes and indices, compared to Firebird. MySQL is designed for large-scale databases, making it a fantastic option for environments requiring extensive resources. 

It is an established open-source database with a vast array of resources available, ensuring you can learn everything needed. It also provides quick and pluggable options and is well-documented.

What needs improvement?

There could be improvements, particularly in Firebird, where the indexing is limited to just a single B-tree index, leading to poor performance for large-scale queries.

For how long have I used the solution?

I have been using MySQL for one to two years.

Buyer's Guide
Oracle MySQL Cloud Service
December 2024
Learn what your peers think about Oracle MySQL Cloud Service. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.

What do I think about the stability of the solution?

MySQL is a stable product and widely used due to its reliability.

What do I think about the scalability of the solution?

I'm probably the wrong person to ask because my use cases only cover college projects, and I might not recognize the scale of an actual deployed product. However, relational databases, in general, are not known to be as scalable as NoSQL databases.

How are customer service and support?

I haven't interacted with official customer service. The availability of community support and documentation for MySQL is extensive and easily accessible.

How would you rate customer service and support?

Positive

Which solution did I use previously and why did I switch?

My work with databases has been more academic than practical, focusing on understanding the code base of MySQL, PostgreSQL, and Firebird rather than using them in a traditional manner.

How was the initial setup?

The initial setup of MySQL is very straightforward. I would rate it as a nine out of ten for ease of setup.

What's my experience with pricing, setup cost, and licensing?

I have only used the community edition and do not have experience with the enterprise edition or its pricing.

What other advice do I have?

I would recommend MySQL to others due to its extensive resources, speed, and suitability for large-scale databases. 

Overall, I rate the solution as a nine out of ten.

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user