maxwell + kafka + bireme传统数仓实时同步方案

1. mysql(maridb) 开启binlog

SHOW VARIABLES LIKE '%log_bin%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | OFF   |
+---------------+-------+
--  如果返回OFF 没有开启，ON 则是已经开启

##1.1 设置开启login

修改my.cnf，mysql 一般位于 $/etc/my.cnf$ maridb一般位于$/etc/my.cnf.d/server.cnf$

# mysqld 中添加如下
[mysqld]
log-bin = mysql-bin #开启binlog
binlog-format = ROW #选择row模式
server_id = 1 #配置mysql replication需要定义，不能和canal的slaveId重复

修改后重启数据库

service mysql restart

检查是否开启

show global variables like "%log_bin%";
+---------------------------------+---------------------------------------+
| Variable_name                   | Value                                 |
+---------------------------------+---------------------------------------+
| log_bin                         | ON                                    |
| log_bin_basename                | /usr/local/mysql/data/mysql-bin       |
| log_bin_index                   | /usr/local/mysql/data/mysql-bin.index |
| log_bin_trust_function_creators | OFF                                   |
| log_bin_use_v1_row_events       | OFF