High availability solution for a transactional database system