MaxScale is a Proxy for the MySQL protocol built with a modular architecture. The underlying concept of modules allows to extend the MaxScale proxy services. The current version implements Read Write splitting and Connection Load Balancing. Internally MySQL queries go through a SQL parsing phase. This gives MaxScale great capabilities regarding queries routing.
So if [...]
At FOSDEM 2014 ProxySQL and MaxScale were both presented. Both are proxy that can help build sophisticated MariaDB/MySQL architectures. But currently what is the most used proxy with MySQL? It is HAproxy. HAproxy is a level 4 proxy that has no knowledge of the MySQL protocol. Being low level makes it very fast but it [...]
Back in January 2010, I wrote an article titled Proxy Trace : Tracing the Variables and Functions Available within MySQL Proxy.
That post was basically a lua script I posted which traces the steps of Proxy, outputting comments as it traverses through the various functions, and then outputs the names and values of [most of] the available variables available within Proxy.
That script worked fine with Proxy 0.7.2 and 0.8.0. It also works just fine with Proxy 0.8.1 (though you need to specify your admin settings in 0.8.1) and 0.8.2 (admin values not necessary).
However, I did go ahead and build it out a little further.
I did not add too much, but I did add the following (the full script, trace.lua, is provided at the end of this post):
This post is not technical!
Who knows me, knows that I am not a nasty person.
I try to be polite and politically correct, and that has being a problem for me several times, because it pays only in long term.
But to day I need to talk about MySQL-Proxy so I can say something not pleasant for someone.
I have found myself in trouble several time because MySQL-Proxy
for stability reasons and performance issues, but a part from
that it normally works as expected.
Is really up to you and how you uses normally if you will get in
trouble or not.
But ... hey MySQL-Proxy is an ALPHA product, oh my!!
It is an ALPHA not even BETA or RC, more reading the
documentation TODAY:
"This documentation covers MySQL Proxy
0.8.0.
Warning
MySQL Proxy is …
[Read more]I’ve seen some interest in trying to get LuaSocket working with MySQL Proxy, and most of those interested have run into issues getting this set up, so I want to provide a brief walk-through on how to get this set-up and working properly.
Note I tested this on Windows, so use .so instead of .dll on *nix systems.
1. Download LuaSocket (contains lua/ and lib/ directories)
2. Copy contents of ‘lua/’ into the following directory:
C:Program FilesMySQLmysql-proxy-0.8.0libmysql-proxylua
3. Copy contents of ‘lib/’ into the following directory:
C:Program FilesMySQLmysql-proxy-0.8.0bin
4. In step #3, you should have copied a ‘socket/’ and ‘mime/’ directories into bin/. Rename the directory named “socket” to “lua-socket”. This will get you past one set of errors.
5. Next, in the C:Program …
[Read more]It's often not desirable to expose your Drupal server directly to the end users. This document describes how to “hide” a Drupal server behind a reverse proxy server. This is typically done for a number of reasons:
protection: the topology of the server, the database server can be hidden from the front end
caching: The proxy server take away load from the backend system through caching
flexibility: the topology behind the reverse proxy can be changed more easily
scalability: the proxy server can be used for future load balancing
The technical problem isn't new. It has been solved before. I had however problems finding a solution in a single document.
The configuration is basically a platform neutral AMP stack …
[Read more]
I have a talk scheduled tonight, for anyone who's in the Southern
New Hampshire area (or greater Northern New England area):
http://permalink.gmane.org/gmane.org.user-groups.linux.gnhlug.announce/743
I'll be going over a number of things, time permitting:
* memcached (in general)
* NorthScale's memcached Amazon Machine Images and Virtual
Appliance
* moxi - memcached proxy
* memcached Functions for MySQL
I'll run a couple demonstrations with each, first simple
memcached usage, then using two memcached instances through moxi,
then I'll throw in using them with the UDFs.
I intend to see if the Boston MySQL Users Group would be
interested in this talk soon as well.
The following just went out to our mailing list:
We are happy to announce that MySQL Proxy 0.7.2 is available in a source and binary release for all of our target platforms.
This latest release also brings back Windows support in both the source and binary release.
The list of important changes in this release is:
* fixed memory leak proxy plugin (#45272)
* fixed ro-balance.lua (#45408)
* added CMake build files
* fixed portability issues for Win32
* added mysql-proxy-svc on Win32
* updated INSTALL file to cover all the build steps on win32
Please report any problems on bugs.mysql.com, our Launchpad discussion mailing list or on IRC: …
[Read more]The following just went out to our mailing list:
We are happy to announce that MySQL Proxy 0.7.2 is available in a source and binary release for all of our target platforms.
This latest release also brings back Windows support in both the source and binary release.
The list of important changes in this release is:
\* fixed memory leak proxy plugin (#45272)
\* fixed ro-balance.lua (#45408)
\* added CMake build files
\* fixed portability issues for Win32
\* added mysql-proxy-svc on Win32
\* updated INSTALL file to cover all the build steps on win32
Please report any problems on bugs.mysql.com, our Launchpad discussion mailing list or on IRC: …
[Read more]The following just went out to our mailing list:
We are happy to announce that MySQL Proxy 0.7.2 is available in a source and binary release for all of our target platforms.
This latest release also brings back Windows support in both the source and binary release.
The list of important changes in this release is:
\* fixed memory leak proxy plugin (#45272)
\* fixed ro-balance.lua (#45408)
\* added CMake build files
\* fixed portability issues for Win32
\* added mysql-proxy-svc on Win32
\* updated INSTALL file to cover all the build steps on win32
Please report any problems on bugs.mysql.com, our Launchpad discussion mailing list or on IRC: …
[Read more]