Opened 8 years ago

Last modified 8 years ago

#337 new enhancement

sql.mit.edu should be bound on the directors

Reported by: achernya Owned by:
Priority: minor Milestone:
Component: sql Keywords:
Cc:

Description

sql.mit.edu is a separate IP that is bound by the server that is the primary at the time. LVS provides a similar service for the Scripts primary, and would be convenient and consistent to do so for SQL.

However, this would require doing something clever as the directors are not on the backend network.

Change History (1)

comment:1 Changed 8 years ago by adehnert

Mitch sayeth: "This is more complicated than Scripts, because to switch SQL, we want to stop accepting connections on the outgoing holder of the shared IP, wait for running queries to finish, and wait for replication to catch up on the incoming shared IP holder before accepting connections there. LVS doesn't offer that without more magic. "

Note: See TracTickets for help on using tickets.