Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

mysqlrouter read/only connection (Classic MySQL protocol ) - howto?

RudiSep 26 2018 — edited Sep 26 2018

Hi

I started to explore the Mysql InnoDB cluster 8.

I installed mysqlrouter on my application server.

I successfully created a read/write connection,using 6446 port

I cant create a read/only connection, using the 6447 port, with the same account and password.

Any ideas?

Thanks,

Rudi

This post has been answered by lefred-MySQL-Oracle on Sep 26 2018
Jump to Answer

Comments

lefred-MySQL-Oracle
Answer

Hi Rudi,

If you have a InnoDB Cluster, you can use the boostrap method of mysql-router to configure the router. It will create the configuration to listen to 4 ports:

1 R/W for standard MySQL protocol

1 R/O for standard MySQL protocol

1 R/W for MySQL X protocol

1 R/O for MySQL X protocol

https://dev.mysql.com/doc/mysql-router/8.0/en/mysql-router-deploying-bootstrapping.html

Cheers,

lefred

Marked as Answer by Rudi · Sep 27 2020
1 - 1

Post Details

Added on Sep 26 2018
1 comment
506 views