MySQL Multi-instance backup

Received a task in recent days, to the online database to make a master-slave backup ~

Personal is a database small white, usually is the most conditional search this, received this task a little startled, but the task is the task, because, the task is to be completed! I'm just going to take the opportunity to learn a database ~

First of all, talk about a few problems, and then slowly correspond to find a solution:

1. How to manage multiple MySQL instances on one host?

Limited resources, only one host to back up the MySQL on multiple machines, so how can I run multiple MySQL on a single machine, it must be to include different ports, search MySQL multi can be configured to manage multiple instances,

Specific configuration, but also after the experiment to come back to record ~

2, how to configure the master-slave framework

This is the core of the work, how to configure the implementation of Master-slave ~ to be tested

3. How to synchronize for the first time

The first thing to be clear is that the online business is not stopped, which means that the primary database can not be stopped, then how to make the first backup? This is a question that cannot be ignored ~ to find the answer

4. Highly Available solutions

Standby running multi-instance, then can not be traditional at the machine level of high availability, to do from the instance level of high availability ~ How to operate, to find the answer

5, how to ensure the performance of multiple instances

It is understood that multi-instance performance does not increase with the number of CPUs, there is a bottleneck, then I need to do is to bind the instance to different CPUs to improve performance.

Now can think of problems such as, follow up to do supplement ~

MySQL Multi-instance backup