Skip to content

hikdo/py-mysql-es

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

py-mysql-es

mysql binlog sync to elasticsearch

Installation

pip install yaml
pip install pyelasticsearch
pip install mysql-replication

MySQL server settings

In your MySQL server configuration file you need to enable replication:

[mysqld]
server-id        = 1
log_bin          = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size  = 100M
binlog-format    = row

MySQL user privileges

CREATE USER es IDENTIFIED BY 'es';
GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'es'@'%';
-- GRANT ALL PRIVILEGES ON *.* TO 'es'@'%' ;
FLUSH PRIVILEGES;

About

mysql binlog to es

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages