Can Amazon RDS provide a good backup data recovery methods?
Microsoft’s Azure SQL database which is not only a fully managed relational cloud database service but also uses in-built intelligence to identify unique database patterns and automatically tunes the performance and protection of the database. Thus, greatly reducing the efforts required by the user to fine-tune the performance (of the database) which is deciding factor in improving the speed of data accessibility.
Other features include scalability with minimal downtime, in-memory OLTP which improves throughput and latency on transactional processing.
Regarding multitenancy, customer need not compromise on performance, security, and efficiency as Microsoft maximizes resource utility and manages thousands of databases as one.
As a first step in migrating to Cloud for NursesRU, the back up raw data on premises can be into structured form and moved into the cloud. With Microsoft Azure database, bulk unstructured/semi-structured data from on-premises can be transformed and imported into SQL database easily. The below diagram depicts the same.
Currently, data backups are saved in the form of raw data in fireproof safes. This process is not automatic and makes data recovery highly impossible when a major disaster occurs. Therefore, it highly recommended to back up the data in an efficient and automated manner.
Amazon RDS creates automated backups of your DB instance during the backup window of your DB instance. Amazon RDS can be recovered at any point in time during the backup retention period.
DB instance can be run in several Availability Zones; an option called a Multi-AZ deployment. Primary DB instance is replicated across Availability Zones to the secondary instance to provide data redundancy, failover support, eliminate I/O freezes, and minimize latency spikes during system backups.