73 questions
0
votes
0
answers
23
views
laravel application with proxysql and mysql8 say NO_AUTO_CREATE_USER [duplicate]
I have mysql group replication and proxysql, now when I connect multiple laravel projects with proxysql they all say SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't ...
0
votes
1
answer
95
views
Does the initial hostgroup_id assignment in ProxySQL (writer_hostgroup vs. reader_hostgroup) affect Galera load balancing?
Let's say we have three Galera nodes:
172.17.0.2
172.17.0.3
172.17.0.4
and we will have the following hostgroups:
writer_hostgroup=0
reader_hostgroup=1
backup_writer_hostgroup=2
offline_hostgroup=4
...
- 3,678
0
votes
0
answers
52
views
Handling Replication Lag with ProxySQL in a Spring Boot Application using MySQL InnoDB
I am working on a Spring Boot application using MySQL 8.0.39 with InnoDB and ProxySQL for load balancing between a master and a slave MySQL server. The database is configured to split read and write ...
- 1
0
votes
0
answers
17
views
ProxySQL can’t connect to XtraDB
I can connect directly from the server where proxysql is deployed to xtraDB, but cannot connect to xtraDB via proxysql.
my proxysql conf
I can connect directly from the server where proxysql is ...
- 1
1
vote
0
answers
83
views
Issue with Proxysql 2.6 and caching_sha2_password plugin with Percona 8 MySQL cluster
I'm struggiling since 4 days with a strange issue with my ProxySQL+MySQL cluster. I've attached all information that seems relevant to me. I read documentation about how to
import '...
- 44
0
votes
1
answer
129
views
ProxySQL to connect to multiple Mysql clusters
I need to integrate Teleport with our existing MySQL instances. We operate multiple group replication clusters, but integrating them with Teleport proves challenging as it requires SSL, which I'm ...
1
vote
0
answers
102
views
Difficulty configuring ProxySQL for sharding MySQL based on ID field
I am currently evaluating ProxySQL for sharding MySQL databases. In my Proof of Concept (POC), I aim to shard data based on the ID field. Specifically, I want odd IDs to be routed to host_group1 (...
- 2,740
0
votes
1
answer
485
views
Is it good for applying connection pool on both application and proxy tier?
I'm having a Galera Mysql cluster and ProxySQL on top of this cluster. ProxySQL has connection pool mechanism itself.
My question is, should I apply connection pool on application (.net, springboot,......
- 421
0
votes
1
answer
126
views
How to connect proxySQL cluster
We are planning to setup a three node proxysql cluster with five mysql backend nodes. But how the application will connect to proxysql servers?
I have completed the setup and stuck how to use the ...
1
vote
2
answers
234
views
Regex to capture multiple element
I was writting a regex to capture the mysql query execute in proxysql.
my expectation of the regex will capture the following commend where email, password, or both of them appear together:
SELECT ...
- 13
1
vote
1
answer
135
views
maxscale rewrite filter with awk
The following rewrite rule works as expected:
%%
regex_grammar: Awk
case_sensitive: false
ignore_whitespace: true
%
SELECT msg FROM mytable WHERE id = 123
%
SELECT msg FROM mytable WHERE id = sha1(123)...
- 55
0
votes
2
answers
2k
views
ProxySQL user is not authenticated by MySQL
I have a container for ProxySQL 2.2.4 and another for MySQL 8.0.31. Both containers are using same network name. So from ProxySQL container I can access MySQL running in another container.
Even, ...
1
vote
1
answer
591
views
Proxysql how do i perform a health check on GCLOUD
I am new to Proxysql and have created a docker file for the Gcloud instance group following is the configration of Docker.file
FROM debian:11
MAINTAINER Hitesh Sidhiyta <[email protected]>
...
- 48
0
votes
1
answer
179
views
What is Mysql/Maria "appication info" or "client identification" - and how not to send it with mysqldump?
There is a mariadb behind a ProxySQL that I am trying to connect to.
When using "debugging tools" like IntelliJ's Database plugin or DBeaver, it only works when we disable "sending ...
- 890
0
votes
1
answer
1k
views
ProxySQL vs MaxScale on Kubernetes
I'm looking to set up a writing proxy for our MariaDB database on Kubernetes. The problem we are currently having is that we only have one Write master on our 3 master galera cluster setup. So even ...
