pacemaker-replication-agents

pacemaker-replication-agents copied to clipboard

Is there any way I can update REPL_INFO position without restarting PCS ? Sometime, Temporary fluctuation at Slave side, reset the SLAVE node to very old position and it takes...

avin-tokade

I am unable to add myinstance1 to corosync pacemaker cluster. any suggestions Migration summary: * Node server1: * Node server2: p_mysql_myinstance:1: migration-threshold=1000000 fail-count=1000000 * Node qoruma01: Failed actions: p_mysql_myinstance:1_start_0 (node=server2,...

sudhir1887

mysqlbinlog is slow for agent purposes

1

For example: ``` [root@mysql tmp]# time mysqlbinlog -vvv --base64-output=decode-rows mysqld-relay-bin.001185 | grep 'Xid =' -A2 | grep -v '\-\-' | tail -n 186 | egrep 'Xid|\# at [0-9]{2,10}' | tac...

dotmanila

geo-DR: remove need to have ssh

9

Why do we need ssh from every machine to every machine? For geo-DR, this is used to fetch who the master is and it's binary log information. Can't we just...

grypyrg

Sometimes the corosync node name is different form the hostname. For mysql_prm there is a specific attriute. Not so for myql_monitor. In my case using crm_mon -n instean of hostname...

dimon00

Is it possible to modify the agent to support mariadb 10.x ?

dimon00

REPL_INFO should not be used if slave was previously replicating properly

1

REPL_INFO can be stale - for example, if slave drops from the network for some reason, the agent would reset replication to use the values from REPL_INFO which would be...

dotmanila

Hello, I'm using pacemaker 1.1.5 with **ocf:percona:mysql_prm_gtid** and I'm getting the following error in the logs: `pengine: error: crm_int_helper: Characters left over after parsing '-inf': '-inf'` Which I fixed by...

wochjop

**mysql 5.7 deprecates information_schema in favor of performance_schema for global_variables. This affects:** `mysql_run -Q -sw -O $MYSQL $MYSQL_OPTIONS_REPL -BN -e "select replace(var\ iable_value,'\n','') as variable_value from information_schema.global_variables\ where variable_name in...

wochjop

Error in Percona replication manager (PRM) setup guide

1

In the manual you add colocation with resource "writer_vip" before create it. This causes the error. [root@centos-web02]# pcs constraint colocation add master ms_MySQL with writer_vip Error: Resource 'writer_vip' does not...

DeV1L