I have a question, but it might be to subjective. So, I thought I'd put it here and ask your opinion.
Question:
I want to know if there is any reasons at all not to use MySQL in this scenario.
2 servers behind a virtual IP with MySQL master-master replication
Goal: redundancy, want this to run 24/7
I have plenty of reasons why to use this (1 I only want your most pessimist thoughts.
(1 We are using this already in an similar situation and are considering using something else for a new setup. We have access to s MSSQL cluster that are more than capable of handling the 24/7 demand.
Doubt:
The reason I'm hesitant to ask this question is that I have a hard time imagining how I would choose a correct answer.