Scalr fully supports MySQL and provides great features to manage efficiently your databases thanks to its Super Fast Engine.
Super Fast MySQL Engine – The database is often the slowest component of web architecture. Scalr features automatic MySQL scaling that can divide reads and writes to speed up the application.
Auto-scaling – When Scalr detects the load has increased above a defined threshold, it will launch a new instance and automatically configure it as a new slave of the current master.
Failover – If one of your master instances becomes unavailable (hardware fault, server crash, alien invasion), Scalr will detect it and trigger its failover command. It will promote one of the slave servers to be the new master, and reconfiguring the other instances to replicate from this new master.
MySQL replication and stats – It’s hard to diagnose and check the health of large databases. Scalr provides a database dashboard that gives you data such as replication stats (e.g. seconds_behind_master and operations per second).
DNS Management – Scalr creates endpoints for you to configure your application to use. When servers fail, Scalr detects it and removes that record from the DNS zone. This means that reads and writes directed at that endpoint will no longer hit the failed server.
Within Scalr you can change all your MySQL database settings
Like all database roles, the options menu contains a MySQL status page.
The MySQL status page allows you to check on the databases’ replication status, last backup (a dump), and last data bundle (binary snapshot).
The MySQL status page allows you to check on the databases’ replication status, last backup (a dump), and last data bundle (binary snapshot).