The Replicator is a critical piece of the Tungsten Clustering solution for MySQL / MariaDB, as well as its own stand-alone data replication product. Automatic recovery is a feature that enables the Replicator to go back online in the event of a transient failure. In this blog we discuss how to enable Automatic Recovery. For more information about Auto-Recovery, please click here to visit the online documentation page.
The Question
Recently, a customer asked us:
We see that the replicators receive a transaction which has a deadlock error in it:
pendingError : Event application failed: seqno=82880882 fragno=0 message=java.sql.SQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
If one performs a service online, it comes back online without issue and continues to replicate. Is there a setting that will allow the cluster (if in automatic mode) to try to online the service on its own (maybe try 2 or 3 times then stop trying if it continuously errors)?
The Answer
Yes! It's called Automatic Recovery.
The following tpm options can be added to the [defaults]
stanza of your tungsten.ini
file:
--auto-recovery-delay-interval=15s
--auto-recovery-max-attempts=3
--auto-recovery-reset-interval=300s
These settings will enable autorecovery, the maximum number of attempts to online the replicator. These settings will also identify the delay between the replicator identifying that autorecovery is needed and an auto-recovery is being attempted.
The Library
Please read the docs!
For more information about Auto-Recovery, please visit the documentation page at https://docs.continuent.com//tungsten-replicator-6.1/operations-autorecovery.html
For more information about Tungsten Replicator, please visit our full online documentation at https://docs.continuent.com
Summary
The Wrap-Up
In this blog post we discussed enabling Automatic Recovery for the Tungsten Replicator.
To learn more about Tungsten Replicator, check out https://www.continuent.com/solutions/tungsten-replicator-all-you-need-to-know/
Tungsten Clustering is the most flexible, performant global database layer available today - use it underlying your SaaS offering as a strong base upon which to grow your worldwide business!
To learn about Continuent Clustering solutions, please visit https://www.continuent.com/solutions
Want to learn more or run a POC? Contact us
Comments
Add new comment