Set up read-only AMO database VIP on ACE load balancer

RESOLVED FIXED

Status

mozilla.org Graveyard
Server Operations
--
minor
RESOLVED FIXED
9 years ago
2 years ago

People

(Reporter: mrz, Assigned: oremj)

Tracking

Bug Flags:
needs-downtime +

Details

(Whiteboard: 02/19 maint window)

(Reporter)

Description

9 years ago
I started to play with this config but am punting to dmoore.  

Want to setup a VIP for read-only AMO db.  Need testing/monitoring and maybe webdev help to verify (?).  

dmoore - I suspect you could make the VIP on 10.2.70.0/24 but I can't figure out how to make VIPs on this thing.
(Reporter)

Comment 1

9 years ago
Marking bug 473084 as a blocker for going live with this (want an HA ACE).
Assignee: server-ops → dmoore
Depends on: 473084
For the record, we'll be duplicating ACLs from the existing NetScaler VIP.
Summary: Setup read-only AMO database VIP on ACE load balancer → Set up read-only AMO database VIP on ACE load balancer
(Reporter)

Comment 3

9 years ago
Needs to include monitoring on status of the backend servers like we do with the Netscaler via SNMP).
(Reporter)

Comment 4

9 years ago
justdave - can you test?

acelb01/db# show service-policy amo-db-vip-policy detail 

Status     : ACTIVE
Description: -
-----------------------------------------
Interface: vlan 70 
  service-policy: amo-db-vip-policy
    class: amo-db-vip
     VIP Address:    Protocol:  Port:
     10.2.70.20      tcp        eq    3306 


acelb01/db# show serverfarm amo-db  
 serverfarm     : amo-db, type: HOST
 total rservers : 3

 ---------------------------------
                                                ----------connections-----------
       real                  weight state        current    total      failures 
   ---+---------------------+------+------------+----------+----------+---------
   rserver: tm-amo01-master01
       10.2.70.144:3306      8      OPERATIONAL  0          0          0
   rserver: tm-amo01-slave02
       10.2.70.142:3306      8      OPERATIONAL  0          0          0
   rserver: tm-amo01-slave03
       10.2.70.135:3306      8      OPERATIONAL  0          0          0
Assignee: dmoore → justdave
(In reply to comment #4)
> justdave - can you test?

I'm not sure I follow what's going on here...  what needs testing?  Connecting to the VIP and see if I get the right databases?
(Reporter)

Comment 6

9 years ago
More or less - if we change the config to point to this VIP, will things still work?
It doesn't have NAT configured in order to proxy client connections properly, but I'm taking care of that addition now.
The amo-db vip (10.2.70.20) is operational and configured for HA. The only remaining addition will be the ACL list currently used by the NetScaler.
Setup on my end is done.  MySQL ACLs are in place to allow the ace's VIP in.  Metrics has been testing it with the AMO stats scripts, and seems to be working okay for them so far as far as I know.
Assignee: justdave → dmoore
(Reporter)

Updated

9 years ago
Assignee: dmoore → mrz
Flags: needs-downtime+
Whiteboard: 02/19 maint window
(Reporter)

Updated

9 years ago
Group: infra
(Assignee)

Updated

9 years ago
Assignee: mrz → oremj
(Assignee)

Comment 10

9 years ago
Read-only vip moved over to 10.2.70.20
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.