My primary use case of MySQL has been in a project during my college studies.
Student at a university with 10,001+ employees
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?
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.
Last updated: Dec 7, 2024
Flag as inappropriateBuyer's Guide
Download our free Oracle MySQL Cloud Service Report and get advice and tips from experienced pros
sharing their opinions.
Updated: December 2024
Popular Comparisons
PostgreSQL
Firebird SQL
EDB Postgres Advanced Server
Percona Server
Buyer's Guide
Download our free Oracle MySQL Cloud Service Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- When evaluating Open Source Databases, what aspect do you think is the most important to look for?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Which database is the best for session cashing?
- Which low-code (no-code) database solution do you prefer?
- Why is Open Source Databases important for companies?