mysql多台Master对应一台Slave配置

《mysql多台Master对应一台Slave配置》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、PVTOPVTO໮ৄPVTO໮ৄ໮ৄ0DVWHU໮ৄ0DVWHU0DVWHUᇍᑨϔৄ0DVWHUᇍᑨϔৄᇍᑨϔৄ6ODYHᇍᑨϔৄ6ODYH6ODYH䜡㕂6ODYH䜡㕂䜡㕂䜡㕂݇Ѣ԰㗙݇Ѣ԰㗙݇Ѣ԰㗙㣅᭛㣅᭛,'㣅᭛,',','˖˖˖˖&ROLQ+X&ROLQ+X&ROLQ+X&ROLQ+X(PDLOKFZ#FRP(PDLOKFZ#FRP(PDLOKFZ#FRP%ORJKWWSZZZFRROLFF%ORJKWWSZZZFRROLFF%OR

2、JKWWSZZZFRROLFF:HE6LWHKWWSZZZXRMLFRP:HE6LWHKWWSZZZXRMLFRPᙴᙴ㿬䌁⠽㔥:HE6LWHKWWSZZZXRMLFRPᙴᙴ㿬䌁⠽㔥ᙴᙴ㿬䌁⠽㔥ᙴᙴ㿬䌁⠽㔥444444೼ℸ৥᭛ゴЁখ㗗䖛ⱘ᭛ḷ԰㗙㸼⼎ᛳ䇶೼ℸ৥᭛ゴЁখ㗗䖛ⱘ᭛ḷ԰㗙㸼⼎ᛳ䇶DŽ೼ℸ৥᭛ゴЁখ㗗䖛ⱘ᭛ḷ԰㗙㸼⼎ᛳ䇶DŽDŽDŽ1/8໛ӑㄪ⬹ϔ˖Ⳉ᥹ᣋ䋱᭄᥂ᑧ᭛ӊ˄ϡ᥼㤤˅໛ӑㄪ⬹Ѡ

3、˖Փ⫼PVTOKRWFRS໛ӑ᭄᥂ᑧ˄ᅠܼ໛ӑˈ䗖ড়ᇣൟ᭄᥂ᑧ໛ӑ˅໛ӑㄪ⬹ϝ˖Փ⫼mysqldump໛ӑ᭄᥂ᑧ˄ᅠܼ๲䞣໛ӑˈ䗖ড়Ёൟ᭄᥂ᑧ໛ӑ˅໛ӑㄪ⬹ಯ˖Փ⫼ЏҢ໡ࠊᴎࠊUHSOLFDWLRQ˄ᅲ⦄᭄᥂ᑧᅲᯊ໛ӑ˅Ўњ䰆ℶmysqlⱘऩ⚍༅ᬜˈ䗮ᐌ៥Ӏ䛑Ӯᇍmysqlخ໛ӑDŽMysqlⱘ໛ӑ᳝ᕜ໮Ёᮍ⊩ˈ䖭䞠៥Џ㽕ߚѿ݊ЁⱘЏҢ໛ӑᴎࠊDŽ೼໛ӑⱘ䖛⿟Ёˈ៥䘛ࠄ䖛໮ϾMASTERᇍᑨϔϾSLAVEˈ䗮ϔ⚍ህᰃ໮Ͼᴎ఼ᇍᑨϔϾᴎ఼DŽ໻ᆊৃ㛑䛑ⶹ䘧masterˈslave໛ӑ䛑ᰃϔϾMYSQLᇍᑨ঺໪ϔϾMYSQLᅲ՟Ԛᰃজ≵᳝ᛇ䖛ϔϾ໛ᴎϞ᳝໮ϾSLAVEਸ਼䖭Ͼᯊ׭Դ៥Ӏ䳔㽕њ㾷ϔ

4、ϟˈmysqld_multiˈmysqladminˈmysqld_safe໮ϾSLAVEⱘᯊ׭MYSQLਃࡼˈ䖯ܹCLIENT䛑ᰃ䳔㽕SOCKETˈPORTˈ✊ৢ䖯ܹᇍᑨњⱘCLIENTDŽৃҹ䗮䖛mysqladmin,mysqld_safeএਃࡼˈ݇䯁᭄᥂ᑧmysqlᦤկњ໮Ͼᅲ՟ⱘㅵ⧚ᮍḜህᰃmysqld_multi1ǃǃǃ᭄᥂ᑧᅝ㺙಴Ў㋏㒳ᰃCentosˈᬙ䗮䖛yum–installmysql-serverৃҹᅝ㺙2ǃǃǃッষ㾘ߦ咬䅸ਃࡼᅲ՟ऴ⫼3306ッষᮄ๲᭄᥂ᑧᅲ՟ऴ⫼3308ッষ3ǃǃǃ᭄᥂ᑧⳂᔩ᭄᥂ᑧⳂᔩ㾘ߦ᭄᥂ᑧⳂᔩ㾘ߦ㋏㒳咬䅸ⱘ᭄᥂ⳂᔩЎ˖/var/lib/mysqlᮄ๲᭄᥂

5、ⳂᔩЎ˖/var/lib/mysql33082/8⊼ᛣ˖䆹Ⳃᔩⱘᴗ䰤ᖙ乏ᰃ755˄ৃҹ᳈催˅ˈⳂᔩ᠔᳝㗙ҹঞ㒘䛑ᖙ乏ᰃmysqlे೼/var/lib/Ⳃᔩϟᠻ㸠བϟ䇁হ˖mkdirmysql3308chmod755–Rmysql3308chownmysql:mysql–Rmysql33084ǃǃǃ㓪䕥䜡㕂᭛ӊ/etc/my.cnf䜡㕂Ё䳔㽕ߚ߿ࠊᅮ.pidҹঞ.sock᭛ӊˈ৺᭄߭᥂ᑧϡ㛑ਃࡼ៪㗙ϡ㛑ৠᯊਃࡼ2Ͼᅲ՟[mysqld_multi]mysqld=/usr/bin/mysqld_safemysqladmin=/usr/bin/mysqladmin[mysqld1]server-id=

6、52port=3306pid-file=/var/lib/mysql/mysql.piddatadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.socklog-bin=mysql-binskip-external-locking3/8user=mysqlold_passwords=1#master-host=172.20.0.52#master-port=3306#master-user=slave1#master-password=123456#master-connect-retry=60#replicate-do-db=test_master_

7、slave[mysqld2]server-id=66port=3308pid-file=/var/lib/mysql3308/mysql.piddatadir=/var/lib/mysql3308socket=/var/lib/mysql3308/mysql.socklog-bin=mysql-binskip-external-lockinguser=mysqlold_passwords=14/8