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

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[matthew zeier [:mrz]]

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.

Comment 1

[matthew zeier [:mrz]]

Marking bug 473084 as a blocker for going live with this (want an HA ACE).

Comment 2

[Derek Moore [:dmoore]]

For the record, we'll be duplicating ACLs from the existing NetScaler VIP.

Comment 3

[matthew zeier [:mrz]]

Needs to include monitoring on status of the backend servers like we do with the Netscaler via SNMP).

Comment 4

[matthew zeier [:mrz]]

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

Comment 5

[Dave Miller [: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?

Comment 6

[matthew zeier [:mrz]]

More or less - if we change the config to point to this VIP, will things still work?

Comment 7

[Derek Moore [:dmoore]]

It doesn't have NAT configured in order to proxy client connections properly, but I'm taking care of that addition now.

Comment 8

[Derek Moore [:dmoore]]

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.

Comment 9

[Dave Miller [:justdave]]

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.

Comment 10

[Jeremy Orem [:oremj]]

Read-only vip moved over to 10.2.70.20