Make a backup database server using the XenServer cloning feature

Test environment

Requirements: will present a primary database server (for short, a machine, WindowsServer2008 installed MySQL database, data volume more than 40 million), the system is a VM created using XenServer, to do a real-time backup. Because the amount of data is too large. The initial data import export takes too long to take 10 to 20 hours. So use the following ideas.

Will be a machine, using xenserver cloning function, copy vm .... = = Select: Fast clone, instantly complete cloning, clone machine for short B machine. Then the A, B machine start.

First, do the following on the B machine:

1, change the IP address, host name.

2, edit the database (MySQl) Data folder under the Auto.cnf file, change the database UUID, hex, can change a bit.

Second, then on the AB machine according to the normal main standby database Setup method to operate. Restart the ab machine after the MySQL service OK.

Backup: When backing up a database, a table in the library does not need to be backed up and can be added in the My.ini of the standby machine:

replicate-ignore-table= database. Table

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>

Make a backup database server using the XenServer cloning feature