Create MySQL from library

We know that Oracle has dataguard real-time backup data, can switch, and MySQL has its own set of library solutions, called Master-slave replication.

To build MySQL from the library is to synchronize the main library data in real time, but also can share the reading pressure of the main library, the database end into a read-write separation structure.

To build MySQL master and slave library note points:

1. The main library and the Server-id from the library must not be the same.

2. Create the replication slave account in the main library.

Grant Replication Slave on * * to ' repl ' @ ' 192.168.0.232 ' identified ' Oracle ';

3. View the Master Library master status

Mysql> Show Master Status \g
1. Row ***************************
file:mysql-bin.000005
position:251651
binlog_do_db:
binlog_ignore_db:
1 row in Set (0.00 sec)

4. Configure the From library

Change Master to
Master_host= ' 192.168.0.232 ',
Master_user= ' Repl ',
-master_password= ' Oracle ',
Master_log_file= ' mysql-bin.000005 ',
master_log_pos=251651;

5. Start from the library

Slave start

Show Slave Status\g

1. Row ***************************
Slave_io_state:waiting for Master to send event
Master_host: ***********
Master_user:repl
master_port:3306
Connect_retry:60
master_log_file:mysql-bin.000005
read_master_log_pos:463725968
relay_log_file:mysql-relay-bin.000006
relay_log_pos:463726114
relay_master_log_file:mysql-bin.000005
Slave_io_running:yes
Slave_sql_running:yes
replicate_do_db: ******************
replicate_ignore_db:
Replicate_do_table:
Replicate_ignore_table:
Replicate_wild_do_table:
Replicate_wild_ignore_table:
last_errno:0
Last_error:
skip_counter:0
exec_master_log_pos:463725968
relay_log_space:873569451
Until_condition:none
Until_log_file:
until_log_pos:0
Master_ssl_allowed:no
Master_ssl_ca_file:
Master_ssl_ca_path:
Master_ssl_cert:
Master_ssl_cipher:
Master_ssl_key:
seconds_behind_master:0
Master_ssl_verify_server_cert:no
last_io_errno:0
Last_io_error:
last_sql_errno:0
Last_sql_error:
Replicate_ignore_server_ids:
master_server_id:100

Attention:

If you slave_io_running:no/ from the library Slave_sql_running:no

Close slave

Set set globalsql_slave_skip_counter=1;
When you turn on slave

Create MySQL from library