Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
cloudappliance:database-troubleshooting [2024_01_12 18:16] – steven | cloudappliance:database-troubleshooting [2024_02_28 01:03] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 3: | Line 3: | ||
##### last updated on: Feb 7, 2023 | ##### last updated on: Feb 7, 2023 | ||
- | This document covers troubleshooting of the MariaDB database server included with the Enterprise File Fabric | + | This document covers troubleshooting of the MariaDB database server included with the Access Anywhere |
There are two main deployment options: | There are two main deployment options: | ||
- | * Local database - database running on same virtual machine as the File Fabric | + | * Local database - database running on same virtual machine as Access Anywhere |
- | * Remote database - File Fabric | + | * Remote database - Access Anywhere |
A remote database could be: | A remote database could be: | ||
- | * An instance of the Enterprise File Fabric | + | * An instance of the Access Anywhere |
* An installation of MariaDB or compatible database | * An installation of MariaDB or compatible database | ||
* An external database-as-a-service compatible with MariaDB | * An external database-as-a-service compatible with MariaDB | ||
Line 25: | Line 25: | ||
## Version Compatibility | ## Version Compatibility | ||
- | The Enterprise File Fabric | + | Access Anywhere |
- | Supported databases (as of Enterprise File Fabric | + | Supported databases (as of Access Anywhere |
* MariaDB 10.4 | * MariaDB 10.4 | ||
Line 53: | Line 53: | ||
### Database Connection Settings | ### Database Connection Settings | ||
- | To check what database an Enterprise File Fabric | + | To check what database an Access Anywhere |
grep ' | grep ' | ||
Line 84: | Line 84: | ||
## Connecting across a Network | ## Connecting across a Network | ||
- | For security the database included with Enterprise File Fabric | + | For security the database included with Access Anywhere |
This section covers settings that need to be changed for the database to be connected to from another machine. Please consult your IT or network administrator for other connectivity issues. | This section covers settings that need to be changed for the database to be connected to from another machine. Please consult your IT or network administrator for other connectivity issues. | ||
Line 90: | Line 90: | ||
### Verify Access to Port | ### Verify Access to Port | ||
- | If the database is remote (the Enterprise File Fabric | + | If the database is remote (Access Anywhere |
curl hostname: | curl hostname: | ||
Line 119: | Line 119: | ||
Comment out **bind-address 127.0.0.1** which was telling mysql to only accept local connections. Adding a line with **::** allows incoming IPv4 and IPv6 connections. A setting of **0.0.0.0** can be used instead, which is also the default. It will allow IPv4 but not IPv6 connections: | Comment out **bind-address 127.0.0.1** which was telling mysql to only accept local connections. Adding a line with **::** allows incoming IPv4 and IPv6 connections. A setting of **0.0.0.0** can be used instead, which is also the default. It will allow IPv4 but not IPv6 connections: | ||
- | # SME managed file, do not edit directly! | + | # NAA managed file, do not edit directly! |
[mysqld] | [mysqld] | ||
# | # | ||
Line 160: | Line 160: | ||
We typically recommend tools from the hypervisor or third-parties to backup the appliance and database. In some cases it’s helpful to use native tools. | We typically recommend tools from the hypervisor or third-parties to backup the appliance and database. In some cases it’s helpful to use native tools. | ||
- | The File Fabric | + | The Access Anywhere |
For more information see https:// | For more information see https:// | ||
Line 263: | Line 263: | ||
## Increasing Database Size | ## Increasing Database Size | ||
- | Another way to deal with a full database is to allocate more space. The File Fabric | + | Another way to deal with a full database is to allocate more space. The Access Anywhere |
<WRAP center round important 100%> | <WRAP center round important 100%> | ||
Line 337: | Line 337: | ||
## Convert to GTID for v2006+ | ## Convert to GTID for v2006+ | ||
- | File Fabric | + | Access Anywhere |
Starting with v2006 and greater, GTID is the recommended method for data migration. | Starting with v2006 and greater, GTID is the recommended method for data migration. | ||
<WRAP center round important 100%> | <WRAP center round important 100%> | ||
- | Warning: This work will bring down the File Fabric. As such you should run this only during a planned maintenance window. | + | Warning: This work will bring down Access Anywhere. As such you should run this only during a planned maintenance window. |
</ | </ | ||
- | ### Enable GTID in the File Fabric | + | ### Enable GTID in the Access Anywhere |
As the root user run the following on every database node: | As the root user run the following on every database node: |