Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 48 Next 18 Older Entries

Displaying posts with tag: proxy (reset)

MaxScale has now its own public irc channel
+1 Vote Up -0Vote Down

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 [...]

MaxScale, ProxySQL and MySQL Proxy
+2 Vote Up -0Vote Down

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 [...]

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...]
What about MySQL-Proxy
+1 Vote Up -0Vote Down

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


  [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...]
Operating a Drupal Site behind a Reverse Proxy Server (Apache)
Employee +0 Vote Up -4Vote Down
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

  [Read more...]
memcached talk tonight, ManadLUG
+0 Vote Up -0Vote Down
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.
MySQL Proxy 0.7.2 released
Employee +0 Vote Up -0Vote Down

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: #mysql-proxy on







  [Read more...]
MySQL Proxy 0.7.2 released
Employee +0 Vote Up -0Vote Down

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: #mysql-proxy on







  [Read more...]
MySQL Proxy 0.7.2 released
Employee +0 Vote Up -0Vote Down

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: #mysql-proxy on







  [Read more...]
Why You Won’t See a Drizzle Proxy
+3 Vote Up -0Vote Down

I’ve been following the excellent work that Jan, Kay, and others have been doing with MySQL Proxy, it has really matured into a great piece of software. I talked to Jan at the MySQL UC and toyed with the idea of integrating libdrizzle into MySQL Proxy. I’ve also been asked by a number of folks when a Drizzle Proxy project will be started and if it will be as feature rich as MySQL Proxy. For a while I just said “Someday, I just don’t have the time.” Lately though I am hoping we never have a Drizzle Proxy project.

Let me explain.

One of the fundamental ideas in software engineering is code reuse through libraries or modules. Rather than create a Drizzle Proxy

  [Read more...]
MySQL Proxy: Roles
Employee +2 Vote Up -0Vote Down

On the MySQL Proxy channel we get questions from time to time if the authentication can be intercepted and replaced data from a external source.

From now on, you can. For example if you want to get data from a external source (like LDAP) or want to implement roles.

Mapping Accounts to “Roles”

There isn’t much needed to implement Roles for MySQL with the help of the MySQL Proxy.

  • mysql.user doesn’t contain users, but roles instead
  • the proxy maps user-accounts to role-accounts with a script like above

It works like this:

  • login to the proxy

     $ mysql --user=jan --password=secret --port=4040
  • proxy looks up username password, finds a role for him

  • proxy replaces credentials ad hoc

  • mysql-server sees the role-name and

  •   [Read more...]
    MySQL Proxy: Hackathon 2009
    Employee +0 Vote Up -0Vote Down

    At MySQL Conference in Santa Clara this April the idea was brought up, now we do it:

    a MySQL Proxy hackathon this summer in Sun Office in Hamburg, Germany.

    We want bring together everyone who is interested in

    • hacking on MySQL Proxy,
    • sharing ideas how it is used and
    • how it should develop.

    More at http://forge.mysql.com/wiki/MySQL_Proxy_Hackathon_2009

    MEM and HTTP Proxy Not Compatible
    Employee +1 Vote Up -0Vote Down
    A bug in libcurl affects how the heartbeat function of MySQL Enterprise Monitor works by sending it to an external website, often www.agent.com.
    MEM and HTTP Proxy Not Compatible
    Employee +0 Vote Up -0Vote Down
    A bug in libcurl affects how the heartbeat function of MySQL Enterprise Monitor works by sending it to an external website, often www.agent.com.
    MEM and HTTP Proxy Not Compatible
    Employee +0 Vote Up -0Vote Down
    A bug in libcurl affects how the heartbeat function of MySQL Enterprise Monitor works by sending it to an external website, often www.agent.com.
    Video: What the MySQL Is This, Anyway?
    +0 Vote Up -0Vote Down

    Giuseppe Maxia and I are in the exact middle of our leg of theMySQL Campus Tour. Yesterday’s session was recorded — play the video online right in your browser at http://technocation.org/node/700/play or download the 80 Mb .mov file at http://technocation.org/node/700/download.

    A PDF of the slides can be downloaded at http://technocation.org/files/doc/2009_04_Tour.pdf (21 Mb).

    Click on the thumbnails for larger pictures of the standing-room only crowd, and lunch with the great folks at Cal Poly afterwards:

      [Read more...]
    Arbitrary Replication/Proxy Topologies with MySQL Sandbox
    Employee +0 Vote Up -0Vote Down
    How would you like to use MySQL Sandbox to deploy and test any replication topology imaginable? Do you want to describe load balancer and proxy configurations, too? If you already love sandbox (or even if you don't), and you want to play with arbitrarily complex replication/proxy topologies... read on.

    Sandbox Is Your Friend

    MySQL Sandbox is a great tool. As of this writing, version 3 is feature complete -- and the new features are greatly desired. Replication support has been there a while for master/slave setups with as many slaves as you want and for replication rings of any size. Version 3 adds multi-level replication trees on a multi-sandbox using sbtool.

    But what if the provided replication setups do not quite match what you need?





      [Read more...]
    Simulating Workload with MySQL Proxy web seminar - April 2, 2009 10:00PT
    Employee +0 Vote Up -0Vote Down

    On April 2nd, at 10:00 PT (13:00 ET, 18:00 UTC, 19:00 CET), there is a free web seminar on Simulating Workload with MySQL Proxy (http://www.mysql.com/news-and-events/web-seminars/display-306.html).

    I will introduce MySQL Proxy, and Diego Medina, MySQL QA Engineer, will talk about the juicy part.

    Participation is free. To enlist, you need to register online (http://www.mysql.com/news-and-events/web-seminars/display-306.html) and then you can attend the event from the comfort of your home or office.

    Simulating Workload with MySQL Proxy web seminar - April 2, 2009 10:00PT
    Employee +0 Vote Up -0Vote Down

    On April 2nd, at 10:00 PT (13:00 ET, 18:00 UTC, 19:00 CET), there is a free web seminar on Simulating Workload with MySQL Proxy (http://www.mysql.com/news-and-events/web-seminars/display-306.html).

    I will introduce MySQL Proxy, and Diego Medina, MySQL QA Engineer, will talk about the juicy part.

    Participation is free. To enlist, you need to register online (http://www.mysql.com/news-and-events/web-seminars/display-306.html) and then you can attend the event from the comfort of your home or office.

    Simulating Workload with MySQL Proxy web seminar - April 2, 2009 10:00PT
    Employee +0 Vote Up -0Vote Down

    On April 2nd, at 10:00 PT (13:00 ET, 18:00 UTC, 19:00 CET), there is a free web seminar on Simulating Workload with MySQL Proxy (http://www.mysql.com/news-and-events/web-seminars/display-306.html).

    I will introduce MySQL Proxy, and Diego Medina, MySQL QA Engineer, will talk about the juicy part.

    Participation is free. To enlist, you need to register online (http://www.mysql.com/news-and-events/web-seminars/display-306.html) and then you can attend the event from the comfort of your home or office.

    MySQL HA – Let’s take a look at Sequoia
    +0 Vote Up -0Vote Down
    MySQL HA: 1. Desirable – most of the time, 2. Needed – often enough, 3. Available – there are some good options out there. Typical solutions consist of: Heartbeat with DRBD on Linux. Although HB was introduced to Linux, it can be used on Solaris, FreeBSD and others without the DRBD but with other solutions. Sun Cluster, Veritas (commercial), MySQL Proxy (still in [...]
    What’s New in MySQL Proxy?
    Employee +0 Vote Up -0Vote Down

    After long wait, MySQL Proxy is back. Its new home on Launchpad is actively updated, and the busy bees Kay and Jan are working to bring us a binary release soon.

    But, what exactly is new in MySQL Proxy?

    It's easy to find out. On Thursday, January 29, 2009, 10:00 am PST, 1:00 pm EST, 18:00 GMT, there is a free webinar (http://www.mysql.com/news-and-events/web-seminars/display-277.html) that explains the news in great detail.

    If you have questions on what has been implemented and what is still in the making, this is your chance to find out. Participation is free. You only need to register on the webinar page (http://www.mysql.com/news-and-events/web-seminars/display-277.html).

      [Read more...]
    What’s New in MySQL Proxy?
    Employee +0 Vote Up -0Vote Down

    After long wait, MySQL Proxy is back. Its new home on Launchpad is actively updated, and the busy bees Kay and Jan are working to bring us a binary release soon.

    But, what exactly is new in MySQL Proxy?

    It's easy to find out. On Thursday, January 29, 2009, 10:00 am PST, 1:00 pm EST, 18:00 GMT, there is a free webinar (http://www.mysql.com/news-and-events/web-seminars/display-277.html) that explains the news in great detail.

    If you have questions on what has been implemented and what is still in the making, this is your chance to find out. Participation is free. You only need to register on the webinar page (http://www.mysql.com/news-and-events/web-seminars/display-277.html).

      [Read more...]
    What’s New in MySQL Proxy?
    Employee +0 Vote Up -0Vote Down

    After long wait, MySQL Proxy is back. Its new home on Launchpad is actively updated, and the busy bees Kay and Jan are working to bring us a binary release soon.

    But, what exactly is new in MySQL Proxy?

    It's easy to find out. On Thursday, January 29, 2009, 10:00 am PST, 1:00 pm EST, 18:00 GMT, there is a free webinar (http://www.mysql.com/news-and-events/web-seminars/display-277.html) that explains the news in great detail.

    If you have questions on what has been implemented and what is still in the making, this is your chance to find out. Participation is free. You only need to register on the webinar page (http://www.mysql.com/news-and-events/web-seminars/display-277.html).

      [Read more...]
    MySQL Proxy Web-Seminar
    Employee +1 Vote Up -0Vote Down

    I just realized something else Chris has mentioned:

    Since MySQL Proxy 0.7.0 is soon to be released, I thought another brief tutorial would be helpful.

    Indeed, we are looking to properly release 0.7.0 soon™.

    In case you are wondering what’s happening with MySQL Proxy and what the deal with the code’s new home is, please consider making some time for the web-seminar next week (http://mysql.com/news-and-events/web-seminars/display-277.html).

    It’s free but registration is required.

    We will also have Carlo Cabanilla talking about

      [Read more...]
    MySQL Proxy Web-Seminar
    Employee +0 Vote Up -0Vote Down

    I just realized something else Chris has mentioned:

    Since MySQL Proxy 0.7.0 is soon to be released, I thought another brief tutorial would be helpful.

    Indeed, we are looking to properly release 0.7.0 soon™.

    In case you are wondering what’s happening with MySQL Proxy and what the deal with the code’s new home is, please consider making some time for the web-seminar next week (http://mysql.com/news-and-events/web-seminars/display-277.html).

    It’s free but registration is required.

    We will also have Carlo Cabanilla talking about

      [Read more...]
    MySQL Proxy Web-Seminar
    Employee +0 Vote Up -0Vote Down

    I just realized something else Chris has mentioned:

    Since MySQL Proxy 0.7.0 is soon to be released, I thought another brief tutorial would be helpful.

    Indeed, we are looking to properly release 0.7.0 soon™.

    In case you are wondering what’s happening with MySQL Proxy and what the deal with the code’s new home is, please consider making some time for the web-seminar next week (http://mysql.com/news-and-events/web-seminars/display-277.html).

    It’s free but registration is required.

    We will also have Carlo Cabanilla talking about

      [Read more...]
    Another MySQL Proxy Tutorial
    +1 Vote Up -0Vote Down

    Since MySQL Proxy 0.7.0 is soon to be released, I thought another brief tutorial would be helpful. Today we ran across a good use case, and so I wanted to pass this along. If you’ve not used Proxy yet, this is a great opportunity to get your feet wet with it and some Lua.

    When queries are routed though MySQL Proxy from various servers, the MySQL Server only sees that the query came from the machine Proxy is running on.

    So when you are viewing output of SHOW PROCESSLIST, you have no way of telling what server a particular query originated from.

    However, this could be very useful information to have, especially to determine which server a particular long-running query is coming from at that particular moment in time.

    Output not using Proxy:

    mysql> show processlist;
    +----+------+-----------------+------+---------+------+-------+------------------+
    | Id | User | Host
      [Read more...]
    MySQL Proxy code now live
    Employee +0 Vote Up -0Vote Down

    It’s done!

    Even if it took a while, too long, really, we finally have the MySQL Proxy code out in the open, where it belongs.

    As part of this effort, we would also like to make our development process more transparent. To that effect, we’ve also created a Launchpad team that serves as a discussion hub. It comes with a mailing list, reachable at mysql-proxy-discuss@lists.launchpad.net, where we hope to have some interesting discussions about where to take Proxy, what to implement in what way, and of course to offer advice to users.

    There’s not much in terms of “process” yet and quite possibly (and hopefully) it will stay this way, but let me outline some of my hopes and plans for going forward:

      [Read more...]
    Showing entries 1 to 30 of 48 Next 18 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.