linux_mysql

安装

[root@localhost ~]# wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

[root@localhost ~]# rpm -ivh mysql57-community-release-el7-8.noarch.rpm

[root@localhost ~]# yum install mysql-server

[root@localhost ~]# systemctl start mysqld

[root@localhost ~]# grep password /var/log/mysqld.log  //查看密码

mysql> set global validate_password_length=1; //修改密码策略

mysql> set global validate_password_policy=0；

mysql> set password=password("root");
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

文件介绍:

数据文件 /var/lib/mysql/   配置文件 /etc/my.cnf  日志文件 /var/log/mysql.log

主从
mysql> create user repl identified by 'repl';

mysql> grant replication slave on *.* to 'repl'@'%' identified by 'repl';  //slave访问master的账户密码

vi /etc/my.cnf

[mysqld]
log-bin=mysql-bin  //二进制日志
server-id=29

[root@localhost ~]# systemctl restart mysqld   //重启

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

mysql> 

关闭防火墙

[root@localhost ~]# systemctl stop firewalld
[root@localhost ~]# systemctl status firewalld

切换到从库所在的机器

[mysqld]
server-id=30
relay-log=slave-relay-bin
relay-log-index=slave-relay-bin.index
read_only=1
mysql> change master to master_host='192.168.19.29',master_port=3306,master_user='repl',master_password='repl',master_log_file='mysql-bin.000001',master_log_pos=154;

mysql> start slave;

mysql> show slave status\G

*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.19.29
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000001
          Read_Master_Log_Pos: 154
               Relay_Log_File: slave-relay-bin.000002
                Relay_Log_Pos: 320
        Relay_Master_Log_File: mysql-bin.000001
             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: 154
              Relay_Log_Space: 527
              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: 29
                  Master_UUID: 26023780-0d0f-11e9-a0b1-000c29bba692
             Master_Info_File: /var/lib/mysql/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave 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: 
                Auto_Position: 0
         Replicate_Rewrite_DB: 
                 Channel_Name: 
           Master_TLS_Version: 
1 row in set (0.00 sec)
说明：binlog:用来记录数据库的跟新 文件内容/var/lib/mysql/

查看二进制日志内容 [root@localhost mysql]# mysqlbinlog --base64-output=decode-rows -v mysql-bin.000001

mysql> show binlog events in 'mysql-bin.000001';

mysql> show variables like '%log%'; //查看日志模式

mysql> set global binlog_format='mixed'; //修改日志模式