PROXYSQL(1)

📦 version 3.0.2, in epel 9, fedora 43, fedora 44

💖 PROXYSQL(1) 💖

okay bestie, welcome to the proxysql manual page — it's from the General Commands Manual section, and it's literally the whole glow-up guide for this proxy. sit down, grab a strawberry 🍓, and let's go.

✨ NAME ✨

proxysql — High Performance Advanced Proxy for MySQL 👑

🌸 SYNOPSIS 🌸

proxysql [OPTIONS]

that's it. that's the whole vibe. options in, magic out. 🪄

🦋 DESCRIPTION 🦋

so proxysql is a high performance, high availability, protocol aware proxy for MySQL and its forks (yes, like Percona Server and MariaDB — they count too, we don't gatekeep 💅).

basically it sits between your app and your databases and handles everything with main character energy. no cap.

🎀 OPTIONS 🎀

every single flag, listed, unsummarised, because we do NOT skip the boring parts in this house. 🔥

  • -c, --config _ARG_ — the configuration file, bestie. by default the proxy goes looking for the config file in these exact locations, in this exact order:
    • proxysql.cnf, in the directory of the proxysql binary
    • proxysql.cfg, in the directory of the proxysql binary
    • /etc/proxysql.cnf
    • /etc/proxysql.cfg

this setting lets you override the config file and point it at a custom location. you're the main character, you pick the spot. 📍

  • -D, --datadir _ARG_ — the data directory, aka where the proxy keeps all its running files:
    • the SQLite database which stores the runtime configuration for the proxy
    • the pidfile
    • the log files

it's giving "everything lives here, no clutter elsewhere." 🏠

  • -e, --exit-on-error — do NOT restart ProxySQL if it crashes. it just… stays down. dramatic, but honest. 💀
  • -f, --foreground — run the daemon process in the foreground. no hiding in the background, we want to see you. 👀
  • -h, -help, --help, --usage — display usage instructions. the classic "help me pls" move. 🫶
  • -M, --no-monitor — do not start the Monitor Module. it's off duty, don't text it. 🙈
  • -n, --no-start — starts only the admin service, which helps you configure the daemon. heads up: this will not accept any traffic until the daemon is started from the admin interface. so it's like, present but not serving. ✋
  • -r, --reuseport — use SO_REUSEPORT. iconic socket behavior, iykyk. 🌈
  • -S, --admin-socket _ARG_ — the administration Unix Socket. 🧚
  • -V, --version — print the current version of ProxySQL. identity check! 🪪
  • --idle-threads — create auxiliary threads to handle idle connections. little helpers for the do-nothing connections. 🐝
  • --initial — reset the admin database with the content from the configuration file. factory reset but make it config-driven. 🔄
  • --no-version-check — do not check for the latest version of ProxySQL. we're off the update grind, and that's valid. 🚫
  • --reload — merge the configuration from the config file with the current runtime database. blending, but for configs. 🥤
  • --sqlite3-server — enable the SQLite3 Server. yes queen, extra server. 👑

🔍 SEE ALSO 🔍

📁 FILES 📁

  • /etc/proxysql.cnf — the configuration file. ✨

👑 AUTHOR 👑

Written by René Cannaò. 🫶

🐛 BUG REPORTS 🐛

if you find a bug (and bestie, you will, that's just software 😭), please report it at:

<https://github.com/sysown/proxysql/issues>

they want to hear from you fr fr.

Copyright (C) 2013-2017 René Cannaò. Modified by Marek Kulik 2021.

This program is free and without warranty. no promises, no drama, just vibes. 💜

and that's the whole page, bestie!! this was the PROXYSQL(1) page from the General Commands Manual — go forth and proxy slay. 💅✨🎀

📦 where this page comes from