In Indian data centers (Central and West India), the public previews of Azure Database for MySQL and for PostgreSQL are available. And, their services provide the app developers with the ability to choose from an even wider number of geographies, and deploy their favorite database on Azure, without the complexity of managing and administering the databases.
Azure Database for MySQL
It provides a managed database service for app development and deployment which allows you to stand up a MySQL database in minutes and scale on the fly – on the cloud you trust most.
With inclusive pricing models, you get all the capabilities you want – like high-availability, security, and recovery – all built in, at no extra cost.
Azure Database for MySQL features tight integration with Azure Web Apps, along with popular content management apps, such as Word Press and Drupal, to deliver fully integrated services that enhance your applications and lighten the burden of database management.
Creating an Azure database for MySQL in India
To create a MySQL database in the Azure portal, do the following.
- Log in to the Azure portal.
- From the left menu, click New> Data + Storage > MySQL Database.
In the New MySQL Database page, configure your new MySQL database.
- Database Name- Type a uniquely identifiable name
- Subscription - Choose the subscription to use
- Database Type - Select Sharedfor low-cost or free tiers, or Dedicated to getting dedicated resources.
- Resource group - Add the MySQL database to an existing resource group or put it in a new one. Resources in the same group can be easily managed together.
- Location - Select a location close to you. When adding to an existing resource group, you're locked to the resource group's location.
- Pricing Tier - Click Pricing Tier, then select a pricing option (Mercurytier is free) and then click "Select".
- Legal Terms - Click Legal Terms, review the purchase details, and click Purchase.
- Pin to dashboard - Select if you want to access it directly from the dashboard. This is especially helpful if you aren't familiar with portal navigation yet.
The following screenshot is just an example of how you can configure your MySQL database.
When you're done configuring, click "Create".
You will see a pop-up notification letting you know that deployment has started.
You will get another pop-up once the deployment has succeeded. The portal will also open your MySQL database page automatically.
Azure Database for PostgreSQL
Azure Database for PostgreSQL provides a managed database service for app development and deployment which allows you to stand up a PostgreSQL database in minutes and scale on the fly – on the cloud you trust most.
With inclusive pricing models, you get all the capabilities you want – like high-availability, security, and recovery – built in, at no extra cost.
Azure Database for PostgreSQL is a managed database service that makes it easier to build apps without the management and administration burden. The service uses community edition of PostgreSQL and seamlessly works with native tools, drivers, and libraries.
It has capabilities of managed services such as automated patching, backup and restore capability, monitoring, alerting, logging, etc. There is a unique opportunity for Microsoft to do something more and better than other cloud providers, specifically in areas such as reliability, security, and elasticity so as to make it simple and worry free for developers.
To create a MySQL database in the Azure portal, do the following.
- Log in to the Azure portal.
- From the left menu, click New> Databases> Azure Database for PostgreSQL.
- To create a new PostgreSQL database in one of the India data centers, follow the Create process, choosing a new logical server in one of the India data centers (Central or West India).
Solutions and Samples
The sample PostgreSQL applications available on GitHub allow you to deploy your sample Day Planner app using node.js or Ruby on Rails on your own Azure subscription with a backend PostgreSQL database. The Day Planner App is a sample application that can be used to manage your day-to-day engagements. The app marks engagements, displays routes between them, and showcases the distance and time required to reach the next engagement.
It also supports deploying Azure Web Apps with a MySQL database backend as a template on GitHub.
Developers can accomplish seamless connectivity for their PostgreSQL and MySQL service using native tools and continue to develop using Python, node.js, Java, PHP or any programming language of choice. It supports development with your favorite open source frameworks such as Django, Flask, etc., and the service will work seamlessly.