azure-database-scaler:事件驱动的逻辑应用程序和函数应用程序,可以按比例放大或缩小Azure数据库服务实例的

  • V2_170624
    了解作者
  • 4.2MB
    文件大小
  • zip
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-04-09 10:25
    上传日期
天蓝色数据库扩展程序 事件驱动的Azure逻辑应用程序和功能应用程序,用于按比例放大或缩小Azure数据库服务实例的容量 面向Azure数据库以在此项目中进行扩展: 放大/缩小什么? vCores( ) 储存空间( ) 如何按比例放大/缩小? 当Azure Monitor Metric Alerts触发了azure-database-scaler时,它开始更改vCore容量或存储大小(警报提供程序必须是Microsoft.DBforMySQL或Microsoft.DBforPostgreSQL ) azure-database-scaler可以按以下方式放大或缩小实例的相同数据库层和相同计算代(Gen4 / Gen5)内的vCore数量: 基本等级:1 <-> 2 通用等级:2 <-> 4 <-> 8 <-> 16 <-> 32 内存优化层:2 <-> 4 <-> 8 <
azure-database-scaler-master.zip
  • azure-database-scaler-master
  • images
  • webhookhandler-url.png
    1MB
  • alert-configuration-steps.png
    1MB
  • slack-authorization-steps.png
    1.1MB
  • architecture-overview.png
    450KB
  • azure-cloud-shell-bash.png
    1007.5KB
  • scripts
  • setup-logicapp.sh
    1.2KB
  • update-functions-app-settings.sh
    1.7KB
  • setup-functions.sh
    2.2KB
  • setup-storage.sh
    501B
  • project.conf.example
    1.2KB
  • project.conf
    1.5KB
  • mysqlslap.sh
    484B
  • logicapp
  • LogicApp.parameters.json
    312B
  • LogicApp.json
    5.1KB
  • docs
  • HOW-TO-SETUP-ALERTS.md
    344B
  • HOW-TO-DEPLOY-APP.md
    4.8KB
  • functions
  • common
  • Define.csx
    1KB
  • Model.csx
    329B
  • webhookhandler
  • run.csx
    5.6KB
  • function.json
    475B
  • dbscaler
  • run.csx
    14.6KB
  • project.json
    453B
  • function.json
    216B
  • LICENSE
    1KB
  • README.md
    3.6KB
  • CHANGELOG.md
    355B
内容介绍
# azure-database-scaler Event driven Azure Logic App & Functions App that scale-up or scale-down the capacity of your Azure database service instance ### Targets Azure Databases to scale in this project: - [Azure Database for MySQL](https://azure.microsoft.com/en-us/services/mysql/) - [Azure Database for PostgreSQL](https://azure.microsoft.com/en-us/services/postgresql/) ### What to scale up/down? - vCores ([What is vCore?](https://docs.microsoft.com/en-us/azure/mysql/concepts-pricing-tiers#compute-generations-vcores-and-memory)) - Storage Size ([What is Storage size?](https://docs.microsoft.com/en-us/azure/mysql/concepts-pricing-tiers#storage)) ### How to scale up/down? - azure-database-scaler starts changing vCore capacity or Storage size when it was triggered by Azure Monitor Metric Alerts (Alerts providers must be either `Microsoft.DBforMySQL` or `Microsoft.DBforPostgreSQL`) - azure-database-scaler scale-up or scale-down the number of vCore within the same database tier & the same compute generations (Gen4 / Gen5) of your instance in the way like: - Basic Tier: 1 <-> 2 - General Purpose Tier: 2 <-> 4 <-> 8 <-> 16 <-> 32 - Memory Optimized Tier: 2 <-> 4 <-> 8 <-> 16 <-> 32 - azure-database-scaler only scale-up the Storage size (Not scale-down supported). It can increase the Storage size by the amount of `StorageScaleupSize`(GB) parameter value to specify in [project config file](scripts/project.conf) for each scale-up action triggered by Azure Monitor Metric Alerts until the Storage size reaches `MaxStorageScaleLimit`(GB) parameter value to specify in [project config file](scripts/project.conf). `MaxStorageScaleLimit`(GB) should be within the follwoing storage size range: - Basic Tier: 5 GB to 1 TB (1024 GB) - General Purpose Tier: 5 GB to 2 TB (2048 GB) - Memory Optimized Tier: 5 GB to 2 TB (2048 GB) ### Alert Metrics, Alert Operator, and Actions to be triggered |Alert Metric|Metric display name | Operators to match | Action | |---|---|---|---| |`cpu_percent`|CPU percent| `GreaterThan` or `GreaterThanOrEqual` | scale-up vCore capacity| |`cpu_percent`|CPU percent| `LessThan` or `LessThanOrEqual` | scale-down vCore capacity| |`storage_percent`|Storage percent| `GreaterThan` or `GreaterThanOrEqual` | scale-up Storage size| |`storage_used`|Storage used| `GreaterThan` or `GreaterThanOrEqual` | scale-up Storage size| |`storage_limit`|Storage limit| `GreaterThan` or `GreaterThanOrEqual` | scale-up Storage size| For the detail on the supported metrics, please see [supported metrics for Azure Database for MySQL](https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics#microsoftdbformysqlservers) or [supported metrics for Azure Database for PostgreSQL](https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics#microsoftdbforpostgresqlservers) ### Architecture: ![](images/architecture-overview.png) Relevant Services: - [Azure Database for MySQL](https://azure.microsoft.com/en-us/services/mysql/) - [Azure Database for PostgreSQL](https://azure.microsoft.com/en-us/services/postgresql/) - [Azure Functions](https://azure.microsoft.com/en-us/services/functions/) - [Azure Logic Apps](https://azure.microsoft.com/en-us/services/logic-apps/) - [Azure Monitor Alerts (Classic)](https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-overview-alerts) - [Slack (for notification)](https://slack.com) ## Documents - [How to deploy the database scaler app](./docs/HOW-TO-DEPLOY-APP.md) - [How to setup Azure Monitor Metric Alerts for Autoscaling(Classic Metric Alert)](./docs/HOW-TO-SETUP-ALERTS.md)
评论
    相关推荐
    • database viewer
      Universal database tool with report builder. Viewing, editing, and printing data; building SQL queries; building reports; sorting and filtering; viewing and printing structure; searching and replacing...
    • FileDatabase
      AppWizard has created this FileDatabase application for you. This application not only demonstrates the basics of using the Microsoft Foundation classes but is also a starting point for writing your ...
    • AccessDatabaseEngine
      未在本地计算机上注册"microsoft.ACE.oledb.12.0"提供程序解决办法
    • AccessDatabaseEngine
      Microsoft.ACE.OLEDB.12.0 未在本地计算机上注册“microsoft.ACE.oledb.12.0”提供程序解决办法
    • Database
      Database
    • database systems
      数据库基础论论知识,刚开始学数据库的人最好的读物之一!
    • Microsoft Office database2007.rar
      Access database engine2007 插件,解决 关于“未在本地计算机上注册“Microsoft.Ace.OleDb.12.0”提供程序”问题。 安装完后,在注册表中可发现 HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\...
    • 微软Access Database Engine 2010
      Access Database Engine 2010访问MS Access 的驱动。
    • AccessDatabaseEngine
      未在本地计算机上注册“Microsoft.ACE.OLEDB.12.0”提供程序,需要安装相应版本的数据访问组件AccessDatabaseEngine。
    • Database Concepts
      Database Concepts, 6th Edition- David M Kroenke, David J Auer 经典的国外原版数据库教程,概念浅显易懂,图文并茂