Download as PDF, PPTX
Uploaded byGiuseppe Maxia
PDF, PPTX15,301 views
MySQL Proxy tutorial
This document provides an overview and agenda for a presentation on MySQL Proxy. MySQL Proxy is a transparent proxy server that allows intercepting and modifying MySQL traffic. It uses the Lua scripting language to intercept queries, inject new queries, and alter results. The presentation covers the basic principles of MySQL Proxy and Lua scripting, demonstrates how to use Lua scripts to debug queries and add new functionality like load balancing. It also provides resources for tutorials, example scripts, and testing MySQL Proxy.
![UiPath Automation Suite Installation (Hands-On) [2/3]](https://cdn.slidesharecdn.com/ss_thumbnails/automationsuitecommunitysession2-251015095633-a6d862f1-thumbnail.jpg?width=600ounds&width=560&fit=bounds)
In this document
Powered by AI
Introduction to MySQL Proxy tutorial by Jan Kneschke and Giuseppe Maxia, overview of agenda and audience engagement.
Definition of proxies in computing, their functions like caching, load balancing, and MySQL Proxy features.
Discusses traditional vs. open source problem-solving in databases, and enhancements with MySQL Proxy features.
Capabilities of MySQL Proxy including command creation, query filtering, usage tracking, and statistical functions.
Introduction to Lua scripting for MySQL Proxy, outlining the core functions and structure for proxy scripts.
Methods to debug scripts running within MySQL Proxy, incorporating diagnostics and testing strategies.
Basic principles of Lua, types, control statements, functions, and using tables for data handling.
Examples of returning datasets, constructing error messages and handling debug messages within MySQL Proxy.
Techniques for redirecting database traffic and managing session information through proxy scripts.
Links to example scripts for MySQL Proxy and Lua, online resources for further learning and documentation.