Questions tagged [mysql-proxy]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
95 views

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 ...
3
votes
1answer
159 views

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 ...
1
vote
1answer
2k views

Maxscale read write split and route filter

I have trouble to forward all SELECT requests to the slave in a MySQL master-slave architecture. I'm using maxscale's read-write router, which does its job except for all statements using ...
2
votes
1answer
455 views

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 ...
2
votes
2answers
1k views

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 ...
3
votes
2answers
432 views

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.
3
votes
1answer
707 views

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 ...