DBPack 读写分离功能发布公告

07 00 00 // 前 3 个字节表示 payload 的长度为 7 个字节 01       // sequence 响应的序号，前 4 个字节一起构成了 OKPacket 的 header 00       // 标识 payload 为 OKPacket 00       // affected row 00       // last insert id 03 00    // 状态标志位 00 00    // warning 数量

SELECT /*+ UseDB('employees-master') */ emp_no, birth_date, first_name, last_name, gender, hire_date FROM employees WHERE emp_no = ?

filters:  - name: auditLogFilter    kind: AuditLogFilter    conf:      audit_log_dir: /var/log/dbpack/      # unit MB      max_size: 300      # unit Day      max_age: 28      # maximum number of old log files to retain      max_backups: 1      # determines if the rotated log files should be compressed using gzip      compress: true      # whether to record the audit log before or after the sql request is actually executed      record_before: true

[timestamp],[username],[ip address],[connection id],[command type],[command],[sql text],[args],[affected row]

2022-06-14 07:15:44,dksl,172.18.0.1:60372,1,COM_QUERY,,SET NAMES utf8mb4,[],02022-06-14 07:15:45,dksl,172.18.0.1:60372,1,COM_STMT_EXECUTE,INSERT,INSERT INTO employees ( emp_no, birth_date, first_name, last_name, gender, hire_date ) VALUES (?, ?, ?, ?, ?, ?),['100000' '1992-01-07' 'scott' 'lewis' 'M' '2014-09-01'],12022-06-14 07:15:45,dksl,172.18.0.1:60372,1,COM_STMT_EXECUTE,DELETE,DELETE FROM employees WHERE emp_no = ?,['100000'],12022-06-14 07:15:45,dksl,172.18.0.1:60372,1,COM_STMT_EXECUTE,INSERT,INSERT INTO employees ( emp_no, birth_date, first_name, last_name, gender, hire_date ) VALUES (?, ?, ?, ?, ?, ?),['100001' '1992-01-07' 'scott' 'lewis' 'M' '2014-09-01'],12022-06-14 07:15:45,dksl,172.18.0.1:60372,1,COM_STMT_EXECUTE,SELECT,SELECT emp_no, birth_date, first_name, last_name, gender, hire_date FROM employees WHERE emp_no = ?,['100001'],0