While I agree with you, "switch over to slave manually" just doesn't seem right. Who would monitor when to switch? Why would somebody want to monitor that? Having said that - there're probably solutions that allow switching when database is waiting for I/O