MySQL is Great
April 27, 2016
MySQL is Great
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with MySQL
I'm using MySQL as the database for several web-based applications that I have deployed in my organization, each of which addresses a specific need. Examples include:
- OTRS - helpdesk ticketing solution
- OpenAtrium - intranet site
- Xibo - digital signage
- Redmine - project tracking application
- JobberBase - job posting website
- MySQL is extremely stable. I never have to reboot due to low resources, though I use it in a Linux environment.
- MySQL is robust. I've never experienced a failure or lost data in 10+ years of use.
- MySQL is easy to use, especially when combined with phpMyAdmin, which gives it a front-end. phpMyAdmin is itself very impressive and allows an administrator to backup/restore, create new databases, add data, remove data, queries, etc. Very powerful.
- MySQL is powerful yet has low hardware requirements. The applications that I use with MySQL are not heavily used, so MySQL meets my needs well. You could run an intranet site with a GB of RAM and an older processor, I visualize all my instances.
- If you do not use phpMyAdmin you have to learn the commands that are needed at the command line. Still easy to use, but if you don't know the commands you are dead in the water.
- MySQL has many limitations that I am aware of (Google it), but for limited use in my environment for my open-source applications it's perfect.
- MySQL has only had a positive impact on my business, as I use it as the backend database on open source applications. I have paid nothing for the software and it has proven to be extremely reliable and powerful. No concerns.
I have used MySQL more than PostgreSQL and thus find is easier to use, both are very powerful and are open source. I am using PostgreSQL in another application I am hosting and it also works flawlessly.
I did not consider Microsoft SQL for the instances where I use MySQL because the cost is far too high. I only use MSSQL where I cannot use MySQL for whatever reason.
I did not consider Microsoft SQL for the instances where I use MySQL because the cost is far too high. I only use MSSQL where I cannot use MySQL for whatever reason.