search

PeerDB-io / peerdb

Fast, Simple and a cost effective tool to replicate data from Postgres to Data Warehouses, Queues and Storage
https://peerdb.io
Other
2.25k stars 92 forks source link

error creating MySQL Peer #2005

Open sapisuper opened 2 months ago

sapisuper commented 2 months ago

hi I want to create peer connection mysql but getting error.

step to do :

  1. login into peerdb psql "port=9900 host=127.0.0.1 password=peerdb user=postgres"

  2. execute command CREATE PEER CREATE PEER mysql_peer FROM MYSQL WITH ( host='127.0.0.1', port=3306, user='root', password='', database='v1_test', disable_tls=false );

error come up : 

postgres=> CREATE PEER mysql_peer FROM MYSQL WITH (
postgres(>     host='127.0.0.1',
postgres(>     port=3306,
postgres(>     user='root',
postgres(>     password='',
postgres(>     database='v1_test',
postgres(>     disable_tls=false
postgres(> );
ERROR:  User provided error: ErrorInfo { severity: "ERROR", code: "internal_error", message: "failed to create peer: invalid config for MYSQL peer mysql_peer", detail: None, hint: None, position: None, internal_position: None, internal_query: None, where_context: None, file_name: None, line: None, routine: None }