How do I use Database Horizontal Scaling

With CloudJiffy you can be able to scale both SQL and NoSQL databases:



Each newly added database server has its own host name (which consists of DB name, node ID and environment’s host) and credentials for administrator access, that you’ll receive in separate email notifications after addition.

The scaling out approach for database servers implies a completely new node addition, i.e. created servers will have the default content (the existing databases and records of the initial DB server won’t be copied to the new instances). In such a way, after increasing the number of database nodes, you’ll receive a set of independent servers.

Tip: You are also able to automate database horizontal scaling based on incoming load with the help of tunable triggers.

You can also reset the password not just for a separate DB server, but for the whole set of databases in case it’s necessary to regain administrator access for all of them:



For ensuring your data security and gaining the increased performance, it makes sense to configure the replication between the servers of your DB cluster. CloudJiffy provides you with two flows to setup a DB cluster:
  • automatically via installation widget
  • manually with the detailed step-by-step guides

Manual Replication

Sometimes, it may be preferable for your DB cluster to include more than just two servers or you may want to set up replication for the already existing environment with your application deployed. In such a case, please, follow one of the instructions below (depending on the chosen database system):
  • MySQL/MariaDB Master Slave Replication
  • MySQL/MariaDB Multi Master Replication
  • PostgreSQL Master Slave Replication
  • MongoDB Master Slave Replication
  • MongoDB Replica Set
  • Docker-Based Couchbase Cluster

We are also going to automate these operations in the nearest future in order to make our platform even more easy-to-use and to save your time for coding.

 


Was this article helpful?

mood_bad Dislike 0
mood Like 0
visibility Views: 12841