Vengala Vinay

Having 12+ Years of Experience in Software Development

Home » Disaster Recovery 101: Architecting Auto-Failovers for MySQL and Magento 2 Deployments on Linode

Disaster Recovery 101: Architecting Auto-Failovers for MySQL and Magento 2 Deployments on Linode

Establishing a High-Availability MySQL Cluster with Orchestrator

For a Magento 2 deployment, a robust and highly available MySQL infrastructure is paramount. We’ll architect an automated failover solution using Orchestrator, a popular MySQL replication topology manager. This setup will involve a primary MySQL instance and at least two replicas, with Orchestrator monitoring their health and orchestrating failovers when necessary. We’ll deploy this on Linode, leveraging its robust infrastructure.

Our primary goal is to achieve automatic failover with minimal manual intervention. Orchestrator handles the detection of primary failures and promotes a replica to become the new primary, reconfiguring other replicas to follow the new primary. This significantly reduces downtime during hardware failures or network disruptions.

Orchestrator Installation and Configuration

First, let’s install Orchestrator on a dedicated node (or one of your existing nodes, though a dedicated node is recommended for production). We’ll use a recent Ubuntu LTS release on Linode.

Node Setup (Ubuntu 22.04 LTS)

Update your system and install necessary packages:

  • SSH into your Linode instance designated for Orchestrator.
  • Run the following commands:
sudo apt update && sudo apt upgrade -y
sudo apt install -y wget gnupg2

Add the Orchestrator repository:

wget -qO - https://download.orchestrator.io/signing-key.asc | sudo apt-key add -
echo "deb [arch=amd64] https://download.orchestrator.io/apt stable main" | sudo tee /etc/apt/sources.list.d/orchestrator.list
sudo apt update

Install Orchestrator and its dependencies:

sudo apt install -y orchestrator mysql-client

Orchestrator Configuration File

Create and configure the Orchestrator configuration file. The default location is /etc/orchestrator/orchestrator.conf.json. Ensure you have a MySQL user with sufficient privileges for Orchestrator to manage your MySQL instances. A dedicated user is highly recommended.

{
  "Debug": false,
  "ListenAddress": ":3000",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_orchestrator_db_password",
  "MySQLOrchestratorHost": "127.0.0.1",
  "MySQLOrchestratorPort": 3306,
  "MySQLOrchestratorUser": "orchestrator_admin",
  "MySQLOrchestratorPassword": "your_orchestrator_admin_password",
  "DetectClusterAlias": true,
  "RecoveryPeriodBlockSeconds": 3600,
  "PromotionForgetMasterPeriodSeconds": 86400,
  "PostponePromotionOnLagMinutes": 5,
  "FailureDetectionPeriodBlockSeconds": 300,
  "DiscoveryPeriodSeconds": 10,
  "AutoDiscoverAtStartup": true,
  "SlaveLagQuery": "SELECT * FROM mysql.slave_lag_master_info",
  "SlaveLagQueryForAllReplicas": true,
  "SlaveLagQueryIntervalSeconds": 10,
  "HealthCheckIntervalSeconds": 10,
  "SnapshotTopologiesIntervalSeconds": 60,
  "SnapshotTopologies": true,
  "MySQLTopologyUserCredentialsDB": "orchestrator",
  "MySQLTopologyUserCredentialsUser": "orchestrator",
  "MySQLTopologyUserCredentialsPassword": "your_orchestrator_db_password",
  "MySQLTopologyUserCredentialsHost": "127.0.0.1",
  "MySQLTopologyUserCredentialsPort": 3306,
  "MySQLTopologyUserCredentialsSSL": false,
  "GlobalWriteableCells": ["cell1", "cell2"],
  "GlobalReadOnlyCells": ["cell3"],
  "Cell": "cell1",
  "HTTPProxyPort": 8080,
  "HTTPProxyBindIP": "0.0.0.0",
  "ReadOnly": false,
  "InstancePollSeconds": 10,
  "ReplicaLagQuery": "SELECT * FROM mysql.slave_lag_master_info",
  "ReplicaLagQueryForAllReplicas": true,
  "ReplicaLagQueryIntervalSeconds": 10,
  "ReplicationCredentialsDB": "orchestrator",
  "ReplicationCredentialsUser": "orchestrator",
  "ReplicationCredentialsPassword": "your_orchestrator_db_password",
  "ReplicationCredentialsHost": "127.0.0.1",
  "ReplicationCredentialsPort": 3306,
  "ReplicationCredentialsSSL": false,
  "SkipUnresolvedHostnames": false,
  "SkipUnresolvedIPs": false,
  "SkipUnresolvedPorts": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedPasswords": false,
  "SkipUnresolvedSSL": false,
  "SkipUnresolvedDBs": false,
  "SkipUnresolvedTables": false,
  "SkipUnresolvedColumns": false,
  "SkipUnresolvedIndexes": false,
  "SkipUnresolvedConstraints": false,
  "SkipUnresolvedTriggers": false,
  "SkipUnresolvedProcedures": false,
  "SkipUnresolvedFunctions": false,
  "SkipUnresolvedEvents": false,
  "SkipUnresolvedViews": false,
  "SkipUnresolvedRoutines": false,
  "SkipUnresolvedLogs": false,
  "SkipUnresolvedBinlogs": false,
  "SkipUnresolvedRelays": false,
  "SkipUnresolvedErrors": false,
  "SkipUnresolvedWarnings": false,
  "SkipUnresolvedNotes": false,
  "SkipUnresolvedMessages": false,
  "SkipUnresolvedStatus": false,
  "SkipUnresolvedVariables": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUnresolvedInterfaces": false,
  "SkipUnresolvedRoutes": false,
  "SkipUnresolvedServices": false,
  "SkipUnresolvedProcesses": false,
  "SkipUnresolvedThreads": false,
  "SkipUnresolvedConnections": false,
  "SkipUnresolvedQueries": false,
  "SkipUnresolvedTransactions": false,
  "SkipUnresolvedLocks": false,
  "SkipUnresolvedSessions": false,
  "SkipUnresolvedUsers": false,
  "SkipUnresolvedRoles": false,
  "SkipUnresolvedPrivileges": false,
  "SkipUnresolvedGrants": false,
  "SkipUnresolvedSchemas": false,
  "SkipUnresolvedDatabases": false,
  "SkipUnresolvedTablespaces": false,
  "SkipUnresolvedFilesystems": false,
  "SkipUnresolvedDisks": false,
  "SkipUnresolvedPartitions": false,
  "SkipUnresolvedVolumes": false,
  "SkipUnresolvedMounts": false,
  "SkipUnresolvedNetworks": false,
  "SkipUn

Recent Posts

Top Categories

Our Products

Our Services