MySQL, best zero dollars you'll ever spend
November 01, 2017
MySQL, best zero dollars you'll ever spend
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with MySQL
MySQL is being used for smaller projects across our organization. Some of these projects are use to enhance or facilitate functionality of our main products, while others are stand alone products that are just gaining ground. All of our new products are being built using MySQL.
- MySQL is very easy to setup and use. You can create a new MySQL instance in a matter of minutes.
- MySQL comes with a great set of tools out of the box that make database administration as easy as possible. Everything from creating or restoring backups to setting up remote server replication is doable with the built in tools.
- MySQL is highly configurable and can be easily tuned to suit the individual needs of the user.
- Because MySQL is so highly configurable, there is a bit of a learning curve when getting started. Getting setup is easy but research into the different storage engines and tuning parameters is required to make MySQL really efficient for your business needs.
- MySQL uses some non standard SQL syntax by default that can take some getting used to.
- Some SQL standards are implemented in very non standard ways so that tasks are able to be accomplished but the statements created for the task don't translate well to other RDBMS.
- MySQL is very cost effective, giving us the ability to satisfy our data storage needs at a comparatively low price.
- MySQL has a large community which helps us to answer our own questions rather than relying on third party consulting.
- MySQL has a very large developer following making it easier to find skilled employees.
- Oracle Database and PostgreSQL
MySQL holds its own in terms of SQL engine speed and storage capability, but database administration is where MySQL really shines. Other products that I've used offer little in terms of tuning or portability. Managing a MySQL database is relatively painless out of the box and with the use of community provided tools like MySQL Workbench administering your MySQL instance is pretty simple.