Data is a core part of every app, at //build a new service that seamlessly migrates third party and SQL Server databases into Microsoft Azure SQL Database with near-zero application downtime was announced on Wednesday.
The new database service simplifies the migration of existing on-premises SQL Server, Oracle, and MySQL databases to Azure, “whether your target database is Azure SQL Database, Azure SQL Database Managed Instance or Microsoft SQL Server in an Azure virtual machine,” wrties the team.
In addition, both Azure Database for MySQL and Azure Database for PostgreSQL options in Azure were made available, too. These new Azure database offerings “run as a service and therefore provide high-availability, data protection and recovery, and scale without downtime” – all built-in at no extra cost or configuration.
Both, Azure Database for MySQL and PostgreSQL, bring in the following common differentiated benefits of the relational database platform services to all applications:
- Provision database server in minutes with built-in high availability that does not require any configuration, VMs or setup.
- Predictable performance with provisioned resources and governance.
- Scale Compute Units up/down in response to actual or anticipated workload changes without application downtime.
- Built-in security to protect sensitive data by encrypting user data and backups as well as data in-motion using SSL encryption.
- Automatic backups with storage for recovery to any point up to 35 days.
- Consistent management experience with Azure Portal, Command Line Interface (CLI) or REST APIs.
Also, in preview a new deployment option within Azure SQL Database called “Managed Instance,” available today, offers near 100% SQL Server compatibility with the benefits of platform as a service!
This includes features like SQL CLR, SQL Server Agent and cross-database querying. If you can imagine a managed SQL Server environment where you continue using instance level capabilities without changing your application design – it’s a real game changer.
Also announced at the //build, Azure Cosmos DB, a globally distributed, multi-model database service delivering turkey global distribution out with guaranteed uptime and millisecond latency at the 99th percentile.
The following are the noteworthy aspects of Azure Cosmos DB’s system design. We will describe these in detail, in future posts.
Azure Cosmos DB allows you to elastically scale across any number of geographical regions while delivering the industry’s only financially-backed database SLAs across availability, latency, throughput, and consistency.
- Enable customers to elastically scale across any number of geographical regions while delivering the industry’s only financially-backed database SLAs across availability, latency, throughput, and consistency. The system should deliver the configured throughput within 5 seconds at the 99th percentile, from the time of the request to scale.
- Azure Cosmos DB automatically indexes data so you can perform blazing fast queries without having to deal with complexities of schema and index management or schema migration in a globally distributed setup.
- Enable customers to build highly responsive, mission-critical applications.
- Ensure that the system is “always on”. The system must provide 99.99% availability regardless of the number of regions associated with their database. To enable customers to test the end-to-end availability properties of the applications, (in steady state) the service must also allow customers to simulate regional failures or mark regions associated with their database offline. This helps validate the end-to-end availability properties of applications.
- Enable developers to write correct globally distributed applications. The system must offer an intuitive and predictable programming model around data consistency. While strong consistency comes with a price, writing large globally distributed applications against an “eventually consistent” database results in an application code which is hard to reason about, is brittle, and rife with correctness bugs.
- Offer stringent financially-backed comprehensive SLAs for 1, 2, 3 and 4 above.
- Relieve the developers from the burden of database schema/index management and versioning. Keeping database schema and indexes in-sync with an application’s schema is especially painful for globally distributed applications.
- Natively support multiple data models and popular APIs for accessing data. The translation between the externally exposed APIs and internal data representation needed to be efficient.
- Operate at a very low cost to pass on the savings to customers.
Today, we enable you to use your choice of container orchestration technology including Kubernetes, Docker Swarm, and Mesos DC/OS with Azure Container Service, which allows you flexibility to use containers exactly how you need.