MySQL Proxy, the Friendly Man in the Middle

Jan Kneschke (MySQL), Jimmy Guerrero (Oracle-MySQL)
Architecture and Technology
Location: Ballroom F

MySQL Proxy evolved a lot since last years Birds of a Feather session. From a simple proof of concept to a production used component in the MySQL stack.

With is very simple core and integrated LUA-scripting the Proxy is able to handle a large set of use-cases from

  • Query Rewriting (Schema Migration, Query Cache optimizations, ...)
  • Query Injection (Query Analysis, auto grouping of INSERTs into Transactions, ...)
  • Query Handling (Query Caching, ...)

to

  • dynamic Load Balancing
  • Connection Pooling
  • Read/Write Splitting

In this overview session we want to present the concept and ideas behind the Proxy and give you an idea what you can use the proxy for your environment.

Photo of Jan Kneschke

Jan Kneschke

MySQL

Jan Kneschke works for Sun as Senior Software Developer in the MySQL Enterprise Tools team and maintains the MySQL Proxy and the agent component of MySQL Enterprise Monitor.

His favourite programming language is Lua as you can see in the

  • MySQL Proxy,
  • lighttpd and
  • the wormhole Storage Engine.

Jimmy Guerrero

Oracle-MySQL

Jimmy Guerrero currently coordinates MySQL’s Cloud Computing, High-Availability and Windows, marketing programs. He joined MySQL in 2005 as the product manager for MySQL Cluster and other MySQL high availability technologies. Prior to joining MySQL he held various sales and technical positions at Idera Software and Embarcadero Technologies. He currently resides in Houston, Texas.

Sponsors
  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Contact Us

View a complete list of MySQL contacts.