当前位置:网站首页>mysql 5.1升级到5.610

mysql 5.1升级到5.610

2022-04-23 14:06:00 franket

重启mysql

[root@upgrade-slave ~]# /etc/init.d/mysql  stop 
Shutting down MySQL (Percona Server)...                    [  OK  ]
[root@upgrade-slave ~]# /etc/init.d/mysql  start
Starting MySQL (Percona Server)...........                 [  OK  ]
[root@upgrade-slave ~]# 

检查日志

151126 21:49:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-11-26 21:49:21 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-26 21:49:21 0 [Note] /usr/sbin/mysqld (mysqld 5.6.27-75.0-log) starting as process 20186 ...
2015-11-26 21:49:21 20186 [Warning] option 'innodb-autoextend-increment': unsigned value 33554432 adjusted to 1000
2015-11-26 21:49:21 20186 [Note] Plugin 'FEDERATED' is disabled.
2015-11-26 21:49:21 7f8f2869e7e0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-11-26 21:49:21 20186 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-11-26 21:49:21 20186 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-26 21:49:21 20186 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-11-26 21:49:21 20186 [Note] InnoDB: Memory barrier is not used
2015-11-26 21:49:21 20186 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-26 21:49:21 20186 [Note] InnoDB: Using Linux native AIO
2015-11-26 21:49:21 20186 [Note] InnoDB: Using CPU crc32 instructions
2015-11-26 21:49:21 20186 [Note] InnoDB: Initializing buffer pool, size = 20.0G
2015-11-26 21:49:25 20186 [Note] InnoDB: Completed initialization of buffer pool
2015-11-26 21:49:29 20186 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-26 21:49:30 20186 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-26 21:49:30 20186 [Note] InnoDB: Waiting for purge to start
2015-11-26 21:49:30 20186 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.27-75.0 started; log sequence number 4538185053276
2015-11-26 21:49:30 20186 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2015-11-26 21:49:30 20186 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2015-11-26 21:49:30 20186 [Note] Server hostname (bind-address): '*'; port: 3306
2015-11-26 21:49:30 20186 [Note] IPv6 is available.
2015-11-26 21:49:30 20186 [Note]   - '::' resolves to '::';
2015-11-26 21:49:30 20186 [Note] Server socket created on IP: '::'.
2015-11-26 21:49:30 20186 [Note] Event Scheduler: Loaded 0 events
2015-11-26 21:49:30 20186 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.27-75.0-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Percona Server (GPL), Release 75.0, Revision 8bb53b6

schema的结构报错已经消失了,启动正常


同步数据库

mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000004 |      120 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

mysql> show slave status\G
Empty set (0.00 sec)

mysql> 
mysql>  CHANGE MASTER TO MASTER_HOST='192.168.100.123', MASTER_PORT=3306, MASTER_LOG_FILE='mysql-bin.000899',MASTER_LOG_POS=451678342,MASTER_USER='repl',MASTER_PASSWORD='xxxxxx';
Query OK, 0 rows affected, 2 warnings (0.33 sec)

mysql> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: 
                  Master_Host: 192.168.100.123
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000899
          Read_Master_Log_Pos: 451678342
               Relay_Log_File: relay-bin.000001
                Relay_Log_Pos: 4
        Relay_Master_Log_File: mysql-bin.000899
             Slave_IO_Running: No
            Slave_SQL_Running: No
              Replicate_Do_DB: 
          Replicate_Ignore_DB: mysql,feeddb,mytempdb
           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: 451678342
              Relay_Log_Space: 120
              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: 
             Master_Info_File: /var/lib/mysql/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: 
                Auto_Position: 0
1 row in set (0.00 sec)

mysql> start slave;
Query OK, 0 rows affected (0.03 sec)

mysql> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Queueing master event to the relay log
                  Master_Host: 192.168.100.123
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000899
          Read_Master_Log_Pos: 465602930
               Relay_Log_File: relay-bin.000002
                Relay_Log_Pos: 585
        Relay_Master_Log_File: mysql-bin.000899
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB: 
          Replicate_Ignore_DB: mysql,feeddb,mytempdb
           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: 451678658
              Relay_Log_Space: 13925024
              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: 82821
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: 3
                  Master_UUID: 
             Master_Info_File: /var/lib/mysql/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Opening tables
           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: 
                Auto_Position: 0
1 row in set (0.00 sec)

mysql> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.100.123
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000900
          Read_Master_Log_Pos: 745342806
               Relay_Log_File: relay-bin.000002
                Relay_Log_Pos: 51863048
        Relay_Master_Log_File: mysql-bin.000899
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB: 
          Replicate_Ignore_DB: mysql,feeddb,mytempdb
           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: 503541121
              Relay_Log_Space: 1368280295
              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: 77965
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: 3
                  Master_UUID: 
             Master_Info_File: /var/lib/mysql/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: System lock
           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: 
                Auto_Position: 0
1 row in set (0.00 sec)

mysql> 

版权声明
本文为[franket]所创,转载请带上原文链接,感谢
https://cloud.tencent.com/developer/article/1986105