MySQL Forge

Resources for the MySQL Community

Categories: Contributing | Development | MySQLUniversity | MySQLProxy

MySQL Proxy Overview

Contents 1 MySQL Proxy Overview 2 Presentation 3 Questions 3.1 Questions asked before the session 3.2 Questions asked during the session 4 Voice recording and other links

← Back to MySQL University main page

[edit] MySQL Proxy Overview

• Date: 2007-09-13
• Presenter: Jan Kneschke
• Scribe: Martin C. Brown
• Attendees (please register by filling in your name below, and read the Instructions for Attendees):
  1. Stefan Hinz
  2. Alexander Nozdrin
  3. Giuseppe Maxia
  4. Ronald Bradford
  5. MatsKindahl 06:17, 12 September 2007 (UTC)
  6. Martin Hansson
  7. Craig Sylvester
  8. Lenz Grimmer
  9. Yves Trudeau
  10. Holman Romero
  11. Mark Leith
  12. ...

[edit] Presentation

This presentation will be an introduction to the MySQL Proxy:

• Architecture
  • event-based
• Use Cases
  • Logging
  • Auditing
  • ScaleOut
• Scripting
  • LUA the Language
  • lua_* C-API
  • script API
• Internals
  • shared lua context
• Future Optimizations
  • script cache

MySQL Proxy Presentation as PDF

[edit] Questions

[edit] Questions asked before the session

1. Is it possible to use the Proxy for sharding a database? This would require that each request-response pair between the proxy and the client results in several request-response pairs between the proxy and the databases.

[edit] Questions asked during the session

1. Did you actually try 10k with mysql-proxy or is it theory?
   • The lighttpd package uses the same system, so it is possible.
2. To clarify, both "HA-proxy" and "LB-proxy" are instances of the MySQL Proxy? Or something else? (Within Failsafe Load Balancing (Slide 9))
   • Yes
3. Is there an example of rewriting the EXPLAIN DELETE to EXPLAIN SELECT queries (Within Query Rewriting (Slide 12))
   • No, but Jan will add a basic example.
4. How does it work together with schemas on your "Removing SPoF" slides (Within Global Transaction ID (Slide 16))
   • Because you are still using a single master - even if the master is failover - the Global Transaction ID is still only coming from one server. See Jan's blog (MySQL Proxy and a Global Transaction ID) for more background info.
5. Does MySQL Proxy pprovide complete transparency?
   • SSL is not supported, because the proxy is a man in the middle and SSL is designed to be a direct end to end encryption. MySQL protocol level compression is also disabled automatically.

[edit] Voice recording and other links

• Voice Recording: Ogg Audio (9.0MB)
• IRC log: IRC Text (12KB)
• Other resources: Jan Kneschke's Website