Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 33 10 Older Entries

Displaying posts with tag: MySQL Proxy (reset)

Spil Games hackday: research MaxScale
+0 Vote Up -0Vote Down

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
+0 Vote Up -0Vote Down

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:

  • MySQL 5.1.26-rc released, and developer resources thoughts
  •   [Read more...]
    Added a Table of Contents
    +1 Vote Up -0Vote Down

    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
    +2 Vote Up -0Vote Down

    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
      [Read more...]
    Using MySQL Proxy 0.8.2 on Windows
    +1 Vote Up -0Vote Down

    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
    Employee_Team +0 Vote Up -0Vote Down

    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


      [Read more...]
    MySQL Proxy 0.8.2 Has Been Released
    Employee_Team +0 Vote Up -0Vote Down

    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


      [Read more...]
    mysqlnd plugins for PHP in practice
    Employee +1 Vote Up -0Vote Down

    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

      [Read more...]
    Syntax for Creating a Windows Service for MySQL (when there are 2 paths which both contain spaces)
    +4 Vote Up -1Vote Down

    Numerous times now, I’ve seen people have troubles creating MySQL services on Windows manually (using ‘sc’), whether it be for mysqld itself, MySQL Proxy, or the MySQL Enterprise Monitor and/or Agent.

    The proper syntax for ‘sc’ can get tricky when you have spaces in pathnames, which is very common in Windows, and the need for –defaults-file (which means two paths each potentially containing spaces).

    So, if you have spaces in both your binpath and your path to –defaults-file, then the following syntax will work for you (all on a single line):

    sc create MySQLEnterpriseMonitorAgent
    binpath= ""C:Program FilesMySQLEnterpriseAgentbinmysql-monitor-agent.exe"
    --defaults-file="C:Program FilesMySQLEnterpriseAgentetcmysql-monitor-agent.ini""
    DisplayName= "MySQL Enterprise Monitor Agent" start= "auto"

    Note that you could easily use the

      [Read more...]
    Getting LuaSocket to Work with MySQL Proxy
    +2 Vote Up -0Vote Down

    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

      [Read more...]
    Showing entries 1 to 10 of 33 10 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.