Availability Of Azure Database For MySQL And Azure Database For PostgreSQL In India

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           

Azure Database

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.

  1. Log in to the Azure portal.
  2. From the left menu, click New> Data + Storage > MySQL Database.

    Azure 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.

Azure Database

When you're done configuring, click "Create".

Azure Database

You will see a pop-up notification letting you know that deployment has started.

Azure Database

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.

  1. Log in to the Azure portal.
  1. From the left menu, click New> Databases> Azure Database for PostgreSQL.

    Azure Database
  1. 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).

    Azure Database

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.