MySQL Forge

Resources for the MySQL Community

ProxyCookbook:TOC

Contents 1 Cookbook 1.1 Chapter 1. Basics 1.2 Chapter 2. Filtering 1.3 Chapter 3. Logging 1.4 Chapter 4. Monitoring 1.5 Chapter 5. Replication 1.6 Chapter 6. Command Extension 1.7 Chapter 7. Proxy Tricks 1.8 Chapter 8. Starting and Stopping mysql-proxy 1.9 Appendices

[edit] Cookbook

[edit] Chapter 1. Basics

• ProxyCookbook#Determine_What_is_Being_Sent
• Tokenizing a Query

[edit] Chapter 2. Filtering

• Filter Out Unwanted Queries With User Feedback 10
• Filter Out Unwanted Queries Without User Feedback 12

[edit] Chapter 3. Logging

• Simulating the General Log 13
• Simulating the Binary Log 15

[edit] Chapter 4. Monitoring

• Basic Monitoring 17
• Monitoring Proxy Traffic 18

[edit] Chapter 5. Replication

• Load Balancing Read Queries 19
• Simulating Replication 20

[edit] Chapter 6. Command Extension

• Shell Interface 21
• Crosstab Queries and Pivot Tables 22
• FOR loops 23
• Data Summaries with Crosstab Queries and Pivot Tables 27

[edit] Chapter 7. Proxy Tricks

• Using Proxy For Testing 24
• Creating a Server On-the-Fly 25

[edit] Chapter 8. Starting and Stopping mysql-proxy

• Wrappers 26
• Integrate mysql-proxy Without Restarting the MySQL Server 26

[edit] Appendices

• Appendix A: Glossary 30
• Appendix B: Tokenizer Constants 31