Shulou(Shulou.com)06/01 Report--

# enable slave log so that chain replication can be carried out

Log-slave-updates=1

# whether the slave library is read-only. 0 means read-write, 1 means read-only.

Read-only=1

# copy only a table

Replicate-do-table=tablename

# copy only certain tables (matches are available)

Replicate-wild-do-table=tablename%

# copy only a library

Replicate-do-db=dbname

# copy only certain libraries

Replicte-wild-do-db=dbname%

# do not copy a table

Replicate-ignore-table=tablename

# do not copy some tables

Replicate-wild-ignore-table=tablename%

# do not copy a library

Replicate-ignore-db=dbname

# whether the copied sql statements are cleared from the relay log immediately. 1 means to clear immediately.

Relay-log-purge=1

# from the server host, used for show slave hosts to generate slave library list

Report-host=hostname

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.