change how mysql ip is gathered to account for potential vips