MySQL????????????????
???????????? ???????[ 2015/11/17 13:21:23 ] ?????????????
????5?????????????
????mysql> show master status;
????+------------------+----------+--------------+------------------+
????| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
????+------------------+----------+--------------+------------------+
????| mysql-bin.000002 | 263 | | |
????+------------------+----------+--------------+------------------+
????6????????????
????mysql> change master to
????-> master_host='192.168.0.202'??
????-> master_user='sync'??
????-> master_password='1234.com'??
????-> master_log_file='mysql-bin.000002'??
????-> master_log_pos=263;
????#Log??pos??master???????????????????д??my.cnf???檔
????7?????slave????????????
????mysql> start slave;
????????Slave_IO_Running ?? Slave_SQL_Running ??????????YES???????????????
????8????????????
????????mysql?????????abc?????mysql?????????????
????mysql> create database abc;
????mysql> show databases;
????+--------------------+
????| Database |
????+--------------------+
????| information_schema |
????| abc |
????| mysql |
????| performance_schema |
????| test |
????+--------------------+
??????slave????????
????“Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’”
??????????????????????slave????master??????????????pos????????
??????flush logs????????????????????????? show master status;???????????????position???
????????slave?У???У?CHANGE MASTER TO MASTER_LOG_FILE=‘???????????’??MASTER_LOG_POS=?;
?????????????????start slave??
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11