Now, the company replicates data from a single server. Now we know that you need to install multiple mysql services. Now, under the existing single-instance database, different ports are divided into the red section below;
[Root @ mysql ~] # Netstat-tunlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
Tcp 0 0 0.0.0.0: 1001 0.0.0.0: * LISTEN 2515/rpc. statd
Tcp 0 0 0.0.0.0: 111 0.0.0.0: * LISTEN 2483/portmap
Tcp 0 0 127.0.0.1: 631 0.0.0.0: * LISTEN 2750/cupsd
Tcp 0 0 127.0.0.1: 25 0.0.0.0: * LISTEN 3056/sendmail: acce
Tcp 0 0: 3306: * LISTEN 4025/mysqld
Tcp 0 0: 3307: * LISTEN 17423/mysqld
Tcp 0 0: 3308: * LISTEN 17388/mysqld
Tcp 0 0: 3309: * LISTEN 20371/mysqld
Tcp 0 0: 22: * LISTEN 2741/sshd
Udp 0 0 0.0.0.0: 995 0.0.0.0: * 2515/rpc. statd
Udp 0 0 0.0.0.0: 998 0.0.0.0: * 2515/rpc. statd
Udp 0 0 0.0.0.0: 42601 0.0.0.0: * 3204/avahi-daemon:
Udp 0 0 0.0.0.0: 5353 0.0.0.0: * 3204/avahi-daemon:
Udp 0 0 0.0.0.0: 111 0.0.0.0: * 2483/portmap
Udp 0 0 0.0.0.0: 631 0.0.0.0: * 2750/cupsd
Udp 0 0: 5353: * 3204/avahi-daemon:
Udp 0 0: 59254: * 3204/avahi-daemon:
[Root @ mysql] # mysqld_multi -- defaults-extra-file =/etc/mysqld_multi.cnf report
Reporting MySQL servers
MySQL server from group: mysqld2 is running
MySQL server from group: mysqld3 is running
MySQL server from group: mysqld4 is running
[Root @ mysql] # lsof-I: 3308
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
Mysqld 17388 mysql 11u IPv6 45429 TCP *: tns-server (LISTEN)
[Root @ mysql] # lsof-I: 3307
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
Mysqld 17423 mysql 11u IPv6 45479 TCP * psession-prxy (LISTEN)
[Root @ mysql] # lsof-I: 3309
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
Mysqld 20371 mysql 11u IPv6 47851 TCP *: tns-adv (LISTEN)
[Root @ mysql] # lsof-I: 3306
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
Mysqld 4025 mysql 11u IPv6 16575 TCP *: mysql (LISTEN)
[Root @ mysql] #
[Root @ mysql ~] #
When the above services are started normally, configure the master and slave nodes. I didn't adjust the IO thread. I don't know how to see the master-slave replication relationship on different ports. The following are the last errors I encountered during the configuration, please help me look at it and make a brick...
Mysql> show slave status \ G;
* *************************** 1. row ***************************
Slave_IO_State:
Master_Host: 192.168.1.10
Master_User: slave001
Master_Port: 3308
Connect_Retry: 60
Master_Log_File: mysql-bin.000003
Read_Master_Log_Pos: 1027
Relay_Log_File: localhost3308-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.000003
Slave_IO_Running: No
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: 1027
Relay_Log_Space: 107
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: 1593
Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the -- replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it ).
Last_ SQL _Errno: 0
Last_ SQL _Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
1 row in set (0.00 sec)
ERROR:
No query specified
Mysql>