Hi Dipti, [Sure, I ll take note of it to use googlegroups email ID for maxscale questions].
That's true. I tried to use 5308 port as mentioned in maxscale configuration sample for binlogrouter. When I configured and try to start maxscale, its failed due to unable to connect to master. I enabled 5308 in master db using firewalld. I am not sure how come maxscale binlog router's listner connecting to mariadb using 5308 (because 3306 is default port for mysql). I just port forward the 5308 requests to 3306 and its started working, but I am not sure what I did is the way we have to do. Then why maxscale binlogrouter is not using directly 3306. Why do we need to configure a different port (5308) to connect to mariadb. I am just asking myself these questions to understand, looking for other expert's enlightenment as well. Thank you for helping out. Regards, Karthick On Mon, Aug 29, 2016 at 5:52 PM, Dipti Joshi <dipti.jo...@mariadb.com> wrote: > Karthick: > > Please ask MaxScale question on maxsc...@googlegroups.com - I have cced > here. > > The port 5308 in documentation is for listener for a mysql client that you > would use as following to register MaxScale with Master as slave > > srvr:/home/my-usr$ mysql -u root -p 5308 -h <maxscale-host-ip> > > >CHANGE MASTER TO MASTER_HOST=‘$master_server’, MASTER_PORT=$master_port, > MASTER_USER='repl', MASTER_PASSWORD=‘somepasswd’, > MASTER_LOG_FILE=‘repl-bin.000159', > MASTER_LOG_POS=4 > > START SLAVE > > Is that what your are doing ? > > Thanks, > Dipti > > > > On Mon, Aug 29, 2016 at 7:11 AM, Karthick Subramanian < > ksubraman...@paycommerce.com> wrote: > >> Hi all, >> >> When I try to configure maxscale for binlogrouter, I noticed that >> documentation examples using port as 5308. When I try to configure >> similarly, it says, 111 connection refused or unable to connect master from >> maxscale. >> >> I have enabled the port in centOs7 using firewalld on both master server >> as well maxscale server: >> >> firewall-cmd --add-port=5308/tcp >> >> But still,I couldn't able to establish connection from maxscale server to >> mariadb server(master): >> >> mysql -u maxscaleoper -h ip:ip:ip:ip --port 5308 -p >> >> ERROR 2003 (HY000): Can't connect to MySQL server on 'ip:ip:ip:ip' (111 >> "Connection refused") >> >> Can anyone please help me on how to resolve this error. Because of this >> error, I couldn't make maxscale up and running. >> >> Regards, >> Karthick S >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> >> >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
