<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
Hi team,
<div class="moz-forward-container">
<p>Thanks for this great job on those library.</p>
<p>I would like to know if it was possible to get some help on the
mariadb resource.</p>
<p>After the configuration of my cluster pcs command shows me:</p>
<p><font color="#0b6cff">root@node1:~# pcs status<br>
Cluster name: clusterserver<br>
Stack: corosync<br>
Current DC: node1 (version 2.0.1-9e909a5bdd) - partition with
quorum<br>
Last updated: Thu Apr 8 15:45:35 2021<br>
Last change: Thu Apr 8 15:45:25 2021 by root via cibadmin on
node1<br>
<br>
2 nodes configured<br>
2 resources configured<br>
<br>
Online: [ node1 node2 ]<br>
<br>
Full list of resources:<br>
<br>
Clone Set: mariadb_server-clone [mariadb_server] (promotable)<br>
Masters: [ node1 ]<br>
Slaves: [ node2 ]<br>
<br>
Daemon Status:<br>
corosync: active/disabled<br>
pacemaker: active/disabled<br>
pcsd: active/enabled</font></p>
<p><br>
</p>
<p>But when I go to mysql on server2 I see my slave statys off:</p>
<p><font color="#0b6cff">MariaDB [(none)]> SHOW SLAVE STATUS\G<br>
*************************** 1. row ***************************<br>
Slave_IO_State: <br>
Master_Host: node1<br>
Master_User: replication<br>
Master_Port: 3306<br>
Connect_Retry: 60<br>
Master_Log_File: master-bin.000001<br>
Read_Master_Log_Pos: 463<br>
Relay_Log_File: master-relay-bin.000002<br>
Relay_Log_Pos: 672<br>
Relay_Master_Log_File: master-bin.000001<br>
Slave_IO_Running: No<br>
Slave_SQL_Running: No<br>
Replicate_Do_DB: <br>
Replicate_Ignore_DB: <br>
Replicate_Do_Table: <br>
Replicate_Ignore_Table: <br>
Replicate_Wild_Do_Table: <br>
Replicate_Wild_Ignore_Table: <br>
Last_Errno: 0<br>
Last_Error: <br>
Skip_Counter: 0<br>
Exec_Master_Log_Pos: 463<br>
Relay_Log_Space: 2935<br>
Until_Condition: None<br>
Until_Log_File: <br>
Until_Log_Pos: 0<br>
Master_SSL_Allowed: No<br>
Master_SSL_CA_File: <br>
Master_SSL_CA_Path: <br>
Master_SSL_Cert: <br>
Master_SSL_Cipher: <br>
Master_SSL_Key: <br>
Seconds_Behind_Master: NULL<br>
Master_SSL_Verify_Server_Cert: No<br>
Last_IO_Errno: 0<br>
Last_IO_Error: <br>
Last_SQL_Errno: 0<br>
Last_SQL_Error: <br>
Replicate_Ignore_Server_Ids: <br>
Master_Server_Id: 0<br>
Master_SSL_Crl: <br>
Master_SSL_Crlpath: <br>
Using_Gtid: Current_Pos<br>
Gtid_IO_Pos: <br>
Replicate_Do_Domain_Ids: <br>
Replicate_Ignore_Domain_Ids: <br>
Parallel_Mode: conservative<br>
SQL_Delay: 0<br>
SQL_Remaining_Delay: NULL<br>
Slave_SQL_Running_State: <br>
Slave_DDL_Groups: 0<br>
Slave_Non_Transactional_Groups: 0<br>
Slave_Transactional_Groups: 0</font><br>
</p>
<p><br>
</p>
<p>On pacemaker log I got the following message:</p>
<p><font color="#0b6cff">Apr 08 19:26:18 node2 pacemaker-execd
[6899] (operation_finished) notice:
mariadb_server_start_0:7072:stderr [ Error performing
operation: No such device or address ]</font><br>
</p>
<p><br>
</p>
<p>Here is the detailed of my configuration:</p>
<p>- pcs : 0.10.1</p>
<p>- Pacemaker 2.0.1</p>
<p>- Corosync Cluster Engine, version '3.0.1'<br>
</p>
<p>- mariadb Ver 15.1 Distrib 10.3.27-MariaDB</p>
<p>- Debian 10.8</p>
<p>Mysql configuration:<br>
</p>
<p>[server]</p>
<p>[mysqld]<br>
user = mysql<br>
pid-file = /run/mysqld/mysqld.pid<br>
socket = /run/mysqld/mysqld.sock<br>
basedir = /usr<br>
datadir = /var/lib/mysql<br>
tmpdir = /tmp<br>
lc-messages-dir = /usr/share/mysql<br>
bind-address = 0.0.0.0<br>
query_cache_size = 16M<br>
log_error = /var/log/mysql/error.log<br>
server-id=2<br>
expire_logs_days = 10<br>
character-set-server = utf8mb4<br>
collation-server = utf8mb4_general_ci<br>
[embedded]<br>
[mariadb]<br>
log-bin<br>
server-id=2<br>
log-basename=master<br>
[mariadb-10.3]<br>
<br>
</p>
<p>Corosync configuration:</p>
<p><font color="#0b6cff"><cib crm_feature_set="3.1.0"
validate-with="pacemaker-3.2" epoch="21" num_updates="0"
admin_epoch="0" cib-last-written="Thu Apr 8 19:26:13 2021"
update-origin="node1" update-client="cibadmin"
update-user="root" have-quorum="1" dc-uuid="1"><br>
<configuration><br>
<crm_config><br>
<cluster_property_set id="cib-bootstrap-options"><br>
<nvpair id="cib-bootstrap-options-stonith-enabled"
name="stonith-enabled" value="false"/><br>
<nvpair id="cib-bootstrap-options-no-quorum-policy"
name="no-quorum-policy" value="ignore"/><br>
<nvpair id="cib-bootstrap-options-have-watchdog"
name="have-watchdog" value="false"/><br>
<nvpair id="cib-bootstrap-options-dc-version"
name="dc-version" value="2.0.1-9e909a5bdd"/><br>
<nvpair
id="cib-bootstrap-options-cluster-infrastructure"
name="cluster-infrastructure" value="corosync"/><br>
<nvpair id="cib-bootstrap-options-cluster-name"
name="cluster-name" value="clusterserver"/><br>
</cluster_property_set><br>
<cluster_property_set id="mysql_replication"><br>
<nvpair
id="mysql_replication-mariadb_server_REPL_INFO"
name="mariadb_server_REPL_INFO" value="node1"/><br>
</cluster_property_set><br>
</crm_config><br>
<nodes><br>
<node id="1" uname="node1"/><br>
<node id="2" uname="node2"/><br>
</nodes><br>
<resources><br>
<clone id="mariadb_server-clone"><br>
<primitive class="ocf" id="mariadb_server"
provider="heartbeat" type="mariadb"><br>
<instance_attributes
id="mariadb_server-instance_attributes"><br>
<nvpair
id="mariadb_server-instance_attributes-binary" name="binary"
value="/usr/sbin/mysqld"/><br>
<nvpair
id="mariadb_server-instance_attributes-config" name="config"
value="/etc/mysql/my.cnf"/><br>
<nvpair
id="mariadb_server-instance_attributes-datadir" name="datadir"
value="/var/lib/mysql"/><br>
<nvpair
id="mariadb_server-instance_attributes-node_list"
name="node_list" value="node1 node2"/><br>
<nvpair
id="mariadb_server-instance_attributes-pid" name="pid"
value="/var/run/mysqld/mysqld.pid"/><br>
<nvpair
id="mariadb_server-instance_attributes-replication_passwd"
name="replication_passwd"
value="similarly-secure-password"/><br>
<nvpair
id="mariadb_server-instance_attributes-replication_user"
name="replication_user" value="replication"/><br>
<nvpair
id="mariadb_server-instance_attributes-socket" name="socket"
value="/var/run/mysqld/mysqld.sock"/><br>
</instance_attributes><br>
<meta_attributes
id="mariadb_server-meta_attributes"><br>
<nvpair
id="mariadb_server-meta_attributes-clone-max" name="clone-max"
value="2"/><br>
<nvpair
id="mariadb_server-meta_attributes-clone-node-max"
name="clone-node-max" value="1"/><br>
<nvpair
id="mariadb_server-meta_attributes-master-max"
name="master-max" value="1"/><br>
<nvpair
id="mariadb_server-meta_attributes-master-node-max"
name="master-node-max" value="1"/><br>
<nvpair
id="mariadb_server-meta_attributes-notify" name="notify"
value="true"/><br>
<nvpair
id="mariadb_server-meta_attributes-promotable-max"
name="promotable-max" value="1"/><br>
<nvpair
id="mariadb_server-meta_attributes-promotable-node-max"
name="promotable-node-max" value="1"/><br>
</meta_attributes><br>
<operations><br>
<op id="mariadb_server-demote-interval-0"
interval="0" name="demote" timeout="120"/><br>
<op id="mariadb_server-monitor-interval-10"
interval="10" name="monitor" role="Master" timeout="30"/><br>
<op id="mariadb_server-monitor-interval-20"
interval="20" name="monitor" role="Slave" timeout="30"/><br>
<op id="mariadb_server-notify-interval-0s"
interval="0s" name="notify" timeout="60s"/><br>
<op id="mariadb_server-promote-interval-0"
interval="0" name="promote" timeout="120"/><br>
<op id="mariadb_server-start-interval-0"
interval="0" name="start" timeout="120"/><br>
<op id="mariadb_server-stop-interval-0"
interval="0" name="stop" timeout="120"/><br>
</operations><br>
</primitive><br>
<meta_attributes
id="mariadb_server-clone-meta_attributes"><br>
<nvpair
id="mariadb_server-clone-meta_attributes-promotable"
name="promotable" value="true"/><br>
</meta_attributes><br>
</clone><br>
</resources><br>
<constraints/><br>
<rsc_defaults><br>
<meta_attributes id="rsc_defaults-options"><br>
<nvpair id="rsc_defaults-options-failure-timeout"
name="failure-timeout" value="30"/><br>
<nvpair
id="rsc_defaults-options-migration-threshold"
name="migration-threshold" value="2"/><br>
</meta_attributes><br>
</rsc_defaults><br>
</configuration><br>
</cib></font></p>
<p><br>
</p>
<p><font color="00000">Did I miss something on my configuration ?
Or do I need more than two servers ?</font></p>
<p><font color="#0b6cff"><br>
</font></p>
<p>Regards,<br>
</p>
</div>
</body>
</html>