peerdb
peerdb copied to clipboard
error creating MySQL Peer
hi I want to create peer connection mysql but getting error.
step to do :
-
login into peerdb psql "port=9900 host=127.0.0.1 password=peerdb user=postgres"
-
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 }
MySQL peer creation is now supported in the UI