Showing entries 1 to 10 of 35
10 Older Entries »
Displaying posts with tag: MySQL Proxy (reset)
WarpSQL now has SQL shim plugins

I made some improvements to the 'proxy' inside of MySQL 5.7 that I've created for WarpSQL (Shard-Query 3).  I've made the MySQL proxy/shim pluggable and I moved the SQLClient to sql/sql_client.cc.  I've merged these changes into 'master' in my fork.

Now you can create "SQL shim" plugins (SHOW PASSWORD is implemented in plugin/sql_shim) and install them in the server like regular plugins:

-- command doesn't work
mysql> show password;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'password' at line 1

-- install the example sql_shim plugin:
mysql> install plugin sql_shim soname 'sql_shim.so';                                                                 Query OK, 0 rows affected (0.00 sec)

-- now the command works
mysql> show password;
+--+
|  |
+--+
|  |
+--+
1 row in set (0.00 sec)


[Read more]
SQL injection in the MySQL server! (of the proxy kind)

[this is a repost of my http://shardquery.com blog post, because it did not syndicate to planet.mysql.com]

As work on WarpSQL (Shard-Query 3) progresses, it has outgrown MySQL proxy.  MySQL proxy is a very useful tool, but it requires LUA scripting, and it is an external daemon that needs to be maintained.  The MySQL proxy module for Shard-Query works well, but to make WarpSQL into a real distributed transaction coordinator, moving the proxy logic inside of the server makes more sense.

The main benefit of MySQL proxy is that it allows a script to "inject" queries between the client and server, intercepting the results and possibly sending back new results to the client.  I would like similar functionality, but inside of the server.

For example, I would like to implement new SHOW commands, and these commands do not need to be …

[Read more]
Spil Games hackday: research MaxScale

Spil Games hackday At Spil Games we organise a monthly hackday (actually the last two Thursday/Friday of the month) where several teams try to hack something in limited amount of time. The only rules for the hackday are: make something cool, keep it simple, document it, learn something and have fun. In general it means time is […]

The post Spil Games hackday: research MaxScale appeared first on Spil Games Engineering.

MySQL Proxy lives – 0.8.4 alpha released

I was surprised to see that there is a 0.8.4 alpha release of MySQL Proxy released just a few days ago (it has been quiet for more than a year). Download it. Many of the bugs fixed are only referenced in an internal bug tracker according to the changelog. There are still about 83 bugs open in the public tracker. I reckon it is good news since it means its still getting some love from the Oracle MySQL team.

Related posts:

  1. MySQL 5.1.26-rc released, and developer resources thoughts
[Read more]
Added a Table of Contents

Not a big deal, but I just added a “Table of Contents” page to my blog to make finding older articles much easier.

I noticed most of my posts are quite lengthy, and it can take a bit of searching/clicking to find an older entry. So unless you happen to recall the ‘month/year’ it was published, which I don’t even remember that, then hopefully this will help.

Really simple, and looks just like this:

[Read more]
Proxy Trace Revisited with MySQL Proxy 0.8.2

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):

  • Outputs backends.type variable
  • Expanded the rows returned outputs (returns more detailed row …
[Read more]
Using MySQL Proxy 0.8.2 on Windows

If you try to start proxy 0.8.2 in Windows, and you receive this error:

The application has failed to start because its side-by-side configuration is incorrect.

Then you need to install the Microsoft Visual C++ runtime libraries (per the 0.8.2 changelogs). Here is the snippet from the changelogs (it just doesn’t mention the error):

The Microsoft Visual C++ runtime libraries are now a requirement for running MySQL Proxy. Users that do not have these libraries must download and install the Microsoft Visual C++ 2008 Service Pack 1 Redistributable Package MFC Security Update. For the current Proxy version, use the following link to obtain the package:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26368

(Bug #12836100)

[Read more]
MySQL Proxy 0.8.2 Has Been Released

We are pleased to announce the release of MySQL Proxy 0.8.2.

Downloads are available from dev.mysql.com:

http://dev.mysql.com/downloads/mysql-proxy/

0.8.2 is a maintenance release and focuses on:

  • Adding the protocol changes of MySQL 5.5 and later
  • Removing the "admin" plugin from the list of default plugins as it requires configuration since 0.8.1

Note to windows users:

The Microsoft Visual C++ runtime libraries are now a requirement for running MySQL Proxy.

Users that do not have these libraries must download and install the Microsoft Visual C++ 2008 Service Pack 1 Redistributable Package MFC Security Update.

For the current Proxy version, use the following link to obtain the package:

[Read more]
MySQL Proxy 0.8.2 Has Been Released

We are pleased to announce the release of MySQL Proxy 0.8.2.

Downloads are available from dev.mysql.com:

http://dev.mysql.com/downloads/mysql-proxy/

0.8.2 is a maintenance release and focuses on:

  • Adding the protocol changes of MySQL 5.5 and later
  • Removing the "admin" plugin from the list of default plugins as it requires configuration since 0.8.1

Note to windows users:

The Microsoft Visual C++ runtime libraries are now a requirement for running MySQL Proxy.

Users that do not have these libraries must download and install the Microsoft Visual C++ 2008 Service Pack 1 Redistributable Package MFC Security Update.

For the current Proxy version, use the following link to obtain the package:

[Read more]
mysqlnd plugins for PHP in practice

If you follow my blog or twitter stream you might know I've recently been at Barcelona to attend the PHP Barcelona conference. Conferences are great for exchanging ideas one of the ideas I discussed with Combell's Thijs Feryn: They are a hosting company providing managed MySQL instances to their customers, as such they run multiple MySQL servers and each server serves a few of their customers. Now they have to provide every customer with database credentials, including a host name to connect to. The issue there is that a fixed hostname takes flexibility out of the setup. Say you have db1.example.com and db2.example.com over time you figure out that there are two high load customers on db1 while db2 is mostly idle. …

[Read more]
Showing entries 1 to 10 of 35
10 Older Entries »