What are the points to be considered during running Databases in the Cloud?

Started by Ritu, April 17, 2019, 06:01:27 PM

Previous topic - Next topic

Ritu

Hey everyone,
I can see this forum is the most activate forum regarding all the issues in web hosting. Every-time I have got appropriate guidance without much of delay.
That's why I again chose this platform to clarify my doubt.

My doubt is about cloud hosting. Like nowadays, due to increased cybercrime, I have read that cloud is the best option to save our files. Is it so? Is cloud really safe to run my databases? 
If yes, then what points shall I consider for that?
If no, then why?

Krishnan

Databases hold critical data of an organization. Therefore the cloud infrastructure needs to take care of its storage, CPU, RAM, network, security, licenses, data protection, and backup.
Following are the points that you need to consider while hosting databases in the cloud :

(1) The database on cloud works on the PaaS model. In the PaaS model, the public cloud provider offers you a managed database service which is also called as Database-as-a-Service(DBaaS). In this service most of the administrative tasks including backup, patching, setting up an infrastructure, providing SLA backed availability and scaling up and down of data is handled by a cloud provider.

(2) To ensure the smooth working of the business, it is important that you consider setting up your DBaaS in Multi-AZ setup.

(3) While running databases in the cloud you must ensure that the cloud service protects your data from other tenants and external attacks.

These are the basic points that you should consider on a primary basis.

Keeran

Quote from: Krishnan on April 18, 2019, 04:59:26 PM
Databases hold critical data of an organization. Therefore the cloud infrastructure needs to take care of its storage, CPU, RAM, network, security, licenses, data protection, and backup.
Following are the points that you need to consider while hosting databases in the cloud :

(1) The database on cloud works on the PaaS model. In the PaaS model, the public cloud provider offers you a managed database service which is also called as Database-as-a-Service(DBaaS). In this service most of the administrative tasks including backup, patching, setting up an infrastructure, providing SLA backed availability and scaling up and down of data is handled by a cloud provider.

(2) To ensure the smooth working of the business, it is important that you consider setting up your DBaaS in Multi-AZ setup.

(3) While running databases in the cloud you must ensure that the cloud service protects your data from other tenants and external attacks.

These are the basic points that you should consider on a primary basis.

I agree with the points mentioned here, and would like to add some input from my side.
I think that you shall consider below points during running Databases in the Cloud :

(i) Make the most of the Database Automation -
The speed up tasks like deploying and managing multiple DB instances is a most important task of any DB admin. So if you are hiring a cloud hosting to make sure you get the admin to monitor your cloud database.

(ii) Balance cost and Performance -
There are many providers that may loot you. So be sure that you get the service from the affordable ones, for this you can do some research about the cloud providers. Know your cloud volumes so as to identify your database performance.



Ritu