/requirements.txt PyMySQL==0.9.3 wheel==0.29.0 mysql-replication==0.21 此外,为了防止遇到乱码问题,还需要改下 binlog2sql_util.py
步骤2:安装clickhouse-mysql 安装pip: 执行pypy/bin/pypy3 -m ensurepip 安装mysql-replication,clickhouse-driver, 执行 pypy/bin/pip3 install mysql-replication和pypy/bin/pip3 install clickhouse-driver 安装clickhouse-mysql并初始化
比如你的环境是mysql-replication:0.31, pymysql1.0.2.
步骤2:安装clickhouse-mysql 安装pip: 执行 pypy/bin/pypy3 -m ensurepip 安装mysql-replication,clickhouse-driver, 执行 pypy/bin/pip3 install mysql-replication 和 pypy/bin/pip3 install clickhouse-driver 安装clickhouse-mysql
连接数满的时候,就可以通过这种方法修改最大连接数)图片图片tc_log->commit终于到commit阶段了图片binlog生成之类的都不看了(要解析Binlog的话,可以使用mysql-replication
2.1 安装配置 获取源代码 git clone http://www.github.com/noplay/python-mysql-replication 使用pip 安装 pip install mysql-replication
/usr/lib/python2.7/site-packages (from -r requirements.txt (line 2)) Requirement already satisfied: mysql-replication
该插件也会使用一个mysql-replication的开源库,该库也是由Python3开发。从MySQL表中拉取行镜像并存储成JSONB形式,然后同步到PG数据库。
get-pip.py /usr/lib64/pypy-5.0.1/bin/pip install MySQL-python /usr/lib64/pypy-5.0.1/bin/pip install mysql-replication
github.com/danfengcao/binlog2sql binlog2sql是大众点评开源的一款用于解析binlog的工具 依赖包 PyMySQL==0.7.11 wheel==0.29.0 mysql-replication