2015

mysql2011/7/27/9:43IT

..

AVA..

..

..

12%..

68..

68

68..

---..

..

K12

mysqlABIP

192.168.1.1(A)

192.168.1.2(B)

mysqlhttp://dev.mysql.com/doc/refman/5.1/zh/replication.html#replicationimplementationdetails

1.mysql

A

#grantreplicationslave,replicationclient,reload,superon*.*tosync_user@192.168.1.2identifiedby123456withgrantoption//B

B

#grantreplicationslave,replicationclient,reload,superon*.*tosync_user@192.168.1.1identifiedby123456withgrantoption//A

#flushprivileges

2./etc/my.cnf

>>>/>

900.00/

PP...

12000.00/

W2...

1500.00/

serverid=1

masterhost=192.168.1.2

masteruser=sync_user

masterpass=123456

masterport=3306

masterconnectretry=60

replicatedodb=db1

replicatedodb=db2

replicateignoredb=mysqlserverid=2

masterhost=192.168.1.1

masteruser=sync_user

masterpass=123456

masterport=3306

masterconnectretry=60

replicatedodb=db1

replicatedodb=db2

replicateignoredb=mysql

1.server_id

2.replicatedodbreplicatedodb=db1,db2

3.replicateignoredb

mysql

#mysqladminurootpshutdown

#mysqld_safeuser=mysql

[1][2][3]B2B1992B2B...www.hc360.com

...www.hc360.com/mvb

...b2b.hc360.com/intro/index.htm

[]

2013 >>

*

ITx86(07.2709:36)TC3600(07.2610:54)LT2002600(07.1914:38)Atempo(07.1208:49)(07.0718:34)(06.2211:32)(04.0108:54)(03.2818:46)(03.1610:04)(02.2809:12)

B2BUB2B.CN 16 70

|||

10

2011

2010PKPC

7232011

3.15

kindle3G (7/27)

2800ES526L3000 (7/27)

(7/27)

0P2055d (7/27)

(7/26)

L (7/26)

(7/26)

3602288

....2010...4..

,

B2BUB2B.CN

()

240w

0.5%

top10

||||||||

0108070700001080707000501062298888010807060999

ICP0100510029

Copyright20002013hc360.com.AllRightsReserved