Description
Book SynopsisTake a deep dive into the Azure SQL Database Hyperscale Service Tier and discover a new form of cloud architecture from Microsoft that supports massive databases. The new horizontally scalable architecture, formerly code-named Socrates, allows you to decouple compute nodes from storage layers. This radically different approach dramatically increases the scalability of the service. This book shows you how to leverage Hyperscale to provide next-level scalability, high throughput, and fast performance from large databases in your environment.
The book begins by showing how Hyperscale helps you eliminate many of the problems of traditional high-availability and disaster recovery architecture. You''ll learn how Hyperscale overcomes storage capacity limitations and issues with scale-up times and costs. With Hyperscale, your costs do not increase linearly with database size and you can manage more data than ever at a lower cost.
The book teaches you how t
Table of Contents
Introduction
Part I. Architecture.1. The Journey to Hyperscale Architecture in Azure SQL2. Azure SQL Hyperscale Architecture: Concepts and Foundations
Part II. Planning and Deployment3. Planning an Azure SQL DB Hyperscale Environment 4. Deploying a Highly Available Hyperscale Database into a Virtual Network 5. Administering a Hyperscale Database in a Virtual Network in the Azure Portal6. Configuring Transparent Data Encryption to Bring Your Own Key7. Enabling Geo-replication for Disaster Recovery8. Configuring Security Features and Enabling Diagnostic and Audit Logs9. Deploying Azure SQL DB Hyperscale using PowerShell10. Deploying Azure SQL DB Hyperscale using Bash and Azure CLI11. Deploying Azure SQL DB Hyperscale using Azure Bicep12. Testing Hyperscale Database Performance Against Other Azure SQL Deployment Options
Part III. Operation and Management13. Monitoring and Scaling 14. Backup, Restore and Disaster Recovery15. Security and Updating16. Managing Costs
Part IV. Migration17. Determining whether Hyperscale is Appropriate 18. Migrating to Hyperscale19. Reverse Migrating Away from Hyperscale
Conclusion