Configure

Database Instance Configuration

After you have deployed the database(s) as per teh customer's requirements, you have to create the following users in the database so that the DB Proxy and the Observability agents will work as expected:

CREATE USER 'monitor'@'%' IDENTIFIED WITH mysql_native_password BY 'monitorPass123';
GRANT USAGE, REPLICATION CLIENT ON *.* TO 'monitor'@'%';


CREATE USER 'appuser'@'%' IDENTIFIED WITH mysql_native_password BY 'appUserPass123';
GRANT ALL ON *.* TO 'appuser'@'%';


CREATE USER 'proxyuser@'%' IDENTIFIED WITH mysql_native_password BY 'proxyUserPass123';
GRANT ALL ON *.* TO 'proxyuser'@'%';

Configure proxysql.cnf

Please find a sample proxysql.cnf file at the data3-testnet-docker repo in KandolaNetwork's Github.

• Configure the backend mysql servers' IP address and port that have been deployed as per the customer specification under mysql_servers (at line 39):

mysql_servers =
(
    { address="192.168.5.168" , port=3308 , hostgroup=10, max_connections=100 , max_replication_lag = 5 }
)

• Confirm that the mysql_users section (last in the sample proxysql.cnf) has the right credentials as configured above for the appuser and proxyuser in the SQL scripts on the backend databases:

mysql_users =
(
    { username = "appuser" , password = "appUserPass123" , default_hostgroup = 10 , active = 1 },
    { username = "proxyuser" , password = "proxyPass123" , default_hostgroup = 10 , active = 1 }
)

• Confirm that the monitor user variable in proxysql.cnf has the right credentials as configured above for the monitor user in the SQL scripts on the backend databases:

mysql_variables=
{
    ...
    monitor_username="monitor"
    monitor_password="monitorPass123"
}

Environment variables for data3-storage-node

Configure the data3-storage-node using the following environment variables:

Name	Description	Sample Value
GRAILS_ENV	Environment type for application development , test, production, etc.	development
OBSERVABILITY_SERVER_HOSTNAME	Hostname / IP of the observability server.	192.168.5.168
OBSERVABILITY_SERVER_PORT	Port number of the observability server.	8443
OBSERVABILITY_SERVER_USERNAME	Username for the observability agent to login to the observability server.	admin
OBSERVABILITY_SERVER_PASSWORD	Password for the observability agent to login to the observability server.	observabilityAdminPass123
DBPROXY_ADMIN_USERNAME	Username for the managing the DB proxy.	admin
DBPROXY_ADMIN_PASSWORD	Password for the managing the DB proxy.	adminPass123
NODE_PROVIDER_BASE_URL	API Base URL of the Data3 Data3 Node Provider Service.	http://192.168.5.168:8080/
SELF_STORAGE_NODE_HOSTNAME	Hostname / IP Address of this node (data3-storage-node) that will allow customers to access the database.	192.168.5.169
SELF_STORAGE_NODE_PORT	Port on this node (data3-storage-node) that will allow customers to access the database. This is typically the host port mapping to the DB Proxy in the container at 6033.	16033
DEPLOYMENT_ADDRESS	The deployment address that uniquely identifies the customer's request for a deployment. See External Deployment Engine for how to set value. This is the ENV Variable that strongly ties the storage node to a customer request.	AAAADDDD
DEPLOYMENT_NAME	Typically the same name that the customer used while requesting the deployment. See External Deployment Engine for how to set value.	Dev Deployment 1