I am working in an environment with worldwide distributed databases. For the reporting, we use MariaDB Connect Engine to access the remote data from our central site.
Sometimes the Network connection to some of our remote locations may be down.
- Is there a way to find out if the connection is down with a SQL command ?
- Is there a way to resume the connection, once the remote location is back online ?
