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: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org