Linuxインストールcanal
753 ワード
Mysql要件 mysql構成 を変更 canalアカウント を追加
配備canalダウンロードhttps://github.com/alibaba/canal/releases
vim /etc/my.conf
1.[mysqld]
2.log-bin=mysql-bin # ok
3.binlog-format=ROW # row
4.server_id=1 # mysql replaction , canal slaveId
[root@starrysky ~]# mysql -u root -p
Enter password:
1.CREATE USER canal IDENTIFIED BY 'canal';
2.GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%';
3.-- GRANT ALL PRIVILEGES ON *.* TO 'canal'@'%' ;
4.FLUSH PRIVILEGES;
show grants for 'canal';
mysql: service mysqld restart /etc/inint.d/mysqld restart
配備canal