What is our primary use case?
I'm not involved from the database side as much. I primarily use it for reviewing the data structure as the architecture before I build a data model in our BI tools.
General querying is pretty much what I do, and also analyzing data types and data structures within the database itself. I review the data structure within them. And I use that to build the data model, which we have in our reporting environment. That's primarily all I use it for.
What needs improvement?
What it would compare it to, from my point of view would be, Microsoft SQL Studio. I find the Microsoft solution a bit better. But mostly in terms of the UI layout, I would say. I just find it a little bit more efficient. But to be honest, I can work equally as well with both.
For how long have I used the solution?
I've been working with MySQL for two and a half years.
What do I think about the scalability of the solution?
We haven't experienced any issues with scalability.
How are customer service and technical support?
I haven't directly contacted their technical support.
I haven't gotten feedback from the IT team.
How was the initial setup?
The initial setup was pretty straightforward. I would have worked with our IT team in terms of the initial setup. In terms of connecting to the database and to the data sources, it is pretty straightforward.
What other advice do I have?
I would rate MySQL a seven out of ten.
To make it a perfect ten, they should improve the UI. It's got quite a narrow range, and there's a lot more obvious to the database side than what I deal with. The UI is not quite as sharp I would say as the Microsoft solution. In some cases, I find that there are better shortcuts available in Microsoft solutions.
If I was choosing, I would probably lean towards Microsoft. That may be just a purely personal preference. My use of MySQL has primarily been from a data integration point of view, a data architecture point of view, and reviewing the database itself, and the data structure, data types. In my role, I don't define data and I don't build the database, I'm purely on the interrogation and the analytics side. I probably would find the Microsoft solution slightly better. But MySQL does absolutely provide what I require from that point of view. So I would recommend it, yes.
Which deployment model are you using for this solution?