MySQL Forums
Forum List  »  Router & Proxy

Slowness using MySQL Router
Posted by: Filippo Ciotta
Date: December 22, 2017 08:23AM

Hello,
I'm a newbie with MySQL so sorry in advance for any inaccuracy.

I'm setting up a Wordpress website hosted on IIS10/Win2016 with PHP 7.1.11.
On the backend I have a cluster of three nodes running MySLQ 5.7 on Win2016 (one R/W, the other two R/O).

I installed MySQL Router on the IIS node to balance the requests to the cluster but I notice a slowdown of the page loading (about x3 times).

After the post is the mysqlrouter.conf.

Is it normal?
Does anyone noticed a similar behaviour?

Thank you,
Filippo

####################################
#
# mysqlrouter.conf
#
####################################

# File automatically generated during MySQL Router bootstrap
[DEFAULT]
logging_folder=C:/ProgramData/MySQL/MySQL Router/log
runtime_folder=C:/ProgramData/MySQL/MySQL Router/run
data_folder=C:/ProgramData/MySQL/MySQL Router/data
keyring_path=C:/ProgramData/MySQL/MySQL Router/data/keyring
master_key_path=C:/ProgramData/MySQL/MySQL Router/mysqlrouter.key

[logger]
level = INFO

[metadata_cache:MySQLCLU]
router_id=6
bootstrap_server_addresses=mysql://testdb01:3306,mysql://testdb02:3306,mysql://testdb03:3306
user=mysql_router6_egojz3hzu6t6
metadata_cluster=MySQLCLU
ttl=300

[routing:MySQLCLU_default_rw]
bind_address=0.0.0.0
bind_port=6446
destinations=metadata-cache://MySQLCLU/default?role=PRIMARY
mode=read-write
protocol=classic

[routing:MySQLCLU_default_ro]
bind_address=0.0.0.0
bind_port=6447
destinations=metadata-cache://MySQLCLU/default?role=SECONDARY
mode=read-only
protocol=classic

[routing:MySQLCLU_default_x_rw]
bind_address=0.0.0.0
bind_port=6448
destinations=metadata-cache://MySQLCLU/default?role=PRIMARY
mode=read-write
protocol=x

[routing:MySQLCLU_default_x_ro]
bind_address=0.0.0.0
bind_port=6449
destinations=metadata-cache://MySQLCLU/default?role=SECONDARY
mode=read-only
protocol=x

Options: ReplyQuote


Subject
Views
Written By
Posted
Slowness using MySQL Router
2043
December 22, 2017 08:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.