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
1
vote
2 answers

Setting up multiple MySQL databases with scalability options

I need to set up a MySQL environment that will support adding many unique databases over time (thousands, actually). I assume that at some point I will need to start adding MySQL servers, and would like my environment to be prepared for the case…
Omer
  • 582
  • 3
  • 14
  • 24
1
vote
1 answer

MySql replication failover on Amazon Cloud

I have configured a MySql Replication with 1 Master 1 Standy and 1 Slave. Master and Standby are put on different availability zones on US East region and the Slave is on the US West region. Both Standby and Slave are replicating from the…
Khoa Nguyen
  • 1,056
  • 2
  • 12
  • 20
1
vote
5 answers

Setting up database sharding - no cross-database queries

I'm developing a web application in which, for each client (a small-large organization), they do not (and should not) be able to query into other client's records. Keeping the data in a single database would be easy and make updating and maintenance…
nogridbag
  • 3,521
  • 4
  • 38
  • 51
1
vote
0 answers

MySQL Proxy with NodeJS

I am trying to create a simple program that create a proxy between a MySQL-based application and a MySQL server. Right now,my approach is to change the application to talk to MySQL at port 3065 and my proxy is a simple socket server whose listens…
Yosi
  • 2,936
  • 7
  • 39
  • 64
1
vote
1 answer

Does maxscale (with Galera) handle Non-primary component/node condition automatically?

We are going to use maxscale as a sql proxy with our mariadb database, with Galera cluster. In Galera cluster, when quorum is not achieved and split-brain condition happens, some node becomes Non-primary. The Non-primary nodes start rejecting…
Anup_Tripathi
  • 2,817
  • 3
  • 26
  • 37
1
vote
1 answer

MemSQL: client-side prepare statement by libmysql.dll

Can someone tell me if "libmysql"dll" exists with a "client-side prepared statements"? https://docs.memsql.com/concepts/v6.5/prepared-statements/ in the documentation I see that "server-side prepared statements" are not supported by MemSQL What if I…
Source
  • 21
  • 1
1
vote
1 answer

Using MySQLProxy with Sphinx

Is there relatively easy way to insert into Sphinx distributed index using MySQL proxy? E.g. you connect to MySQL proxy and send something like: insert into my_ft_index values(1000, 'harry potter'); then MySQLProxy somehow calculate the hash of…
Nick
  • 9,962
  • 4
  • 42
  • 80
1
vote
0 answers

How to efficiently invalidate cache?

I’ve been trying to optimize for performance one behemoth software based on php and mysql. I have gone through caching in Apache and indexes in MySQL but it is not enough. Since all forms within this software are built and printed dynamically from…
Artur Kedzior
  • 3,994
  • 1
  • 36
  • 58
1
vote
3 answers

MySQL proxy redirect Read/Write

We have a system where we have a Master / Multiple Slaves . Currently everything happens on the Master and the slaves are just here for backup . We use Codeigniter as a development platform . Now we decided to user the slaves for the Reads and the…
Tarek
  • 3,810
  • 3
  • 36
  • 62
1
vote
1 answer

Lua script to stop firing a query in mysql via mysql proxy

I am a beginner to lua language.The main concept is when a user fire the DROP TABLE command in mysql it should not be executed.But he can fire all other commands as usual in mysql.But i don't want to use GRANTS for this.Is there any luaScript to…
robin
  • 19
  • 1
  • 10
1
vote
0 answers

MySQL Proxy and Load Balancing

I just want to understand exactly how connections and queries behave with MySQL Proxy. I have two back-end servers both running identical MySQL installations, set up in a master-master config which seems to be functioning perfectly. I.e. I can…
imperium2335
  • 23,402
  • 38
  • 111
  • 190
1
vote
1 answer

mysql-proxy result field manipulation

I have a MYSQL server and MYSQL-PROXY and I am trying to manipualte the results I send to the client as a response to a SELECT query. I have writen this code in lua: function string.starts(String,Start) return…
jordi
  • 1,157
  • 1
  • 13
  • 37
0
votes
1 answer

MySQL-proxy and basic failover (detect state)

I have just installed mysql proxy 0.8.2, and started playing with it. I am using it together with two MySQL 5.5 servers, listening on 3306, the proxy is running on 4040. Oh, and OS is Win 7 32-bit. My problem is that that the mysql proxy checking…
hugo
  • 1
  • 3
0
votes
1 answer

How to execute a lua script from mysql-proxy

I am trying to execute a lua script from mysql proxy. I wrote a script called login.lua .I installed mysql-proxy successfully.I tried to invoke the command mysql-proxy --proxy-lua-script=/path/to/login.lua And then i started the mysql client and…
Anusha Pachunuri
  • 1,389
  • 4
  • 18
  • 39
0
votes
0 answers

Does mysql-router has support for lua language?

I want to write and sql query interceptor and possibly manipulate query results too. I found some documentation for mysql-proxy at http://download.nust.na/pub6/mysql/tech-resources/articles/proxy-gettingstarted.html. this gives me flexibility to…
Raju Nimbalkar
  • 1
  • 2
1 2
3
4 5