1 源库配置

1.1 修改配置文件

1.1.1 查看OB数据库模式

MySQL [oceanbase]> show variables like 'ob_compatibility_mode';
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| ob_compatibility_mode | MYSQL |
+-----------------------+-------+
1 row in set (0.003 sec)

1.1.2 检查归档是否开启

• 检查归档是否开启

obclient [oceanbase]> show parameters like 'enable_log_archive';
+--------+----------+---------------+----------+--------------------+-----------+-------+-------------------------------+----------+---------+---------+-------------------+
| zone   | svr_type | svr_ip        | svr_port | name               | data_type | value | info                          | section  | scope   | source  | edit_level        |
+--------+----------+---------------+----------+--------------------+-----------+-------+-------------------------------+----------+---------+---------+-------------------+
| zone_1 | observer | 192.168.2.154 |     2882 | enable_log_archive | NULL      | True  | control if enable log archive | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
+--------+----------+---------------+----------+--------------------+-----------+-------+-------------------------------+----------+---------+---------+-------------------+
1 row in set (0.024 sec)

SELECT TENANT_NAME, LOG_MODE FROM oceanbase.DBA_OB_TENANTS WHERE TENANT_TYPE = 'USER'\G
*************************** 1. row ***************************
TENANT_NAME: uf30
   LOG_MODE: ARCHIVELOG
1 row in set (0.006 sec)

• 打开归档

MySQL [(none)]> ALTER SYSTEM ARCHIVELOG;
Query OK, 0 rows affected (0.428 sec)

• 要求开启归档（enable_log_archive=True）
• 设置归档位置

MySQL [(none)]> alter system set backup_dest='file:///home///admin///obbackup';
Query OK, 0 rows affected (0.195 sec)

• 说明：
  1.用户在配置数据库信息时需要在user处填写user@tenant_name格式的用户名，如果用户是集群用户，请勿填写#cluster_name,集群标识会导致无法解析当前用户的增量日志。端口需要填写2881。
  2.数据库的sys租户不能作为数据同步用户。
  3.zcbus_service后台程序需要和OceanBase库在一个局域网，real进程需要执行SHOW parameters LIKE ‘obconfig_url’命令获取并连接管理端口（默认2882），如果设置了端口转发会导致增量日志分析不到
  4.OceanBase各个版本之间权限视图不一致，无法细致区分，DBA权限可规避该问题。

1.2 创建用户及赋权

1.2.1 创建用户

create user zcbus identified by '******';

1.2.2 用户赋权

GRANT SELECT, SHOW VIEW, SHOW DATABASES ON *.* TO zcbus;
GRANT SELECT ON oceanbase.dba_ob_archivelog TO zcbus;

1.2.3 权限查询

show grants for zcbus;

2 补充说明

2.1 数据类型支持