Stopping Azure Database for MySQL flexible servers will also stop incurring cost?

Thank you so much for the response. Additional query: How to compute the storage cost? So we can determine if its meaningful to stop it or just leave it as is.

We only have 1 database in the server.

This is the detail compute of the service.

We only have local redundancy and no geo-redundancy.

Thank you.

NLE JB,
To compute the storage cost for your Azure Database for MySQL flexible server, here’s a structured breakdown of the important factors:

Key Components for Cost Calculation

1. Storage Size
   • You have set your storage size to 20 GiB.
   • Azure charges on a per GiB per month basis, so knowing the unit cost is essential.
2. Storage Redundancy
   • You chose Locally Redundant Storage (LRS), which is typically less expensive compared to geo-redundant options.
3. Billing Approach
   • The service charges for the provisioned storage capacity (20 GiB) regardless of usage.

Cost Calculation Steps

1. Find the price per GiB
   • Check Azure's pricing page for the latest rates specific to your region and storage type (LRS for MySQL Flexible Server).
2. Compute Monthly Storage Cost
   • Assuming the cost per GiB per month is $0.10 and there is no additional cost for IOPS:
     Storage Cost:

              - 20 GiB×$0.10/GiB/month=$2.00/month20 GiB×$0.10/GiB/month=$2.00/month
     

   • Backup Storage Cost:

     - If backups are stored separately and the backup size is equivalent to the database size:
     
           - 20 GiB×$0.10/GiB/month×7 days=$1.40/month20 GiB×$0.10/GiB/month×7 days=$1.40/month
     

   • Total Monthly Cost:
   • $2.00+$1.40=$3.40/month$2.00+$1.40=$3.40/month

Considerations for Stopping the Server

• Cost Comparison: Compare the calculated monthly storage cost against potential savings from stopping the server.
• Requirements: Ensure that stopping the server won't disrupt your business activities or lead to data loss.

Decision Making:

• Compare the Cost with Benefits:
• Evaluate if the cost of $3.40/month is justified by the benefits of keeping the database active.
  • Consider factors like the importance of the data, frequency of access, and potential downtime costs.

Next Steps

1. Access Azure Pricing Calculator: Visit the Azure Pricing Calculator to input your specific parameters and get an exact monthly estimate.
2. Evaluate Your Needs: Based on the calculated costs, assess the necessity of keeping the server on versus stopping it.

This structured approach will give you a clear understanding of whether to keep the server running or stop it based on economic considerations.

Thank you for that wonderful insight. I have additional info here:

this is the estimated cost as per viewing the cost compute of the service.

since it was mentioned that if the service was stop the compute cost (in this case 18.98 usd/month) will also stop. But since the storage is used (in this case 20GiB) and based on the image above its 20 x 0.14 so the cost estimated total is $2.8. Is this correct?

Thank you.

NLE JB
. Based on the details provided, here is the breakdown of the estimated costs:

1. Compute Cost: USD 18.98/month
2. Storage Cost: 20 GiB at USD 0.14 per GiB20×0.14=USD 2.8020×0.14=USD2.80

However, the image you referenced shows the storage cost calculated as:

20×0.14=USD 2.7620×0.14=USD2.76

This slight discrepancy might be due to rounding or a variation in the pricing model. The total estimated cost mentioned in the image is USD 21.74/month, which includes both compute and storage costs.
For more details, refer to Azure pricing calculator.
If you have any further queries, please let us know. I am happy to help you.
If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread.

NLE JB
Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.