MySQL using the PAAs platform above Azure

Some people see this topic may be confused, in the Globe and mooncake version of Azure did not launch this service Ah, here to do an explanation is I am to a domestic e-commerce platform to do the Azure project encountered, in the domestic or belong to private Preview (privately-made previews) is not visible on azure at home.

The following is a brief introduction to this service, the service can only be deployed in the data center of China North, so there are some restrictions on the use, if you want to use the second service, the first need to apply to Microsoft, through the evaluation to determine whether it is available.

Because of latency issues, it is recommended that your app also be placed in the data center of the north.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/5C/06/wKiom1UZAJDzEePYAAIFfCXkHzU869.jpg "title=" Home MySQL (change). png "style=" float:left; "alt=" wkiom1uzajdzeepyaaiffcxkhzu869.jpg "/>

In this case, the ACL control and database backup settings are available:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5C/00/wKioL1UZApTx7kY9AAJJtaQaGZ0453.jpg "style=" float: none; "title=" MySQL backup settings (change). png "alt=" wkiol1uzaptx7ky9aajjtaqagz0453.jpg "/>

To create a new user, set the permissions for the different databases:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/5C/00/wKioL1UZApTxB_MLAAGqI2wVqVg441.jpg "title=" MySQL account settings (change). png "alt=" wkiol1uzaptxb_mlaagqi2wvqvg441.jpg "/>

Use this tool for data migration:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5C/06/wKiom1UZAVrRyZ4CAAGRP9lWo0g983.jpg "style=" float: none; "Title=" Navicat for Mysql.png "alt=" Wkiom1uzavrryz4caagrp9lwo0g983.jpg "/>

1. customers may have special needs, can change the server configuration file

Answer: We currently do not provide the function of parameter change, we are planning to open a part of the commonly used parameters so that users can change, you can change the parameters and why to change the reason Tell background to determine if you can change .

2. Database Server Connection latency is relatively large

A. Now based on azure PAAS platform mysql currently really only supports china North china

3. The client's local database version is too low to upload data to Azure

A : We recommend that customers upgrade to the latest 5.5 versions, in the for data migration.

4.< /span> customer uploads data report wrong: ktv_demo \ data_res ource. MYI

A : This error may be due to the customer's local data Schema of the engine type is not well compatible, it is recommended Change into InnoDB.

This article is from the "jeff-Microsoft Public Cloud" blog, be sure to keep this source http://jeffcsc.blog.51cto.com/8669937/1626469

MySQL using the PAAs platform above Azure