1+X中级C卷:主从数据库管理

MariaDB [(non)]> start slave;

MariaDB [(noпе)]> show slave statusG

hkkkkkkkkkkkkkkkkkkkk1. rowkkkkkkkkkkkkkkkkkkkkkkkki-k

Slave, _IO_ State: Waiting for master to send event

Master_ Host: mysql1

Master_ User: user

Master_ Port: 3306

Connect_ Retry: 6C

Master_ Log_ _File: mysql-bin.000003

Read_ Master Log_ Pos: 245

Relay Log. _File: mariadb-relay bin000005

Relay Log, Pos: 529

Relay_ Master _Log_ File: mysql-in.00003

Slave. IO_ Running: Yes

Slave_ SQL _Running: Yes

Replicate_ Do_ DB:

Replicate_ lgnore. _DB:

Replicate_ Do_ Table:

Replicate lgnore_ Table:

Replicate_ Wild, _Do_ Table:

Replicate_ Wild, lgnore Table:

Last Errno: 0

Last_ Error:

Skip_ Counter: 0

Exec_ Master Log. Pos: 245

Relav Ioa Snace: 1256

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: NoLast_ IO _Errno: 0

Last_ IO Error:

Last SQL Errno: 0

Last SQL_ Error:

Replicate_ Ignore Server_ Ids:Master_ Server ld; 30

1 row in set (0.00 sec)