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

MySQL-proxy load-balancer issues

I tried to configure mysql-proxy 0.8.2. There are two hosts behind it: M1 (10.10.10.1) and M2 (10.10.10.2). There is a MySQL replication between M1 and M2. M1 is master, M2 is slave. All request what type is "write", forwarding to M1 correctly and…
user218547
  • 71
  • 1
  • 6
3
votes
2 answers

how to setup and configure mysql-proxy on ubuntu on amazon ec2

i am trying to setup mysql-proxy on ubuntu on amazon ec2 i have done following: sudo apt-get install mysql-proxy --yes vi /etc/default/mysql-proxy i put following content on…
user3011768
  • 191
  • 2
  • 3
  • 11
2
votes
1 answer

mysql-proxy for a remote MySQL server

My program works with a remote MySQL server, and I want to create a local proxy server on my computer in order to make things faster (pool connections, cache queries etc.). I went by the documentation:…
Erel Segal-Halevi
  • 33,955
  • 36
  • 114
  • 183
2
votes
1 answer

Mysql-Proxy Doesn't Failover (?)

This is the first time I am using mysql-proxy and I am experiencing the weird behavior I was wondering if the community has tackled it before. I have mysql-proxy (0.8.2) running on amazon linux (in ec2) connected to 2 mysql servers. My java client…
A.RG
  • 21
  • 2
2
votes
1 answer

Google API Insufficient authentication scope for MySQL proxy on Google Cloud

I am having a problem starting proxy for Google SQL. I installed proxy like this: $ wget https://dl.google.com/cloudsql/cloud_sql_proxy.linux.amd64 $ mv cloud_sql_proxy.linux.amd64 cloud_sql_proxy $ chmod +x cloud_sql_proxy $ sudo mkdir…
John-no1
  • 61
  • 4
2
votes
1 answer

mysql proxy r/w replication and temporary tables

I am doing master/slave replication on MySQL5.1 and r/w split with mysql proxy 0.8.x It works fine except with temporary tables. MySQL throws an error, that the temporary table is not existent. This is the query log for the master server: …
merlin
  • 2,717
  • 3
  • 29
  • 59
2
votes
1 answer

Best implementation for MySQL replication with Rails 3?

We're looking at potentially setting up replication for our primary MySQL database, and while setting up the replication seems pretty straight-forward, the application implementation seems a bit murkier. My first idea would be to set up a…
vonconrad
  • 25,227
  • 7
  • 68
  • 69
2
votes
2 answers

MySQL failover using MySQL Proxy

I'm looking at implementing a failover mechanism for a MySQL database using MySQL Proxy (http://forge.mysql.com/wiki/MySQL_Proxy) My proposed setup is as follows: One active MySQL server and one passive MySQL with two way replication enabled between…
Nikhil Kashyap
  • 1,049
  • 2
  • 11
  • 15
2
votes
1 answer

Ruby on rails and a replicated MySQL instance

[Disclaimer: I'm wearing my devops hat, which isn't even my full-time hat. I don't have a RoR hat, I just do my best.] I have a RoR application that runs in several data centres. MySQL lets me replicate my data to all the DC's, but only one…
jma
  • 3,580
  • 6
  • 40
  • 60
2
votes
1 answer

HAProxy/MySQL Proxy/ Mysql Router Master-slave replication; read-wirte splitting strategy

We have MySQL MASTER-SLAVE Replication (1 Master and 1 Slave) setup and everything is working fine. Currently all load (reads/writes) are going to MASTER server. Now we want all writes to be redirected to only Master server and reads to be…
Navrattan Yadav
  • 1,993
  • 1
  • 17
  • 22
2
votes
2 answers

Is it possible to use mysql proxy for query processing in front of microsoft sql server?

I want to use mysql proxy for processing queries trying to execute. I want to make this process available for all databases like mysql, ms sql server, oracle and ... is it possible to use mysql proxy as base engine and connect these database from…
JGC
  • 12,737
  • 9
  • 35
  • 57
2
votes
2 answers

What are the alternate solution(s) for Load-balancing in MySQL database server

Are there any better choices other than using MySQL-proxy to perform Load-balancing in actual database servers? MySQL-proxy is in its alpha edition. So I think this solution is not enough tested.
Snehasish Sarkar
  • 134
  • 10
2
votes
0 answers

mysql-proxy not running lua script

I know there are many mysql-proxy questions on SO, however I have read through many of them and none seem to solve my problem. I am simply trying to get mysql-proxy up and running, with the eventual purpose of rewriting some queries that go through…
almel
  • 7,178
  • 13
  • 45
  • 58
2
votes
2 answers

How to use mysql proxy with python

How to write script in python to trace queries with MySQL Proxy. I have tried to get the information about this but I could not find any thing regarding python,please help me out any body to write a script in python for tacking queries with mysql…
neotam
  • 2,611
  • 1
  • 31
  • 53
2
votes
2 answers

Redis as a MySQL engine?

Are there any existing efforts which fake a Redis server as a special type of MySQL engine? For example: CREATE TABLE key_value_pairs ( id INT, name VARCHAR(30), VALUE VARCHAR(200) ) ENGINE = REDIS; So data could be directly JOIN'ed…
est
  • 11,429
  • 14
  • 70
  • 118
1
2
3 4 5