Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [proxysql]

24 questions
6
votes
5 answers

How to easily bring 80 MySQL users into ProxySQL?

I am setting up ProxySQL in front of a Percona MySQL server with 88 user accounts. I don't even know most of their passwords. Passwords are stored in MySQL as hashes but are stored in ProxySQL in plain text. How can I easily bring in all 88…
IcarusNM
  • 591
  • 1
  • 4
  • 11
3
votes
2 answers

How to avoid replication lag in case all writes on master and reads on replica?

I have stuck with the replication lag problem. I am trying to refactor my DB infrastructure. The first step was read-write split. I used ProxySQL то implement it. Now I have masterDb where all INSERT and UPDATES executing and 2 replicas where I…
Volodymyr Bilovus
  • 133
  • 1
  • 5
2
votes
1 answer

Stategies for scaling out MySQL/MariaDB when database gets too large for a single host?

What are your strategies when a MySQL/MariaDB database server grows to have too much traffic for a single host to handle, i.e. scaling CPU/RAM is not an option anymore? Do you deploy ProxySQL to start splitting the traffic according to some rule to…
Otto
  • 444
  • 10
2
votes
1 answer

Setup proxysql read-write split with both galera cluster and master slave replication

I have the following setup: Three node galera cluster (galera-1, galera-2, galera-3) galera-2 is master to slave-1 (master-slave replication) slave-1 is master to both slave-2 and slave-3 slave-1, slave-2 and slave-3 have read_only = 1 I have the…
supercoco
  • 131
  • 4
2
votes
2 answers

Mysql: Is it possible to handle 1000 concurrent while having low cpu?

We're running Centos 7, we're in the process Mariadb 5.5, upgrading to 10.3 today. PHP 5. The queries are bad, and there are far too many of them to optimize, but I'm trying what I can, the database structure is bad. The client doesn't care about…
Lynob
  • 159
  • 1
  • 8
2
votes
1 answer

ProxySQL equivalent of MaxScale schemarouter

background My employer developed a web application we provide on software-as-a-service terms to our customers. To allow for multiple customers with a huge mass of data to be stored in a database, we chose to let the application create a schema per…
Phillip -Zyan K Lee- Stockmann
  • 75
  • 8
1
vote
1 answer

mysql client auto reconnect in case of ERROR 2013

I'm searching for a way how to instruct mysql client to reconnect in case of ERROR 2013. I'm testing PXC with ProxySQL and want to keep sql statements flowing from the client in case when the writer node get killed and new one is promoted. Is it…
Sevak
  • 11
  • 3
1
vote
1 answer

MySQL replication and ProxySQL

I just came across ProxySQL. I have one simple question, if I were to use ProxySQL, do I still need to set up Replication(master-slave) first for MySQL server? Because there is hostgroup(0,1) in ProxySQL which to determine which MySQL server master…
kleorence baker
  • 11
  • 2
1
vote
0 answers

MHA vs Orchestrator

Im going to setup an HA solution. Im planning to use Orchestrator. But seems MHA is also doing well. If anyone already used/using any one these solutions, please suggest me to choose a right one with the following requirements. Fastest…
TheDataGuy
  • 1,986
  • 5
  • 36
  • 67
1
vote
2 answers

ProxySQL user not connecting - XtraDB

I'm trying to set up a xtraDB Cluster consisting of 3 nodes. Now i've got the cluster up and running and per the instructions i'm trying to set up ProxySQL for load balancing. So i've installed proxySQL on all 3 nodes. And now i'm trying to…
Jdeboer
  • 51
  • 4
0
votes
1 answer

Memory Fragmentation in Primary MariaDB 10.6.18 with ProxySQL 2.5.5

Hello Community Members, We have recently migrated our DB server to Azure from Onprem, and we are struggling with memory fragmentation in MariaDB Database. DB is consuming more than 2 times of buffer pool memory allocated. We see this fragmentation…
Gopinath Karangula
  • 933
  • 2
  • 10
  • 21
0
votes
0 answers

MySQL randomly inserts a string as decimal into varchar column

We have encountered rather weird behavior which is very hard to reproduce. When inserting specific strings that resemble scientific notation into a varchar column, it would be inserted as 65 of 9 which would indicate an overflow, meaning, that our…
Igor Yavych
  • 97
  • 1
0
votes
0 answers

Moving data between old mysql and new proxySQL with 3 mysql nodes

I have old data in single mysql database (~700GB), and want to move to ProxySQL with 3 mysql nodes - separate 2 big big tables on node 2 and 3, while rest of data on node 1. I readed how to do this by simply mysqldump, but I have lack of disk space,…
Mariusz Koniarz
  • 1
0
votes
1 answer

MySQL Master Slave Asynchronous GTID Replication Failover/Switchover over ProxySQL with little downtime

This is a production setup and I have to perform a failover from Master A to new potential master B. MySQL Version is 5.7 and CentOS 7 is the OS. I have a simple master slave setup with A as Master and B,C,D,E,F as async slaves. ProxySQL Cluster is…
Avinash Pawar
  • 216
  • 2
  • 11
0
votes
1 answer

Unable to find variable : mysql-monitor_username in global_variables table in information_schema database in MySQL

I am trying to perform the initial configuration in proxysql and I found that while doing the Configure monitoring, I am unable to find the variable mysql-monitor_username in the global_variables table. The article says that we need to execute the…
msbeast
  • 21
  • 4
1
2