The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Replication Using Sketchy Cellular VPN Connection 2021-02-08

I have a master and slave both running 10.3.13 configured to replicate.

The master is in a remote location using cellular VPN to connect site to site

The slave is at the corporate offices connected to the remote location using VPN.

As you can imagine the remote location master connection is up and down hundreds of times a day. However, when the connection is up the replication is successful.

However, if the cellular VPN is down for an extended amount of time the replication does not re-establish.

Doing my research, I think the variable I need to change is the "master-retry-count" (https://mariadb.com/kb/en/mysqld-options/#-master-retry-count). I suspect I need to set it to zero so that the slave will not stop attempting to reconnect.

I cannot find this variable. Where is it located? How do I determine what it is set for currently? How do I change it?

Thank you, Craig

Answer Answered by Ian Gilfillan in this comment.

This is not a variable, it's a mysqld option, so you can't access it from within the server by doing SHOW VARIABLES etc. It will have the default value, 86400 (you can verify this by running mysqld --verbose --help) unless changed, from a config file or the command line.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.