What is our primary use case?
The primary use case is as a reporting solution, data collection, data manipulation, and similar tasks. We install MySQL on Linux and Windows machines for testing our enterprise application.
We are a solution provider and this product is part of our offering to our clients.
How has it helped my organization?
MySQL hasn't really affected our organization, specifically because we primarily use it in a consulting model.
What is most valuable?
All of the databases basically have the same set of features.
What I've been most pleased with is the cost point, performance, and ease of use.
It is very easy to configure, it's easy to deploy, and it's cross-platform capabilities are quite nice.
What needs improvement?
The analytics features are in need of improvement. They aren't as far along as the capabilities that you have in terms of analytics for SQL Server and Oracle.
For how long have I used the solution?
I have been using MySQL for about five years.
What do I think about the stability of the solution?
I've had no problems with stability and its recovery processing, error processing, and things along those lines have been fine. We always use Java applications and the JDBC drivers work fine.
I haven't had any issues at all with its reporting or its transaction processing, or anything else.
What do I think about the scalability of the solution?
For our use-cases, the scalability is fine. We haven't seen any issues and we're processing probably hundreds of millions of rows each day. We're not into the billions or tens of billions, so we're probably a medium-to-low use case.
Most of our instances are single-instance databases, so I haven't had to deal with its clustering capabilities or distributed database feature set.
Our clients vary in size, although we generally operate as a small system inside a major organization.
How are customer service and technical support?
I have never had to utilize technical support. There was never an issue that I had to call in.
Which solution did I use previously and why did I switch?
I use a lot of databases including MySQL, Microsoft SQL Server, Oracle, and PostgreSQL.
The performance of SQL Server and Oracle is better than MySQL. The two alternatives have other features, as well.
How was the initial setup?
The initial set up very straightforward. MySQL is easy to deploy and very easy to configure. We can literally bring up instances in minutes.
What's my experience with pricing, setup cost, and licensing?
This product has a good price point.
Which other solutions did I evaluate?
We had been on SQL Server and Oracle, and a subset of our customers wanted us to switch and use MySQL. We explored what that transition would take and then implemented it.
What other advice do I have?
My advice for anybody who is looking into implementing MySQL is to start by carefully evaluating their use cases. One of the things that we found is that MySQL didn't necessarily have all of the flexibility for JSON and XML processing at the time. I know that they've improved it, although it's not quite the same as what you see specifically in Oracle. So, the customer has to evaluate that. For straight-on basic transaction processing, it's worked out just as well with few issues from SQL Server to MySQL or from Oracle to MySQL.
For my use, I'm fine with what they have. I'll be interested in what they'll provide in analytics, as well as JSON and XML processing if that's even on their roadmap. For right now, it's really not an impact on my use case.
If I were rating SQL Server or Oracle then I would rate either one a nine out of ten. The only difference is that they do perform better than MySQL, although they don't perform so much better than it's relevant.
I would rate this solution an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.