mysql 开启热备份_mysql怎么实现热备份

[mysqld]

#主从备份

#log-bin=mysql-bin

#binlog_format=mixed

server-id=2

replicate-do-db=mydb

replicate-ignore-db=mysql

replicate-ignore-db=test

replicate-ignore-db=information_schema

replicate-ignore-db=performance_schema

replicate-wild-ignore-table=mydb.000%

replicate-wild-ignore-table=mydb.tmp%

replicate-wild-ignore-table=mysql.%

replicate-wild-ignore-table=test.%

replicate-wild-ignore-table=information_schema.%

replicate-wild-ignore-table=performance_schema.%

relay_log=mysql-relay-bin

log-slave-updates=ON