Hello World!

1
yum -y install mariadb mariadb-server
2
#启动Mariadb
3
systemctl start mariadb

1
[root@master ~]# vim /etc/my.cnf.d/server.cnf

1
[mysqld]
2
server-id=1
3
log-bin=master-bin

1
重启
2
[root@master ~]# systemctl  restart mariadb
3
登录数据库
4
[root@slave ~]# mysql -uroot
5
验证配置是否生效
6
MariaDB [(none)]> show master status;
7
+------------------+----------+--------------+------------------+
8
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
9
+------------------+----------+--------------+------------------+
10
| mysql-bin.000001 |      328 |              |                  |
11
+------------------+----------+--------------+------------------+
12
1 row in set (0.000 sec)
13
创建用户并授权
14
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'xiaye'@'%' IDENTIFIED BY '000000';
15
Query OK, 0 rows affected (0.001 sec)
16
MariaDB [(none)]> flush privileges;
17
Query OK, 0 rows affected (0.000 sec)

1
[root@slave ~]# vim /etc/my.cnf.d/server.cnf

1
[mysqld]
2
server-id=2
3
log-bin=mysql-bin

1
[root@slave ~]# systemctl  restart mariadb
2
登录数据库
3
[root@slave ~]# mysql -u root
4
连接主库
5
MariaDB [(none)]> change master to master_host='192.168.22.64',master_user='xiaye',master_password='000000';
6
Query OK, 0 rows affected (0.195 sec)
7
重启
8
[root@slave ~]# systemctl restart mariadb

1
[root@slave ~]# mysql -uroot
2
Welcome to the MariaDB monitor.  Commands end with ; or \g.
3
Your MariaDB connection id is 13
4
Server version: 10.3.23-MariaDB-log MariaDB Server
5
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
6

7
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
8

9
MariaDB [(none)]> show slave status \G
10
*************************** 1. row ***************************
11
Slave_IO_State: Waiting for master to send event
12
Master_Host: 192.168.22.64
13
Master_User: xiaye
14
Master_Port: 3306
15
Connect_Retry: 60
16
Master_Log_File: mysql-bin.000001
17
Read_Master_Log_Pos: 635
18
Relay_Log_File: slave-relay-bin.000003
19
Relay_Log_Pos: 934
20
Relay_Master_Log_File: mysql-bin.000001
21
Slave_IO_Running: Yes
22
Slave_SQL_Running: Yes
23
Replicate_Do_DB:
24
Replicate_Ignore_DB:
25
Replicate_Do_Table:
26
Replicate_Ignore_Table:
27
Replicate_Wild_Do_Table:
28
Replicate_Wild_Ignore_Table:
29
Last_Errno: 0
30
Last_Error:
31
Skip_Counter: 0
32
Exec_Master_Log_Pos: 635
33
Relay_Log_Space: 1243
34
Until_Condition: None
35
Until_Log_File:
36
Until_Log_Pos: 0
37
Master_SSL_Allowed: No
38
Master_SSL_CA_File:
39
Master_SSL_CA_Path:
40
Master_SSL_Cert:
41
Master_SSL_Cipher:
42
Master_SSL_Key:
43
Seconds_Behind_Master: 0
44
Master_SSL_Verify_Server_Cert: No
45
Last_IO_Errno: 0
46
Last_IO_Error:
47
Last_SQL_Errno: 0
48
Last_SQL_Error:
49
Replicate_Ignore_Server_Ids:
50
Master_Server_Id: 1
51
Master_SSL_Crl:
52
Master_SSL_Crlpath:
53
Using_Gtid: No
54
Gtid_IO_Pos:
55
Replicate_Do_Domain_Ids:
56
Replicate_Ignore_Domain_Ids:
57
Parallel_Mode: conservative
58
SQL_Delay: 0
59
SQL_Remaining_Delay: NULL
60
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
61
Slave_DDL_Groups: 2
62
Slave_Non_Transactional_Groups: 0
63
Slave_Transactional_Groups: 0
64
1 row in set (0.000 sec)