mysql主从配置（windowsxp开二个mysql测试）2011-05-2521:12:32|分类：HYPERLINK"http://th9988.blog.163.com/blog/"\l"m=0&t=1&c=fks_087065084081088064093087095095080094089075086082085065"\o"mysql"mysql|标签：|字号大中小订阅环境:个人pcxp一台;使用:官方下载：mysql-noinstall-5.1.36-win32.zip1.解压成2个（文件夹）mysql-5.1.36-win32_1（主）mysql-5.1.36-win32_2（从）2.配置文件修改主服务器配置修改>mysql-5.1.36-win32_1/my-small.ini修改名称为my.ini>修改刚才my.ini文件的[client]port=3307[mysqld]server-id=1port=3307binlog-do-db=testbinlog-ignore-db=backuplog-bin=mysql-bin>启动mysql-5.1.36-win32_1/bin/mysqld.exe--defaults-file=..youpath.my-small.ini>使用主mysql-uroot创建同步角色GRANTREPLICATIONSLAVE,RELOAD,SUPERON*.*TObackup@'127.0.0.1'IDENTIFIEDBY'1234';>并且运行mysql>showmasterstatus;+------------------+----------+--------------+------------------+|File|Position|Binlog_Do_DB|Binlog_Ignore_DB|+------------------+----------+--------------+------------------+|mysql-bin.000001|106|test|backup|+------------------+----------+--------------+------------------+1rowinset(0.00sec)从服务器配置：>mysql-5.1.36-win32_2/my-small.ini修改名称为my.ini>修改刚才my.ini文件的[client]#password=your_passwordport=3308socket=/tmp/mysql.sock#Herefollowsentriesforsomespecificprograms#TheMySQLserver[mysqld]server-id=2master-host=127.0.0.1master-user=backupmaster-password=1234master-port=3307port=3308>启动mysql-5.1.36-win32_2/bin/mysqld.exe(我这会有个警告，没事)>参考主服务器运行的showmasterstatus;数据slavestop;CHANGEMASTERTOMASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=106;slavestart;然后:在主mysql服务器usetestcreatetablett(iiint);然后在从mysql服务器usetestshowtables;mysql>showtables;+----------------+|Tables_in_test|+----------------+|tt|+----------------+1rowinset(0.00sec)