Database as a service (DBaaS) is a cloud computing service model which provides customers with some form of access to a database without the need for setting up physical hardware, installing software or configuring for performance. This is all taken care by the Vendor themselves.
All of the administrative tasks and maintenance are taken care of by the cloud provider directly. Sounds Very Easy rt ?. Of course, if the customer opts for more control over the database, this option is available and may vary depending on the provider.
The whole reason why you would use a cloud solution is easy scaling. The second point is crucial if you need to be able to do point-in-time restores of individual databases, or be able to easily move databases to separate servers.
Eg. When Techuva (An IOT , ERP Company based on India) had around 50+ IOT devices sending data every 2 minutes.. when they had to scale up to 200+ devices.. they didn’t had run around to buy new servers or buy new hard-discs or enable large servers.. The Auto Scaling helped them to increase from 50 GB HDD to 200 GB HDD and increase from 4 GB ROM TO 16 GB ROM without any downtime. Thanks to AWS RDS.
DB on Cloud and DBaaS enables automates installation, disk provisioning and management, patching, minor version upgrades, failed instance replacement, as well as backup and recovery of your SQL Server databases. Cloud Solutions also offers automated Multi-AZ (Availability Zone) synchronous replication, allowing you to set up a highly available and scalable environment fully managed by Vendors directly.
Well right now : All the DBA features aren’t available on the Cloud DB Solutions, such as :
- You need full control over the database instances, including access to the operating system and software stack.
- You want your own experienced database administrators managing the databases, including backups, replication and clustering.
- Your database size and performance needs exceed the current maximums, or other limits of the Vendor
- You need to use SQL Server features or options not currently supported
So, What are things that you need to worry, When you are data is lying in someone’s Cloud
- Review which IP or Domains have access to your DB.
- Periodically take Backups and Snapshots and store it in a different server.
- Have stronger Password restrictions
- Don’t store Personally Identifiable Information or Sensitive Information in Plain Text.
- Validate all the requests from the application for authenticity using a Hash Key or AuthKey or SessionID to avoid any eavesdrops.
Remember the hacker out there just needs access to your data and he can analyse & sell it to competition at this convenience,
So as a DB Owner / Application Owner – Keeping the dark horses away from your Data is Most Important,
Need some IT Consulting ? talk to our experts free @ firstname.lastname@example.org
Stay tuned …
Techuva Solutions Pvt Ltd.