1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
mysql> USE about;

mysql> SELECT * FROM basic_info;
+----+-----------+---------------------------+
| id | item | description |
+----+-----------+---------------------------+
| 1 | Job | MySQL DBA |
+----+-----------+---------------------------+
| 2 | Location | Shanghai |
+----+-----------+---------------------------+
| 3 | Education | Bachelor |
+----+-----------+---------------------------+
| 4 | E-mail | root@mysql-dba.com |
+----+-----------+---------------------------+
| 5 | QQ | 80803824 |
+----+-----------+---------------------------+
| 6 | WeChat | cothean |
+----+-----------+---------------------------+

mysql> SELECT * FROM dba_skills;
+----+-----------------------+-----------------------------------------------------------------+
| id | item | description |
+----+-----------------------+-----------------------------------------------------------------+
| 1 | Operating System | CentOS/RHEL, Ubuntu, Shell |
+----+-----------------------+-----------------------------------------------------------------+
| 2 | MySQL Server | Architecture, Operating Mechanism |
+----+-----------------------+-----------------------------------------------------------------+
| 3 | InnoDB Storage Engine | Architecture, Internal Structure |
+----+-----------------------+-----------------------------------------------------------------+
| 4 | Replication | Async, Semi-Sync, Multi-Source |
+----+-----------------------+-----------------------------------------------------------------+
| 5 | Backup and Recovery | mysqldump, Xtrabackup, Binlog Server, mydumper |
+----+-----------------------+-----------------------------------------------------------------+
| 6 | HA and LB Solution | MS/MM, Xenon, MGR, MHA, Consul, Keepalived, LVS |
+----+-----------------------+-----------------------------------------------------------------+
| 7 | Optimization | Server Hardware, Operating System, Configuration Parameter, SQL |
+----+-----------------------+-----------------------------------------------------------------+
| 8 | Middleware | ProxySQL, Cetus, Radon, MyCAT |
+----+-----------------------+-----------------------------------------------------------------+
| 9 | Redis | Replication, Cluster, Sentinel |
+----+-----------------------+-----------------------------------------------------------------+
| 10 | MongoDB | Replica Set, Sharding |
+----+-----------------------+-----------------------------------------------------------------+
| 11 | Monitor | PMM, Zabbix |
+----+-----------------------+-----------------------------------------------------------------+
| 12 | Others | Server Management, IDC Construction |
+----+-----------------------+-----------------------------------------------------------------+

mysql> SELECT * FROM dev_skills;
+----+------------------------+--------------+
| id | item | description |
+----+------------------------+--------------+
| 1 | Language | Python |
+----+------------------------+--------------+
| 2 | Development Tool | PyCharm, Vim |
+----+------------------------+--------------+
| 3 | Code Version Control | Git, SVN |
+----+------------------------+--------------+
| 4 | Environment | Docker |
+----+------------------------+--------------+
| 5 | Continuous Integration | Jenkins |
+----+------------------------+--------------+