hello Mark ,,
first thanks for answering me
Originally Posted by Mark_NL
So you want to have HA apache, and a master-slave setup for mysql?
What are you going to do when server 1 (mysql master goes down?)
i will promote the Passive (which is really acts as a master) server to be a master
lets clarify the point, & tell you what i want to do to help me much better ,
i want to load balance between two nodes, through sharing the requests to apache on both servers & if one fail then the other will work
about pacemaker & keepalived ,i dont say that they are not good softwares, but i will have to study again on new software & decide which one i should use, then i will get to the same problem can i use any of this softwares to direct only mysql writes to Active server, while redirecting mysql reads to be shared between Active & Passive ???
please could anyone help me
thanks for everyone