Stack Overflow
Stack Overflow

Questions tagged [mysql-proxy]

MySQL Proxy is a simple program that sits between the client and MySQL server that can monitor, analyze or transform their communication. It is used mainly for load balancing, failover and query analysis.

Useful Links

71 questions
0
votes
0 answers

Mock Server from MySQL Installation

I see there is a mock mysql functionality out of the box from mysql installation and it is documented here It involves, setting up a mock tcp port with binary called ./mysql_server_mock but I couldn't find this in my installation. I installed MySQL…
Mail
  • 314
  • 1
  • 2
  • 9
0
votes
0 answers

Proxying and Rewriting MySQL Queries

I am trying to use MySQL-Proxy to achieve the following use case. Client connects to MySQL proxy server port, fires query A. MySQL Proxy port listens to this, replaces query A with B and returns result of B to client. As I see from the doc, I have…
Mail
  • 314
  • 1
  • 2
  • 9
0
votes
0 answers

How to compare query with string in lua scripting?

I have created a Mysql-proxy using lua scripting. For some particular query, i want to override the resultset with some other data. But while comparing query with string, it is showing false while print in console have same value. Please check the…
Rohit
  • 406
  • 1
  • 5
  • 21
0
votes
1 answer

How to connect to a web service that returns JSON in LUA

I am beginner in LUA. I have written the following code in lua file that mysql proxy run with it. function read_query(packet) if string.byte(packet) == proxy.COM_QUERY then local command = string.lower(packet) if…
Vickie Jack
  • 95
  • 1
  • 10
0
votes
2 answers

how to Download MySQL-Proxy in linux 16.04 (LTS)

I'm running Ubuntu 16.04 LTS and I want to use Mysql-proxy.I want to download mysql-proxy by terminal with instruction and I have a ubuntu 16.04. Any suggestions???
Raf
  • 1
  • 5
0
votes
2 answers

Redirect all the mysql requests to other DB server

I have a staging server on AWS where my web application is running.the application uses Dedicated Database server(mysql/linux) from other provider. i would like to spin a new server on a AWS that should act like a proxy server to connect with my…
stan06
  • 11
  • 1
0
votes
0 answers

How can the proxy address be made as the ONLY point of access to MySQL server for specific user?

As we know mysql-proxy can be used as make a proxy address for MySQL server and also to change any query or results using lua script. My question is how can I make the proxy address as the ONLY point of access to MySQL server and so if a client…
Majid NK
  • 311
  • 1
  • 3
  • 16
0
votes
1 answer

Expiring memcached using mysql proxy when an update occurs?

I have mysql Proxy running which takes a query, performs an md5 on it, and caches the result into a memcached DB. the problem occurs when an update happens in the rails app that would invalidate that cache. Any ideas on how to invalidate all of the…
tesserakt
  • 3,231
  • 4
  • 27
  • 40
0
votes
2 answers

Error proxy : Redirection of MySQL queries

I want to redirect MySQL queries destinated to a server (ex:192.168.1.1) to another server (ex:192.168.1.2) I use MySQL proxy V0.8.5 on the first server (192.168.1.1) and tried the following command mysql-proxy --proxy-address=192.168.1.1:3306…
Atnaize
  • 1,766
  • 5
  • 25
  • 54
0
votes
0 answers

COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'latin1'

I've had a look at the other answers, and none of them solve this. We have a website running through mysql-proxy to the 2 mariadb servers. all the tables are encoded using utf8_unicode_ci, but when the web-app tries to do a query, it throws this…
Martin McInnes
  • 1
  • 2
  • 3
0
votes
0 answers

meaning of 'return proxy.PROXY_IGNORE_RESULT' in connect_server() hook

I am trying to implement connection pooling(many clients are served by few db connections) with mysql-proxy. I took a look at ro-pooling.lua and it seems that some actions must be done in connect_server() hook. If I want to create a new…
JustasM
  • 1
  • 1
0
votes
1 answer

Unable to compile mysql-proxy into an rpm

I am trying to compile and package mysql-proxy-0.8.4.tar.gz into rpm. I followed the instructions to build [root@localhost mysql-proxy]# rpmbuild -ta --clean mysql-proxy-0.8.4.tar.gz I get this error checking which pkg-config file to use to find…
Santhosh
  • 891
  • 3
  • 12
  • 31
0
votes
1 answer

Storing the logged queries into mysql client

The client system i am using is (192.168.YY.YY) and the backend address i have mentioned in mysql-proxy is (192.168.XX.XX).I use the following LuaScript to log the queries using mysql-proxy function read_query( packet ) b={} j=1 if…
robin
  • 19
  • 1
  • 10
0
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
  • 11,184
  • 11
  • 71
  • 113
0
votes
0 answers

google cloud compute load balancer 504 error

I have the following setup. 2 x gce n1.standard instances running nginx/php5-fpm 1 x cloud SQL d8 instance with both GCE instances connected to it. The front end servers are running a stripped down version of osCommerce-2.3.3.4 with NO admin…
Justin W. Johns
  • 119
  • 1
  • 8
1 2 3
4
5