342 Commits (v3.0.0-alpha)

Author	SHA1	Message	Date
Javier Jaramago Fernández	705f50e0f9	Add initial POC for PostgreSQL monitoring support	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ò	38350292e2	Merge pull request #4600 from sysown/v2.x_proxy ... Implementation of PROXY protocol V1	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	ee5b1fc795	Merge remote-tracking branch 'Master_POSTGRES/v2.x_postgres' into v2.x_postgres_reset_connection	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
Rene Cannao	d85430b709	Implementation of PROXY protocol V1 ... This commit introduces: - class ProxyProtocolInfo() , that: - performs parsing - validates subnet - run automated tests in DEBUG build - variable mysql-proxy_protocol_networks . Accepted values: - empty string: disables PROXY protocol - '*' : allows connections from any IP - comma separated list of subnets - automated testing in DEBUG build during start - export of PROXY protocol information in internal session, using PROXY_V1 - a TAP test to verify various connections	2 years ago
Rahim Kanji	db3fe26590	PgSQL_Thread will now reset connections independently, eliminating the ... need for connections purger HGCU_thread_run(). Changes made: Removed pgsql-reset_connection_algorithm Removed pgsql-connpoll_reset_queue_length Removed HGCU_thread_run()	2 years ago
Rahim Kanji	058be0d9ae	* Reset the connection if there is a mismatch between client and server ... session variables. * Changing the user on the same connection is not supported in PostgreSQL. If a connection with a different username is needed, a new connection will be created; otherwise, a connection with the same username will be selected from the connection pool. * Added RESET SESSION timeout.	2 years ago
Rahim Kanji	a22aeca394	Reset Session Implementation ... * Added Reset Session support * Removed dead code	2 years ago
Javier Jaramago Fernández	b91b6b8f9f	Add list of special permitted variables tracking errors - Closes #4591 ... This list hold tracking errors that in practice are equivalent to ER_UNKNOWN_SYSTEM_VARIABLE and that we want to handle in the same way.	2 years ago
Rene Cannao	ae1e088d82	Initial work to write Base_Session	2 years ago
Rahim Kanji	4244e32ed0	Added pgsql-default_client_encoding incase client doesn't provide one	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
René Cannaò	de345ecaed	Merge remote-tracking branch 'public/v2.x' into v2.x_postgres_240422	2 years ago
René Cannaò	9283cd2e9b	Code cleanup in MySQL_Thread::refresh_variables() ... Use macros to avoid repeating variable name and strings with the variable name. Because this commit avoids duplications of name and literals, this commit also renames: mysql_thread___monitor_groupreplication_max_transaction_behind_for_read_only to: mysql_thread___monitor_groupreplication_max_transactions_behind_for_read_only	2 years ago
Rahim Kanji	962e8c03e9	Added SSL connection support for PostgreSQL connection. ... * Added pgsql-have_ssl variable Note: There is a retrying mechanism when authentication fails if sslmode is prefer which seems incorrect. Need to investigate it.	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
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
Anphuc Bui	e0db02df27	Merge branch 'v2.x' into v2.x	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
René Cannaò	984582eaae	Renamed variable evaluate_replication_lag_on_servers_load ... Renamed variable from: mysql-recover_replication_lag_shunned_servers_on_comit to: mysql-evaluate_replication_lag_on_servers_load	2 years ago
Rahim Kanji	b75b05c392	Restore servers that are in a shunned state due to replication lag only upon commit (triggered by the command LOAD MYSQL SERVERS TO RUNTIME), provided that the replication lag is below the maximum threshold.	2 years ago
Anphuc Bui	0bcddd0002	Merge branch 'v2.x' into v2.x	2 years ago
anphucbui	bb35b20719	Moving core discovery logic to fit into read_only framework as a new task type	2 years ago
René Cannaò	d2c8d655a8	Deprecate mysql-default_tx_isolation #4335 ... Variable mysql-default_tx_isolation is unused.	2 years ago
René Cannaò	c3c9746bbc	Merge branch 'v2.x' into v2.x_sha2pass_draft3	2 years ago
anphucbui	5a3037785f	Add support for AWS RDS MySQL Multi-AZ Cluster auto-discovery	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
Rahim Kanji	743cd502a5	* Updated variable name from 'mysql-query_cache_with_warnings_support' to 'mysql-query_cache_handle_warnings' ... * Introduced global variable 'mysql-handle_warnings' to control warning support in ProxySQL * Included 'handling_warnings' flag in the 'mysql_hostgroup_attributes' table (hostgroup_settings). This flag holds top priority and can override the value of the global variable 'mysql_handle_warnings'.	3 years ago
Rahim Kanji	6b295477d6	Enhanced Warnings handling in ProxySQL: ... * Implemented 'SHOW WARNINGS' and 'SHOW COUNT(*) FROM WARNINGS' query handling. * When a query produces warnings, the warning count is now included in the query response. Additionally, a new variable 'mysql-query_cache_with_warnings_support' has been introduced for the query cache feature: * A value of '0' means that if a query execution produces warnings, the resultset will not be saved in the query cache. * A value of '1' indicates that if a query produces warnings, the resultset will be saved in the query cache, but the warning count in that resultset will be set to '0'. ** Note: * Warning handling is dependent on the query digest and 'mysql-query_digests' must be enabled for it to work. * Warnings saved in logfile ['mysql-log_mysql_warnings_enabled'] and the current feature can work in conjunction with each other.	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
René Cannaò	299c833eb3	Merge pull request #4283 from sysown/v2.x_reordering_mysql_variables ... Reordered SQL_ISOLATION_LEVEL, SQL_TRANSACTION_READ, and SQL_WSREP_SYNC_WAIT tracked variables	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
Rahim Kanji	8d03589cf9	Moved SQL_ISOLATION_LEVEL, SQL_TRANSACTION_READ, and SQL_WSREP_SYNC_WAIT to the higher bound.	3 years ago
Rahim Kanji	a3d29863e8	Adding SET TRANSACTION ISOLATION LEVEL * support	3 years ago
René Cannaò	9ede04de52	Merge branch 'v2.x' into v2.x_sha2pass_draft3	3 years ago
René Cannaò	37f8a50b90	Adding variable mysql-set_parser_algorithm ... Variable mysql-set_parser_algorithm defines which algorithm is used by SetParser for the parsing of SET statements. If value is 1: parse1() is used If value is 2: parse1v2() is used parse1v2() allows also the using a single SetParser per MySQL_Thread to process all SET statements. Regex is compiled only once. set_testing-240-t was also modified to test both algorithms	3 years ago
René Cannaò	73ac61b0fb	Remove tracking of log_queries_not_using_indexes ... log_queries_not_using_indexes is not enabled because in MySQL it is *only* a global variable, while in MariaDB is a global *and* session variable . We believe it is not the time to create a lot of exceptions and complex logic for conflicting backend implementations	3 years ago
René Cannaò	dc732c5628	Add support for sql_quote_show_create #4254	3 years ago
René Cannaò	32fb42245a	Adding 2 variables in possible_unknown_variables	3 years ago
René Cannaò	76bb204f14	New variable mysql-default_authentication_plugin ... New MySQL variable default_authentication_plugin accepting two possible values: * mysql_native_password * caching_sha2_password	3 years ago