Setting up ProxySQL as a connection pool for Azure Database for MySQL - Flexible Server

Published Jul 27 2021 03:58 PM 3,371 Views
Microsoft

ProxySQL is a high-performance MySQL proxy that enables developers to distribute queries across multiple MySQL servers to balance the load more efficiently. ProxySQL performs a read/write split that is transparent to the application and doesn’t require any application side changes. In addition to intelligent load balancing, ProxySQL also provides built-in connection pooling, which is useful for certain application frameworks and workloads that don’t handle connection management well.

 

This blog post provides the steps required to set up ProxySQL with Azure Database for MySQL - Flexible Server. You can use this functionality for connection pooling or splitting the read and write workloads across Azure Database for MySQL Flexible read replicas. 

 

Deployment options


There are multiple options available for deploying ProxySQL. You can install ProxySQL:

  • On an application server (Recommended) – You can install ProxySQL on the same server as application, which helps to minimize network latency, avoids having a single point of failure, and lowers cost. Before using this approach, ensure that your application server has sufficient CPU and memory to handle the extra workload incurred by running ProxySQL.
  • In a dedicated VM on Azure – You can deploy a dedicated server for ProxySQL on the same virtual network to manage all the short-lived sessions coming from application servers. To some degree, this option requires fewer backend connections and less configuration effort. In addition, it doesn’t add to the workload running on the application server. However, using this option does pose a potential risk in that it could lead to a situation in which the VM becomes a single point of failureleading to unavailability of the application if the ProxySQL VM is down. This approach also increases the network latency between the ProxySQL VM and the application server/database server. 
  • In a Kubernetes cluster – If there’s an existing Kubernetes cluster that hosts the application, consider deploying ProxySQL in the Kubernetes cluster when the system demands high availability and reliability. To set up the pod, put ProxySQL in a container coupled with an application container in same pod using a sidecar patternor deploy a separate pod for ProxySQL service for redundancy. For further information, see Deploy ProxySQL as a service on Kubernetes using Azure Database for MySQL. 

The traffic flow associated with this architecture is shown in the following diagram. 

ziling_0-1627354413591.png

The following table shows the network isolation and latency with each deployment option.

 

 

On app server

In extra VM

In K8S cluster

Public access (allowed IP addresses)

Not recommended

Private access (VNet

integration)

Round-trip time (RTT)*

2*t3

2*(t1+t2)

Internal communication
within k8s+2*t4

 *RTT explains the total amount of time that could be delayed in all of communication points. 

 

This blog focuses on installing ProxySQL on an Ubuntu VMwhich can either be the VM that hosts the application or a dedicated VM. The Azure Database for MySQL server is provisioned with the default public access networking option, but the steps below also apply to a server provisioned with private access (VNet integration).

 

Prerequisites

 

Before setting up ProxySQL, ensure that you have: 

 

Install ProxySQL on the Ubuntu VM

 

1. On the Ubuntu VM, download the latest version of ProxySQL (from https://github.com/sysown/proxysql/releasesinto the /tmp directory.

cd /tmp
curl -OL  https://github.com/sysown/proxysql/releases/download/v2.^C6/proxysql_2.0.6-ubuntu18_amd64.deb 

2. Install ProxySQL by using dpkgand then update the package repository to ensure that you have the latest version build.
 

sudo dpkg -i proxysql_*  
sudo apt-get update 

3. Install the mysql-client.

 

sudo apt install mysql-client-core-8.0

4. Restart the ProxySQL service.

 

sudo systemctl start proxysql 

5. Check the status of the service.

 

systemctl status proxysql  

If the service has started successfully, you should see output similar to the following:

 

apple@proxysqlnew:~$ systemctl status proxysql 
● proxysql.service - High Performance Advanced Proxy for MySQL
Loaded: loaded (/lib/systemd/system/proxysql.service; enabled; vendor pres>
Active: active (running) since Tue 2021-07-20 10:58:22 UTC; 1min 13s ago
Process: 743 ExecStart=/usr/bin/proxysql -c /etc/proxysql.cnf (code=exited,>
Main PID: 1137 (proxysql)
Tasks: 20 (limit: 38530)
Memory: 138.3M
CGroup: /system.slice/proxysql.service
├─1137 /usr/bin/proxysql -c /etc/proxysql.cnf
└─1139 /usr/bin/proxysql -c /etc/proxysql.cnf
Jul 20 10:58:18 proxysqlnew systemd[1]: Starting High Performance Advanced Prox>
Jul 20 10:58:19 proxysqlnew proxysql[743]: 2021-07-20 10:58:19 [INFO] Using con>
Jul 20 10:58:19 proxysqlnew proxysql[743]: 2021-07-20 10:58:19 [INFO] SSL keys/>
Jul 20 10:58:22 proxysqlnew systemd[1]: Started High Performance Advanced Proxy>
lines 1-15/15 (END)...skipping...
● proxysql.service - High Performance Advanced Proxy for MySQL
Loaded: loaded (/lib/systemd/system/proxysql.service; enabled; vendor preset: enabled)
Active: active (running) since Tue 2021-07-20 10:58:22 UTC; 1min 13s ago
Process: 743 ExecStart=/usr/bin/proxysql -c /etc/proxysql.cnf (code=exited, status=0/SUCCESS)
Main PID: 1137 (proxysql)
Tasks: 20 (limit: 38530)
Memory: 138.3M
CGroup: /system.slice/proxysql.service
├─1137 /usr/bin/proxysql -c /etc/proxysql.cnf
└─1139 /usr/bin/proxysql -c /etc/proxysql.cnf
Jul 20 10:58:18 proxysqlnew systemd[1]: Starting High Performance Advanced Proxy for MySQL...
Jul 20 10:58:19 proxysqlnew proxysql[743]: 2021-07-20 10:58:19 [INFO] Using config file /etc/proxysql.cnf
Jul 20 10:58:19 proxysqlnew proxysql[743]: 2021-07-20 10:58:19 [INFO] SSL keys/certificates found in datadir (/var/lib/proxysql): loading them.
Jul 20 10:58:22 proxysqlnew systemd[1]: Started High Performance Advanced Proxy for MySQL.

 

Set up ProxySQL

 

1. Connect to the ProxySQL administration interface using the default password ‘admin’.

 

mysql -h127.0.0.1 -uadmin -padmin -P6032 

2. Configure the host group to add Azure Database for MySQL as the backend server, and then enable read/write traffic to the server group defined.

 

insert into mysql_servers(hostgroup_id,hostname,port,weight,comment) values(1,'pfsmysql57.mysql.database.azure.com',3306,1,'Azure Mysql'); 

3. Enable SSL support in the ProxySQL server pool.

 

UPDATE mysql_servers SET use_ssl=1 WHERE hostgroup_id=1;  

 

Create MySQL users on the Azure MySQL server

 

While you can use the default admin user in Azure Database for MySQL, you can also create another admin user for the ProxySQL connection. To create an admin user for the ProxySQL connection, perform the following steps:

 

1. Create a MySQL user. 

 

CREATE USER 'mydemouser'@'%' IDENTIFIED BY 'secretpassword';  

 2. Grant privileges to the new user and then refresh.

 

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'mydemouser'@'%' WITH GRANT OPTION; 
FLUSH PRIVILEGES; 

 

Create the ProxySQL user

 

  • Allow the ‘mydemouser’/default admin user to connect to ProxySQL server.

 

insert into mysql_users(username,password,default_hostgroup,transaction_persistent) values ('mydemouser','secretpassword',1,1); 

 

Configure monitoring on ProxySQL

 

1. Create a monitor user on Azure Database for MySQL.

 

CREATE USER 'monitoruser'@'%' IDENTIFIED BY 'secretpassword';
GRANT SELECT ON *.* TO ' monitoruser'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;  

2. On the server running ProxySQL, configure mysql-monitor to the username of the new account.

 

mysql -h127.0.0.1 -uadmin -padmin -P6032
set mysql-monitor_username='monitoruser';
set mysql-monitor_password='secretpassword';  

 

Configure the routing rules on ProxySQL

 

  • On the server running ProxySQL, configure a route rule to forward the read/write traffic to the backend host group.

 

insert into mysql_query_rules(rule_id,active,match_digest,destination_hostgroup,apply)values(1,1,'^SELECT.*FOR UPDATE$,^SELECT',1,1);

insert into mysql_query_rules(rule_id,active,match_digest,destination_hostgroup,apply)values(2,1,'SELECT',1,1); 

 Note: To split the read/write load to a different server group, change the "hostgroup" and "match_digest" parameters appropriately.

 

Key parameters to modify based on workload change

 

There are several important parameters to modify based on changes to the workload. 

 

Parameter 

Description 

mysql-max_connections 

Specifies the maximum number of client connections that the proxy can handle. If this threshold is reached, new connections are rejected with the #HY000 error, and the error message “Too many connections” displays. 

mysql-free_connections_pct 

Controls the percentage of open idle connections allowed out of the total maximum number of connections for a specific server in a host group.

 

Note: If your application frequently establishes new connections, we recommend increasing the value of the ‘mysql-free_connections_pct’ parameter from the default (10%) to a value between 50-60%. This will increase the number of open idle connections in the connection pool and significantly improve performance. 

mysql-wait_timeout 

Specifies the time that a proxy session (a conversation between a MySQL client and a ProxySQL) can be idle before the proxy ends the session.

mysql-connect_timeout_server_max 

Specifies the timeout for connecting to a backend server from the proxy. When this timeout is reached, an error with the code 9001 is returned to the client and the message “Max connect timeout reached while reaching hostgroup…” displays. 

Mysql-query_retries_on_failure 

Specifies the number of times failed queries can be restarted for applications tolerant to query failures. 

Mysql-max_transaction_time 

The default value of 4 hours is ideal for most applications and use-casesbut applications run in an HTAP mode. If any queries tend to take more than 4 hours (for example, weekly business reports running against an OLTP DB), then increase the value if applications should not tolerate stuck or very slow running queries against a database. 

Mysql-max_allowed_packet 

Specifies the maximum size of one packet that mysql can accept. The best practice is to mirror the max_allowed_packet  value from the backend mysql database. 

Mysql-long_query_time 

Specifies the threshold for counting queries passing through the proxy as ‘slow’ queries. 

 

1. To change the value of any parameter, run the following command: 

 

UPDATE global_variables SET variable_value=xxx WHERE variable_name=xxxx'; 

2. To view current settings for a specific parameter, run the following command: 

 

SELECT * FROM global_variables WHERE variable_name LIKE '%xxx%' 

Note: For more information about configuring parameters based on your workload, see the List of MySQL Variables.

 

Save the ProxySQL configuration changes to persist across restarts

 

1. To save the settings to runtime on the server hosting ProxySQL, run the following commands:

 

load mysql users to runtime;  
load mysql servers to runtime;  
load mysql query rules to runtime;  
load mysql variables to runtime;  
load admin variables to runtime; 


2. To save the settings to disk on the server running ProxySQL, run the following commands:

 

save mysql users to disk;  
save mysql servers to disk;  
save mysql query rules to disk;  
save mysql variables to disk;  
save admin variables to disk;  

 

Verify that ProxySQL is managing opening connections

 

After successfully completing the above steps, you’ve configured ProxySQL as a connection pool to manage all the short live sessions. To test the functionality by determining if IO requests are being forwarded properly, perform the following steps.

 

1. Sign in to the server running ProxySQL using the ProxySQL user you created.

 

mysql -h127.0.0.1 -u<AzureMySQLUsername> -p<password> -P6033  

2. Run the read and write queries.

 

SELECT * FROM mydemotable; 
UPDATE mydemotable SET mydemocolumn=value WHERE condition;  

3. To verify that ProxySQL has routed the above read and write correctly, connect to the ProxySQL administration interface with the default password ‘admin’.

 

mysql -h127.0.0.1 -uadmin -padmin -P6032 

4. To review the query details via ProxySQL, run the following query:

 

SELECT * FROM stats_mysql_query_digest 
SELECT * FROM stats_mysql_commands_counters WHERE Total_cnt; 

5. To monitor connection usage in the pool, run the following query

 

SELECT * FROM stats.stats_mysql_connection_pool; 

6. Review the output for details about the pool usage and determine if there are any failed sessions by checking the items in bold text below.

 

mysql> SELECT * FROM stats.stats_mysql_connection_pool; 

+-----------+-------------------------------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+ 

| hostgroup | srv_host                            | srv_port | status | ConnUsed | ConnFree | ConnOK | ConnERR | MaxConnUsed | Queries | Queries_GTID_sync | Bytes_data_sent | Bytes_data_recv | Latency_us | 

+-----------+-------------------------------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+ 

| 1         | pfsmysql57.mysql.database.azure.com | 3306     | ONLINE | 0        | 0        | 0      | 0       | 0           | 0       | 0                 | 0               | 0               | 892        | 

+-----------+-------------------------------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+ 

1 row in set (0.01 sec) 

 

Conclusion

 

ProxySQL is a great lightweight load balancer proxy that can improve your application performance and scalability with MySQL. It helps with improved connection management, reduced latency, and transparent read/write load balancing across replicas running Azure Database for MySQL Flexible Server.

 

For more detailed configuration informationsee the ProxySQL official site: 

https://proxysql.com/documentation/getting-started/ 

 

If you have any feedback or questions about using the architecture described above, please leave a comment below or email us at AskAzureDBforMySQL@service.microsoft.com.

2 Comments
Occasional Visitor

Hello,

 we are having or wordpress application hosted on azure app servie and we are using Azure mysql read replicas to handle heavy workloads. we are trying to distribute our read and write workloads sing a proxysql server implemented in a vm now my questin is how can I connect my appservice to vm....or is it just giving the master string connection with above username to appservice is enough for my proysql to route traffic for read and write reqest.pls help me with this. Thanks in advance

Microsoft

@h_e_m_a sorry for late response as I just saw your update now. From app service side, we should configure the connection string of proxysql instead of mysql server as bellow:

mysql -uproxysql -pproxysql -h proxysqlHostIP -P 6033

 

%3CLINGO-SUB%20id%3D%22lingo-sub-2589350%22%20slang%3D%22en-US%22%3ESetting%20up%20ProxySQL%20as%20a%20connection%20pool%20for%20Azure%20Database%20for%20MySQL%20-%20Flexible%20Server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2589350%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.proxysql.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EProxySQL%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eis%20a%20high-performance%20MySQL%20proxy%20that%20enables%20developers%20to%20distribute%20queries%20across%20multiple%20MySQL%20servers%20to%20balance%20the%20load%20more%20efficiently.%20ProxySQL%20performs%20a%20read%2Fwrite%20split%20that%20is%20transparent%20to%20the%20application%20and%20doesn%E2%80%99t%20require%20any%20application%20side%20changes.%20In%20addition%20to%20intelligent%20load%20balancing%2C%20ProxySQL%20also%20provides%20built-in%20connection%20pooling%2C%20which%20is%20useful%20for%20certain%20application%20frameworks%20and%20workloads%20that%20don%E2%80%99t%20handle%20connection%20management%20well.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThis%20blog%20post%20provides%20the%20steps%20required%20to%20set%20up%20ProxySQL%20with%20Azure%20Database%20for%20MySQL%20-%20Flexible%20Server.%20You%20can%20use%20this%20functionality%20for%20connection%20pooling%20or%20splitting%20the%20read%20and%20write%20workloads%20across%20Azure%20Database%20for%20MySQL%20Flexible%20read%20replicas.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233117%26quot%3B%3Atrue%2C%26quot%3B134233118%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A120%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20aria-level%3D%221%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20aria-level%3D%221%22%20id%3D%22toc-hId--406786774%22%20id%3D%22toc-hId--385786162%22%20id%3D%22toc-hId--385786162%22%20id%3D%22toc-hId--385786162%22%20id%3D%22toc-hId--385786162%22%20id%3D%22toc-hId--385786162%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EDeployment%26nbsp%3Boptions%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3CBR%20%2F%3EThere%20are%20multiple%20options%20available%20for%20deploying%20ProxySQL.%20You%20can%20install%20ProxySQL%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%2216%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%221%22%20data-aria-level%3D%221%22%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3EOn%20an%20application%20server%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B(Recommended)%20%E2%80%93%20You%20can%20install%20ProxySQL%20on%20the%20same%20server%20as%20application%2C%20which%20helps%20to%20minimize%20network%20latency%2C%20avoids%20having%20a%20single%20point%20of%20failure%2C%20and%20lowers%20cost.%20Before%20using%20this%20approach%2C%20ensure%20that%20your%20application%20server%20has%20sufficient%20CPU%20and%20memory%20to%20handle%20the%20extra%20workload%20incurred%20by%20running%20ProxySQL.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%2216%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%222%22%20data-aria-level%3D%221%22%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3EIn%20a%20dedicated%20VM%20on%20Azure%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%E2%80%93%20You%20can%20deploy%20a%20dedicated%20server%20for%20ProxySQL%26nbsp%3Bon%26nbsp%3Bthe%20same%20virtual%20network%20to%20manage%20all%20the%20short%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E-%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Elived%26nbsp%3Bsessions%20coming%20from%20application%20servers.%20To%20some%20degree%2C%20this%20option%20requires%20fewer%20backend%20connections%20and%20less%20configuration%20effort.%20In%20addition%2C%20it%20doesn%E2%80%99t%20add%20to%20the%20workload%20running%20on%20the%20application%20server.%20However%2C%26nbsp%3Busing%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ethis%20option%20does%20pose%20a%20potential%20risk%26nbsp%3Bin%26nbsp%3Bthat%20it%20could%20lead%20to%20a%20situation%20in%20which%20the%20VM%26nbsp%3Bbecomes%26nbsp%3Ba%20single%20point%20of%20failure%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eleading%26nbsp%3Bto%20unavailability%20of%20the%20application%20if%26nbsp%3Bthe%26nbsp%3BProxySQL%20VM%20is%20down.%20T%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ehis%20approach%20also%20increases%20the%26nbsp%3Bnetwork%20latency%20between%26nbsp%3Bthe%26nbsp%3BProxySQL%20VM%20and%26nbsp%3Bthe%26nbsp%3Bapplication%20server%2Fdatabase%20server.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A547%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B720%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B0%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%2216%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%223%22%20data-aria-level%3D%221%22%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3EIn%20a%20Kubernetes%20cluster%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%E2%80%93%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EIf%20there%E2%80%99s%26nbsp%3Ban%26nbsp%3Bexisting%20Kubernetes%20cluster%26nbsp%3Bthat%20hosts%20the%20application%2C%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Econsider%20deploying%26nbsp%3BProxySQL%26nbsp%3Bin%26nbsp%3Bthe%26nbsp%3BKubernetes%20cluster%20when%26nbsp%3Bthe%26nbsp%3Bsystem%20demands%26nbsp%3Bhigh%20availability%20and%20reliability.%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3ETo%26nbsp%3Bset%20up%20the%26nbsp%3Bpod%2C%20put%26nbsp%3BProxySQL%26nbsp%3Bin%20a%20container%20coupled%20with%26nbsp%3Ban%26nbsp%3Bapplication%20container%20in%20same%20pod%26nbsp%3Busing%26nbsp%3Ba%26nbsp%3Bsidecar%20pattern%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eor%20deploy%20a%20separate%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Epod%20for%26nbsp%3BProxySQL%26nbsp%3Bservice%26nbsp%3Bfor%20redundancy.%20For%20further%20information%2C%20see%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-database-for-mysql%2Fdeploy-proxysql-as-a-service-on-kubernetes-using-azure-database%2Fba-p%2F1105959%22%20target%3D%22_blank%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EDeploy%20ProxySQL%20as%20a%20service%20on%20Kubernetes%20using%20Azure%20Database%20for%20MySQL%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A547%2C%26quot%3B335559739%26quot%3B%3A120%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B720%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B0%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThe%26nbsp%3Btraffic%20flow%26nbsp%3Bassociated%20with%20this%26nbsp%3Barchitecture%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eis%20shown%20in%20the%20following%20diagram.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A540%2C%26quot%3B335559739%26quot%3B%3A120%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22ziling_0-1627354413591.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298543iE935CB8EDADB479F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22ziling_0-1627354413591.png%22%20alt%3D%22ziling_0-1627354413591.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThe%20following%20table%20shows%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ethe%20network%20isolation%26nbsp%3Band%20latency%20with%20each%20deployment%20option.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CTABLE%20border%3D%221%22%20width%3D%2299.7800586510264%25%22%3E%0A%3CTBODY%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2225%25%22%3E%26nbsp%3B%3C%2FTD%3E%0A%3CTD%20width%3D%2224.926686217008797%25%22%20height%3D%2257px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSTRONG%3EOn%20app%20server%3C%2FSTRONG%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2224.926686217008797%25%22%20height%3D%2257px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSTRONG%3EIn%20extra%20VM%3C%2FSTRONG%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2224.926686217008797%25%22%20height%3D%2257px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSTRONG%3EIn%20K8S%20cluster%3C%2FSTRONG%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2225%25%22%3EPublic%20access%20(allowed%20IP%20addresses)%3C%2FTD%3E%0A%3CTD%20width%3D%2224.926686217008797%25%22%20height%3D%2257px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%E2%88%9A%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2224.926686217008797%25%22%20height%3D%2257px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3ENot%20recommended%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2224.926686217008797%25%22%20height%3D%2257px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%E2%88%9A%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2225%25%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EPrivate%20access%26nbsp%3B(VNet%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eintegration)%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2224.926686217008797%25%22%20height%3D%2257px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%E2%88%9A%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2224.926686217008797%25%22%20height%3D%2257px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%E2%88%9A%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2224.926686217008797%25%22%20height%3D%2257px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%E2%88%9A%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%2225%25%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3ERound-trip%20time%20(RTT)*%3C%2FSPAN%3E%3C%2FTD%3E%0A%3CTD%20width%3D%2224.926686217008797%25%22%20height%3D%2284px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E2*t3%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2224.926686217008797%25%22%20height%3D%2284px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E2*(t1%2Bt2)%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%2224.926686217008797%25%22%20height%3D%2284px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EInternal%20communication%3CBR%20%2F%3Ewithin%20k8s%2B2*t4%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A720%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CI%3E%3CSPAN%20data-contrast%3D%22auto%22%3E*RTT%20explains%26nbsp%3Bthe%26nbsp%3Btotal%26nbsp%3Bamount%20of%20time%20that%26nbsp%3Bcould%20be%20delayed%20in%26nbsp%3Ball%20of%20communication%20points.%3C%2FSPAN%3E%3C%2FI%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%20data-ccp-props%3D%22%7B%26quot%3B134233117%26quot%3B%3Atrue%2C%26quot%3B134233118%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559738%26quot%3B%3A120%2C%26quot%3B335559739%26quot%3B%3A120%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThis%20blog%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Efocuses%26nbsp%3Bon%20installing%20ProxySQL%20on%20an%20Ubuntu%20VM%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ewhich%20can%26nbsp%3Beither%26nbsp%3Bbe%20the%20VM%20that%20hosts%20the%20application%20or%20a%20dedicated%20VM.%20The%20Azure%20Database%20for%20MySQL%20server%20is%20provisioned%20with%20the%20default%20public%20access%20networking%20option%2C%20but%20the%20steps%20below%26nbsp%3Balso%26nbsp%3Bapply%26nbsp%3Bto%26nbsp%3Ba%26nbsp%3Bserver%20provisioned%20with%20private%20access%20(VNet%20integration).%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20aria-level%3D%221%22%20id%3D%22toc-hId-2080726059%22%20id%3D%22toc-hId-2101726671%22%20id%3D%22toc-hId-2101726671%22%20id%3D%22toc-hId-2101726671%22%20id%3D%22toc-hId-2101726671%22%20id%3D%22toc-hId-2101726671%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EPrerequisites%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EBefore%20setting%20up%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EProxySQL%2C%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3Bensure%20that%20you%20have%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3A%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233117%26quot%3B%3Atrue%2C%26quot%3B134233118%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A40%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSPAN%20data-contrast%3D%22none%22%3EA%20Linux%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EVirtual%20Machine%20running%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EUbuntu%2C%20which%20will%20be%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ethe%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EProxySQL%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eserver.%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EFor%20more%20information%2C%20see%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fvirtual-machines%2Flinux%2Fquick-create-portal%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ECreate%20a%20Linux%20virtual%20machine%20in%20the%20Azure%20portal%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233118%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A547%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B720%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B0%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20data-contrast%3D%22none%22%3EAn%20Azure%20Database%20for%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EMySQL%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eserver%20to%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Euse%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eas%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ehost%20group%201%20(the%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Emaster%26nbsp%3Bserver).%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3BYou'll%20configure%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EProxySQL%20to%20direct%20all%20the%20read%2Fwrite%20workload%20to%20this%20server.%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EFor%20more%20information%2C%20see%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fmysql%2Fquickstart-create-mysql-server-database-using-azure-portal%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ECreate%20an%20Azure%20Database%20for%20MySQL%20server%20by%20using%20the%20Azure%20portal%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233117%26quot%3B%3Atrue%2C%26quot%3B134233118%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A540%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B720%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B0%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20data-contrast%3D%22none%22%3EFirewall%20rules%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eallowing%20the%20Linux%20VM%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E(ports%26nbsp%3B3306%2C%206032%2C6033%2C22%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E)%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3Bto%20connect%20to%20the%20Azure%20Database%20for%20MySQL%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eserver.%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EFor%20more%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Einformation%2C%20see%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fmysql%2Fhowto-manage-firewall-using-portal%23create-a-server-level-firewall-rule-in-the-azure-portal%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ECreate%20a%20server-level%20firewall%20rule%20in%20the%20Azure%20portal%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20aria-level%3D%221%22%20id%3D%22toc-hId-273271596%22%20id%3D%22toc-hId-294272208%22%20id%3D%22toc-hId-294272208%22%20id%3D%22toc-hId-294272208%22%20id%3D%22toc-hId-294272208%22%20id%3D%22toc-hId-294272208%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EInstall%20ProxySQL%20on%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ethe%26nbsp%3BUbuntu%20VM%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E1.%20On%20the%20Ubuntu%20VM%2C%20download%20the%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Elatest%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eversion%20of%20ProxySQL%20(from%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fsysown%2Fproxysql%2Freleases%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2Fsysown%2Fproxysql%2Freleases%3C%2FA%3E)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Einto%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ethe%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%2F%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Etmp%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Edirectory.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ecd%20%2Ftmp%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A240%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ecurl%20-OL%26nbsp%3B%20https%3A%2F%2Fgithub.com%2Fsysown%2Fproxysql%2Freleases%2Fdownload%2Fv2.%5EC6%2Fproxysql_2.0.6-ubuntu18_amd64.deb%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A240%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E2.%20Install%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EProxySQL%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eby%20using%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Edpkg%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eand%26nbsp%3Bthen%26nbsp%3Bupdate%20the%20package%20repository%20to%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eensure%20that%20you%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ehave%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ethe%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Elatest%20version%20build.%3CBR%20%2F%3E%26nbsp%3B%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3Esudo%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Edpkg%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B-%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ei%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eproxysql%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E_*%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A240%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Esudo%26nbsp%3Bapt-get%20update%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A240%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E3.%20Install%26nbsp%3Bthe%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Emysql-client%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3Esudo%26nbsp%3Bapt%20install%20mysql-client-core-8.0%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A240%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E4.%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3ERestart%26nbsp%3Bthe%26nbsp%3BProxySQL%20service.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3Esudo%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Esystemctl%26nbsp%3Bstart%26nbsp%3Bproxysql%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A240%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E5.%20Check%26nbsp%3Bthe%20status%20of%20the%26nbsp%3Bservice.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3Esystemctl%26nbsp%3Bstatus%26nbsp%3Bproxysql%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A240%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EIf%26nbsp%3Bthe%20service%20has%20started%26nbsp%3Bsuccessfully%2C%20you%26nbsp%3Bshould%26nbsp%3Bsee%26nbsp%3Boutput%20similar%20to%20the%26nbsp%3Bfollowing%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3Eapple%40proxysqlnew%3A~%24%20systemctl%20status%20proxysql%20%3CBR%20%2F%3E%E2%97%8F%20proxysql.service%20-%20High%20Performance%20Advanced%20Proxy%20for%20MySQL%20%3CBR%20%2F%3ELoaded%3A%20loaded%20(%2Flib%2Fsystemd%2Fsystem%2Fproxysql.service%3B%20enabled%3B%20vendor%20pres%26gt%3B%20%3CBR%20%2F%3EActive%3A%20active%20(running)%20since%20Tue%202021-07-20%2010%3A58%3A22%20UTC%3B%201min%2013s%20ago%20%3CBR%20%2F%3EProcess%3A%20743%20ExecStart%3D%2Fusr%2Fbin%2Fproxysql%20-c%20%2Fetc%2Fproxysql.cnf%20(code%3Dexited%2C%26gt%3B%20%3CBR%20%2F%3EMain%20PID%3A%201137%20(proxysql)%20%3CBR%20%2F%3ETasks%3A%2020%20(limit%3A%2038530)%20%3CBR%20%2F%3EMemory%3A%20138.3M%20%3CBR%20%2F%3ECGroup%3A%20%2Fsystem.slice%2Fproxysql.service%20%3CBR%20%2F%3E%E2%94%9C%E2%94%801137%20%2Fusr%2Fbin%2Fproxysql%20-c%20%2Fetc%2Fproxysql.cnf%20%3CBR%20%2F%3E%E2%94%94%E2%94%801139%20%2Fusr%2Fbin%2Fproxysql%20-c%20%2Fetc%2Fproxysql.cnf%20%3CBR%20%2F%3EJul%2020%2010%3A58%3A18%20proxysqlnew%20systemd%5B1%5D%3A%20Starting%20High%20Performance%20Advanced%20Prox%26gt%3B%20%3CBR%20%2F%3EJul%2020%2010%3A58%3A19%20proxysqlnew%20proxysql%5B743%5D%3A%202021-07-20%2010%3A58%3A19%20%5BINFO%5D%20Using%20con%26gt%3B%20%3CBR%20%2F%3EJul%2020%2010%3A58%3A19%20proxysqlnew%20proxysql%5B743%5D%3A%202021-07-20%2010%3A58%3A19%20%5BINFO%5D%20SSL%20keys%2F%26gt%3B%20%3CBR%20%2F%3EJul%2020%2010%3A58%3A22%20proxysqlnew%20systemd%5B1%5D%3A%20Started%20High%20Performance%20Advanced%20Proxy%26gt%3B%20%3CBR%20%2F%3Elines%201-15%2F15%20(END)...skipping...%20%3CBR%20%2F%3E%E2%97%8F%20proxysql.service%20-%20High%20Performance%20Advanced%20Proxy%20for%20MySQL%20%3CBR%20%2F%3ELoaded%3A%20loaded%20(%2Flib%2Fsystemd%2Fsystem%2Fproxysql.service%3B%20enabled%3B%20vendor%20preset%3A%20enabled)%20%3CBR%20%2F%3EActive%3A%20active%20(running)%20since%20Tue%202021-07-20%2010%3A58%3A22%20UTC%3B%201min%2013s%20ago%20%3CBR%20%2F%3EProcess%3A%20743%20ExecStart%3D%2Fusr%2Fbin%2Fproxysql%20-c%20%2Fetc%2Fproxysql.cnf%20(code%3Dexited%2C%20status%3D0%2FSUCCESS)%20%3CBR%20%2F%3EMain%20PID%3A%201137%20(proxysql)%20%3CBR%20%2F%3ETasks%3A%2020%20(limit%3A%2038530)%20%3CBR%20%2F%3EMemory%3A%20138.3M%20%3CBR%20%2F%3ECGroup%3A%20%2Fsystem.slice%2Fproxysql.service%20%3CBR%20%2F%3E%E2%94%9C%E2%94%801137%20%2Fusr%2Fbin%2Fproxysql%20-c%20%2Fetc%2Fproxysql.cnf%20%3CBR%20%2F%3E%E2%94%94%E2%94%801139%20%2Fusr%2Fbin%2Fproxysql%20-c%20%2Fetc%2Fproxysql.cnf%20%3CBR%20%2F%3EJul%2020%2010%3A58%3A18%20proxysqlnew%20systemd%5B1%5D%3A%20Starting%20High%20Performance%20Advanced%20Proxy%20for%20MySQL...%20%3CBR%20%2F%3EJul%2020%2010%3A58%3A19%20proxysqlnew%20proxysql%5B743%5D%3A%202021-07-20%2010%3A58%3A19%20%5BINFO%5D%20Using%20config%20file%20%2Fetc%2Fproxysql.cnf%20%3CBR%20%2F%3EJul%2020%2010%3A58%3A19%20proxysqlnew%20proxysql%5B743%5D%3A%202021-07-20%2010%3A58%3A19%20%5BINFO%5D%20SSL%20keys%2Fcertificates%20found%20in%20datadir%20(%2Fvar%2Flib%2Fproxysql)%3A%20loading%20them.%20%3CBR%20%2F%3EJul%2020%2010%3A58%3A22%20proxysqlnew%20systemd%5B1%5D%3A%20Started%20High%20Performance%20Advanced%20Proxy%20for%20MySQL.%20%3C%2FPRE%3E%0A%3CP%20aria-level%3D%221%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20aria-level%3D%221%22%20id%3D%22toc-hId--1534182867%22%20id%3D%22toc-hId--1513182255%22%20id%3D%22toc-hId--1513182255%22%20id%3D%22toc-hId--1513182255%22%20id%3D%22toc-hId--1513182255%22%20id%3D%22toc-hId--1513182255%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ESet%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eup%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EProxySQL%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E1.%20Connect%20to%20the%20ProxySQL%20administration%20interface%26nbsp%3Busing%26nbsp%3Bthe%20default%20password%20%E2%80%98admin%E2%80%99.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CSPAN%20data-contrast%3D%22auto%22%3Emysql%26nbsp%3B-h127.0.0.1%20-uadmin%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B-%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Epadmin%26nbsp%3B-P6032%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A240%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E2.%20Configure%26nbsp%3Bthe%26nbsp%3Bhost%20group%20to%20add%20Azure%26nbsp%3BDatabase%20for%26nbsp%3BMySQL%20as%26nbsp%3Bthe%26nbsp%3Bbackend%20server%2C%20and%20then%20enable%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eread%2Fwrite%20traffic%20to%26nbsp%3Bthe%20server%20group%20defined.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CSPAN%20data-contrast%3D%22auto%22%3Einsert%20into%26nbsp%3Bmysql_servers%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E(%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ehostgroup_id%2Chostname%2Cport%2Cweight%2Ccomment)%20values(1%2C'pfsmysql57.mysql.database.azure.com'%2C3306%2C1%2C'Azure%26nbsp%3BMysql%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E')%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A240%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E3.%20Enable%20SSL%20support%20in%26nbsp%3Bthe%26nbsp%3BProxySQL%20server%20pool.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CSPAN%20data-contrast%3D%22auto%22%3EUPDATE%26nbsp%3Bmysql_servers%26nbsp%3BSET%26nbsp%3Buse_ssl%3D1%20WHERE%26nbsp%3Bhostgroup_id%3D1%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A240%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%20aria-level%3D%221%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20aria-level%3D%221%22%20id%3D%22toc-hId-953329966%22%20id%3D%22toc-hId-974330578%22%20id%3D%22toc-hId-974330578%22%20id%3D%22toc-hId-974330578%22%20id%3D%22toc-hId-974330578%22%20id%3D%22toc-hId-974330578%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ECreate%26nbsp%3BMySQL%20users%20on%26nbsp%3Bthe%26nbsp%3BAzure%20MySQL%26nbsp%3Bserver%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EWhile%26nbsp%3Byou%26nbsp%3Bcan%26nbsp%3Buse%26nbsp%3Bthe%26nbsp%3Bdefault%20admin%20user%20in%20Azure%26nbsp%3BDatabase%20for%26nbsp%3BMySQL%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3Byou%20can%20also%26nbsp%3Bcreate%20another%20admin%20user%20for%26nbsp%3Bthe%20ProxySQL%26nbsp%3Bconnection%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233117%26quot%3B%3Atrue%2C%26quot%3B134233118%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A40%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3ETo%20create%20an%20admin%20user%20for%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ethe%20ProxySQL%20connection%2C%20perform%20the%26nbsp%3Bfollowing%20steps%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E1.%20Create%26nbsp%3Ba%26nbsp%3BMySQL%20user%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233117%26quot%3B%3Atrue%2C%26quot%3B134233118%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A1080%2C%26quot%3B335559739%26quot%3B%3A40%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-60px%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ECREATE%20USER%20'mydemouser'%40'%25'%20IDENTIFIED%20BY%20'secretpassword%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E'%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A1350%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A240%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B2.%20Grant%20privileges%20to%20the%20new%20user%20and%20then%20refresh.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EGRANT%20SELECT%2C%20INSERT%2C%20UPDATE%2C%20DELETE%2C%20CREATE%2C%20DROP%2C%20RELOAD%2C%20PROCESS%2C%20REFERENCES%2C%20INDEX%2C%20ALTER%2C%20SHOW%20DATABASES%2C%20CREATE%20TEMPORARY%20TABLES%2C%20LOCK%20TABLES%2C%20EXECUTE%2C%20REPLICATION%20SLAVE%2C%20REPLICATION%20CLIENT%2C%20CREATE%20VIEW%2C%20SHOW%20VIEW%2C%20CREATE%20ROUTINE%2C%20ALTER%20ROUTINE%2C%20CREATE%20USER%2C%20EVENT%2C%20TRIGGER%20ON%20*.*%20TO%20'mydemouser'%40'%25'%20WITH%20GRANT%26nbsp%3BOPTION%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A1350%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A240%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EFLUSH%26nbsp%3BPRIVILEGES%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A1350%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A240%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%20aria-level%3D%221%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20aria-level%3D%221%22%20id%3D%22toc-hId--854124497%22%20id%3D%22toc-hId--833123885%22%20id%3D%22toc-hId--833123885%22%20id%3D%22toc-hId--833123885%22%20id%3D%22toc-hId--833123885%22%20id%3D%22toc-hId--833123885%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ECreate%26nbsp%3Bthe%20ProxySQL%20user%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%2236%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%221%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAllow%20the%20%E2%80%98mydemouser%E2%80%99%2Fdefault%20admin%20user%20to%20connect%20to%20ProxySQL%20server%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Einsert%20into%20mysql_users(username%2Cpassword%2Cdefault_hostgroup%2Ctransaction_persistent)%20values%20('mydemouser'%2C'secretpassword'%2C1%2C1%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E)%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A810%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B916%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B0%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%20aria-level%3D%221%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20aria-level%3D%221%22%20id%3D%22toc-hId-1633388336%22%20id%3D%22toc-hId-1654388948%22%20id%3D%22toc-hId-1654388948%22%20id%3D%22toc-hId-1654388948%22%20id%3D%22toc-hId-1654388948%22%20id%3D%22toc-hId-1654388948%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EConfigure%26nbsp%3Bmonitoring%20on%20ProxySQL%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E1.%20Create%26nbsp%3Ba%26nbsp%3Bmonitor%20user%20on%20Azure%26nbsp%3BDatabase%20for%26nbsp%3BMySQL.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ECREATE%20USER%20'monitoruser'%40'%25'%20IDENTIFIED%20BY%20'secretpassword%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E'%3B%3CBR%20%2F%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%20data-contrast%3D%22none%22%3EGRANT%20SELECT%20ON%20*.*%20TO%20'%26nbsp%3Bmonitoruser'%40'%25'%20WITH%20GRANT%26nbsp%3BOPTION%3B%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EFLUSH%26nbsp%3BPRIVILEGES%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A810%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E2.%26nbsp%3BOn%26nbsp%3Bthe%20server%20running%26nbsp%3BProxySQL%2C%20configure%26nbsp%3Bmysql-monitor%20to%20the%20username%20of%20the%20new%20account.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Emysql%26nbsp%3B-h127.0.0.1%20-uadmin%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B-%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Epadmin%26nbsp%3B-P6032%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eset%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Emysql%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E-%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Emonitor_username%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E'%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Emonitoruser%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E'%3B%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eset%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Emysql%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E-%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Emonitor_password%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E'%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Esecretpassword%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E'%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A810%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%20aria-level%3D%221%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20aria-level%3D%221%22%20id%3D%22toc-hId--174066127%22%20id%3D%22toc-hId--153065515%22%20id%3D%22toc-hId--153065515%22%20id%3D%22toc-hId--153065515%22%20id%3D%22toc-hId--153065515%22%20id%3D%22toc-hId--153065515%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EConfigure%20the%20routing%20rules%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eon%26nbsp%3BProxySQL%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%20data-leveltext%3D%22%EF%82%B7%22%20data-font%3D%22Symbol%22%20data-listid%3D%2236%22%20aria-setsize%3D%22-1%22%20data-aria-posinset%3D%221%22%20data-aria-level%3D%221%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EOn%26nbsp%3Bthe%20server%20running%26nbsp%3BProxySQL%2C%20configure%26nbsp%3Ba%26nbsp%3Broute%20rule%20to%20forward%20the%20read%2Fwrite%20traffic%20to%26nbsp%3Bthe%26nbsp%3Bbackend%20host%20group.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Einsert%20into%20mysql_query_rules(rule_id%2Cactive%2Cmatch_digest%2Cdestination_hostgroup%2Capply)values(1%2C1%2C'%5ESELECT.*FOR%20UPDATE%24%2C%5ESELECT'%2C1%2C1%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E)%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%20data-contrast%3D%22none%22%3Einsert%20into%20mysql_query_rules(rule_id%2Cactive%2Cmatch_digest%2Cdestination_hostgroup%2Capply)values(2%2C1%2C'SELECT'%2C1%2C1%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%20data-contrast%3D%22none%22%3E)%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CFONT%20size%3D%223%22%3E%26nbsp%3B%3CSTRONG%3ENote%3C%2FSTRONG%3E%3A%20To%20split%20the%20read%2Fwrite%20load%20to%20a%20different%20server%20group%2C%20change%20the%20%22%3CSTRONG%3Ehostgroup%3C%2FSTRONG%3E%22%20and%20%22%3CSTRONG%3Ematch_digest%3C%2FSTRONG%3E%22%20parameters%20appropriately.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20aria-level%3D%221%22%20id%3D%22toc-hId--1981520590%22%20id%3D%22toc-hId--1960519978%22%20id%3D%22toc-hId--1960519978%22%20id%3D%22toc-hId--1960519978%22%20id%3D%22toc-hId--1960519978%22%20id%3D%22toc-hId--1960519978%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EKey%26nbsp%3Bparameters%26nbsp%3Bto%20modify%26nbsp%3Bbased%20on%20workload%20change%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThere%20are%20several%20important%20parameters%20to%20modify%20based%20on%20changes%20to%20the%20workload.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CTABLE%20style%3D%22height%3A%20666px%3B%20font-weight%3A%20400%3B%20border-style%3A%20solid%3B%22%20data-tablestyle%3D%22MsoTableGrid%22%20data-tablelook%3D%221184%22%20aria-rowcount%3D%229%22%3E%0A%3CTBODY%3E%0A%3CTR%20aria-rowindex%3D%221%22%3E%0A%3CTD%20width%3D%22229.826px%22%20height%3D%2229px%22%20data-celllook%3D%2265536%22%3E%3CP%3E%3CSTRONG%3E%3CFONT%20color%3D%22%23000000%22%3EParameter%26nbsp%3B%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22742.747px%22%20height%3D%2229px%22%20data-celllook%3D%2265536%22%3E%3CP%3E%3CSTRONG%3E%3CFONT%20color%3D%22%23000000%22%3EDescription%26nbsp%3B%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20aria-rowindex%3D%222%22%3E%0A%3CTD%20width%3D%22229.826px%22%20height%3D%2283px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3Emysql-max_connections%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22742.747px%22%20height%3D%2283px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3ESpecifies%20the%20maximum%20number%20of%20client%20connections%20that%20the%20proxy%20can%20handle.%20If%20this%20threshold%20is%20reached%2C%20new%20connections%20are%20rejected%20with%20the%20%23HY000%20error%2C%20and%20the%20error%20message%20%E2%80%9CToo%20many%20connections%E2%80%9D%20displays.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20aria-rowindex%3D%223%22%3E%0A%3CTD%20width%3D%22229.826px%22%20height%3D%22164px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3Emysql-free_connections_pct%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22742.747px%22%20height%3D%22164px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EControls%20the%20percentage%20of%20open%20idle%20connections%26nbsp%3Ballowed%26nbsp%3Bout%20of%20the%20total%20maximum%20number%20of%20connections%20for%20a%20specific%20server%20in%20a%20host%20group.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3ENote%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3E%3A%20If%20your%20application%20frequently%20establishes%20new%20connections%2C%20we%20recommend%20increasing%20the%20value%20of%20the%20%E2%80%98%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Emysql-free_connections_pct%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%E2%80%99%20parameter%20from%20the%20default%20(10%25)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eto%20a%20value%20between%2050-60%25.%26nbsp%3BThis%26nbsp%3Bwill%20increase%20the%20number%20of%20open%20idle%20connections%20in%20the%20connection%20pool%20and%20significantly%20improve%20performance.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20aria-rowindex%3D%224%22%3E%0A%3CTD%20width%3D%22229.826px%22%20height%3D%2256px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3Emysql-wait_timeout%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22742.747px%22%20height%3D%2256px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3ESpecifies%20the%20time%20that%20a%26nbsp%3Bproxy%20session%20(a%20conversation%20between%20a%20MySQL%20client%20and%20a%20ProxySQL)%26nbsp%3Bcan%20be%26nbsp%3Bidle%26nbsp%3Bbefore%20the%26nbsp%3Bproxy%20ends%20the%20session.%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20aria-rowindex%3D%225%22%3E%0A%3CTD%20width%3D%22229.826px%22%20height%3D%2283px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3Emysql-connect_timeout_server_max%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22742.747px%22%20height%3D%2283px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3ESpecifies%20the%20timeout%20for%20connecting%20to%20a%20backend%20server%20from%20the%20proxy.%20When%20this%20timeout%20is%20reached%2C%20an%20error%26nbsp%3Bwith%20the%20code%209001%26nbsp%3Bis%20returned%20to%20the%20client%20and%20the%20message%20%E2%80%9CMax%20connect%20timeout%20reached%20while%20reaching%26nbsp%3Bhostgroup%E2%80%A6%E2%80%9D%20displays.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20aria-rowindex%3D%226%22%3E%0A%3CTD%20width%3D%22229.826px%22%20height%3D%2256px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EMysql-query_retries_on_failure%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22742.747px%22%20height%3D%2256px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3ESpecifies%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ethe%20number%20of%20times%26nbsp%3Bfailed%20queries%20can%20be%20restarted%26nbsp%3Bfor%26nbsp%3Bapplications%20tolerant%20to%20query%20failures%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20aria-rowindex%3D%227%22%3E%0A%3CTD%20width%3D%22229.826px%22%20height%3D%22110px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EMysql-max_transaction_time%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22742.747px%22%20height%3D%22110px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EThe%20default%20value%20of%204%20hours%20is%20ideal%20for%20most%20applications%20and%20use-cases%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ebut%26nbsp%3Bapplications%20run%20in%20an%26nbsp%3BHTAP%20mode.%20If%20any%20queries%20tend%20to%20take%20more%20than%204%20hours%20(for%20example%2C%26nbsp%3Bweekly%20business%20reports%26nbsp%3Brunning%26nbsp%3Bagainst%20an%26nbsp%3BOLTP%20DB)%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3Bthen%20increase%20the%20value%20if%20applications%20should%20not%20tolerate%20stuck%20or%20very%20slow%20running%20queries%20against%20a%20database.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20aria-rowindex%3D%228%22%3E%0A%3CTD%20width%3D%22229.826px%22%20height%3D%2256px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EMysql-max_allowed_packet%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22742.747px%22%20height%3D%2256px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3ESpecifies%20the%20maximum%20size%20of%20one%20packet%20that%20mysql%20can%20accept.%20The%20best%20practice%20is%20to%20mirror%20the%20max_allowed_packet%26nbsp%3B%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Evalue%20from%20the%20backend%26nbsp%3Bmysql%26nbsp%3Bdatabase.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20aria-rowindex%3D%229%22%3E%0A%3CTD%20width%3D%22229.826px%22%20height%3D%2229px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EMysql-long_query_time%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22742.747px%22%20height%3D%2229px%22%20data-celllook%3D%220%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3ESpecifies%26nbsp%3Bthe%20threshold%26nbsp%3Bfor%20counting%20queries%20passing%20through%20the%20proxy%20as%20%E2%80%98slow%E2%80%99%26nbsp%3Bqueries%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E1.%20To%20change%20the%20value%20of%26nbsp%3Bany%26nbsp%3Bparameter%2C%20run%20the%20following%20command%3A%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A540%2C%26quot%3B335559738%26quot%3B%3A120%2C%26quot%3B335559739%26quot%3B%3A120%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EUPDATE%26nbsp%3Bglobal_variables%26nbsp%3BSET%26nbsp%3Bvariable_value%3Dxxx%26nbsp%3BWHERE%26nbsp%3Bvariable_name%3Dxxxx%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E'%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A810%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B916%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B0%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E2.%20To%20view%20current%20settings%20for%26nbsp%3Ba%26nbsp%3Bspecific%20parameter%2C%20run%20the%20following%20command%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3A%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A540%2C%26quot%3B335559738%26quot%3B%3A120%2C%26quot%3B335559739%26quot%3B%3A120%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ESELECT%20*%20FROM%26nbsp%3Bglobal_variables%26nbsp%3BWHERE%26nbsp%3Bvariable_name%26nbsp%3BLIKE%20'%25xxx%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%25'%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A810%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B916%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B0%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E%3CSTRONG%3ENote%3C%2FSTRONG%3E%3A%20For%20more%26nbsp%3Binformation%20about%20configuring%26nbsp%3Bparameters%26nbsp%3Bbased%20on%20your%20workload%2C%26nbsp%3Bsee%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ethe%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fproxysql.com%2FDocumentation%2Fglobal-variables%2Fmysql-variables%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EList%20of%20MySQL%20Variables%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-505992243%22%20id%3D%22toc-hId-526992855%22%20id%3D%22toc-hId-526992855%22%20id%3D%22toc-hId-526992855%22%20id%3D%22toc-hId-526992855%22%20id%3D%22toc-hId-526992855%22%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A720%2C%26quot%3B335559739%26quot%3B%3A120%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%3CSPAN%20class%3D%22TextRun%20SCXW123940015%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW123940015%20BCX0%22%20data-ccp-parastyle%3D%22heading%201%22%3ESave%20the%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW123940015%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW123940015%20BCX0%22%20data-ccp-parastyle%3D%22heading%201%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW123940015%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW123940015%20BCX0%22%20data-ccp-parastyle%3D%22heading%201%22%3EProxySQL%20configuration%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW123940015%20BCX0%22%20data-ccp-parastyle%3D%22heading%201%22%3Echanges%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW123940015%20BCX0%22%20data-ccp-parastyle%3D%22heading%201%22%3Eto%20persist%20across%20restarts%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E1.%20To%20save%20the%20settings%20to%20runtime%26nbsp%3Bon%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ethe%20server%20hosting%20ProxySQL%2C%20run%20the%20following%20commands%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233117%26quot%3B%3Atrue%2C%26quot%3B134233118%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A540%2C%26quot%3B335559739%26quot%3B%3A40%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3Eload%26nbsp%3Bmysql%26nbsp%3Busers%20to%26nbsp%3Bruntime%3B%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3Eload%26nbsp%3Bmysql%26nbsp%3Bservers%20to%26nbsp%3Bruntime%3B%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3Eload%26nbsp%3Bmysql%26nbsp%3Bquery%20rules%20to%26nbsp%3Bruntime%3B%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3Eload%26nbsp%3Bmysql%26nbsp%3Bvariables%20to%26nbsp%3Bruntime%3B%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3Eload%20admin%20variables%20to%26nbsp%3Bruntime%3B%26nbsp%3B%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A900%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E2.%20To%20save%20the%20settings%20to%20disk%26nbsp%3Bon%20the%20server%20running%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EProxySQL%2C%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Erun%26nbsp%3Bthe%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Efollowing%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ecommands%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Esave%26nbsp%3Bmysql%26nbsp%3Busers%20to%26nbsp%3Bdisk%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A900%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Esave%26nbsp%3Bmysql%26nbsp%3Bservers%20to%26nbsp%3Bdisk%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A900%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Esave%26nbsp%3Bmysql%26nbsp%3Bquery%20rules%20to%26nbsp%3Bdisk%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A900%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Esave%26nbsp%3Bmysql%26nbsp%3Bvariables%20to%26nbsp%3Bdisk%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A900%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Esave%20admin%20variables%20to%26nbsp%3Bdisk%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A900%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-372307519%22%20id%3D%22toc-hId-393308131%22%20id%3D%22toc-hId-393308131%22%20id%3D%22toc-hId-393308131%22%20id%3D%22toc-hId-393308131%22%20id%3D%22toc-hId-393308131%22%3E%3CSPAN%20class%3D%22TextRun%20SCXW19901940%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW19901940%20BCX0%22%20data-ccp-parastyle%3D%22heading%201%22%3EVerify%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW19901940%20BCX0%22%20data-ccp-parastyle%3D%22heading%201%22%3Ethat%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW19901940%20BCX0%22%20data-ccp-parastyle%3D%22heading%201%22%3EP%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW19901940%20BCX0%22%20data-ccp-parastyle%3D%22heading%201%22%3EroxySQL%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW19901940%20BCX0%22%20data-ccp-parastyle%3D%22heading%201%22%3Eis%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW19901940%20BCX0%22%20data-ccp-parastyle%3D%22heading%201%22%3Emanaging%20opening%20connections%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22EOP%20SCXW19901940%20BCX0%22%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559738%26quot%3B%3A160%2C%26quot%3B335559739%26quot%3B%3A40%2C%26quot%3B335559740%26quot%3B%3A240%7D%22%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3EAfter%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3Esuccessfully%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3Ecompleting%20the%20above%20steps%2C%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3Eyou%E2%80%99ve%20configured%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3EProxySQL%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3Eas%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3Ea%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3Econnection%20pool%20to%20manage%20all%20the%20short%20live%20sessions.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3ETo%20test%20the%20functionality%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3Eby%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3Edetermin%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3Eing%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3Eif%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3EIO%20requests%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eare%20being%20forwarded%20properly%3C%2FSPAN%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3E%2C%20perform%20the%20following%20steps%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22TextRun%20SCXW137504372%20BCX0%22%20data-contrast%3D%22none%22%3E%3CSPAN%20class%3D%22NormalTextRun%20SCXW137504372%20BCX0%22%3E.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E1.%20Sign%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ein%20to%26nbsp%3Bthe%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eserver%20running%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EProxySQL%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eusing%20the%26nbsp%3BProxySQL%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Euser%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eyou%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ecreated.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Emysql%26nbsp%3B-h127.0.0.1%20-u%3CAZUREMYSQLUSERNAME%3E%26nbsp%3B-p%3CPASSWORD%3E%26nbsp%3B-P6033%3C%2FPASSWORD%3E%3C%2FAZUREMYSQLUSERNAME%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E2.%20Run%20the%20read%20and%20write%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Equeries%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ESELECT%20*%20FROM%26nbsp%3Bmydemotable%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EUPDATE%26nbsp%3Bmydemotable%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3ESET%26nbsp%3Bmydemocolumn%3Dvalue%20WHERE%26nbsp%3Bcondition%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E3.%20To%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Everify%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ethat%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EProxySQL%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ehas%20routed%20the%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eabove%20read%20and%20write%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ecorrectly%2C%20connect%20to%20the%20ProxySQL%20administration%20interface%20with%20the%20default%20password%20%E2%80%98admin%E2%80%99.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3Emysql%26nbsp%3B-h127.0.0.1%20-uadmin%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B-%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Epadmin%26nbsp%3B-P6032%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E4.%20To%20review%20the%20query%20details%20via%20ProxySQL%2C%20run%26nbsp%3Bthe%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Efollowing%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Equery%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3ESELECT%20*%20FROM%26nbsp%3Bstats_mysql_query_digest%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3ESELECT%20*%20FROM%26nbsp%3Bstats_mysql_commands_counters%26nbsp%3BWHERE%26nbsp%3BTotal_cnt%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E5.%20To%20monitor%20connection%20usage%20in%20the%20pool%2C%26nbsp%3Brun%20the%26nbsp%3Bfollowing%26nbsp%3Bquery%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%3A%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-indent-padding-left-30px%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3ESELECT%20*%20FROM%26nbsp%3Bstats.stats_mysql_connection_pool%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A806%2C%26quot%3B335559738%26quot%3B%3A80%2C%26quot%3B335559739%26quot%3B%3A80%2C%26quot%3B335559740%26quot%3B%3A264%2C%26quot%3B469777462%26quot%3B%3A%5B916%2C1832%2C2748%2C3664%2C4580%2C5496%2C6412%2C7328%2C8244%2C9160%2C10076%2C10992%2C11908%2C12824%2C13740%2C14656%5D%2C%26quot%3B469777927%26quot%3B%3A%5B0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%2C0%5D%2C%26quot%3B469777928%26quot%3B%3A%5B1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%2C1%5D%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E6.%20Review%20the%20output%20for%20details%26nbsp%3Babout%20the%20pool%20usage%20and%20determine%20if%20there%26nbsp%3Bare%26nbsp%3Bany%20failed%20sessions%26nbsp%3Bby%20checking%20the%20items%20in%20bold%20text%20below.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3Emysql%26gt%3B%20SELECT%20*%20FROM%26nbsp%3Bstats.stats_mysql_connection_pool%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A540%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E%2B-----------%2B-------------------------------------%2B----------%2B--------%2B----------%2B----------%2B--------%2B---------%2B-------------%2B---------%2B-------------------%2B-----------------%2B-----------------%2B------------%2B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A540%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E%7C%26nbsp%3Bhostgroup%26nbsp%3B%7C%26nbsp%3Bsrv_host%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7C%26nbsp%3Bsrv_port%26nbsp%3B%7C%20status%20%7C%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3EConnUsed%26nbsp%3B%7C%26nbsp%3BConnFree%26nbsp%3B%7C%26nbsp%3BConnOK%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%7C%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3EConnERR%20%7C%26nbsp%3BMaxConnUsed%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%7C%20Queries%20%7C%26nbsp%3BQueries_GTID_sync%26nbsp%3B%7C%20Bytes_data_sent%20%7C%26nbsp%3BBytes_data_recv%26nbsp%3B%7C%26nbsp%3BLatency_us%26nbsp%3B%7C%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A540%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E%2B-----------%2B-------------------------------------%2B----------%2B--------%2B----------%2B----------%2B--------%2B---------%2B-------------%2B---------%2B-------------------%2B-----------------%2B-----------------%2B------------%2B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A540%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E%7C%201%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7C%20pfsmysql57.mysql.database.azure.com%20%7C%203306%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7C%20ONLINE%20%7C%200%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7C%200%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7C%200%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7C%200%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7C%200%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7C%200%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7C%200%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7C%200%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7C%200%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7C%20892%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7C%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A540%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E%2B-----------%2B-------------------------------------%2B----------%2B--------%2B----------%2B----------%2B--------%2B---------%2B-------------%2B---------%2B-------------------%2B-----------------%2B-----------------%2B------------%2B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A540%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3E1%20row%20in%20set%20(0.01%20sec)%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233279%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559685%26quot%3B%3A540%2C%26quot%3B335559739%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20aria-level%3D%221%22%20id%3D%22toc-hId--1435146944%22%20id%3D%22toc-hId--1414146332%22%20id%3D%22toc-hId--1414146332%22%20id%3D%22toc-hId--1414146332%22%20id%3D%22toc-hId--1414146332%22%20id%3D%22toc-hId--1414146332%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EConclusion%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EProxySQL%20is%20a%20great%20lightweight%20load%20balancer%20proxy%20that%20can%20improve%20your%20application%20performance%20and%20scalability%20with%20MySQL.%20It%20helps%20with%20improved%20connection%20management%2C%20reduced%20latency%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3Band%20transparent%20read%2Fwrite%20load%20balancing%20across%26nbsp%3Breplicas%20running%26nbsp%3BAzure%20Database%20for%20MySQL%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E-%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EFlexible%26nbsp%3BServer.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EFor%20more%20detailed%20configuration%26nbsp%3Binformation%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Esee%20the%20ProxySQL%20official%20site%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%3A%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233117%26quot%3B%3Atrue%2C%26quot%3B134233118%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fproxysql.com%2Fdocumentation%2Fgetting-started%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Ehttps%3A%2F%2Fproxysql.com%2Fdocumentation%2Fgetting-started%2F%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233117%26quot%3B%3Atrue%2C%26quot%3B134233118%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A120%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22none%22%3EIf%20you%20have%20any%20feedback%20or%20questions%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eabout%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eusing%26nbsp%3Bthe%20architecture%26nbsp%3Bdescribed%26nbsp%3Babove%2C%20please%20leave%20a%20comment%20below%20or%20email%20us%20at%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22mailto%3AAskAzureDBforMySQL%40service.microsoft.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EAskAzureDBforMySQL%40service.microsoft.com%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2589350%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.proxysql.com%2F%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%20target%3D%22_blank%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EProxySQL%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22none%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eis%20a%20high-performance%20MySQL%20proxy%20that%20enables%20developers%20to%20distribute%20queries%20across%20multiple%20MySQL%20servers%20to%20balance%20the%20load%20more%20efficiently.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThis%20blog%20post%20provides%20the%20steps%20required%20to%20set%20up%20ProxySQL%20with%20Azure%20Database%20for%20MySQL%20-%20Flexible%20Server.%20You%20can%20use%20this%20functionality%20for%20connection%20pooling%20or%20splitting%20the%20read%20and%20write%20workloads%20across%20Azure%20Database%20for%20MySQL%20Flexible%20read%20replicas.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B134233117%26quot%3B%3Atrue%2C%26quot%3B134233118%26quot%3B%3Atrue%2C%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A120%2C%26quot%3B335559740%26quot%3B%3A264%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22ziling_0-1627354413591.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298543iE935CB8EDADB479F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22ziling_0-1627354413591.png%22%20alt%3D%22ziling_0-1627354413591.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2674904%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20up%20ProxySQL%20as%20a%20connection%20pool%20for%20Azure%20Database%20for%20MySQL%20-%20Flexible%20Server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2674904%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3Bwe%20are%20having%20or%20wordpress%20application%20hosted%20on%20azure%20app%20servie%20and%20we%20are%20using%20Azure%20mysql%20read%20replicas%20to%20handle%20heavy%20workloads.%20we%20are%20trying%20to%20distribute%20our%20read%20and%20write%20workloads%20sing%20a%20proxysql%20server%20implemented%20in%20a%20vm%20now%20my%20questin%20is%20how%20can%20I%20connect%20my%20appservice%20to%20vm....or%20is%20it%20just%20giving%20the%20master%20string%20connection%20with%20above%20username%20to%20appservice%20is%20enough%20for%20my%20proysql%20to%20route%20traffic%20for%20read%20and%20write%20reqest.pls%20help%20me%20with%20this.%20Thanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2748213%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20up%20ProxySQL%20as%20a%20connection%20pool%20for%20Azure%20Database%20for%20MySQL%20-%20Flexible%20Server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2748213%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1135055%22%20target%3D%22_blank%22%3E%40h_e_m_a%3C%2FA%3E%26nbsp%3Bsorry%20for%20late%20response%20as%20I%20just%20saw%20your%20update%20now.%20From%20app%20service%20side%2C%20we%20should%20configure%20the%20connection%20string%20of%20proxysql%20instead%20of%20mysql%20server%20as%20bellow%3A%3C%2FP%3E%0A%3CPRE%3Emysql%26nbsp%3B-uproxysql%26nbsp%3B-pproxysql%26nbsp%3B-h%26nbsp%3BproxysqlHostIP%26nbsp%3B-P%26nbsp%3B6033%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Jul 27 2021 08:00 PM
Updated by:
www.000webhost.com