mysql8.0.31使用percona-xtrabackup 8.0.30的备份恢复:从库做备份恢复
上篇为主库做备份恢复：
https://www.modb.pro/db/599597
RESET MASTER和RESET SLAVE使用场景和说明
https://blog.csdn.net/yabingshi_tech/article/details/50736735
测试结果：
从库需要stop slave/reset slave/start slave然后自动恢复主从关系。
从库操作：
[root@mysql1 ~]# mkdir /backup
[root@mysql1 ~]# xtrabackup --backup --target-dir=/backup --user=root --password=abcd1234 --no-server-version-check
2022-12-27T15:22:29.917581+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/mysql/data --innodb_buffer_pool_size=2G --innodb_flush_log_at_trx_commit=2 --log_bin=/mysql/data/mysql-bin --server-id=1
2022-12-27T15:22:29.917949+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --port=3306 --socket=/mysql/mysql.sock --backup=1 --target-dir=/backup --user=root --password=* --no-server-version-check=1
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
221227 15:22:30 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/mysql/mysql.sock' as 'root' (using password: YES).
221227 15:22:30 version_check Connected to MySQL server
221227 15:22:30 version_check Executing a version check against the server...
221227 15:22:30 version_check Done.
2022-12-27T15:22:30.040761+08:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: /mysql/mysql.sock
2022-12-27T15:22:30.054900+08:00 0 [Note] [MY-011825] [Xtrabackup] Using server version 8.0.31
2022-12-27T15:22:30.079507+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing LOCK INSTANCE FOR BACKUP ...
2022-12-27T15:22:30.102654+08:00 0 [Note] [MY-011825] [Xtrabackup] uses posix_fadvise().
2022-12-27T15:22:30.102727+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /mysql/data
2022-12-27T15:22:30.102771+08:00 0 [Note] [MY-011825] [Xtrabackup] open files limit requested 0, set to 1024
2022-12-27T15:22:30.102900+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration:
2022-12-27T15:22:30.102921+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2022-12-27T15:22:30.102937+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2022-12-27T15:22:30.103021+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = ./
2022-12-27T15:22:30.103040+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2022-12-27T15:22:30.103061+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648
2022-12-27T15:22:30.104132+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-12-27T15:22:30.110552+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2022-12-27T15:22:30.325631+08:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: /mysql/mysql.sock
2022-12-27T15:22:30.333186+08:00 0 [Note] [MY-011825] [Xtrabackup] Redo Log Archiving is not set up.
2022-12-27T15:22:30.441277+08:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (29487655)
2022-12-27T15:22:30.645774+08:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces
2022-12-27T15:22:30.645887+08:00 0 [Note] [MY-011825] [Xtrabackup] Generating a list of tablespaces
2022-12-27T15:22:30.645918+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2022-12-27T15:22:30.647709+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 3 files.
2022-12-27T15:22:30.648078+08:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 6 for test/t, old maximum was 0
2022-12-27T15:22:30.650208+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2022-12-27T15:22:30.651214+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2022-12-27T15:22:30.652291+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo003.ibu'.
2022-12-27T15:22:30.654164+08:00 0 [Note] [MY-012910] [InnoDB] Opened 3 existing undo tablespaces.
2022-12-27T15:22:30.654804+08:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./ibdata1 to /backup/ibdata1
2022-12-27T15:22:30.725094+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./ibdata1 to /backup/ibdata1
2022-12-27T15:22:30.753868+08:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./sys/sys_config.ibd to /backup/sys/sys_config.ibd
2022-12-27T15:22:30.754816+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./sys/sys_config.ibd to /backup/sys/sys_config.ibd
2022-12-27T15:22:30.756957+08:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./jycdb/test.ibd to /backup/jycdb/test.ibd
2022-12-27T15:22:30.757715+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./jycdb/test.ibd to /backup/jycdb/test.ibd
2022-12-27T15:22:30.760029+08:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./jyc/t.ibd to /backup/jyc/t.ibd
2022-12-27T15:22:30.760788+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./jyc/t.ibd to /backup/jyc/t.ibd
2022-12-27T15:22:30.763678+08:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./test/t.ibd to /backup/test/t.ibd
2022-12-27T15:22:30.764058+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./test/t.ibd to /backup/test/t.ibd
2022-12-27T15:22:30.767535+08:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./mysql.ibd to /backup/mysql.ibd
2022-12-27T15:22:30.912339+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./mysql.ibd to /backup/mysql.ibd
2022-12-27T15:22:30.926199+08:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./undo003.ibu to /backup/undo003.ibu
2022-12-27T15:22:30.995399+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./undo003.ibu to /backup/undo003.ibu
2022-12-27T15:22:31.025210+08:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./undo_002 to /backup/undo_002
2022-12-27T15:22:31.071237+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./undo_002 to /backup/undo_002
2022-12-27T15:22:31.099900+08:00 2 [Note] [MY-011825] [Xtrabackup] Copying ./undo_001 to /backup/undo_001
2022-12-27T15:22:31.172265+08:00 2 [Note] [MY-011825] [Xtrabackup] Done: Copying ./undo_001 to /backup/undo_001
2022-12-27T15:22:31.441574+08:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (29487655)
2022-12-27T15:22:31.654543+08:00 0 [Note] [MY-011825] [Xtrabackup] Starting to backup non-InnoDB tables and files
2022-12-27T15:22:31.655074+08:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/general_log.CSM to /backup/mysql/general_log.CSM
2022-12-27T15:22:31.655727+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/general_log.CSM to /backup/mysql/general_log.CSM
2022-12-27T15:22:31.656862+08:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/general_log.CSV to /backup/mysql/general_log.CSV
2022-12-27T15:22:31.656906+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/general_log.CSV to /backup/mysql/general_log.CSV
2022-12-27T15:22:31.658703+08:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/slow_log.CSM to /backup/mysql/slow_log.CSM
2022-12-27T15:22:31.658852+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/slow_log.CSM to /backup/mysql/slow_log.CSM
2022-12-27T15:22:31.660831+08:00 3 [Note] [MY-011825] [Xtrabackup] Copying mysql/slow_log.CSV to /backup/mysql/slow_log.CSV
2022-12-27T15:22:31.660876+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql/slow_log.CSV to /backup/mysql/slow_log.CSV
2022-12-27T15:22:31.662792+08:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/clone_status_377.sdi to /backup/performance_schema/clone_status_377.sdi
2022-12-27T15:22:31.663220+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/clone_status_377.sdi to /backup/performance_schema/clone_status_377.sdi
2022-12-27T15:22:31.665065+08:00 3 [Note] [MY-011825] [Xtrabackup] Copying performance_schema/clone_progress_378.sdi to /backup/performance_schema/clone_progress_378.sdi
2022-12-27T15:22:31.665549+08:00 3 [Note] [MY-011825] [Xtrabackup] Done: Copying performance_schema/clone_progress_378.sdi to /backup/performance_schema/clone_progress_378.sdi
2022-12-27T15:22:31.755758+08:00 0 [Note] [MY-011825] [Xtrabackup] Finished backing up non-InnoDB tables and files
2022-12-27T15:22:31.755802+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG BINARY LOGS
2022-12-27T15:22:31.769942+08:00 0 [Note] [MY-011825] [Xtrabackup] Selecting LSN and binary log position from p_s.log_status
2022-12-27T15:22:31.785076+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying /mysql/data/mysql-bin.000007 to /backup/mysql-bin.000007 up to position 277
2022-12-27T15:22:31.785410+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying /mysql/data/mysql-bin.000007 to /backup/mysql-bin.000007
2022-12-27T15:22:31.788854+08:00 0 [Note] [MY-011825] [Xtrabackup] Writing /backup/mysql-bin.index
2022-12-27T15:22:31.789001+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /backup/mysql-bin.index
2022-12-27T15:22:31.794862+08:00 0 [Note] [MY-011825] [Xtrabackup] Writing /backup/xtrabackup_binlog_info
2022-12-27T15:22:31.795006+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /backup/xtrabackup_binlog_info
2022-12-27T15:22:31.798154+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
2022-12-27T15:22:31.802617+08:00 0 [Note] [MY-011825] [Xtrabackup] The latest check point (for incremental): '29487655'
2022-12-27T15:22:31.802672+08:00 0 [Note] [MY-011825] [Xtrabackup] Stopping log copying thread at LSN 29489284
2022-12-27T15:22:31.802814+08:00 1 [Note] [MY-011825] [Xtrabackup] Starting to parse redo log at lsn = 29487655
2022-12-27T15:22:31.803097+08:00 1 [Note] [MY-011825] [Xtrabackup] >> log scanned up to (29489386)
2022-12-27T15:22:32.810311+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing UNLOCK INSTANCE
2022-12-27T15:22:32.810614+08:00 0 [Note] [MY-011825] [Xtrabackup] All tables unlocked
2022-12-27T15:22:32.810773+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying ib_buffer_pool to /backup/ib_buffer_pool
2022-12-27T15:22:32.810953+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying ib_buffer_pool to /backup/ib_buffer_pool
2022-12-27T15:22:32.814021+08:00 0 [Note] [MY-011825] [Xtrabackup] Backup created in directory '/backup/'
2022-12-27T15:22:32.814065+08:00 0 [Note] [MY-011825] [Xtrabackup] MySQL binlog position: filename 'mysql-bin.000007', position '277', GTID of the last change '0489844a-85ae-11ed-97ee-d67f35a9de29:1-5,740dc65b-7ced-11ed-9e87-82b000a4e5ee:1-9,d0271cef-7782-11ed-828a-d67f35a9de29:1-5'
2022-12-27T15:22:32.814238+08:00 0 [Note] [MY-011825] [Xtrabackup] Writing /backup/backup-my.cnf
2022-12-27T15:22:32.814381+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /backup/backup-my.cnf
2022-12-27T15:22:32.818217+08:00 0 [Note] [MY-011825] [Xtrabackup] Writing /backup/xtrabackup_info
2022-12-27T15:22:32.818370+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Writing file /backup/xtrabackup_info
2022-12-27T15:22:33.824821+08:00 0 [Note] [MY-011825] [Xtrabackup] Transaction log of lsn (29487655) to (29489396) was copied.
2022-12-27T15:22:34.041445+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
[root@mysql1 ~]# ll /backup
total 86056
-rw-r-----. 1 root root 447 Dec 27 15:22 backup-my.cnf
-rw-r-----. 1 root root 6459 Dec 27 15:22 ib_buffer_pool
-rw-r-----. 1 root root 12582912 Dec 27 15:22 ibdata1
drwxr-x---. 2 root root 19 Dec 27 15:22 jyc
drwxr-x---. 2 root root 22 Dec 27 15:22 jycdb
drwxr-x---. 2 root root 92 Dec 27 15:22 mysql
-rw-r-----. 1 root root 277 Dec 27 15:22 mysql-bin.000007
-rw-r-----. 1 root root 29 Dec 27 15:22 mysql-bin.index
-rw-r-----. 1 root root 25165824 Dec 27 15:22 mysql.ibd
drwxr-x---. 2 root root 64 Dec 27 15:22 performance_schema
drwxr-x---. 2 root root 28 Dec 27 15:22 sys
drwxr-x---. 2 root root 19 Dec 27 15:22 test
-rw-r-----. 1 root root 16777216 Dec 27 15:22 undo_001
-rw-r-----. 1 root root 16777216 Dec 27 15:22 undo_002
-rw-r-----. 1 root root 16777216 Dec 27 15:22 undo003.ibu
-rw-r-----. 1 root root 144 Dec 27 15:22 xtrabackup_binlog_info
-rw-r-----. 1 root root 138 Dec 27 15:22 xtrabackup_checkpoints
-rw-r-----. 1 root root 652 Dec 27 15:22 xtrabackup_info
-rw-r-----. 1 root root 4096 Dec 27 15:22 xtrabackup_logfile
-rw-r-----. 1 root root 39 Dec 27 15:22 xtrabackup_tablespaces
[root@mysql1 ~]# xtrabackup --prepare --apply-log-only --target-dir=/backup
2022-12-27T15:23:25.210688+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksums=1 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_file_size=50331648 --innodb_page_size=16384 --innodb_undo_directory=./ --innodb_undo_tablespaces=2 --server-id=1 --innodb_log_checksums=ON --innodb_redo_log_encrypt=0 --innodb_undo_log_encrypt=0
2022-12-27T15:23:25.211010+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --prepare=1 --apply-log-only=1 --target-dir=/backup
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2022-12-27T15:23:25.211097+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /backup/
2022-12-27T15:23:25.211207+08:00 0 [Note] [MY-011825] [Xtrabackup] This target seems to be not prepared yet.
2022-12-27T15:23:25.212042+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-12-27T15:23:25.225025+08:00 0 [Note] [MY-011825] [Xtrabackup] xtrabackup_logfile detected: size=8388608, start_lsn=(29487655)
2022-12-27T15:23:25.226761+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2022-12-27T15:23:25.226796+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2022-12-27T15:23:25.226814+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2022-12-27T15:23:25.226890+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = .
2022-12-27T15:23:25.226908+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 1
2022-12-27T15:23:25.226930+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 8388608
2022-12-27T15:23:25.227524+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2022-12-27T15:23:25.227878+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2022-12-27T15:23:25.227904+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2022-12-27T15:23:25.227921+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2022-12-27T15:23:25.227948+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = .
2022-12-27T15:23:25.227964+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 1
2022-12-27T15:23:25.227980+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 8388608
2022-12-27T15:23:25.228006+08:00 0 [Note] [MY-011825] [Xtrabackup] Starting InnoDB instance for recovery.
2022-12-27T15:23:25.228024+08:00 0 [Note] [MY-011825] [Xtrabackup] Using 104857600 bytes for buffer pool (set by --use-memory parameter)
2022-12-27T15:23:25.228098+08:00 0 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2022-12-27T15:23:25.228140+08:00 0 [Note] [MY-012944] [InnoDB] Uses event mutexes
2022-12-27T15:23:25.228158+08:00 0 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2022-12-27T15:23:25.228183+08:00 0 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.12
2022-12-27T15:23:25.228410+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-12-27T15:23:25.228612+08:00 0 [Note] [MY-012951] [InnoDB] Using software crc32.
2022-12-27T15:23:25.229341+08:00 0 [Note] [MY-012203] [InnoDB] Directories to scan './'
2022-12-27T15:23:25.229425+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2022-12-27T15:23:25.231349+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 8 files.
2022-12-27T15:23:25.232526+08:00 0 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M
2022-12-27T15:23:25.248365+08:00 0 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2022-12-27T15:23:25.254910+08:00 0 [Note] [MY-011951] [InnoDB] page_cleaner coordinator priority: -20
2022-12-27T15:23:25.255629+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2022-12-27T15:23:25.275666+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2022-12-27T15:23:25.276605+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2022-12-27T15:23:25.393510+08:00 0 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 29487655 in redo log file ./#innodb_redo/#ib_redo0.
2022-12-27T15:23:25.393650+08:00 0 [Note] [MY-012560] [InnoDB] The log sequence number 25719735 in the system tablespace does not match the log sequence number 29487655 in the redo log files!
2022-12-27T15:23:25.393698+08:00 0 [Note] [MY-012551] [InnoDB] Database was not shutdown normally!
2022-12-27T15:23:25.393718+08:00 0 [Note] [MY-012552] [InnoDB] Starting crash recovery.
2022-12-27T15:23:25.393901+08:00 0 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 29487655, whereas checkpoint_lsn = 29487655 and start_lsn = 29487616
2022-12-27T15:23:25.393945+08:00 0 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 29489284
2022-12-27T15:23:25.423045+08:00 0 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2022-12-27T15:23:25.483749+08:00 0 [Note] [MY-012532] [InnoDB] Applying a batch of 5 redo log records ...
2022-12-27T15:23:25.487725+08:00 0 [Note] [MY-012533] [InnoDB] 100%
2022-12-27T15:23:25.987881+08:00 0 [Note] [MY-012535] [InnoDB] Apply batch completed!
2022-12-27T15:23:26.092598+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2022-12-27T15:23:26.092872+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2022-12-27T15:23:26.093559+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo003.ibu'.
2022-12-27T15:23:26.095503+08:00 0 [Note] [MY-012910] [InnoDB] Opened 3 existing undo tablespaces.
2022-12-27T15:23:26.095647+08:00 0 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 4070
2022-12-27T15:23:26.116197+08:00 0 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2022-12-27T15:23:26.116269+08:00 0 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 2 thread: 20639 ms.
2022-12-27T15:23:26.116404+08:00 0 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2022-12-27T15:23:26.116601+08:00 0 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-27T15:23:26.171252+08:00 0 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2022-12-27T15:23:26.171642+08:00 0 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2022-12-27T15:23:26.205016+08:00 0 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2022-12-27T15:23:26.205299+08:00 0 [Note] [MY-012976] [InnoDB] 8.0.30 started; log sequence number 29489294
2022-12-27T15:23:26.205897+08:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 1 for sys/sys_config, old maximum was 0
2022-12-27T15:23:26.247889+08:00 0 [Note] [MY-011825] [Xtrabackup] starting shutdown with innodb_fast_shutdown = 1
2022-12-27T15:23:26.248105+08:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2022-12-27T15:23:27.247830+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2022-12-27T15:23:27.259787+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2022-12-27T15:23:27.289257+08:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 29489294
2022-12-27T15:23:27.290028+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-12-27T15:23:27.291435+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
[root@mysql1 ~]# service mysql stop
Shutting down MySQL.. SUCCESS!
[root@mysql1 ~]# mv /mysql/data /mysql/data.bak
[root@mysql1 ~]# mkdir -p /mysql/data
[root@mysql1 ~]# chown -R mysql.mysql /mysql/data
[root@mysql1 ~]# ps -ef|grep mysql
root 31870 28382 0 15:24 pts/1 00:00:00 grep --color=auto mysql
[root@mysql1 ~]# xtrabackup --copy-back --target-dir=/backup
2022-12-27T15:24:36.514369+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/mysql/data --innodb_buffer_pool_size=2G --innodb_flush_log_at_trx_commit=2 --log_bin=/mysql/data/mysql-bin --server-id=1
2022-12-27T15:24:36.514766+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --port=3306 --socket=/mysql/mysql.sock --copy-back=1 --target-dir=/backup
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2022-12-27T15:24:36.514852+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /backup/
2022-12-27T15:24:36.514946+08:00 0 [ERROR] [MY-011825] [Xtrabackup] The target is not fully prepared. Please prepare it without option --apply-log-only
[root@mysql1 ~]# xtrabackup --prepare --target-dir=/backup
2022-12-27T15:24:53.004168+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksums=1 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_file_size=50331648 --innodb_page_size=16384 --innodb_undo_directory=./ --innodb_undo_tablespaces=2 --server-id=1 --innodb_log_checksums=ON --innodb_redo_log_encrypt=0 --innodb_undo_log_encrypt=0
2022-12-27T15:24:53.004514+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --prepare=1 --target-dir=/backup
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2022-12-27T15:24:53.004595+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /backup/
2022-12-27T15:24:53.004703+08:00 0 [Note] [MY-011825] [Xtrabackup] This target seems to be already prepared with --apply-log-only.
2022-12-27T15:24:53.005576+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-12-27T15:24:53.005843+08:00 0 [Note] [MY-011825] [Xtrabackup] xtrabackup_logfile was already used to '--prepare'.
2022-12-27T15:24:53.006557+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2022-12-27T15:24:53.006586+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2022-12-27T15:24:53.006603+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2022-12-27T15:24:53.006676+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = .
2022-12-27T15:24:53.006693+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2022-12-27T15:24:53.006714+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648
2022-12-27T15:24:53.007205+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2022-12-27T15:24:53.007533+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2022-12-27T15:24:53.007561+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2022-12-27T15:24:53.007578+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2022-12-27T15:24:53.007605+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = .
2022-12-27T15:24:53.007621+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2022-12-27T15:24:53.007636+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648
2022-12-27T15:24:53.007661+08:00 0 [Note] [MY-011825] [Xtrabackup] Starting InnoDB instance for recovery.
2022-12-27T15:24:53.007679+08:00 0 [Note] [MY-011825] [Xtrabackup] Using 104857600 bytes for buffer pool (set by --use-memory parameter)
2022-12-27T15:24:53.007749+08:00 0 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2022-12-27T15:24:53.007806+08:00 0 [Note] [MY-012944] [InnoDB] Uses event mutexes
2022-12-27T15:24:53.007824+08:00 0 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2022-12-27T15:24:53.007850+08:00 0 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.12
2022-12-27T15:24:53.008117+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-12-27T15:24:53.008310+08:00 0 [Note] [MY-012951] [InnoDB] Using software crc32.
2022-12-27T15:24:53.009381+08:00 0 [Note] [MY-012203] [InnoDB] Directories to scan './'
2022-12-27T15:24:53.009490+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2022-12-27T15:24:53.010420+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 8 files.
2022-12-27T15:24:53.011834+08:00 0 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M
2022-12-27T15:24:53.031931+08:00 0 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2022-12-27T15:24:53.037945+08:00 0 [Note] [MY-011951] [InnoDB] page_cleaner coordinator priority: -20
2022-12-27T15:24:53.038555+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2022-12-27T15:24:53.045721+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2022-12-27T15:24:53.046598+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2022-12-27T15:24:53.193216+08:00 0 [Note] [MY-011825] [InnoDB] Creating redo log file at ./#innodb_redo/#ib_redo0_tmp with file_id 0 with size 33554432 bytes
2022-12-27T15:24:53.196936+08:00 0 [Note] [MY-011825] [InnoDB] Renaming redo log file from ./#innodb_redo/#ib_redo0_tmp to ./#innodb_redo/#ib_redo0
2022-12-27T15:24:53.199127+08:00 0 [Note] [MY-012893] [InnoDB] New redo log files created, LSN=29489294
2022-12-27T15:24:53.199665+08:00 0 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 29489676 in redo log file ./#innodb_redo/#ib_redo0.
2022-12-27T15:24:53.200849+08:00 0 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 29489676, whereas checkpoint_lsn = 29489676 and start_lsn = 29489664
2022-12-27T15:24:53.204069+08:00 0 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2022-12-27T15:24:53.258074+08:00 0 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2022-12-27T15:24:53.258122+08:00 0 [Note] [MY-012535] [InnoDB] Apply batch completed!
2022-12-27T15:24:53.258469+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2022-12-27T15:24:53.265759+08:00 0 [Note] [MY-013041] [InnoDB] Resizing redo log from 32M to 1024M (LSN=29489676) synchronously. If this takes too long, consider starting the server with large --innodb_redo_log_capacity, and resizing the redo log online using SET.
2022-12-27T15:24:53.267859+08:00 0 [Note] [MY-012968] [InnoDB] Starting to delete and rewrite redo log files.
2022-12-27T15:24:53.267949+08:00 0 [Note] [MY-011825] [InnoDB] Removing redo log file: ./#innodb_redo/#ib_redo0
2022-12-27T15:24:53.411345+08:00 0 [Note] [MY-011825] [InnoDB] Creating redo log file at ./#innodb_redo/#ib_redo0_tmp with file_id 0 with size 33554432 bytes
2022-12-27T15:24:53.415509+08:00 0 [Note] [MY-011825] [InnoDB] Renaming redo log file from ./#innodb_redo/#ib_redo0_tmp to ./#innodb_redo/#ib_redo0
2022-12-27T15:24:53.417432+08:00 0 [Note] [MY-012893] [InnoDB] New redo log files created, LSN=29490188
2022-12-27T15:24:53.417546+08:00 0 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2022-12-27T15:24:53.473119+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2022-12-27T15:24:53.473890+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2022-12-27T15:24:53.474537+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo003.ibu'.
2022-12-27T15:24:53.476149+08:00 0 [Note] [MY-012910] [InnoDB] Opened 3 existing undo tablespaces.
2022-12-27T15:24:53.476231+08:00 0 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 4070
2022-12-27T15:24:53.499576+08:00 0 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2022-12-27T15:24:53.499640+08:00 0 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 2 thread: 23418 ms.
2022-12-27T15:24:53.502818+08:00 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2022-12-27T15:24:53.502852+08:00 0 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2022-12-27T15:24:53.502983+08:00 0 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-27T15:24:53.553124+08:00 0 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2022-12-27T15:24:53.553545+08:00 0 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2022-12-27T15:24:53.588825+08:00 0 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2022-12-27T15:24:53.589204+08:00 0 [Note] [MY-012976] [InnoDB] 8.0.30 started; log sequence number 29490198
2022-12-27T15:24:53.589752+08:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 1 for sys/sys_config, old maximum was 0
2022-12-27T15:24:53.629141+08:00 0 [Note] [MY-011825] [Xtrabackup] starting shutdown with innodb_fast_shutdown = 1
2022-12-27T15:24:53.629264+08:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2022-12-27T15:24:54.628991+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2022-12-27T15:24:54.639492+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2022-12-27T15:24:54.659979+08:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 29490198
2022-12-27T15:24:54.660873+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-12-27T15:24:54.662269+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
[root@mysql1 ~]# ps -ef|grep mysql
root 31930 28382 0 15:24 pts/1 00:00:00 grep --color=auto mysql
[root@mysql1 ~]#
[root@mysql1 ~]#
[root@mysql1 ~]#
[root@mysql1 ~]#
[root@mysql1 ~]# xtrabackup --copy-back --target-dir=/backup
2022-12-27T15:25:02.833338+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/mysql/data --innodb_buffer_pool_size=2G --innodb_flush_log_at_trx_commit=2 --log_bin=/mysql/data/mysql-bin --server-id=1
2022-12-27T15:25:02.833722+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --port=3306 --socket=/mysql/mysql.sock --copy-back=1 --target-dir=/backup
xtrabackup version 8.0.30-23 based on MySQL server 8.0.30 Linux (x86_64) (revision id: 873b467185c)
2022-12-27T15:25:02.833810+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /backup/
2022-12-27T15:25:02.835255+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying undo_001 to /mysql/data/undo_001
2022-12-27T15:25:02.863244+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying undo_001 to /mysql/data/undo_001
2022-12-27T15:25:02.896878+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying undo_002 to /mysql/data/undo_002
2022-12-27T15:25:02.924617+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying undo_002 to /mysql/data/undo_002
2022-12-27T15:25:02.956645+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying ibdata1 to /mysql/data/ibdata1
2022-12-27T15:25:02.974302+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying ibdata1 to /mysql/data/ibdata1
2022-12-27T15:25:03.000852+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying mysql-bin.000007 to /mysql/data/mysql-bin.000007
2022-12-27T15:25:03.001011+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql-bin.000007 to /mysql/data/mysql-bin.000007
2022-12-27T15:25:03.002146+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying mysql-bin.index to /mysql/data/mysql-bin.index
2022-12-27T15:25:03.002294+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying mysql-bin.index to /mysql/data/mysql-bin.index
2022-12-27T15:25:03.004096+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./sys/sys_config.ibd to /mysql/data/sys/sys_config.ibd
2022-12-27T15:25:03.004573+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./sys/sys_config.ibd to /mysql/data/sys/sys_config.ibd
2022-12-27T15:25:03.007665+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./jycdb/test.ibd to /mysql/data/jycdb/test.ibd
2022-12-27T15:25:03.007940+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./jycdb/test.ibd to /mysql/data/jycdb/test.ibd
2022-12-27T15:25:03.011436+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./jyc/t.ibd to /mysql/data/jyc/t.ibd
2022-12-27T15:25:03.011728+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./jyc/t.ibd to /mysql/data/jyc/t.ibd
2022-12-27T15:25:03.015416+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./test/t.ibd to /mysql/data/test/t.ibd
2022-12-27T15:25:03.015709+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./test/t.ibd to /mysql/data/test/t.ibd
2022-12-27T15:25:03.018699+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./mysql.ibd to /mysql/data/mysql.ibd
2022-12-27T15:25:03.086037+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./mysql.ibd to /mysql/data/mysql.ibd
2022-12-27T15:25:03.118714+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./undo003.ibu to /mysql/data/undo003.ibu
2022-12-27T15:25:03.141918+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./undo003.ibu to /mysql/data/undo003.ibu
2022-12-27T15:25:03.173581+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./mysql/general_log.CSM to /mysql/data/mysql/general_log.CSM
2022-12-27T15:25:03.173725+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./mysql/general_log.CSM to /mysql/data/mysql/general_log.CSM
2022-12-27T15:25:03.176635+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./mysql/general_log.CSV to /mysql/data/mysql/general_log.CSV
2022-12-27T15:25:03.176682+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./mysql/general_log.CSV to /mysql/data/mysql/general_log.CSV
2022-12-27T15:25:03.179596+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./mysql/slow_log.CSM to /mysql/data/mysql/slow_log.CSM
2022-12-27T15:25:03.179736+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./mysql/slow_log.CSM to /mysql/data/mysql/slow_log.CSM
2022-12-27T15:25:03.182863+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./mysql/slow_log.CSV to /mysql/data/mysql/slow_log.CSV
2022-12-27T15:25:03.182910+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./mysql/slow_log.CSV to /mysql/data/mysql/slow_log.CSV
2022-12-27T15:25:03.185901+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./performance_schema/clone_status_377.sdi to /mysql/data/performance_schema/clone_status_377.sdi
2022-12-27T15:25:03.186059+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./performance_schema/clone_status_377.sdi to /mysql/data/performance_schema/clone_status_377.sdi
2022-12-27T15:25:03.187160+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./performance_schema/clone_progress_378.sdi to /mysql/data/performance_schema/clone_progress_378.sdi
2022-12-27T15:25:03.187308+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./performance_schema/clone_progress_378.sdi to /mysql/data/performance_schema/clone_progress_378.sdi
2022-12-27T15:25:03.190531+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./ib_buffer_pool to /mysql/data/ib_buffer_pool
2022-12-27T15:25:03.190672+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./ib_buffer_pool to /mysql/data/ib_buffer_pool
2022-12-27T15:25:03.193831+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./xtrabackup_info to /mysql/data/xtrabackup_info
2022-12-27T15:25:03.193964+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./xtrabackup_info to /mysql/data/xtrabackup_info
2022-12-27T15:25:03.197035+08:00 1 [Note] [MY-011825] [Xtrabackup] Creating directory ./#innodb_redo
2022-12-27T15:25:03.197088+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: creating directory ./#innodb_redo
2022-12-27T15:25:03.197222+08:00 1 [Note] [MY-011825] [Xtrabackup] Copying ./ibtmp1 to /mysql/data/ibtmp1
2022-12-27T15:25:03.215185+08:00 1 [Note] [MY-011825] [Xtrabackup] Done: Copying ./ibtmp1 to /mysql/data/ibtmp1
2022-12-27T15:25:03.304608+08:00 0 [Note] [MY-011825] [Xtrabackup] completed OK!
[root@mysql1 ~]# ll /mysql
total 312
drwxr-xr-x. 2 mysql mysql 4096 Sep 14 04:08 bin
drwxr-xr-x. 9 mysql mysql 4096 Dec 27 15:25 data
drwxr-x---. 10 mysql mysql 4096 Dec 16 10:56 data_bak
drwxr-x---. 12 mysql mysql 4096 Dec 27 15:23 data.bak
drwxr-xr-x. 2 mysql mysql 55 Sep 14 04:08 docs
drwxr-xr-x. 3 mysql mysql 4096 Sep 14 04:08 include
drwxr-xr-x. 6 mysql mysql 201 Sep 14 04:08 lib
-rw-r--r--. 1 mysql mysql 287627 Sep 14 00:15 LICENSE
drwxrwxr-x. 2 mysql mysql 22 Dec 7 16:59 log
drwxr-xr-x. 4 mysql mysql 30 Sep 14 04:08 man
-rw-r--r--. 1 mysql mysql 666 Sep 14 00:15 README
drwxr-xr-x. 28 mysql mysql 4096 Sep 14 04:08 share
drwxr-xr-x. 2 mysql mysql 77 Sep 14 04:08 support-files
[root@mysql1 ~]# ll /mysql/data
total 98324
-rw-r-----. 1 root root 6459 Dec 27 15:25 ib_buffer_pool
-rw-r-----. 1 root root 12582912 Dec 27 15:25 ibdata1
-rw-r-----. 1 root root 12582912 Dec 27 15:25 ibtmp1
drwxr-x---. 2 root root 6 Dec 27 15:25 #innodb_redo
drwxr-x---. 2 root root 19 Dec 27 15:25 jyc
drwxr-x---. 2 root root 22 Dec 27 15:25 jycdb
drwxr-x---. 2 root root 92 Dec 27 15:25 mysql
-rw-r-----. 1 root root 277 Dec 27 15:25 mysql-bin.000007
-rw-r-----. 1 root root 17 Dec 27 15:25 mysql-bin.index
-rw-r-----. 1 root root 25165824 Dec 27 15:25 mysql.ibd
drwxr-x---. 2 root root 64 Dec 27 15:25 performance_schema
drwxr-x---. 2 root root 28 Dec 27 15:25 sys
drwxr-x---. 2 root root 19 Dec 27 15:25 test
-rw-r-----. 1 root root 16777216 Dec 27 15:25 undo_001
-rw-r-----. 1 root root 16777216 Dec 27 15:25 undo_002
-rw-r-----. 1 root root 16777216 Dec 27 15:25 undo003.ibu
-rw-r-----. 1 root root 652 Dec 27 15:25 xtrabackup_info
[root@mysql1 ~]# chown -R mysql.mysql /mysql/data
[root@mysql1 ~]# ll /mysql/data
total 98324
-rw-r-----. 1 mysql mysql 6459 Dec 27 15:25 ib_buffer_pool
-rw-r-----. 1 mysql mysql 12582912 Dec 27 15:25 ibdata1
-rw-r-----. 1 mysql mysql 12582912 Dec 27 15:25 ibtmp1
drwxr-x---. 2 mysql mysql 6 Dec 27 15:25 #innodb_redo
drwxr-x---. 2 mysql mysql 19 Dec 27 15:25 jyc
drwxr-x---. 2 mysql mysql 22 Dec 27 15:25 jycdb
drwxr-x---. 2 mysql mysql 92 Dec 27 15:25 mysql
-rw-r-----. 1 mysql mysql 277 Dec 27 15:25 mysql-bin.000007
-rw-r-----. 1 mysql mysql 17 Dec 27 15:25 mysql-bin.index
-rw-r-----. 1 mysql mysql 25165824 Dec 27 15:25 mysql.ibd
drwxr-x---. 2 mysql mysql 64 Dec 27 15:25 performance_schema
drwxr-x---. 2 mysql mysql 28 Dec 27 15:25 sys
drwxr-x---. 2 mysql mysql 19 Dec 27 15:25 test
-rw-r-----. 1 mysql mysql 16777216 Dec 27 15:25 undo_001
-rw-r-----. 1 mysql mysql 16777216 Dec 27 15:25 undo_002
-rw-r-----. 1 mysql mysql 16777216 Dec 27 15:25 undo003.ibu
-rw-r-----. 1 mysql mysql 652 Dec 27 15:25 xtrabackup_info
[root@mysql1 ~]# service mysql start
Starting MySQL.Logging to '/mysql/data/mysql1.err'.
.. SUCCESS!
[root@mysql1 ~]# mysql -u root -pabcd1234
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.31 MySQL Community Server - GPL
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show master status\G;
*************************** 1. row ***************************
File: mysql-bin.000008
Position: 277
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 0489844a-85ae-11ed-97ee-d67f35a9de29:1-5,
740dc65b-7ced-11ed-9e87-82b000a4e5ee:1-9,
d0271cef-7782-11ed-828a-d67f35a9de29:1-5
1 row in set (0.00 sec)
ERROR:
No query specified
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: 192.168.207.132
Master_User: root
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000003
Read_Master_Log_Pos: 197
Relay_Log_File: mysql1-relay-bin.000009
Relay_Log_Pos: 1401
Relay_Master_Log_File: mysql-bin.000003
Slave_IO_Running: No
Slave_SQL_Running: No
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: 1185
Relay_Log_Space: 0
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: 0
Master_UUID: 0489844a-85ae-11ed-97ee-d67f35a9de29
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set: 0489844a-85ae-11ed-97ee-d67f35a9de29:1-5,
740dc65b-7ced-11ed-9e87-82b000a4e5ee:1-9,
d0271cef-7782-11ed-828a-d67f35a9de29:1-5
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
Master_public_key_path:
Get_master_public_key: 0
Network_Namespace:
1 row in set, 1 warning (0.00 sec)
ERROR:
No query specified
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: 192.168.207.132
Master_User: root
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000003
Read_Master_Log_Pos: 197
Relay_Log_File: mysql1-relay-bin.000009
Relay_Log_Pos: 1401
Relay_Master_Log_File: mysql-bin.000003
Slave_IO_Running: No
Slave_SQL_Running: No
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: 1185
Relay_Log_Space: 0
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: 0
Master_UUID: 0489844a-85ae-11ed-97ee-d67f35a9de29
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set: 0489844a-85ae-11ed-97ee-d67f35a9de29:1-5,
740dc65b-7ced-11ed-9e87-82b000a4e5ee:1-9,
d0271cef-7782-11ed-828a-d67f35a9de29:1-5
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
Master_public_key_path:
Get_master_public_key: 0
Network_Namespace:
1 row in set, 1 warning (0.00 sec)
ERROR:
No query specified
mysql> show processlist;
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 40 | Waiting on empty queue | NULL |
| 8 | root | localhost | NULL | Query | 0 | init | show processlist |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
2 rows in set (0.00 sec)
mysql> show processlist;
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 42 | Waiting on empty queue | NULL |
| 8 | root | localhost | NULL | Query | 0 | init | show processlist |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
2 rows in set (0.00 sec)
mysql> show processlist;
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 43 | Waiting on empty queue | NULL |
| 8 | root | localhost | NULL | Query | 0 | init | show processlist |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
2 rows in set (0.00 sec)
mysql> show processlist;
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 44 | Waiting on empty queue | NULL |
| 8 | root | localhost | NULL | Query | 0 | init | show processlist |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
2 rows in set (0.00 sec)
mysql> show processlist;
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 46 | Waiting on empty queue | NULL |
| 8 | root | localhost | NULL | Query | 0 | init | show processlist |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
2 rows in set (0.00 sec)
mysql> show processlist;
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 79 | Waiting on empty queue | NULL |
| 8 | root | localhost | NULL | Query | 0 | init | show processlist |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
2 rows in set (0.00 sec)
mysql> show processlist;
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 80 | Waiting on empty queue | NULL |
| 8 | root | localhost | NULL | Query | 0 | init | show processlist |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
2 rows in set (0.00 sec)
mysql> show processlist;
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 81 | Waiting on empty queue | NULL |
| 8 | root | localhost | NULL | Query | 0 | init | show processlist |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
2 rows in set (0.00 sec)
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: 192.168.207.132
Master_User: root
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000003
Read_Master_Log_Pos: 197
Relay_Log_File: mysql1-relay-bin.000009
Relay_Log_Pos: 1401
Relay_Master_Log_File: mysql-bin.000003
Slave_IO_Running: No
Slave_SQL_Running: No
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: 1185
Relay_Log_Space: 0
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: 0
Master_UUID: 0489844a-85ae-11ed-97ee-d67f35a9de29
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set: 0489844a-85ae-11ed-97ee-d67f35a9de29:1-5,
740dc65b-7ced-11ed-9e87-82b000a4e5ee:1-9,
d0271cef-7782-11ed-828a-d67f35a9de29:1-5
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
Master_public_key_path:
Get_master_public_key: 0
Network_Namespace:
1 row in set, 1 warning (0.00 sec)
ERROR:
No query specified
mysql> start slave;
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: 192.168.207.132
Master_User: root
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000003
Read_Master_Log_Pos: 197
Relay_Log_File: mysql1-relay-bin.000009
Relay_Log_Pos: 1401
Relay_Master_Log_File: mysql-bin.000003
Slave_IO_Running: No
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 13124
Last_Error: Slave failed to initialize relay log info structure from the repository
Skip_Counter: 0
Exec_Master_Log_Pos: 1185
Relay_Log_Space: 0
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: 13124
Last_SQL_Error: Slave failed to initialize relay log info structure from the repository
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
Master_UUID: 0489844a-85ae-11ed-97ee-d67f35a9de29
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp: 221227 15:27:38
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set: 0489844a-85ae-11ed-97ee-d67f35a9de29:1-5,
740dc65b-7ced-11ed-9e87-82b000a4e5ee:1-9,
d0271cef-7782-11ed-828a-d67f35a9de29:1-5
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
Master_public_key_path:
Get_master_public_key: 0
Network_Namespace:
1 row in set, 1 warning (0.00 sec)
ERROR:
No query specified
mysql> stop slave;
Query OK, 0 rows affected, 2 warnings (0.00 sec)
mysql> start slave;
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository
mysql> reset slave;
Query OK, 0 rows affected, 1 warning (0.03 sec)
mysql> start slave;
Query OK, 0 rows affected, 1 warning (0.03 sec)
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for source to send event
Master_Host: 192.168.207.132
Master_User: root
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000003
Read_Master_Log_Pos: 1185
Relay_Log_File: mysql1-relay-bin.000003
Relay_Log_Pos: 420
Relay_Master_Log_File: mysql-bin.000003
Slave_IO_Running: Yes
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: 1185
Relay_Log_Space: 811
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: 0
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_UUID: 0489844a-85ae-11ed-97ee-d67f35a9de29
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Replica has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set: 0489844a-85ae-11ed-97ee-d67f35a9de29:1-5,
740dc65b-7ced-11ed-9e87-82b000a4e5ee:1-9,
d0271cef-7782-11ed-828a-d67f35a9de29:1-5
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
Master_public_key_path:
Get_master_public_key: 0
Network_Namespace:
1 row in set, 1 warning (0.00 sec)
ERROR:
No query specified
mysql> show master status\G;
*************************** 1. row ***************************
File: mysql-bin.000008
Position: 277
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 0489844a-85ae-11ed-97ee-d67f35a9de29:1-5,
740dc65b-7ced-11ed-9e87-82b000a4e5ee:1-9,
d0271cef-7782-11ed-828a-d67f35a9de29:1-5
1 row in set (0.00 sec)
ERROR:
No query specified
mysql> select * from test.t;
+------+
| id |
+------+
| 1 |
| 2 |
+------+
2 rows in set (0.00 sec)
mysql> show master status\G;
*************************** 1. row ***************************
File: mysql-bin.000008
Position: 551
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 0489844a-85ae-11ed-97ee-d67f35a9de29:1-6,
740dc65b-7ced-11ed-9e87-82b000a4e5ee:1-9,
d0271cef-7782-11ed-828a-d67f35a9de29:1-5
1 row in set (0.00 sec)
ERROR:
No query specified
mysql> show processlist;
+----+-----------------+-----------------+------+---------+------+----------------------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------------+------+---------+------+----------------------------------------------------------+------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 565 | Waiting on empty queue | NULL |
| 8 | root | localhost | NULL | Query | 0 | init | show processlist |
| 9 | system user | connecting host | NULL | Connect | 363 | Waiting for source to send event | NULL |
| 10 | system user | | NULL | Query | 335 | Replica has read all relay log; waiting for more updates | NULL |
| 11 | system user | | NULL | Query | 338 | Waiting for an event from Coordinator | NULL |
| 12 | system user | | NULL | Connect | 363 | Waiting for an event from Coordinator | NULL |
| 13 | system user | | NULL | Connect | 363 | Waiting for an event from Coordinator | NULL |
| 14 | system user | | NULL | Connect | 363 | Waiting for an event from Coordinator | NULL |
+----+-----------------+-----------------+------+---------+------+----------------------------------------------------------+------------------+
8 rows in set (0.00 sec)
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for source to send event
Master_Host: 192.168.207.132
Master_User: root
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000003
Read_Master_Log_Pos: 1457
Relay_Log_File: mysql1-relay-bin.000003
Relay_Log_Pos: 692
Relay_Master_Log_File: mysql-bin.000003
Slave_IO_Running: Yes
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: 1457
Relay_Log_Space: 1083
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: 0
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_UUID: 0489844a-85ae-11ed-97ee-d67f35a9de29
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Replica has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set: 0489844a-85ae-11ed-97ee-d67f35a9de29:6
Executed_Gtid_Set: 0489844a-85ae-11ed-97ee-d67f35a9de29:1-6,
740dc65b-7ced-11ed-9e87-82b000a4e5ee:1-9,
d0271cef-7782-11ed-828a-d67f35a9de29:1-5
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
Master_public_key_path:
Get_master_public_key: 0
Network_Namespace:
1 row in set, 1 warning (0.00 sec)
ERROR:
No query specified
mysql>
主库操作：
[root@mysql2 ~]# mysql -h 192.168.207.132 -P 3306 -u root -pabcd1234
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.31 MySQL Community Server - GPL
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show slave status\G;
Empty set, 1 warning (0.00 sec)
ERROR:
No query specified
mysql> show master status\G;
*************************** 1. row ***************************
File: mysql-bin.000003
Position: 1185
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 0489844a-85ae-11ed-97ee-d67f35a9de29:1-5,
d0271cef-7782-11ed-828a-d67f35a9de29:1-5
1 row in set (0.00 sec)
ERROR:
No query specified
mysql> show processlist;
+----+-----------------+-----------------------+------+---------+------+------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------------------+------+---------+------+------------------------+------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 4205 | Waiting on empty queue | NULL |
| 10 | root | 192.168.207.132:57476 | NULL | Query | 0 | init | show processlist |
+----+-----------------+-----------------------+------+---------+------+------------------------+------------------+
2 rows in set (0.00 sec)
mysql> show processlist;
+----+-----------------+-----------------------+------+---------+------+------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------------------+------+---------+------+------------------------+------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 4209 | Waiting on empty queue | NULL |
| 10 | root | 192.168.207.132:57476 | NULL | Query | 0 | init | show processlist |
+----+-----------------+-----------------------+------+---------+------+------------------------+------------------+
2 rows in set (0.00 sec)
mysql> insert into t values(2);
ERROR 1046 (3D000): No database selected
mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> insert into t values(2);
Query OK, 1 row affected (0.01 sec)
mysql> select * from test.t;
+------+
| id |
+------+
| 1 |
| 2 |
+------+
2 rows in set (0.00 sec)
mysql> show processlist;
+----+-----------------+-----------------------+------+------------------+------+-----------------------------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------------------+------+------------------+------+-----------------------------------------------------------------+------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 4645 | Waiting on empty queue | NULL |
| 10 | root | 192.168.207.132:57476 | test | Query | 0 | init | show processlist |
| 11 | root | 192.168.207.131:35208 | NULL | Binlog Dump GTID | 308 | Source has sent all binlog to replica; waiting for more updates | NULL |
+----+-----------------+-----------------------+------+------------------+------+-----------------------------------------------------------------+------------------+
3 rows in set (0.00 sec)
mysql> show slave status\G;
Empty set, 1 warning (0.00 sec)
ERROR:
No query specified
mysql> show master status\G;
*************************** 1. row ***************************
File: mysql-bin.000003
Position: 1457
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set: 0489844a-85ae-11ed-97ee-d67f35a9de29:1-6,
d0271cef-7782-11ed-828a-d67f35a9de29:1-5
1 row in set (0.00 sec)
ERROR:
No query specified
mysql>
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
