As for me, it is very important to configure everything properly at the start.
That's why so good to read some docs before installation but not after))
That’s a very naive approach to .. well, life IMHO. You will never get everything configured properly at the start, remember you can aim for the perfect solution - but perfect and practical, along with time constraints very rarely go hand in hand!
Yes, it's impossible to get everything right the first time; however, I agree that planning beforehand guarantees a better percentage of success. Ready, Aim, Fire is a much better strategy than Ready, Fire, Aim.
We do run few heavy databases on our server, but some times it gets crash so we thought we can come up with mysql clustering solution. Whenever one of the server goes down, we want other server to take over its job.
Did you get my question?
On Linux its little difficult to configure mysql clustering. I know window enviornment.I dont know much about Linux.I think you will have to take search on net.That will help you better.
Can you give me a example of what type of SQL database would need a cluster server to do its job? I would imagine it would be under a very heavy work load.
We do run few heavy databases on our server, but some times it gets crash so we thought we can come up with mysql clustering solution. Whenever one of the server goes down, we want other server to take over its job.