测试环境安装配置obproxy(社区版)

测试环境安装obproxy，记录一下，已脱敏

[root@ensbrain data]# rpm -ivh obproxy-3.1.0-1.el7.x86_64.rpm
警告：obproxy-3.1.0-1.el7.x86_64.rpm: 头V4 RSA/SHA1 Signature, 密钥 ID e9b4a7aa: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:obproxy-3.1.0-1.el7              ################################# [100%]
[root@ensbrain data]#


[root@ensbrain data]# su - admin
上一次登录：三 11月  3 16:29:41 CST 2021pts/0 上
[admin@ensbrain ~]$ cd /opt/data/obproxy && /home/admin/obproxy-3.1.0/bin/obproxy -p2883 -c obcluster -r "10.X.X.153:2881" -o "enable_cluster_checkout=false,enable_strict_kernel_release=false,enable_metadb_used=false"
/home/admin/obproxy-3.1.0/bin/obproxy -p2883 -c obcluster -r 10.X.X.153:2881 -o enable_cluster_checkout=false,enable_strict_kernel_release=false,enable_metadb_used=false
listen port: 2883
cluster_name: obcluster
rs list: 10.X.X.153:2881
optstr: enable_cluster_checkout=false,enable_strict_kernel_release=false,enable_metadb_used=false
[admin@ensbrain obproxy]$ 
[admin@ensbrain obproxy]$ mysql -h127.1 -uroot@proxysys -P2883 -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.25

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MySQL [(none)]> 
MySQL [(none)]> alter proxyconfig set obproxy_sys_password='proxysys123456';
Query OK, 0 rows affected (0.002 sec)

MySQL [(none)]> alter proxyconfig set observer_sys_password='proxyro123456';
Query OK, 0 rows affected (0.001 sec)

MySQL [(none)]> show proxyconfig like '%sys_password%';
+-----------------------+------------------------------------------+--------------------------------+-------------+---------------+
| name                  | value                                    | info                           | need_reboot | visible_level |
+-----------------------+------------------------------------------+--------------------------------+-------------+---------------+
| observer_sys_password | dcb332deaee8b0030c3fd21a8e9f2813984339ea | password for observer sys user | false       | SYS           |
| obproxy_sys_password  | 3a8d187554571d6be2b27749187dcb8ca6285ede | password for obproxy sys user  | false       | SYS           |
+-----------------------+------------------------------------------+--------------------------------+-------------+---------------+
2 rows in set (0.001 sec)

MySQL [(none)]> Bye
[admin@ensbrain obproxy]$ mysql -h127.1 -uroot@sys#obcluster -P2883 -p123456 -c -A oceanbase
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.25 OceanBase 3.1.1 (r20210508100750-b47c8fdd84ca9281ec7cb0122ad8962aaa55e21a) (Built May  8 2021 10:37:40)

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MySQL [oceanbase]> select * from __all_server;
+----------------------------+----------------------------+------------+----------+----+-------+------------+-----------------+--------+-----------------------+-------------------------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+
| gmt_create                 | gmt_modified               | svr_ip     | svr_port | id | zone  | inner_port | with_rootserver | status | block_migrate_in_time | build_version                                                                       | stop_time | start_service_time | first_sessid | with_partition | last_offline_time |
+----------------------------+----------------------------+------------+----------+----+-------+------------+-----------------+--------+-----------------------+-------------------------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+
| 2021-11-02 15:56:17.636161 | 2021-11-02 16:46:41.380133 | 10.X.X.153 |     2882 |  1 | zone1 |       2881 |               1 | active |                     0 | 3.1.1_20210508100750-b47c8fdd84ca9281ec7cb0122ad8962aaa55e21a(May  8 2021 10:37:40) |         0 |   1635842800430174 |            0 |              1 |                 0 |
+----------------------------+----------------------------+------------+----------+----+-------+------------+-----------------+--------+-----------------------+-------------------------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+
1 row in set (0.010 sec)

MySQL [oceanbase]> show full processlist;