1043 Commits (docs/passthrough-auth-spec)

Author	SHA1	Message	Date
Rene Cannao	c5916100f1	fix: complete all AI review fixes for PostgreSQL cluster synchronization ... This commit addresses the remaining issues identified by AI reviews in PR 5234: - Fixed CLUSTER_QUERY_RUNTIME_PGSQL_SERVERS macro to resolve numeric vs VARCHAR comparison issue - Verified that PostgreSQL variables are already included in admin_variables_names array - Fixed inconsistent gating/reset behavior for pgsql diffs when mysql checksum flags are disabled (added pgsql diffs reset for checksum_mysql_query_rules, checksum_mysql_servers, checksum_mysql_users) - Initialized atomic counters in ProxySQL_Cluster constructor to value 3 - Added missing get_peer_to_sync_pgsql_variables wrapper function (implementation + header declaration) - Fixed test issues in test_cluster_sync_pgsql-t.cpp (NULL checks, tuple indexing, test plan) - Updated PostgreSQL modules documentation to include pgsql_variables - Standardized SQL string quoting to single quotes consistently All compilation issues have been resolved and the codebase now has consistent PostgreSQL cluster synchronization behavior across all modules. Signed-off-by: Rene <rene@localhost>	6 months ago
Rene Cannao	119ca5003a	Fix compilation errors in debug build ... - Move explicit template instantiations for send_ok_msg_to_client and send_error_msg_to_client to after template definitions - Add missing closing brace for init_mcp_variables() - Fix missing #endif and closing brace for GloMCPH shutdown block	6 months ago
René Cannaò	313f637cf0	Merge branch 'v3.1-vec' into v3.1-MCP1 ... Signed-off-by: René Cannaò <rene.cannao@gmail.com>	6 months ago
Rene Cannao	d64b4c85d8	fix: resolve PostgreSQL cluster sync compilation issues ... - Add missing set_metrics() function to ProxySQL_Node_Entry class - Fix undefined 'd_query' variable in PostgreSQL variables function - Remove deprecated PostgreSQL functions integrated into pgsql_servers sync - Add missing admin variables for PostgreSQL modules - Fix structural compilation issues in set_checksums function - PostgreSQL cluster sync now builds successfully for both debug and regular builds Resolves linking errors and compilation failures that prevented debug and regular builds from completing successfully.	6 months ago
Rene Cannao	5a85ef04f6	Fix MCP variables persistence and add DISK command support ... This commit fixes several issues with MCP (Model Context Protocol) variables not being properly persisted across storage layers and adds support for DISK commands. Changes: 1. lib/Admin_FlushVariables.cpp: - Fixed flush_mcp_variables___runtime_to_database() to properly insert variables into runtime_global_variables using db->execute() with formatted strings (matching admin pattern) - Fixed SQL format string to avoid double-prefix bug (qualified_name already contains "mcp-" prefix) - Fixed lock ordering by releasing outer wrlock before calling runtime_to_database with use_lock=true, then re-acquiring - Removed explicit BEGIN/COMMIT transactions to match admin pattern 2. lib/Admin_Handler.cpp: - Added MCP DISK command handlers that rewrite commands to SQL queries: * LOAD MCP VARIABLES FROM DISK -> INSERT OR REPLACE INTO main.global_variables * SAVE MCP VARIABLES TO DISK -> INSERT OR REPLACE INTO disk.global_variables * SAVE MCP VARIABLES FROM MEMORY/MEM -> INSERT OR REPLACE INTO disk.global_variables - Separated DISK command handlers from MEMORY/RUNTIME handlers 3. lib/ProxySQL_Admin.cpp: - Added flush_mcp_variables___runtime_to_database() call to stats section to ensure MCP variables are repopulated when runtime_global_variables is cleared and refreshed 4. tests/mcp_module-t.cpp: - Added verbose diagnostic output throughout tests - Added section headers and test numbers for clarity - Added variable value logging and error logging All 52 MCP module tests now pass.	6 months ago
Rene Cannao	ab2c4f34b0	feat: add PostgreSQL variables to unified cluster sync ... - Add PostgreSQL type handling in pull_global_variables_from_peer() - Add PostgreSQL peer selection call using get_peer_to_sync_pgsql_variables() - Integrate PostgreSQL into the data-driven variable sync architecture This enables automatic peer discovery and selection for PostgreSQL variables synchronization across cluster nodes.	6 months ago
Rene Cannao	1beb5b9e5b	fix: address review comments for PostgreSQL cluster sync PR ... - Fix SQL string literals in CLUSTER_QUERY_PGSQL_SERVERS_V2 to use single quotes - Initialize all std::atomic<int> counters in ProxySQL_Cluster constructor to 3 - Add missing cluster_pgsql_variables_diffs_before_sync and cluster_pgsql_variables_save_to_disk admin variables - Add get_peer_to_sync_pgsql_variables wrapper function for consistency - Fix copy/paste log text error in set_variable function for mysql_query_rules - Make PgSQL diffs consistent with MySQL diffs when checksum flags are disabled - Remove TAP test calls from helper function, move assertions to main - Fix tuple size mismatch in string_format calls (remove extraneous 12th element) - Update test plan from 6 to 10 to match actual test count Resolves all issues identified by gemini-code-assist and coderabbitai review comments.	6 months ago
Rene Cannao	81c53896bc	Fix MCP module TAP test failures ... - Add MCP variables to load_save_disk_commands map for LOAD/SAVE commands - Add MCP variable validation in is_valid_global_variable() for SET commands - Implement has_variable() method in MCP_Threads_Handler - Add CHECKSUM command handlers for MCP VARIABLES (DISK/MEMORY/MEM) Test results improved from 28 passed / 16 failed to 49 passed / 3 failed. Remaining 3 failures are test expectation issues (boolean representation).	6 months ago
Rene Cannao	87fff9e046	Add MCP (Model Context Protocol) module skeleton ... Add new MCP module supporting multiple MCP server endpoints over HTTPS with JSON-RPC 2.0 protocol skeleton. Each endpoint (/mcp/config, /mcp/observe, /mcp/query, /mcp/admin, /mcp/cache) is a distinct MCP server with its own authentication configuration. Features: - HTTPS server using existing ProxySQL TLS certificates - JSON-RPC 2.0 skeleton implementation (actual protocol TBD) - 5 MCP endpoints with per-endpoint auth configuration - LOAD/SAVE MCP VARIABLES admin commands - Configuration file support (mcp_variables section) Implementation follows GenAI module pattern: - MCP_Threads_Handler: Main module handler with variable management - ProxySQL_MCP_Server: HTTPS server wrapper using libhttpserver - MCP_JSONRPC_Resource: Base endpoint class with JSON-RPC skeleton	6 months ago
Rene Cannao	c476f56f97	Add initial GenAI module placeholder ... Implement a new GenAI module for ProxySQL with basic infrastructure: - GenAI_Threads_Handler class for managing GenAI module configuration - Support for genai- prefixed variables in global_variables table - Dummy variables: genai-var1 (string) and genai-var2 (integer) - Config file support via genai_variables section - Flush functions for runtime_to_database and database_to_runtime - Module lifecycle: initialization at startup, graceful shutdown - LOAD/SAVE GENAI VARIABLES admin command infrastructure Core functionality verified: - Config file loading works - Variables persist in global_variables table - Disk save/load via SQL works - Module initializes and shuts down properly Related files: - include/GenAI_Thread.h: New GenAI thread handler class - lib/GenAI_Thread.cpp: Implementation with dummy variables - lib/Admin_Handler.cpp: Added GENAI command vectors and handlers - lib/Admin_FlushVariables.cpp: Added genai flush functions - lib/ProxySQL_Admin.cpp: Added init_genai_variables() and load_save_disk_commands entry - include/proxysql_admin.h: Added function declarations - lib/Makefile: Added GenAI_Thread.oo to build - src/main.cpp: Added module initialization and cleanup - src/proxysql.cfg: Added genai_variables configuration section	6 months ago
Rene Cannao	efe0d4fe61	Add extensive doxygen documentation for vacuum_stats and stats_pgsql_stat_activity ... This commit documents: 1. The vacuum_stats() function's purpose, behavior, and the reason why stats_pgsql_stat_activity is excluded from bulk deletion operations 2. The fact that stats_pgsql_stat_activity is a SQL VIEW (not a table) and attempting DELETE on it would cause SQLite error: "cannot modify stats_pgsql_stat_activity because it is a view" The documentation explains: - Why TRUNCATE stats_mysql_query_digest triggers vacuum_stats(true) - Why both MySQL and PostgreSQL tables are cleared regardless of protocol - How the view is automatically cleared via its underlying table stats_pgsql_processlist - The importance of keeping the view excluded from deletion lists	6 months ago
Rene Cannao	e2d64114d4	Refactor ProxySQL_Cluster: Eliminate code duplication and modernize atomic operations ... This commit implements two major architectural improvements to ProxySQL clustering: Major Changes: - Data-driven approach eliminates 95 lines of repetitive code in set_checksums() - Modern C++ atomics replace legacy GCC __sync_* built-ins - Improved maintainability and performance across cluster synchronization Code Duplication Elimination: - Replaced 142 lines of nearly identical if-statements with 47 lines of data-driven code - Added ChecksumModuleInfo structure with member pointers for unified processing - Generalized sync message generation using snprintf() templates - Single loop now handles all 15 cluster modules (MySQL + PostgreSQL) Atomic Operations Modernization: - Converted all cluster_*_diffs_before_sync variables from int to std::atomic<int> - Replaced __sync_fetch_and_add() with .load() for read operations (more efficient) - Replaced __sync_lock_test_and_set() with direct assignment for write operations - Updated member pointer types to handle atomic variables correctly - Ensures thread safety while maintaining identical functionality Files Modified: - include/ProxySQL_Cluster.hpp: Added <atomic> include and std::atomic<int> declarations - lib/ProxySQL_Cluster.cpp: Implemented data-driven set_checksums() and atomic operations - lib/ProxySQL_Admin.cpp: Updated all cluster variable writes to use atomic operations Technical Benefits: - 67% reduction in repetitive code for cluster checksum processing - Modern C++11 atomic operations with better performance characteristics - Type safety with proper atomic types instead of compiler built-ins - Consistent error handling and memory management patterns - Improved maintainability for adding new cluster modules Impact: - Maintains exact same functionality while dramatically improving code quality - Better performance for read operations (load vs __sync_fetch_and_add) - Foundation for future threading optimizations - Cleaner, more maintainable clustering codebase	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 ... This commit implements comprehensive PostgreSQL cluster synchronization functionality to resolve issue #5147 where ProxySQL didn't sync PostgreSQL settings between cluster instances. **Changes Made:** ### 1. Added PostgreSQL Cluster Query Definitions (ProxySQL_Cluster.hpp) - CLUSTER_QUERY_RUNTIME_PGSQL_SERVERS - CLUSTER_QUERY_PGSQL_SERVERS_V2 - CLUSTER_QUERY_PGSQL_USERS - CLUSTER_QUERY_PGSQL_QUERY_RULES - CLUSTER_QUERY_PGSQL_QUERY_RULES_FAST_ROUTING ### 2. Extended Cluster Structure (ProxySQL_Cluster.hpp & proxysql_admin.h) - Added PostgreSQL checksum values to ProxySQL_Node_Entry - Added cluster admin variables: - cluster_pgsql_query_rules_diffs_before_sync - cluster_pgsql_servers_diffs_before_sync - cluster_pgsql_users_diffs_before_sync - cluster_pgsql_*_save_to_disk variables ### 3. Implemented PostgreSQL Peer Pull Functions (ProxySQL_Cluster.cpp) - pull_pgsql_query_rules_from_peer() - pull_runtime_pgsql_servers_from_peer() - pull_pgsql_servers_v2_from_peer() - pull_pgsql_users_from_peer() - get_peer_to_sync_pgsql_*() functions ### 4. Added Admin Variable Support (ProxySQL_Admin.cpp) - Added PostgreSQL cluster variables to admin interface - Implemented GET and SET handlers for all new variables - Integrated with existing variable initialization system ### 5. Integrated PostgreSQL Sync into Cluster Monitoring - Added PostgreSQL diff variables to monitoring logic - Implemented complete sync detection and conflict resolution - Added debug and error logging for PostgreSQL sync operations **Key Features:** - Full compatibility with existing MySQL cluster sync patterns - Configurable sync thresholds and persistence options - Checksum-based change detection and conflict resolution - Comprehensive logging and debug support - Reuses existing MySQL sync infrastructure for consistency This implementation enables ProxySQL clusters to automatically synchronize PostgreSQL servers, users, and query rules between all cluster members, providing the same level of high availability and consistency for PostgreSQL as was already available for MySQL. Resolves: #5147	7 months ago
Rahim Kanji	38befb845f	Fixed PROXYSQL STOP	8 months ago
Wazir Ahmed	5219d4be93	processlist: Prevent crash due to SQLITE_TOOBIG ... - Add new mysql/pgsql variable `processlist_max_query_length`. - Min: 1K - Max: 32M - Default: 2M - Truncate current query based on the configuration before inserting into `stats_*_processlist` tables. - Refactor/fix code related to other processlist configurations. 1. `session_idle_show_processlist` value was not updated in `ProxySQL_Admin.variables`. 2. Pass processlist config as an argument to `MySQL_Threads_Handler::SQL3_Processlist` instead of using thread-local variables. Signed-off-by: Wazir Ahmed <wazir@proxysql.com>	8 months ago
René Cannaò	ecad6f9249	Merge pull request #5160 from sysown/v3.0_disable_pgsql_prometheus_5159 ... Separate Query Cache Metrics for MySQL and PostgreSQL & Disable Prometheus Metrics for PostgreSQL	9 months ago
René Cannaò	abafaccbc0	Merge pull request #5156 from sysown/v3.0_pgsql_stat_activity_issue_4682 ... Add backend_pid and backend_state to stats_pgsql_processlist and create stats_pgsql_stat_activity view	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 ... - Added `backend_pid` and `backend_state` columns to `stats_pgsql_processlist` to display PostgreSQL backend process ID and connection state. - Created `stats_pgsql_stat_activity` view on top of `stats_pgsql_processlist` with column aliases matching PostgreSQL's `pg_stat_activity` for consistency.	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 ... skip processing the Describe Portal. This is because libpq automatically includes a Describe Portal during execution, and sending it again would be redundant. * Removed server_capabilities from PgSQL modules	12 months ago
René Cannaò	c48c3310a6	Check if database file exists before checking if it is writable ... Related to bf3cca8639	1 year ago
René Cannaò	bf3cca8639	exit if database file is not writable ... If database file (proxysql.db) is not writable, exit immediately instead of crashing because it is not writable. See issue #4893	1 year ago
René Cannaò	cb53db81ca	Export MySQL_Logger metrics for v3.0 ... Port of #4802	1 year ago
René Cannaò	2551d350e9	Port to 3.0 of in-memory query logging ... See #4713 for further details	1 year ago
Javier Jaramago Fernández	9e941854c3	Replace table based 'VACUUM' for SQLite3 'stats' database ... Introduced generic approach based on the potential benefits for 'VACUUM' over the 'stats' database instead of the previous selective, table based, approach.	1 year ago
René Cannaò	b9dcc9420a	PROXYSQL FLUSH LOGS forces debug database flush ... Also increased barching size from 31 to 100	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 ... * Added Query Cache Support for PgSQL: * Introduced new variables for PgSQL Query Cache management: * pgsql-query_cache_size_MB * pgsql-query_cache_soft_ttl_pct * pgsql-query_cache_stores_empty_result * pgsql-query_cache_handle_warnings (not yet utilized) * Overwriting Transaction Status: * Sending current transaction state to the client when a result is returned from the query cache. * This currently does not differentiate between normal and error transaction states—both are treated as active transaction states. * Cache Lifetime Management: Replaced manual reference counting with std::shared_ptr to efficiently manage the lifecycle of cache entries, ensuring proper memory deallocation and reducing complexity. * Unified Purging Logic: Refactored the query cache purging logic to use a single thread for both MySQL and PgSQL cache entries. * Code Cleanup: Removed unnecessary methods and data members to streamline the codebase and improve maintainability. * Performance Optimization: Improved memory management, reducing memory footprint and enhancing performance.	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 ... Refactored Query Processor [WIP]	2 years ago
Rahim Kanji	e723082a1b	Refactored Query Processor Architecture ... - Introduced separate query processors for MySQL and PostgreSQL. - Removed unnecessary GTID logic from `PgSQL_Session`. - Added a command counter for PostgreSQL queries. - Refactored `Query_Processor` to serve as a base class containing core functionalities applicable to both MySQL and PostgreSQL. Changes: - Removed GTID-related code from `PgSQL_Logger` and `PgSQL_Session`: - bool with_gtid; - char gtid_buf[128]; - int gtid_hid; - Added new PostgreSQL-specific tables: - `pgsql_query_rules`, `pgsql_firewall_whitelist_rules`, `pgsql_query_rules_fast_routing` - `runtime_pgsql_query_rules`, `runtime_pgsql_firewall_whitelist_rules`, `runtime_pgsql_query_rules_fast_routing` - Added PostgreSQL-related variables: pgsql_thread___commands_stats pgsql_thread___query_digests pgsql_thread___query_digests_lowercase pgsql_thread___query_digests_no_digits pgsql_thread___query_digests_replace_null pgsql_thread___query_digests_normalize_digest_text pgsql_thread___query_digests_track_hostname pgsql_thread___query_digests_keep_comment pgsql_thread___query_digests_max_digest_length pgsql_thread___query_digests_max_query_length pgsql_thread___query_digests_grouping_limit pgsql_thread___query_digests_groups_grouping_limit pgsql_thread___enable_load_data_local_infile pgsql_thread___auditlog_filename pgsql_thread___auditlog_filesize pgsql_thread___eventslog_filename pgsql_thread___eventslog_filesize pgsql_thread___eventslog_default_log pgsql_thread___eventslog_format pgsql_thread___firewall_whitelist_errormsg pgsql_thread___firewall_whitelist_enabled pgsql_thread___query_processor_iterations pgsql_thread___query_processor_regex	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 ... 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 ... 'stats_pgsql_client_host_cache_reset' tables.	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 ... * Implemented 'SHOW FULL PGSQL PROCESSLIST' command. * Implemented 'SHOW PGSQL PROCESSLIST' command.	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 ... This fixes a regression introduced in 14ba7475d4 . Up to ProxySQL 2.5.1 , stats_mysql_query_digest.digest was uppercase . From ProxySQL 2.5.2 to 2.6.4 it became lowercase . This because we switched from: sprintf(... 0x16llX ...) to: ostringstream ... << "0x" << std::hex ...	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 ... * Removed unused columns from pgsql_users. * Fixed checksum computation for mysql_users. * Fixed saving of pgsql_users and pgsql_servers to disk during initial load of ProxySQL from the configuration file..	2 years ago
Rene Cannao	7fe013fac2	Merge branch 'proxysql_v2.x_240813' into v2.x_postgres_merge_v2.x_240813 ... This merges ProxySQL v2.x up to 2024-08-13	2 years ago
Javier Jaramago Fernández	130d3fe04a	Issue warning when time interval variable gets rounded ... Variables specifying timing intervals, like 'stats_mysql_connections', may get rounded to the closer, valid time interval. Now a warning is issued for making the user aware of this rounding operation.	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 ... PRAGMA journal_mode=OFF should drastically reduce CPU overhead	2 years ago
Rene Cannao	a3193ad1dd	PRAGMA journal_mode=OFF on debug database ... PRAGMA journal_mode=OFF should drastically reduce CPU overhead	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 ... various FreeBSD related fixes	2 years ago
René Cannaò	2eb1d0d1c1	Merge pull request #20 from sysown/v2.x_postgres_backend ... Added generic error handling, transaction detection and handling	2 years ago
Andriy Utkin	5e79afa8e0	Set thread names	2 years ago
Rahim Kanji	c5c9b4c8d7	Changed PostgreSQL default port ... * Changed admin port from 6034 to 6132 * Changed pgsql backend port from 6035 to 6133	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 ... * Implemented generic error handling to cover all the scenarios. * Extraction of results from PGconn in case of connection errors. Introduced a patch to facilitate this. * Added transaction handling. * Ready packet now includes transaction status. * Split command completion and ready packet to increase flexibility. * Resolved multiple bugs to enhance stability.	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. ... Using a few MySQL thread variables, particularly for query digest, query processor, and query cache. In the future, we plan to create a global variable for modules that are common to both MySQL and PGSQL	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()" ... This reverts commit a43a1ccc40.	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 ... This seems to speedup compile time, and also lead to smaller binary	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 ... Merged main ProxySQL code up to commit 959c629	2 years ago
René Cannaò	d3a90a8ef6	Some refactoring of ProxySQL_Admin ... Related to flush_XXXXX_variables___database_to_runtime(). Added three new functions then used by the various main functions(): * flush_GENERIC_variables__retrieve__database_to_runtime() * flush_GENERIC_variables__checksum__database_to_runtime() * flush_GENERIC_variables__process__database_to_runtime()	2 years ago
Javier Jaramago Fernández	e91bcd2c81	Move Admin 'HTTP_Server' and 'RESTAPI' init to end of phase3 - Closes #4510 ... Prevents invalid accesses that this modules can perform on other yet non-initialized modules during boot process.	2 years ago
René Cannaò	7a50a68f28	Split of ProxySQL_Admin.cpp ... ProxySQL_Admin.cpp as become very big, thus it is time to split it in smaller files for better reasibility and processing. Still a work in progress.	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 ... # Conflicts: # include/MySQL_Session.h # lib/Makefile # lib/MySQL_Session.cpp # lib/MySQL_Thread.cpp # lib/ProxySQL_Admin.cpp # lib/ProxySQL_Poll.cpp	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) ... * Fixed few bugs * Added Load and Save commands for PostgreSQL tables	2 years ago
Rahim Kanji	e029d39007	Initial PostgreSQL commit ... * Added plain text and SCRAM authentication	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 ... Introducing mysql_servers_ssl_params	2 years ago
René Cannaò	ee4cd19a07	Merge pull request #4459 from sysown/v2.x_openssl_verify_load_cacert_duration ... ProxySQL Test to evaluate loading and verifying CA Certificate 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 ... First commit to introduce table mysql_servers_ssl_params . This allows to configure per host SSL parameters.	2 years ago
René Cannaò	53262987ac	Added new status variable mysql_listener_paused ... New variable mysql_listener_paused added to table stats_mysql_global . The variable is a boolean: - true : listener is paused because PROXYSQL PAUSE was executed - false : listener is not paused The variable is also reported by Prometheus exporter as proxysql_mysql_listener_paused Related to #4391	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 ... Merge of several PRs into single one	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 ... Fix interactions between 'checksum_%' and '%_diffs_before_sync' variables	3 years ago
René Cannaò	b6deb15ec3	Merge pull request #4372 from sysown/v2.x_prep_stmt_mem_usage ... Added memory usage monitoring for the prepared statement cache.	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' ... - Introduced dependency between 'checksum_variables' and their corresponding '%_diffs_before_sync' variable. Checksum variables being 'false' implies a '0' value. Variable dependencies need to be introduced in the handler for both variables, since order can't be assumed. - Added missing sets statements for 'GloProxyCluster' variables when updating '%_diffs_before_sync'. - Fixed typo in 'cluster_ldap_variables_diffs_before_sync' handling, creating unintentional checksum resets.	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. ... * Added missing 'servers_defaults' column in ProxySQL cluster syncing.	3 years ago
Rahim Kanji	989687c68a	Implemented memory usage monitoring for the prepared statement cache with the following changes: ... * Added two new variables to the 'stats_memory_metrics' table: prepare_statement_metadata_memory prepare_statement_backend_memory * Introduced corresponding variables in the Prometheus exporter to measure memory usage of prepare statement metadata and prepare statement backend.	3 years ago
Javier Jaramago Fernández	ecf4f69fe0	Fix Admin support for MySQL client '8.1.0' - Closes #4300 ... MySQL client check command for dollars quote support ('SELECT $$'), is now intercepted in both MySQL and Admin interfaces. The error reported to the client is dependent of 'mysql-server_version' variable value.	3 years ago
Javier Jaramago Fernández	a4b6bd0b8f	Refactor and homogenization of checksums computation ... - Simplified checksum computation for monitoring actions - Refactored checksum computation for 'mysql_servers' and 'mysql_servers_v2' modules in 'commit'.	3 years ago
Javier Jaramago Fernández	3b8e23e75a	Fix invalid fallback response for 'CLUSTER_QUERY_MYSQL_SERVERS_V2' ... If 'MySQL_HostGroups_Manager::incoming_mysql_servers' happens to be empty when a 'CLUSTER_QUERY_MYSQL_SERVERS_V2' request is received in Admin, since there wasn't any user config promoted to runtime yet, the response should be an empty resulset.	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' ... - Resultsets for 'runtime_mysql_servers' and 'mysql_servers_v2' are now directly generated by the SQL query. - Checksum computations are simplified to 'SQLite3_result::raw_checksum' and equivalent function 'mysql_raw_checksum'.	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 ... - Preserve old simulator behavior via 'TEST_AURORA_RANDOM' macro. - Add new deterministic behavior for testing particular scenarios. - Add support for simulating multiple clusters via an updated 'REPLICA_HOST_STATUS' table and hostgroup based selection. - Provide a sensible default population for manual testing.	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 ... Closing the file descriptors also on REST API after the fork. It excludes all the pipes. close_all_non_term_fd() accepts a vector of FDs to exclude	3 years ago
René Cannaò	7899ca1d5f	Close all FDs in Scheduler ... When scheduler calls ProxySQL_External_Scheduler::run_once() , after fork() we call close_all_non_term_fd() to close all file descriptors.	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 ... # Conflicts: # lib/MySQL_HostGroups_Manager.cpp # lib/ProxySQL_Cluster.cpp	3 years ago
René Cannaò	85777ee63a	Merge pull request #4242 from sysown/v2.x_ssl_keylog_support ... Special handling of relative file paths supplied in the 'admin-ssl_keylog_file' variable	3 years ago
Rahim Kanji	ada4621401	Special handling for 'admin-ssl_keylog_file' is only filename is provided.	3 years ago