<div dir="ltr">Hi <br>I don't know if its the right address to send this mail to but I really need help so I'm gonna try my luck anyway <br><br>I'm trying to configure a RHEL HA cluster with MySQl and GFS,<br>
<br>
I have 2 virtual machines running centos5.2 virt1.xen and virt2.xen<br>
on them I have sheared iscsi device with GFS2 that i want MySQL database to be on.<br>
<br>
I installed MySQL servers on both virtual machines, but I can't
configure the cluster service properly so it will be a HA MyQSL cluster<br>
<br>
Please help I can't find any proper howtos about that.<br>
<br>
I get this errors:<br>
clurgmgrd[4070]:  Stopping service service:MySQL<br>
clurgmgrd[4070]:  stop on mysql "mysql" returned 1 (generic error)<br>
clurgmgrd: [4070]: Checking Existence Of File
/var/run/cluster/mysql/mysql:mysql.pid [mysql:mysql] > Failed - File
Doesn't Exist<br>
clurgmgrd: [4070]:  Stopping Service mysql:mysql > Failed<br>
clurgmgrd[4070]:  Marking service:MySQL as 'disabled', but some resources may still be allocated!<br>
clurgmgrd[4070]:  Service service:MySQL is disabled<br>
clurgmgrd[4070]:  stop on clusterfs "GFS" returned 2 (invalid argument(s))<br>
clurgmgrd: [4070]:  stop: Could not match /dev/vgoo/iscsi with a real device<br>
clurgmgrd[4070]:  Marking service:MySQL as 'disabled', but some resources may still be allocated!<br>
clurgmgrd[4070]:  Service service:MySQL is disabled<br>
clurgmgrd[4070]:  Stopping service service:MySQL<br>
clurgmgrd[4070]:  stop on clusterfs "GFS" returned 2 (invalid argument(s))<br>
<br>
This is my conf files:<br>
# cat /etc/cluster/cluster.conf <br>
<?xml version="1.0"?><br>
<cluster alias="virt-cluster" config_version="15" name="virt-cluster"><br>
        <fence_daemon clean_start="0" post_fail_delay="0" post_join_delay="3"/><br>
        <clusternodes><br>
                <clusternode name="virt2.xen" nodeid="1" votes="1"><br>
                        <fence/><br>
                        <multicast addr="<a href="http://192.168.122.188">192.168.122.188</a>"/><br>
                </clusternode><br>
                <clusternode name="virt1.xen" nodeid="2" votes="1"><br>
                        <fence/><br>
                        <multicast addr="<a href="http://192.168.122.188">192.168.122.188</a>"/><br>
                </clusternode><br>
        </clusternodes><br>
        <cman expected_votes="3" two_node="0"><br>
                <multicast addr="<a href="http://192.168.122.188">192.168.122.188</a>"/><br>
        </cman><br>
        <fencedevices/><br>
        <rm><br>
                <failoverdomains><br>
                        <failoverdomain name="virt12" nofailback="0" ordered="0" restricted="0"/><br>
                        <failoverdomain name="FD" nofailback="0" ordered="1" restricted="0"><br>
                                <failoverdomainnode name="virt2.xen" priority="2"/><br>
                                <failoverdomainnode name="virt1.xen" priority="1"/><br>
                        </failoverdomain><br>
                </failoverdomains><br>
                <resources><br>
                        <ip address="<a href="http://192.168.122.188">192.168.122.188</a>" monitor_link="0"/><br>
                </resources><br>
                <service autostart="1" domain="FD" exclusive="0" name="MySQL" recovery="relocate"><br>
                        <mysql config_file="/etc/my.cnf" listen_address="<a href="http://192.168.9.36">192.168.9.36</a>" name="mysql" shutdown_wait="0"/><br>
                        <ip ref="<a href="http://192.168.122.188">192.168.122.188</a>"/><br>
<clusterfs device="/dev/sda1" force_unmount="0" fsid="59408"
fstype="gfs" mountpoint="/data" name="gfs" self_fence="0"/><br>
                </service><br>
        </rm><br>
        <quorumd interval="3" label="rac_qdisk" min_score="1" tko="20" votes="1"/><br>
</cluster><br>
<br>
<br>
<br>
# cat /etc/my.cnf <br>
[mysqld]<br>
datadir=/data<br>
socket=/var/lib/mysql/mysql.sock<br>
user=mysql<br>
# Default to using old password format for compatibility with mysql 3.x<br>
# clients (those using the mysqlclient10 compatibility package).<br>
old_passwords=1<br>
<br>
[mysqld_safe]<br>
log-error=/var/log/mysqld.log<br>
pid-file=/var/run/mysqld/mysqld.pid<br>
<br>
<br>
<br>
# cat /etc/hosts<br>
# Do not remove the following line, or various programs<br>
# that require network functionality will fail.<br>
<a href="http://127.0.0.1">127.0.0.1</a>               localhost.localdomain localhost<br>
::1             localhost6.localdomain6 localhost6<br>
<br>
hostname = virt1.xen<br>
<br>
<a href="http://192.168.122.24">192.168.122.24</a> virt2.xen<br><br>all the conf file are the same on both virt machines<br><br>with this configurations the virtual machine didn't load after reboot it got stuck on loading cman<br>
<br>I can't find any proper howtos on configuring the services and resources in the cluster, and I realy need to do this<br><br>Thank for your help<br><br>Grigory<br><br><br></div>