Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mysql-proxy]

MySQL Proxy : Open-source project for MySQL query manipulation and redirection.

MySQL Proxy is an open-source program that sits between your client and MySQL server(s) that can monitor, analyze, transform and/or redirect communication of queries.

LUA scripts have been provided for encourage development and contribution of code for connections pooling and advancement query routing.

8 questions
3
votes
1 answer

MySQL proxy and SHOW PROCESSLIST query time

I have MySQL replication currently occurring between two masters bidirectionally, one in a data center locally, another over at Amazon EC2. Everything seems to function normally replication wise, no issues per se, except for the occasional query…
Mark D
  • 1,140
  • 4
  • 16
  • 28
3
votes
2 answers

What's the latest on MySQL Proxy?

Does somebody here know the latest state of the development of MySQL Proxy? Most materials I found on web are outdated.
bettersayhello
  • 201
  • 2
  • 6
3
votes
1 answer

Cache query that is not stored in QueryCache

One of our customers has an online-shop running xt-commerce 4.2. This version of the e-commerce-software has a very expensive query for the category-tree. The query adds about 3 seconds delay and is executed on every page request. Since the software…
Martin Seitl
  • 161
  • 8
2
votes
1 answer

Distribute records on different MySQL databases - MySQL Proxy alternative

My scenario is the following: Right now I am using one big MySQL database with multiple tables to store user data. Many tables contain auto increment columns. I would like to split this into 2 or more databases. The distribution should be done by…
horen
  • 129
  • 3
2
votes
2 answers

MySQL proxy to replication configuration

Is there any solution (say a proxy) that makes MySQL replication cluster behave like one database towards developers? Developers then won't need to worry about using master to write and slaves to read etc.?
Sławosz
  • 121
  • 4
1
vote
1 answer

MySQL Proxy no longer working noticed when backend MySQL at version 5.7.43-47-log

When developing data analytical applications, the workstation needs to use MySQL-Proxy (version 0.8) to connect to the MySQL data source. This method has been working fine for years, however, we recently noticed that the connection is no longer…
Mike
  • 57
  • 4
1
vote
1 answer

Forcing a LIMIT to MySQL Queries using ProxySQL, QueryRewrite, or some other method

I have a system that end users will need to query but they are not guaranteed to be well versed in query writing. We wanted to ensure every SELECT statement ends with a LIMIT 100000. I have thought of some regex to do this and some tools. It…
Ali Razeghi - AWS
  • 7,566
  • 1
  • 26
  • 38
0
votes
1 answer

mysql/mariadb replication with proxy

I have a standard master-slave replication for MariaDB to sync one database (master) to multiple slaves. One of the slaves lives behind a proxy, so I need to proxy the replication request to the proxy and from the proxy to the master. Can I use the…
userk23r
  • 11
  • 2