Commit Graph

1043 Commits (docs/passthrough-auth-spec)

Author SHA1 Message Date
Rene Cannao c5916100f1 fix: complete all AI review fixes for PostgreSQL cluster synchronization
6 months ago
Rene Cannao 119ca5003a Fix compilation errors in debug build
6 months ago
René Cannaò 313f637cf0
Merge branch 'v3.1-vec' into v3.1-MCP1
6 months ago
Rene Cannao d64b4c85d8 fix: resolve PostgreSQL cluster sync compilation issues
6 months ago
Rene Cannao 5a85ef04f6 Fix MCP variables persistence and add DISK command support
6 months ago
Rene Cannao ab2c4f34b0 feat: add PostgreSQL variables to unified cluster sync
6 months ago
Rene Cannao 1beb5b9e5b fix: address review comments for PostgreSQL cluster sync PR
6 months ago
Rene Cannao 81c53896bc Fix MCP module TAP test failures
6 months ago
Rene Cannao 87fff9e046 Add MCP (Model Context Protocol) module skeleton
6 months ago
Rene Cannao c476f56f97 Add initial GenAI module placeholder
6 months ago
Rene Cannao efe0d4fe61 Add extensive doxygen documentation for vacuum_stats and stats_pgsql_stat_activity
6 months ago
Rene Cannao e2d64114d4 Refactor ProxySQL_Cluster: Eliminate code duplication and modernize atomic operations
7 months ago
Rene Cannao e0dec1c54c fix: Complete pgsql_servers_v2 checksum integration in runtime_checksums_values
7 months ago
Rene Cannao b67c7c1d1c feat: Implement PostgreSQL cluster synchronization for issue #5147
7 months ago
Rahim Kanji 38befb845f Fixed PROXYSQL STOP
8 months ago
Wazir Ahmed 5219d4be93 processlist: Prevent crash due to SQLITE_TOOBIG
8 months ago
René Cannaò ecad6f9249
Merge pull request #5160 from sysown/v3.0_disable_pgsql_prometheus_5159
9 months ago
René Cannaò abafaccbc0
Merge pull request #5156 from sysown/v3.0_pgsql_stat_activity_issue_4682
9 months ago
Rahim Kanji 5bfb6e216c Few fixes
9 months ago
Rahim Kanji e6d0338959 Turning off Prometheus metrics collection for PostgreSQL modules in ProxySQL
9 months ago
Rahim Kanji fc4d7f76a0 Added 'SHOW FULL PGSQL ACTIVITY' and 'SHOW PGSQL ACTIVITY' handling
9 months ago
Rahim Kanji f3ea179384 Add backend PID/state to stats_pgsql_processlist and create pg_stat_activity-style view
9 months ago
Rahim Kanji 1e988c665e Removed admin_handler_command_kill_connection
9 months ago
Evgeny Kuzin 949eda1ccd
generate postgres metrics in addition to mysql metrics
11 months ago
Rahim Kanji 703a5f35f5 Added stats_pgsql_prepared_statements_info table
12 months ago
Rahim Kanji bc87d0d901 * For a Describe Portal message, peek at the next message in the extended query frame. If it is an Execute message, indicating that client is sending a Bind/Describe/Execute sequence
12 months ago
René Cannaò c48c3310a6 Check if database file exists before checking if it is writable
1 year ago
René Cannaò bf3cca8639 exit if database file is not writable
1 year ago
René Cannaò cb53db81ca Export MySQL_Logger metrics for v3.0
1 year ago
René Cannaò 2551d350e9 Port to 3.0 of in-memory query logging
1 year ago
Javier Jaramago Fernández 9e941854c3 Replace table based 'VACUUM' for SQLite3 'stats' database
1 year ago
René Cannaò b9dcc9420a PROXYSQL FLUSH LOGS forces debug database flush
1 year ago
René Cannaò c2f1871adf Make set_thread_name() optional
1 year ago
Rahim Kanji 6d614a4b99 Merge branch 'v3.0'
2 years ago
Rahim Kanji 110ce8d511 Fixed crash caused by sending single semicolon (;) on admin interface
2 years ago
Rahim Kanji 720441af20 Refactored and Optimized Query Cache with PgSQL Support
2 years ago
Rahim Kanji 0229daeb64 Added stats_pgsql_query_digest and stats_pgsql_query_digest_reset tables
2 years ago
René Cannaò d4bd93672e
Merge pull request #79 from sysown/v2.x_refactore_query_processor
2 years ago
Rahim Kanji e723082a1b Refactored Query Processor Architecture
2 years ago
René Cannaò cbf4628ea3 Merge remote-tracking branch 'proxysql27/v2.7' into v2.x_postgres_merge27_20240917
2 years ago
Javier Jaramago Fernández d516ca5e84 Merge branch 'v2.x_postgres' of https://github.com/sysown/proxysql_postgresql into v2.x-postgres_dual_password
2 years ago
René Cannaò cf9d5fe21a
Merge pull request #4574 from sysown/set-thread-names
2 years ago
Rahim Kanji 745449fcbc Removed Client_Session.h and Client_Session.cpp
2 years ago
Javier Jaramago Fernández bbda0a86eb Add initial impl for dual-password support
2 years ago
Rahim Kanji 5bf827d8e4 Removed type selector
2 years ago
Rahim Kanji 3112a56da4 Added 'stats_pgsql_client_host_cache' and
2 years ago
Rahim Kanji e939cf088e Added 'stats_pgsql_errors' and 'stats_pgsql_errors_reset' tables
2 years ago
Rahim Kanji 43d3ec82c8 Added stats_pgsql_processlist table
2 years ago
Rahim Kanji 0b8df6df00 Added stats_pgsql_users table
2 years ago
Rahim Kanji b4e1e1eea7 Added stats_pgsql_free_connections table
2 years ago
René Cannaò 58fa5ee5ec Use uppercase in stats_mysql_query_digest.digest
2 years ago
Rahim Kanji 9cfe5b1761 Added stats_pgsql_connection_pool & stats_pgsql_connection_pool_reset tables
2 years ago
Rahim Kanji c35a6a24cf Added stats_pgsql_global table
2 years ago
Rahim Kanji 2730a41a38 Remove 'gtid_port' column from pgsql_servers table
2 years ago
Rahim Kanji 3c870e5c05 Removed unused columns + Bug fixes
2 years ago
Rene Cannao 7fe013fac2 Merge branch 'proxysql_v2.x_240813' into v2.x_postgres_merge_v2.x_240813
2 years ago
Javier Jaramago Fernández 130d3fe04a Issue warning when time interval variable gets rounded
2 years ago
Rene Cannao 29383c7d47 Initialize all_modules_started also for release
2 years ago
Rene Cannao 28aba93526 Fix bug #44
2 years ago
Rene Cannao a1fd4af1a6 Splitting ProxySQL_Admin
2 years ago
René Cannaò 01bb6e9a08 PRAGMA journal_mode=OFF on debug database
2 years ago
Rene Cannao a3193ad1dd PRAGMA journal_mode=OFF on debug database
2 years ago
Rene Cannao 465eaef87e Merge branch 'v2.x_postgres' into v2.x_240630
2 years ago
René Cannaò 25f02a33ce
Merge pull request #4496 from sysown/v2.6.x-freebsd_fixes
2 years ago
René Cannaò 2eb1d0d1c1
Merge pull request #20 from sysown/v2.x_postgres_backend
2 years ago
Andriy Utkin 5e79afa8e0 Set thread names
2 years ago
Rahim Kanji c5c9b4c8d7 Changed PostgreSQL default port
2 years ago
Rahim Kanji d3e9c9c85a Merge remote-tracking branch 'remotes/Master/v2.x' into v2.x_proxysql_postgres_merge
2 years ago
Javier Jaramago Fernández 188faae40d Remove old commented/outdated code on 'ProxySQL_Admin'
2 years ago
Javier Jaramago Fernández 58778464b9 Fix memory leak during 'SAVE MYSQL USERS FROM RUNTIME' - Closes #4567
2 years ago
Rahim Kanji c8ce94c85b Merge remote-tracking branch 'Master_POSTGRES/v2.x_postgres' into v2.x_postgres_backend
2 years ago
Miro Stauder 565848c4a0 use local includes - prometheus
2 years ago
Miro Stauder b7258e965f use local includes - openssl
2 years ago
Rahim Kanji 65fc633cf5 Generic error handling, transaction detection and handling, bug fixes
2 years ago
Rahim Kanji 6aa8a50d3d Fixed SET <pgsql-*>=<value> for pgsql variables
2 years ago
Javier Jaramago Fernández 9470923e6f Fix assert on 'ldap' variables checksum computation
2 years ago
Rahim Kanji aaf88010f2 Fixed typo
2 years ago
Miro Stauder 8394fd444e use local includes - prometheus
2 years ago
Miro Stauder 7695c42534 use local include - openssl
2 years ago
Rahim Kanji a2516654cf Added PgSQL Thread variables.
2 years ago
Rahim Kanji 06a32365cc Merge remote-tracking branch 'Master_POSTGRES/v2.x_postgres' into v2.x_postgres_backend
2 years ago
Rahim Kanji dcbe140199 Route query to PostgreSQL backend server
2 years ago
Miro Stauder da61f23eb3 Merge branch 'v2.x' into v2.6.x-freebsd_fixes
2 years ago
Javier Jaramago Fernández f962d13148 Fix crashes during shutdown due to uninitialized 'AdminHTTPServer'
2 years ago
Javier Jaramago Fernández 80c30d76f0 Fix un-initialized variable 'all_modules_started'
2 years ago
René Cannaò 10a7caf601 Further cleanup on servers tables for PgSQL
2 years ago
René Cannaò 3005c598e3 Adding pgsql_replication_hostgroups
2 years ago
René Cannaò a0172c4803 Remove not relevant servers tables from PgSQL
2 years ago
René Cannaò cf311557dd Revert "Remove not relevant tables from save_pgsql_servers_runtime_to_database()"
2 years ago
René Cannaò a43a1ccc40 Remove not relevant tables from save_pgsql_servers_runtime_to_database()
2 years ago
René Cannaò e0e8c125c5 Adding explicitly instantiate of template class functions
2 years ago
René Cannaò fde8ace076 Removed json.hpp from include files
2 years ago
René Cannaò 0cfab2616f First attempt to use Base_Thread and Base_Session
2 years ago
René Cannaò de345ecaed Merge remote-tracking branch 'public/v2.x' into v2.x_postgres_240422
2 years ago
René Cannaò b295aca4ab Handle clickhouse in flush_GENERIC_variables__process__database_to_runtime()
2 years ago
René Cannaò 38c6c2ac7b Merge branch 'v2.x-main' into v2.x_postgres_240422
2 years ago
René Cannaò d3a90a8ef6 Some refactoring of ProxySQL_Admin
2 years ago
Javier Jaramago Fernández e91bcd2c81 Move Admin 'HTTP_Server' and 'RESTAPI' init to end of phase3 - Closes #4510
2 years ago
René Cannaò 7a50a68f28 Split of ProxySQL_Admin.cpp
2 years ago
René Cannaò 9d215cfed3 Some documentation
2 years ago
René Cannaò 1053674b0a Some Doxygen
2 years ago
René Cannaò 6258ed625d Fix compiling
2 years ago
René Cannaò 42178f8dd9 Use of function pointer for SIGUSR1 handler
2 years ago
Miro Stauder 9ac76349fe refactor FLUSH LOGS and signal handler
2 years ago
Rahim Kanji 936e27139b Merge branch 'v2.x_PostgreSQL_Merge' into v2.x_postgres
2 years ago
Miro Stauder 3e3b6ecd1a add SIGUSR1 handler to trigger PROXYSQL FLUSH LOGS
2 years ago
Miro Stauder 6d9252a9d8 use /dev/fd to get open file descriptors
2 years ago
Rahim Kanji ebf20b6a60 * Added PostgreSQL configuration (port: 6034 Admin and 6035: PostgreSQL client connections)
2 years ago
Rahim Kanji e029d39007 Initial PostgreSQL commit
2 years ago
René Cannaò 6b9a787c45 Removed dead code
2 years ago
Miro Stauder 8aee52740f fix type casts
2 years ago
Miro Stauder ee739edd8b fix format strings
2 years ago
René Cannaò 8a4246d1e9
Merge pull request #4458 from sysown/v2.x_Servers_SSL_Params
2 years ago
René Cannaò ee4cd19a07
Merge pull request #4459 from sysown/v2.x_openssl_verify_load_cacert_duration
2 years ago
Javier Jaramago Fernández caed360eeb Merge branch 'v2.x' of github.com:sysown/proxysql into v2.x_sha2pass_draft3
2 years ago
Rahim Kanji 211b8ae212 Fixed memory leak in ProxySQL_Test___Load_MySQL_Whitelist
2 years ago
Rahim Kanji fa22117842 Added ProxySQL Test to assess the duration of loading and verifying the CA certificate
2 years ago
René Cannaò 9a7c3e8196 Introducing mysql_servers_ssl_params
2 years ago
René Cannaò 53262987ac Added new status variable mysql_listener_paused
2 years ago
René Cannaò c3c9746bbc
Merge branch 'v2.x' into v2.x_sha2pass_draft3
2 years ago
René Cannaò 2840e18e13
Merge pull request #4295 from sysown/v2.x-aurora_autodiscovery-refactor_cluster_mysql_servers-gr_bootstrap_mode
2 years ago
Javier Jaramago Fernández 862a1a7085 Fix Admin deadlock on concurrent connections - Closes #4415
3 years ago
Javier Jaramago Fernández e8d2254689 Merge branch 'v2.x' of github.com:sysown/proxysql into v2.x-aurora_autodiscovery-refactor_cluster_mysql_servers-gr_bootstrap_mode
3 years ago
René Cannaò 3c2418246c
Merge branch 'v2.x' into v2.x_sha2pass_draft3
3 years ago
René Cannaò 699fe7efcd Moved proxysql_find_charset_* functions out of MySQL_Thread.cpp
3 years ago
René Cannaò e997f6b8bb
Merge pull request #4381 from sysown/v2.x-depr_checksum_vars_fix
3 years ago
René Cannaò b6deb15ec3
Merge pull request #4372 from sysown/v2.x_prep_stmt_mem_usage
3 years ago
Javier Jaramago Fernández a8446deef0 Merge branch 'v2.x' of github.com:sysown/proxysql into v2.x-depr_checksum_vars_fix
3 years ago
Javier Jaramago Fernández 437fcad1d4 Fix interactions between 'checksum_%' and '%_diffs_before_sync'
3 years ago
Rahim Kanji ade6fb0e2b * Added 'hostgroup_settings' column (JSON-Formatted) to 'mysql_hostgroup_attributes' and it's counterpart 'runtime_mysql_hostgroup_attributes' table to accommodate new hostgroup attributes.
3 years ago
Rahim Kanji 989687c68a Implemented memory usage monitoring for the prepared statement cache with the following changes:
3 years ago
Javier Jaramago Fernández ecf4f69fe0 Fix Admin support for MySQL client '8.1.0' - Closes #4300
3 years ago
Javier Jaramago Fernández a4b6bd0b8f Refactor and homogenization of checksums computation
3 years ago
Javier Jaramago Fernández 3b8e23e75a Fix invalid fallback response for 'CLUSTER_QUERY_MYSQL_SERVERS_V2'
3 years ago
Javier Jaramago Fernández 6b58a004e6 Merge branch 'v2.x-gr_bootstrap_mode' into v2.x-aurora_autodiscovery-refactor_cluster_mysql_servers-gr_bootstrap_mode
3 years ago
Javier Jaramago Fernández 858c430b59 Merge branch 'v2.x' of github.com:sysown/proxysql into v2.x-gr_bootstrap_mode
3 years ago
Javier Jaramago Fernández a10f427121 Merge branch 'v2.x_refactor_cluster_mysql_servers' of github.com:sysown/proxysql into v2.x-aurora_autodiscovery-refactor_cluster_mysql_servers
3 years ago
Javier Jaramago Fernández 7f0ef596ed Merge branch 'v2.x' of github.com:sysown/proxysql into v2.x_refactor_cluster_mysql_servers
3 years ago
Javier Jaramago Fernández f48dfce6cf Simplified resultset and checksum generation for 'mysql_servers'
3 years ago
Javier Jaramago Fernández dfe8588017 Fix timestamps regression for 'stats_mysql_query_digest'
3 years ago
René Cannaò 9ede04de52 Merge branch 'v2.x' into v2.x_sha2pass_draft3
3 years ago
Javier Jaramago Fernández cfa6d891d3 Merge branch 'v2.x' of github.com:sysown/proxysql into v2.x-aurora_autodiscovery
3 years ago
Javier Jaramago Fernández 3d06427efe Improve simulator support for AWS Aurora
3 years ago
René Cannaò 8106ae5ee3 Merge branch 'v2.x' into v2.x_sha2pass_draft3
3 years ago
René Cannaò d79c5cfba3 Close fd after fork() also on REST API
3 years ago
René Cannaò 7899ca1d5f Close all FDs in Scheduler
3 years ago
René Cannaò 629aa3d93b Drafting TAP test_change_user-t
3 years ago
Rahim Kanji 063af84f7f Merge remote-tracking branch 'Master/v2.x' into v2.x_refactor_cluster_mysql_servers_final
3 years ago
René Cannaò 85777ee63a
Merge pull request #4242 from sysown/v2.x_ssl_keylog_support
3 years ago
Rahim Kanji ada4621401 Special handling for 'admin-ssl_keylog_file' is only filename is provided.
3 years ago