In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-17 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
1. Configure the service profile of the master-slave node
1.1.Configuring master nodes:
# binlog_format=mixed
Binlog-format=ROW
# required unique id between 1 and 2 ^ 32-1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
Server-id = 1
Log-slave-updates=true
Master-info-repository=TABLE
Relay-log-info-repository=TABLE
Sync-master-info=1
Slave-parallel-threads=2
Binlog-checksum=CRC32
Master-verify-checksum=1
Slave-sql-verify-checksum=1
Binlog-rows-query-log_events=1
Report-port=3306
Report-host=www.pancou.com
1.2.Configuring slave nodes:
[mysqld]
# binlog_format=mixed
Binlog-format=ROW
# required unique id between 1 and 2 ^ 32-1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
Server-id = 2
Log-slave-updates=true
Master-info-repository=TABLE
Relay-log-info-repository=TABLE
Sync-master-info=1
Slave-parallel-threads=2
Binlog-checksum=CRC32
Master-verify-checksum=1
Slave-sql-verify-checksum=1
Binlog-rows-query-log_events=1
Report-port=3306
Report-host=www.pancou.com
MariaDB [(none)] > change master to master_host='192.168.110.128',master_port=3306,master_user='repl_user',master_password='pancou',master_use_gtid=current_pos
Query OK, 0 rows affected (0.06 sec)
MariaDB [(none)] > start slave
Query OK, 0 rows affected (0.01 sec)
MariaDB [(none)] > change master to master_host='192.168.110.130',master_port=3306,master_host='repl_user',master_password='pancou',master_use_gtid=current_pos
Query OK, 0 rows affected (0.03 sec)
MariaDB [(none)] > start slave
Query OK, 0 rows affected (0.02 sec)
MariaDB [(none)] > show slave status\ G
* * 1. Row *
Slave_IO_State: Connecting to master
Master_Host: repl_user
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:
Read_Master_Log_Pos: 4
Relay_Log_File: www-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File:
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 4
Relay_Log_Space: 248
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 2
Master_SSL_Crl:
Master_SSL_Crlpath:
Using_Gtid: Current_Pos
Gtid_IO_Pos: 0-2-645
1 row in set (0.00 sec)
MariaDB [(none)] > show variables like 'slave_parallel%'
+-+ +
| | Variable_name | Value |
+-+ +
| | slave_parallel_max_queued | 131072 | |
| | slave_parallel_threads | 2 | |
+-+ +
2 rows in set (0.01sec)
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.