MySQL5.7主从复制集群配置

MySQL5.7 叮叮叮叮DD1 DDDDDD32 DDDDD33 DDDD44 DDDD45 DDDDDDDDD41DDDDDD(1)□□□□my.cnf□□[mysqld]server-id=1#0 叮ID 叮叮叮叮叮口log-bin=mysql-bin#□□□□□□□□mysql-bin□□□□□□□□□□□□□binlog-do-db=testdb#□□□□□□□□□□□□□□□□□□□□□□□binlog—ignore—db=mysql,information_schema,performance_schema#□□□□□□□□□□□□□□□□□□□□□□□expire_logs_days=7#□□□□□□7□□□binlog□□□□(2)□□□□my.cnf□□[mysqld]server-id=2replicate-do-db=testdbreplicate-ignore-db=mysql,information_schema,performance_schemarelay-log=mysql-relay-binread-only=12DDDDD□□□□□□□□□□□□□□□□□□□a□□□□□□□□□□□□□□□□□□IP 叮叮口grantreplicationslave,replicationclienton*.*'repl'@'192.168.119.%'identifiedby'Repl@2018!';to3 DDDD□□□□mysql-uroot-pmysql>stopslave;changemasterto->master_host 二’192.168.119.132',#masterUip->master_user 二'repl',#□□□□□->master_password 二'Repl@2018!',#□□->master_log_file 二'mysql-bin.000002',#□□masterU 叮叮->master_log_pos=120;#□□masterU 叮叮□□□changemastertomaster_host 二'192.168.119.131',master_user二'repl',master_password 二'Repl@2018!',master_log_file 二'mysql-bin.000001',master_log_pos=457;mysql>startslave;4 DDDD□□slave□□□mysql>showslavestatus\G;5 DDDDDDDDDMySQL5.7□□□□□□□□□□□□□□□□□□□□DATABASE□□□□□□□□□□□□□□□□□□□□□□L0GICAL_CL0CK□□□□□□□□□□□□□□□□□□□□□□□□□□□□□□□□□□1 叮叮叮叮叮叮叮叮mysql>showprocesslist;akrctfprrce331j.atrIdU5TX-i|旳昏上1dhCctmud|Time1State-1TIln£&j_2110CHlh.0Bt1tflstdb1Cw=iY101-gtart-ingT-1shcnr.pEDGeaflLiflt13a^arenuser11WJ1L1Cmsct1151IETaiiLlQigrshowvariableslite131avc_parallel_typeTj4++IVariable_najneIValueIIslavt_pa 匚也1 丄亡1_匸四亡ICATABtSEI 十十十1cowin(0・00sec)□□□□□□□...