We have an app with some peculiar characteristics that prevent us from doing master-slave MySQL replication. It's something to do with random numbers being generated for each session and stored procedures.
We plan on fixing the app next year but in the meantime we need to make our MySQL machines "highly available" so what options do we have? Would a plain RH cluster work? We run MySQL mysql-server-5.0.45-7.el5.x86_64.
Thanks for any advice.