Azure MySQL PaaS (3) Create MySQL offsite read-only database (Master-slave)

Windows Azure Platform Family of articles Catalog

　　The azure MySQL PAAs service provides off-site read-only functionality, and we can create MySQL master nodes at primary sites, such as the Azure Shanghai Data Center. The master node can be used for OLTP online transaction processing.

Then, in the Azure Beijing datacenter, create a MySQL read-only node. A read-only node can be used as a report display.

Before you begin this article, note that:

1. This article uses the ASM mode: Azure China, which is connected to the Internet by the century.https://manage.windowsazure.cn

2. We can use MySQL Workbench to manage the MySQL database in the cloud. :https://dev.mysql.com/downloads/workbench/

3. First in the Azure Shanghai Data Center (primary site), create the server name and database, while setting the user name and password

4. Get the connection string to the MySQL PAAs and set the firewall rules

5. Using MySQL Workbench, link to the azure MySQL Shanghai site

6. Create a read-only database (Slave) in the Azure Beijing data center using the UI

Next start the text:

1. Login:https://manage.windowsazure.cn

2. Select New, create a new MySQL Server in azure Shanghai data. Such as:

　　

3. When you are finished creating, select the server name.

　　

Create a new database. Such as:

　　

Set up firewall rules, such as:

　　

4. After setting up, we can link to the MySQL service in Shanghai Data Center via the following information:

Host Name:leimysqlshsvr.mysqldb.chinacloudapi.cn

Username:leimysqlshsvr%mysqladmin

MySQL Workbench After the connection is slightly.

5. Next we create a read-only library in the Azure Beijing data Center.

We click Add Master-slave copy, such as:

　　

　　

6. In the popup window, create a new azure Beijing read-only database, located in North China (Beijing). Note The server name must be unique.

　　

7. Once the creation is complete, you can observe the following:

　　

Note that the primary instance (master) is the Azure Shanghai Datacenter, the azure Beijing data Center is the slave node

	Azure Master Node	Azure Slave Node
Data center	Azure Shanghai	Azure Beijing
Hostname	leimysqlshsvr.mysqldb.chinacloudapi.cn	leimysqlbjsvr.mysqldb.chinacloudapi.cn
User name	Leimysqlshsvr%mysqladmin	Leimysqlbjsvr%mysqladmin
Password	On the UI interface, enter	When the slave node is created, it is automatically obtained from the master node

Finally, don't forget to set the firewall rules for the azure Beijing slave node.

========================================================= delimiter ==============================================

Arm mode first dig anti-...

Azure MySQL PaaS (3) Create a MySQL offsite read-only database (Master-slave)