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.