Flow from mradm02.private.scl3 to tp-a01-rw-zeus.phx.mozilla.com for MySQL

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
6 years ago
4 years ago

People

(Reporter: solarce, Unassigned)

Tracking

Details

(Reporter)

Description

6 years ago
Source: mradm02.private.scl3.mozilla.com - 10.22.75.130
Destination: tp-a01-rw-zeus.phx.mozilla.com - 10.8.70.90
Port: TCP 3306 (MySQL)
done!

[root@mradm02 ~]# nc -zv tp-a01-rw-zeus.phx.mozilla.com 3306
Connection to tp-a01-rw-zeus.phx.mozilla.com 3306 port [tcp/mysql] succeeded!
Assignee: network-operations → arzhel
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED

Updated

6 years ago
Blocks: 765950

Updated

6 years ago
Blocks: 774564
No longer blocks: 774564
(Reporter)

Comment 2

6 years ago
So nc works, but MySQL fails

[root@mradm02 ~]# nc -zv tp-a01-rw-zeus.phx.mozilla.com 3306
Connection to tp-a01-rw-zeus.phx.mozilla.com 3306 port [tcp/mysql] succeeded!

[root@mradm02 ~]# mysql -h tp-a01-ro-zeus.phx.mozilla.com

ERROR 2003 (HY000): Can't connect to MySQL server on 'tp-a01-ro-zeus.phx.mozilla.com' (110)

I am not seeing a protection class or anything in Zeus and the MySQL services in the backend pool are alive and responding to queries
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
(Reporter)

Updated

6 years ago
Assignee: arzhel → network-operations
Priority: -- → P1
if nc works, there's really nothing more netops can allow. check with the dbas.

[cransom@mradm02 ~]$ nc -v tp-a01-rw-zeus.phx.mozilla.com 3306
Connection to tp-a01-rw-zeus.phx.mozilla.com 3306 port [tcp/mysql] succeeded!
8
5.0.77-logi??	+(${aUf",s?}{p@0mXOb"
Assignee: network-operations → server-ops-database
Component: Server Operations: ACL Request → Server Operations: Database
Priority: P1 → --
QA Contact: ravi → cshields
In comment 2, brandon tested nc with tp-a01-rw but tried mysql with tp-a01-ro.
(Reporter)

Comment 5

6 years ago
This is my fail, all that's needed for this is rw anyway, it's getting a proper cluster soon

Thanks casey and sheeri for sorting me out
Status: REOPENED → RESOLVED
Last Resolved: 6 years ago6 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.