We are using master- slave schema for scalability. To provide failover we are looking for solution which allows switching from slave to master. Are there any off the shelf solutions? Custom scripts?