Mahmoud Mohammad Abdelsalam wrote:
Hallo all,
i have a working server of opensuse 10.2 and it is working just fine ,
i have mysql 5 and i need to make clustering on that server by getting
two mysql server up , any ideas? please help.
Your cluster can have three states.
Host A is up Host B is down (Cluster State 1)
Host A is down Host B is up (Cluster State 2)
Host A is up Host B is up (Cluster State 3)
Both hosts should have a 'heartbeat' program and another
which detects the 'heartbeat' of the other host.
On Host A, if it doesn't detect Host B's heartbeat,
then Host A should be in State 1. If it detects
Host B's heartbeat, then Host A should go to State 3.
If B's heartbeat disappears, A goes back to State 1.
For Host A, state 2 does not need to be defined.
Similarly, if B doesn't detect A's heartbeat, then
B goes to State 2. If B detects A's heartbeat, then
go to State 3. If A's heartbeat disappears, B goes
back to State 3. For host B, state 1 does not need
to be defined.
For BOTH hosts, the host CAN leave the cluster without
the host going down. Simply define a "State 0" on
both machines, which just kills all the heartbeat
program, mysql, and any other processes which also
run on that host when it's part of the cluster.
For either host to leave the cluster, it goes to
State 0 (Kill all cluster-related processes).
This is very similar to the directory
/etc/init.d/rc6.d
Regards,
Mahmoud Abdelsalam.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]