自动缩放Azure SQL数据库 [英] Autoscaling Azure SQL Database
问题描述
我们有一个使用Azure SQL作为数据库后端的应用程序.在正常负载/条件下，该数据库可以在Premium 1计划上成功运行.但是，在清晨，我们会运行一些作业，这些作业会增加数据库负载.在这几个小时内，我们需要转到Premium 3计划. Premium 3的成本大约是其8倍，因此显然我们不想支付24/7全天候使用此计划的费用.
We have an application that uses Azure SQL for the database backend. Under normal load/conditions this database can successfully run on a Premium 1 plan. However, during the early morning hours we have jobs that run that increase database load. During these few hours we need to move to a Premium 3 plan. The cost of a Premium 3 is about 8 times more, so obviously we do not want to pay the costs of running on this plan 24/7.
是否可以向上和向下自动缩放数据库?云服务提供了一种简便的方法来扩展Azure门户中的实例数量，但是，对于Azure SQL数据库而言，没有类似的东西.可以使用Azure SDK以编程方式完成此操作吗?我找不到有关此主题的任何文档.
Is it possible to autoscale the database up and down? Cloud services offer an easy way to scale the number of instances in the Azure Portal, however, nothing like this exists for Azure SQL databases. Can this be done programmatically with the Azure SDK? I have been unable to locate any documentation on this subject.
推荐答案
仔细研究@ErikEJ的答案中的文章(谢谢！)之后，我能够找到以下内容，这些内容似乎是随着Elastic发行版新发布的.比例预览:
After digging through the articles in @ErikEJ's answer (Thanks!) I was able to find the following, which appears to be newly published with the release of the Elastic Scale preview:
以下REST API现在也新可用了，它使您几乎可以对数据库执行任何操作:
The following REST APIs are now newly available as well, which let you do pretty much whatever you want to your databases:
对于我最初提出的扩展服务层的问题(例如P1-> P3-> P1):
And for my original question of scaling service tiers (ex. P1 -> P3 -> P1):
有了这些新的发展，我将假设自动缩放还可以作为Azure门户中的简单配置(就像云服务一样)在时间上是一个时间问题.
With these new developments I am going to assume it's only a matter of time before autoscaling is also available as a simple configuration in the Azure Portal, much like cloud services.
这篇关于自动缩放Azure SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
