Database Replication is Here!

In addition to scaling web servers and process servers with a single click, we’re delighted to announce single-click database replication for MySQL, PostgreSQL, MongoDB and Redis databases.

Database scaling

This is what happens when you hit ‘scale up’:

  1. We fire up a new server in your cloud
  2. We install your database server (the same version as the original server)
  3. A full backup of the original server is taken and restored on the new server
  4. The new server is configured as a slave of the master database
  5. The master database is configured according to this new setup
  6. A new set of environment variables are made available to be used in your code and scripts

Why would you use database replication you ask? These are some common use-cases:

  1. Load balancing - write to one database and read from many.
  2. Failover- if something happens to the master database, you can switch to the slave.
  3. Long-running queries- avoids locking tables by not running queries on the production database. Mostly useful for reporting databases.

The actual replication differs by database server, but here are the main aspects of our implementation:

  • MySQL: There is only one master server - all other servers are set up as read-only replicas.
  • PostgreSQL:There is only one master server - all other servers are set up as read-only replicas. Replication is setup as Streaming Replication.
  • MongoDB: Scaling up a MongoDB sets up a replica set, which builds an odd number of servers.
  • Redis: There is only one master server - all other servers are set up as replicas, and any changes on them are overwritten by the master.

For more information, please refer to our documentation. We hope you enjoy this new feature, and as always, let us know if you have any questions!

Khash Sajadi

Khash is the founder and CEO of Cloud 66, a full stack container management as a service. Follow him on @khash

London, UK and San Francisco, US
Subscribe and get updates

Have feedback? Please get in touch @cloud66 on Twitter.

Everything you need to build, manage and maintain containers in production on your own servers and any cloud

Try Cloud 66 — 14 Days Free Trial, No credit card required