What is most valuable?
MySQL is open-source. There are a lot of open-source communities trying to come up with their own patches, and to come up with their own features, which help MySQL develop faster than traditional databases like Oracle, which is closed source.
The solution is also compatible with a lot of other databases, like Percona, and it's compatible with MariaDB. It's also compatible with a lot of other shared database solutions.
Since MySQL is mostly used as a relational database in a lot of organizations, a lot of other solutions are being merged with MySQL and it's a rather easy process.
Unlike a lot of closed source services, the new features are solely based on customer feedback. The customer feedback of open source is way larger than the closed source application.
What needs improvement?
The developers of MySQL, which are Oracle MySQL, Percona, and MariaDB, seem to not be focusing much on object-oriented replication. Basically, replication is based on a text level of replication. There is a text level replication in Oracle, that is so similar it can be implemented in MySQL, however, it needs to pull a lot of resources. They have altered their approach for replication. Still, more focus on object-oriented replication would be good.
They should come up with a better solution than the NDB cluster for better scaling. If they could come up with a better solution for write scaling, apart from the NDB cluster, which is supported by all open source communities, that would be great. Although the NDB cluster, I believe, is an open-source tool, it's not widely supported as a solution.
My understanding is there are a lot of features in MySQL 8.0, the latest release, which I'm not too familiar with yet.
For how long have I used the solution?
While I have just been at this company for the past two and a half years, and have been working on MySQL since I began here, I have about 12 years of experience in total with the solution.
What do I think about the stability of the solution?
MySQL is reliable. If you are talking about it in terms of relational databases, MySQL is pretty stable. If you want to go ahead with a quite secure database like any PCR database or a customer-related database or even a bank-related database, it's still feasible that you can migrate to MySQL.
What do I think about the scalability of the solution?
There are a lot of features provided by Oracle MySQL, Percona, and MariaDB. They all have their own replication cluster. Percona has XtraDB, MariaDB has GaleraDB, Oracle MySQL has its own cluster as well. MySQL replication is common in all three organizations.
There is one cluster called the NDB cluster, which has been supported and developed by Oracle, and is based on MySQL. This is different than all of the other clusters. It's very scalable in the other clusters are all re-scalable, but they are not write scalable. NDB cluster is the only cluster feature recorded by Oracle MySQL, which is write scalable as well as re-scalable.
How are customer service and technical support?
The solution seems to have plenty of technical support due to the fact that there are three companies who are product owners, and therefore there are three companies who are supporting MySQL. They are: Oracle, Percona, and MariaDB. They're doing pretty well.
There are a lot of companies also that support their customers. This is the good thing about any software which is open-source. A lot of open source communities come up with their own features and they try to patch up with the original source.
How was the initial setup?
The initial setup has evolved a lot. It's pretty straight forward whether you're using Mac, Windows, Linux, etc. You can set it up on almost every operating system.
It's supported by the open-source community, and they have plenty of documentation online that users can reference for assistance. If you are working in almost any operating system and you have any questions related to the installation, you'll find the documentation you need.
What's my experience with pricing, setup cost, and licensing?
I am not sure, what the licensing costs are for the solution. From my experience, there is no straightforward cost. You can get that cost from the Oracle website about the Oracle MySQL licensing costs, however, it's not a straightforward price code for everyone.
If you are an existing customer, you can negotiate and you can get a better quote. The pricing on the website may be for new customers. That said, you can still negotiate. The same is true for Percona and MariaDB as well.
What other advice do I have?
We are using MySQL 5.6, 5.7, and MySQL 8.0.
In terms of advice, I'd say when implementing MySQL, if a company has been using any previous relational database, like Oracle, Microsoft SQL or DB2, the easiest way to migrate from any database is from Oracle to MySQL. There'll be some challenges from Microsoft SQL, as well as from DB2 to MySQL. Any existing application which is working with the Oracle database as a backend database, DB2 database as a backend database, or Microsoft as the backend database, they will still work fine with MySQL.
MySQL is a product supported by a lot of applications and a lot of organizations. Almost every client and every API would be able to support MySQL. There still will need be a lot of testing, however, I don't think there would be any application that wouldn't be able to support MySQL due to the fact that it's widely supported.
I'd rate the solution nine out of ten.