//新建服务其它端口的mysql服务1打开mysql的bin目录cdC:\ProgramFiles\MySQL\MySQLServer5.1\bin2创建服务名命令语句+------------------+---------------------------------+---------------------------+||服务名称|配置服务信息文件|+------------------+---------------------------------+---------------------------+|mysqld--installmysql_center--defaults-file=C:\my-opts-center.ini|+----------------------------------------------------------------------+3服务配置文件复制C:\ProgramFiles\MySQL\MySQLServer5.1\my.ini--->C:\my-opts-center.ini修改文件中的port参数datadir参数对应值#TheTCP/IPPorttheMySQLServerwilllistenonport=3306#Pathtothedatabaserootdatadir="C:/mysqldata/centerdata"4服务对应数据存放路径复制C:\ProgramFiles\MySQL\MySQLServer5.1\data--->C:/mysqldata/centerdata5打开服务启动mysql_center的服务配同步数据库是主：127.0.0.1：3307从：127.0.0.1：3309一修改配置文件1主数据库配置文件(C:\my-opts-master.ini)添加下面内容log_slave_updatesserver-id=307binlog-do-db=databaseNameenable-named-pipesocket=mypipe2#slave-skip-errors=1062,1053slave-skip-errors=alllog-bin=center-bin#Don’tresolvehostnamesslave-skip-errors=all#skip-name-resolve#Don’tresolvehostnamesmaster-connect-retry=102从数据库配置文件(C:\my-opts-slave.ini)添加下面内容log_slave_updatesserver-id=309binlog-do-db=databaseNameenable-named-pipesocket=mypipe2#slave-skip-errors=1062,1053slave-skip-errors=alllog-bin=center-binreplicate-wild-do-table=databaseName.tablename1replicate-wild-do-table=databaseName.tablename2replicate-wild-do-table=databaseName.tablename3..replicate-wild-do-table=databaseName.tablenamen#Don’tresolvehostnamesslave-skip-errors=all#skip-name-resolve#Don’tresolvehostnamesmaster-connect-retry=10二执行命令1->分别连接两端数据库(打开两个命令窗口)(1)->主：mysql-uusername-p-P3307(2)->从:mysql-uusername-p-P33092->主：flushtableswithreadlock;3->主：showmasterstatus;mysql>showmasterstatus;+----------------------------+------------+----------------------+--------------------------+|File|Position|Binlog_Do_DB|Binlog_Ignore_DB|+----------------------------+------------+----------------------+--------------------------+|center-bin.000001|106|databaseName||+--------------------------