Mysql is still the king of the Hill !
August 01, 2016

Mysql is still the king of the Hill !

Franck Leveneur | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with MySQL

Mysql is being used across the while organization. MySQL is able to scale to our company's need, serving 10,000s of transactions per second. By adding slaves, we can quickly scale "reads" ; queries requiring to read only data vs adding data or updating / deleting existing ones.
  • Replication: Setting up Mysql replication is fairly easy. Replication is robust and stable and with Mysql 5.7, new features will allow to take replication to another level. (Multi-source)
  • Configuration: Mysql allows to configure some "variables" live without restarting the server.
  • Scales: Mysql can scale pretty well if properly configured and architected in the application eco-system.
  • Optimizing queries can be challenging. Having a tool to trace some queries could be useful.
  • Roles: Adding support for user role would be useful. Currently done via "proxy" i believe but it seems a little tricky.
  • Positive Impact. Mysql is well known and understood by developers.
  • Positive : Cost: The cost of Mysql ownership is very low compare to MS SQL and Oracle
  • AWS : Combining Mysql with EC2 instance makes it easy to create new server, facilitate the admin part.
Cost: StartUp companies don't have the money to invest large amount of money in pricey databases. By using Mysql, the saving is huge.
Mysql is well suited for large scale transactional environments. A clear example is a recent post from an Uber engineer who switched from Postgres to Mysql. The fact that Facebook uses Mysql speaks for itself.
FullText search is weak on Mysql, this is understandable as the amount of data we deal with today are in the GB.
ES, Sphix, or Solr are better choices for searching text.
Mysql can scale for data warehouse up to a certain limit and certain type of queries.
ColumnStore architecture is the way to go : RedShift, SnowFLake, MemSQL, and MariaDB Beta of ColumnStore are better choices.