Being an Open Source database, MySql is one of the most popular database systems used off-late. Combined with PHP, it forms a very formidable combination for Web based systems. Since everything is going the Cloud way these days, I will just compare 2 different ways in which MySql can be made available on a Cloud.
The first method is the Do-It-Yourself (DIY) way, in which you can setup your own version of mysql database over a cloud server, and use it for your applications.
The second method is to use a Mysql system which is available as a Service.(Database as a Service – DbaaS).
DbaaS:
- Rule based Auto Scale up/down
- No downtime during scaling
- Pay per actual usage
- Highly available, self-healing database which never fails
- Zero code changes to application.
- Connection string is very similar to normal method of connection.
DIY:
– Very simple to use for small applications
– Cheaper that DbaaS implementation as the Mysql is free and you only pay for the cloud instance
– Highly complex to scale when usage increases
– Risk of downtimes when usage is high.
Using the DbaaS spares you a lot of time on constant monitoring of the DB during high usage hours. But it is not cheap. If reliability and secure service is your objective , DbaaS is the way to go.
Follow Me!