议题
基于 Azure 存储提供数据的高可用性和高可靠性 数据库服务的高可用 VM1 Primary VM2 VMn 支持异地灾备恢复 3 synchronous copies in Azure Storage 3 asynchronous copies in a remote DC
Power BI, App Services, Data Factory, Analytics, ML, Cognitive, Bot SQL Data Warehouse SQL Database MySQL 预览 PostgreSQL 预览 智能 : 建议, 优化, 监测 Azure 关系型数据库 托管运维平台 灵活 : 按需弹性放缩, 资源管理 可信 : 高可用 / 灾备备份 / 恢复, 安全, 审计, 多租户隔离 Azure 云主机 + 网络 Azure 云存储 全球 38 个数区域据中心 // // 灵活
Azure Global Database Service architecture DB Cluster is decomposed into Azure Service Fabric applications All applications and all DB tenants are individually deployable Databases are services managed by Azure Service Fabric Azure Infrastructure Services Azure Service Fabric Provisioning services Control data store Node connection routing Control Plane Data Plane Connection routing Telemetry SQL DB tenant Resource Governance Node health SQL DW tenant
host OS host OS Drawbridge: A container technology to achieve isolation, security and density in the cloud Modified Windows Kernel to run in user mode, aka Library OS or LibOS Designed for running on Windows and leverages Pico-process feature Pico-process is a NT process with empty address space NT process shared address space ntdll gdi32 user32 400+ NT calls ntoskr nl 800+ Win32 calls win32k Picoprocess picoprocess isolated address space ABI boundary PAL security monitor ntoskrnl 4 5 calls All 1200+ system calls blocked from user-mode (NTOS and win32k) Enforced by 35-line change to KiSystemServiceHandler No perf impact to other processes leverages slow path used by UMS 45 new system calls added to process (Drawbridge system calls) Even hard-coded traps can t break out
LibOS: A user mode runtime library exposing semantics of Windows kernel NT UM Network Stack I/O AFD Wait Pool Object Manager Process Manager Loader Threads APC Memory Manager DRTL Union FS PEB/TEB Simple Heap HE ABI Handler Streams Sync Objects Threads Memory Manager
SQL Platform Abstraction Layer (SQLPAL): Windows and Linux Windows Non-Windows DBMS DBMS Ring 3 Win32 Lib-OS SOSv2 SQLPAL Ring 3 Win32 Lib-OS SOSv2 SQLPAL Ring 0 Host Extension(HE) Windows Kernel Ring 0 Host Extension(HE) Linux Kernel Windows Host Extension has a driver for creating the Pico process and a monitor process (user mode) that implements non-perf related ABIs. ABI calls are handled by the driver and are either handled directly (Like File IO) or are marshalled to the monitor process for handling (like File Open) On Linux everything is in user mode. Main difference is Ring 0 to 3 transition point. And hence no isolation
SQL PAL and SOSv2 Architecture SQL Server Hosted Windows APIs NT User Mode SOS Direct APIs Storage Manager Network Manager Resource Manager Process Manager Object Manager Security Manager Config Manager SOSv2 (Memory, Scheduling, Synchronization) Host Extension and Integration PAL Debugger Extension HE Debugger Bridge 10
后台用的 DB Engine 是 MySQL 社区版本 (Community Edition) 支持现有的 MySQL 客户端和工具 ( 例如 phpmyadmin, MySQL workbench, navicat 等 )
关闭 MySQL 本身的主从复制功能 主库的 Binlog 已经存储于 Azure Storage 在 PaaS 内设置一主多从, 不需要打开 MySQL 本身的主从复制功能 复制 通过外部独立进程, 进行主库 binlog 的解析和从库入库操作 Commit 的性能损耗 > Write 的性能损耗 Write Combine 优化 读 写
数据中心 A Promote 数据中心 B 基于异地副本的恢复 主实例 灾备恢复指标 运维人员通过 Portal 或 Powershell 升级副本为主实例 需要支付异地副本的费用 3 份同步拷贝 3 份同步拷贝
数据中心 A 数据中心 B 基于异地数据拷贝的恢复 DB A 灾备恢复指标 恢复 DB 运维人员通过 Powershell 进行恢复 所有版本具备这个功能, 没有额外费用 3 份同步拷贝 3 份异步拷贝
支持标准的 MySQL Slave 模式 常见混合云场景 通过管理门户配置同步和查看同步状态 o http://www.windowsazure.cn/documentation/articles/m ysql-database-data-replication
Azure 中国官网 https://www.azure.cn/ 提供最新产品与解决方案信息, 技术文档, 以及 SDKs 下载 Azure 应用程序开发说明 https://www.azure.cn/dev-notes/ 概述了海外与中国区服务开发人员需要注意的区别 申请一元试用, 即刻体验 Azure 服务 :https://www.azure.cn/pricing/1rmb-trial-full/ Azure 镜像市场 : https://market.azure.cn/ Microsoft 云科技公众号 Azure 云助手手机 App