You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently, only MySQL/PostgreSQL dialects can be automatically translated. Engineers can use MySQL dialects and protocols to access PostgreSQL databases and vice versa.
But I don't konw how to use the feature. I want to use Mysql client to access PostgreSQL database.
I try to set server.yaml's props:proxy-frontend-database-protocol-type: MySQL
And config-yaml dataSources to jdbc:postgresql.
I can use MySQL cli client to connect to ShardingSphere-Proxy and see the database.
But show tables command return nothing. I can't see any tables.
Here's my yaml files. yaml.zip
By the way: If I change the server.yaml's proxy-frontend-database-protocol-type to PostgreSQL and use psql client to connect. It works well.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
In DB Gateway document. It says:
But I don't konw how to use the feature. I want to use Mysql client to access PostgreSQL database.
I try to set server.yaml's props:proxy-frontend-database-protocol-type: MySQL
And config-yaml dataSources to jdbc:postgresql.
I can use MySQL cli client to connect to ShardingSphere-Proxy and see the database.
But show tables command return nothing. I can't see any tables.
Here's my yaml files.
yaml.zip
By the way: If I change the server.yaml's proxy-frontend-database-protocol-type to PostgreSQL and use psql client to connect. It works well.
Beta Was this translation helpful? Give feedback.
All reactions