文件名称:py-mysql-es:mysql binlog到es
文件大小:62KB
文件格式:ZIP
更新时间:2024-06-01 04:29:10
Python
py-mysql-es mysql binlog同步到elasticsearch 安装 pip install yaml pip install pyelasticsearch pip install mysql-replication MySQL服务器设置 在您MySQL服务器配置文件中,您需要启用复制: [mysqld] server-id = 1 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M binlog-format = row MySQL用户权限 CREATE USER es IDENTIFIED BY 'es'; GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT
【文件预览】:
py-mysql-es-master
----requirements.txt(95B)
----etc()
--------config.yaml(398B)
----pymysqlreplication()
--------gtid.pyc(5KB)
--------event.pyc(11KB)
--------__init__.pyc(924B)
--------table.py(1KB)
--------__init__.py(734B)
--------gtid.py(3KB)
--------binlogstream.pyc(12KB)
--------table.pyc(2KB)
--------tests()
--------event.py(8KB)
--------constants()
--------bitmap.pyc(2KB)
--------bitmap.py(1KB)
--------packet.pyc(11KB)
--------row_event.pyc(19KB)
--------packet.py(9KB)
--------column.py(3KB)
--------binlogstream.py(18KB)
--------column.pyc(4KB)
--------row_event.py(22KB)
----sync.py(5KB)
----README.md(629B)
----logs()
--------run.log(0B)
----.editorconfig(57B)