Comments on: The importance of report_host & report_port https://shlomi-noach.github.io/blog/mysql/the-importance-of-report_host-report_port Blog by Shlomi Noach Tue, 18 May 2010 07:27:13 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Replication configuration checklist | code.openark.org https://shlomi-noach.github.io/blog/mysql/the-importance-of-report_host-report_port/comment-page-1#comment-13735 Tue, 18 May 2010 07:27:13 +0000 https://shlomi-noach.github.io/blog/?p=818#comment-13735 […] report-host, report-port: the host and port identifying the slave when looking at SHOW SLAVE HOSTS on master. Set this up on all hosts. See further discussion here. […]

]]> By: New and Noteworthy in openark kit | code.openark.org https://shlomi-noach.github.io/blog/mysql/the-importance-of-report_host-report_port/comment-page-1#comment-2493 Tue, 30 Jun 2009 06:39:12 +0000 https://shlomi-noach.github.io/blog/?p=818#comment-2493 […] by utilizing the report_port parameter on the slaves, reading the value on SHOW SLAVE HOSTS (see this post). Both utilities support skipping SHOW SLAVE HOSTS and just picking up slaves by looking at SHOW […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/the-importance-of-report_host-report_port/comment-page-1#comment-1912 Wed, 13 May 2009 12:48:03 +0000 https://shlomi-noach.github.io/blog/?p=818#comment-1912 Hi Baron,

I agree there’s a need to remember the manual settings. So if you change an instance’s port – you need to remember changing the report_port as well.

How do you overcome the problem of non-default ports for slaves, when going through SHOW PROCESSLIST?

]]> By: Xaprb https://shlomi-noach.github.io/blog/mysql/the-importance-of-report_host-report_port/comment-page-1#comment-1910 Wed, 13 May 2009 12:38:29 +0000 https://shlomi-noach.github.io/blog/?p=818#comment-1910 In my experience they work pretty well until changes are made without restarting servers — and then you can start to see different things from each host in a replication topology 🙁 This is why Maatkit kind of moved away from this, towards detecting masters and slaves from the processlist.

]]>