第 3 章 启动服务

流程

1. 运行以下命令启动 MySQL 数据库，该命令启动配置了示例 inventory 数据库的 MySQL 数据库服务器：

   $ oc new-app -l app=mysql --name=mysql quay.io/debezium/example-mysql:latest

   Copy to Clipboard Toggle word wrap

2. 运行以下命令，为 MySQL 数据库配置凭证，该命令更新 MySQL 数据库的部署配置以添加用户名和密码：

   $ oc set env deployment/mysql MYSQL_ROOT_PASSWORD=debezium MYSQL_USER=mysqluser MYSQL_PASSWORD=mysqlpw

   Copy to Clipboard Toggle word wrap

3. 通过调用以下命令来验证 MySQL 数据库是否正在运行，该命令后跟显示 MySQL 数据库正在运行的输出，以及 pod 是否已就绪：

   $ oc get pods -l app=mysql
   NAME            READY   STATUS    RESTARTS   AGE
   mysql-1-2gzx5   1/1     Running   1          23s

   Copy to Clipboard Toggle word wrap

4. 打开一个新终端，再登录示例 inventory 数据库。

   此命令在运行 MySQL 数据库的 pod 中打开一个 MySQL 命令行客户端。客户端使用您之前配置的用户名和密码：

   $ oc exec mysql-1-2gzx5 -it -- mysql -u mysqluser -pmysqlpw inventory
   mysql: [Warning] Using a password on the command line interface can be insecure.
   Reading table information for completion of table and column names
   You can turn off this feature to get a quicker startup with -A
   
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 7
   Server version: 5.7.29-log MySQL Community Server (GPL)
   
   Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
   
   Oracle is a registered trademark of Oracle Corporation and/or its
   affiliates. Other names may be trademarks of their respective
   owners.
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   
   mysql>

   Copy to Clipboard Toggle word wrap

5. 列出 inventory 数据库中的表：

   mysql> show tables;
   +---------------------+
   | Tables_in_inventory |
   +---------------------+
   | addresses           |
   | customers           |
   | geom                |
   | orders              |
   | products            |
   | products_on_hand    |
   +---------------------+
   6 rows in set (0.00 sec)

   Copy to Clipboard Toggle word wrap

6. 探索数据库并查看其包含的数据，例如，查看 customers 表：

   mysql> select * from customers;
   +------+------------+-----------+-----------------------+
   | id   | first_name | last_name | email                 |
   +------+------------+-----------+-----------------------+
   | 1001 | Sally      | Thomas    | sally.thomas@acme.com |
   | 1002 | George     | Bailey    | gbailey@foobar.com    |
   | 1003 | Edward     | Walker    | ed@walker.com         |
   | 1004 | Anne       | Kretchmar | annek@noanswer.org    |
   +------+------------+-----------+-----------------------+
   4 rows in set (0.00 sec)

   Copy to Clipboard Toggle word wrap