3879 Commits (2.6.6)

Author	SHA1	Message	Date
René Cannaò	8ab51c65e7	ssl_params: use NULL instead of empty string #4466 ... If values in mysql_servers_ssl_params are empty strings, they needs to be passed as NULL arguments in mysql_ssl_set() and mysql_options() Closes #4466	2 years ago
Anphuc Bui	e0db02df27	Merge branch 'v2.x' into v2.x	2 years ago
anphucbui	d04173b026	Update discovery logic to add discovered servers with default values instead of originating server's values, add new field in mmsd for reader hostgroup, and query monitor db instead of admin db	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
René Cannaò	b7f53c10a2	Merge pull request #4258 from sysown/v2.x_sha2pass_draft3 ... V2.x sha2pass draft3	2 years ago
Rahim Kanji	ee3d24121e	Update MySQL_PreparedStatement.cpp ... * Fixed typo * Added comment	2 years ago
René Cannaò	548ededd4f	Include MySQLServers_SslParams in MySQL_Connection ... This allows to preserve the parameters, and output in the error log if needed	2 years ago
René Cannaò	fdd800a217	Avoid fast retry on cluster	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
Javier Jaramago Fernández	1bc309bbf6	Fix buffer over-read on concurrent SHA2 auths ... During an full 'caching_sha2_password' auth, it's possible that the pass has been updated in 'GloMyAuth'. If this possibility is not taking into account buffer over-read could take place and valid auth attempts denied.	2 years ago
Javier Jaramago Fernández	ed3a5d7734	Add doc for 'switching_auth_type' in SHA2 full	2 years ago
Javier Jaramago Fernández	ab8af07c19	Add 'switching_auth_sent' to 'PROXYSQL INTERNAL SESSION' ... Improved observability for auth switch performed during authentication. The new field 'switching_auth_sent' is only updated when an actual auth switch requested to the client.	2 years ago
Javier Jaramago Fernández	3f2a7aa693	Fix memory issues during 'chaching_sha2' auth ... Auth 'caching_sha2_password' imposses and async flow on several previously sync functions. This new async flow needs to take into account the potential allocations for 'MySQL_Session' attributes and client connection userinfo.	2 years ago
René Cannaò	b3dcee9c53	Merge pull request #4448 from sysown/v2.6.0-update_to_openssl_v3.2.1 ... update OpenSSL from v3.1.4 to v3.2.1	2 years ago
René Cannaò	6e18b04290	Merge pull request #4450 from sysown/v2.x_shun_replication_lag ... Restore shunned server (due to replication lag) state on commit, provided that the replication lag is below the maximum threshold.	2 years ago
René Cannaò	6a6807c07c	Merge pull request #4455 from sysown/v2.x_memleak_fix_stats_mysql_prepared_statements_info ... Fixed memory leak issue in querying of stats_mysql_prepared_statements_info table + Resolved a heap use-after-free issue	2 years ago
René Cannaò	5c42db6696	If cluster synchnonization fails , wait 1 second ... This is a simple way to slow down loops	2 years ago
René Cannaò	0e0db46db3	Fixing offset in cluster results	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ò	da039d1fd0	Fix bug in previous commit	2 years ago
René Cannaò	385e109501	Initialize incoming_mysql_servers_ssl_params to NULL	2 years ago
René Cannaò	8e6bd3e983	Add mysql_servers_ssl_params to MyHGM	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ò	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	4c1974ce08	Fixed memory leaks in ProxySQL HTTP Server	2 years ago
Rahim Kanji	3f7a90ce97	Fixed heap use after free issue.	2 years ago
Rahim Kanji	e53cd200ab	Code cleanup	2 years ago
Rahim Kanji	1e4c108659	Fixed memory leak in querying stats_mysql_prepared_statements_info	2 years ago
Rahim Kanji	5bdb8e11e5	Fixed error message	2 years ago
Rahim Kanji	b2549127ee	Resolving node's hostname in the event of a connection error and when executing the "LOAD PROXYSQL SERVERS TO RUNTIME" command	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
Miro Stauder	0971a48f9d	update OpenSSL from v3.1.4 to v3.2.1	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
Javier Jaramago Fernández	ce67a50cfc	Fix missing update for session 'clear_text_password' ... During first 'caching_sha2_password' login, 'clear_text_password' is unknown until authentication is completed. Info previously fetched from 'MySQL_Authentication' should be amended with the received password.	2 years ago
Javier Jaramago Fernández	bd7ab0d801	Fix empty passwords handling for 'caching_sha2_password'	2 years ago
René Cannaò	06844eda3f	Merge pull request #4429 from sysown/v2.x-4335 ... Deprecate mysql-default_tx_isolation #4335	2 years ago
Javier Jaramago Fernández	e93b243a16	Fix variable overflow on 'sha256_crypt_r'	2 years ago
René Cannaò	1516097d74	Merge pull request #4432 from sysown/v2.x-year ... Update copyright year	2 years ago
René Cannaò	bb562ec484	Update copyright year	2 years ago
René Cannaò	7f57f20e5a	Merge pull request #4430 from sysown/v2.x-4241 ... Added metric MultiplexDisabled_ext #4241	2 years ago
René Cannaò	7d429c69ad	Merge pull request #4428 from sysown/v2.x-pause_status ... Added new status variable mysql_listener_paused	2 years ago
René Cannaò	acf2b7bd7e	Merge pull request #4427 from sysown/v2.x-4396 ... Handle STATUS command without backends	2 years ago
René Cannaò	26738b4c15	Merge pull request #4425 from sysown/v2.x-4355 ... Fast shutdown for TERM signal #4355	2 years ago
René Cannaò	41cd740701	Added metric MultiplexDisabled_ext #4241 ... In the output of PROXYSQL INTERNAL SESSION and stats_mysql_processlist.extended_info , MultiplexDisabled was only returning the output of MySQL_Connection::MultiplexDisabled() . If there was a transaction, or an error, multiplexing was disabled but MultiplexDisabled() was still reporting false. Therefore it was necessary to also check server_status flag and last_errno. This commits intruduces MultiplexDisabled_ext , that reports the output of: MySQL_Connection::MultiplexDisabled() || MySQL_Connection::isActiveTransaction() This should make troubleshooting easier. Also, removed any reference to deprecated STATUS_MYSQL_CONNECTION_TRANSACTION . Closes #4241	2 years ago
René Cannaò	d2c8d655a8	Deprecate mysql-default_tx_isolation #4335 ... Variable mysql-default_tx_isolation is unused.	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ò	e958946b82	Handle STATUS command without backends ... Handles special queries executed by the STATUS command in mysql cli . Specifically: - "select DATABASE(), USER() limit 1" - "select @@character_set_client, @@character_set_connection, @@character_set_server, @@character_set_database limit 1" Closes #4396 Closes #4426	2 years ago
René Cannaò	93fca24914	Fast shutdown for TERM signal #4355 ... Closes #4355	2 years ago
René Cannaò	496ee02cae	Input validation for mysql-server_capabilities ... Input validation on mysql-server_capabilities assumed that it was 16 bits (for historical reasons). This has now improved and supports up to 32 bits. Notes: - some capabilities are changed at runtime while performing the handshake with the client - even if we support 32 bits capabilities, many of them do not have any real meaning for proxysql (not supported) Closes #2091	2 years ago
René Cannaò	29b7cd0529	Modify generate_one_byte_pkt() ... Modified generate_one_byte_pkt() to prefix the data with 1 byte. This is the "equivalent" of what MySQL performs in wrap_plguin_data_into_proper_command() , prefixing the data with a command	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
René Cannaò	c0ea4d6392	Merge pull request #4414 from sysown/v2.x_issue_4399 ... Fixed crash on frequently querying stats_mysql_query_digest* tables	2 years ago
Javier Jaramago Fernández	862a1a7085	Fix Admin deadlock on concurrent connections - Closes #4415	2 years ago
Rahim Kanji	6156125905	Fixed ProxySQL crash on querying stats_mysql_query_digest and stats_mysql_query_digest_rest	2 years ago
René Cannaò	83cf46dd83	Merge branch 'v2.x' into v2.x-aurora_autodiscovery-refactor_cluster_mysql_servers-gr_bootstrap_mode	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
Rahim Kanji	282aae705d	Merge remote-tracking branch 'Master/v2.x' into v2.x_unified_makefile_fixes ... # Conflicts: # lib/Makefile	3 years ago
René Cannaò	3c2418246c	Merge branch 'v2.x' into v2.x_sha2pass_draft3	3 years ago
Rahim Kanji	6cb80643f5	Merge remote-tracking branch 'Master/v2.x' into v2.x_unified_makefile_fixes ... # Conflicts: # test/tap/tap/Makefile # test/tap/tests/Makefile	3 years ago
René Cannaò	bd7846f430	Move ProxySQL_Poll() to its own source file	3 years ago
René Cannaò	5181812065	Removed redundant near_pow_2()	3 years ago
René Cannaò	699fe7efcd	Moved proxysql_find_charset_* functions out of MySQL_Thread.cpp	3 years ago
René Cannaò	1e98de78af	Merge pull request #4365 from sysown/v2.x_warning_support ... Added warnings handling	3 years ago
Rahim Kanji	4af5dd2a1d	Merge remote-tracking branch 'Master/v2.x' into v2.x_testing_ci_test_failures ... # Conflicts: # deps/Makefile # lib/set_parser.cpp	3 years ago
René Cannaò	8fdc7f010e	Merge pull request #4340 from sysown/v2.x-2.6_new_defaults_2 ... V2.x new default for mysql-set_parser_algorithm	3 years ago
Javier Jaramago Fernández	bb0f2da42c	Fix Valgrind reported 'realloc' of zero length	3 years ago
Rahim Kanji	8606742583	Merge remote-tracking branch 'Master/v2.x' into v2.x_warning_support_final ... # Conflicts: # test/tap/tests/set_testing-240-t.cpp	3 years ago
Miro Stauder	c92a93b69b	fix conditional debug messages	3 years ago
Miro Stauder	e3c1d9bc7c	refactor makefiles	3 years ago
Rahim Kanji	09eb50a83e	Remove any trailing spaces and semicolons from the SET statement	3 years ago
Rahim Kanji	e1c489acb1	* If the backend server has CLIENT_DEPRECATE_EOF enabled, and the client does not support CLIENT_DEPRECATE_EOF, warning_count will be '0' in intermediate EOF packet. ... * Suppress the display of warning counts in the "SHOW WARNINGS" statement.	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
Rahim Kanji	045d6bcaeb	* Execute all test cases with 'CLIENT_DEPRECATE_EOF' both enabled and disabled. ... * Introduced 'ps_type' enum to differentiate between preparing a statement and executing a statement * Fixed issue where the warning count fails to reset when the SET statement generates a warning. * Resolved the issue where the 'server_status' and 'warning count' were not accurately represented in the statement. * Replaced 'mysql_warning_count' with 'mysql_stmt_warning_count' for retrieving the warning count in statements. * Added 'handle_warning' field in hostgroup_attributes TAP test * Updated warnings TAP test	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
Rahim Kanji	dae3d669b9	* Setting 'warning_count' as soon as query is executed. ... * 'MySQL_Connection::warning_count' will be globally employed for managing multiplexing control and transmitting the warning count to the client * Fixed prepare statement bug: When preparing, if the digest matches, the result set is retrieved from the cache and sent to the client. Note: Currently using 'mysql_warning_count' to retrieve the warning count for prepared statement.	3 years ago
René Cannaò	eb2a1eccef	Merge pull request #4374 from sysown/v2.x_hostgroup_attr_settings ... Introduced 'hostgroup_settings' column to 'mysql_hostgroup_attributes' and it's counterpart 'runtime_hostgroup_attributes' table	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	05208e2839	* Update warning_count as soon as query is executed.	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
René Cannaò	f16290d78d	Prevent assert after fcntl() for O_NONBLOCK ... There are several asserts after fcntl() in MySQL_Thread::create_new_session_and_client_data_stream() . This commit removes the assert after F_SETFL with O_NONBLOCK. This because it is possible that proxysql is already shutting down. The entry in the error log is kept.	3 years ago
Rahim Kanji	1807315950	Merge branch 'v2.x_hostgroup_attr_settings' into v2.x_warnings_support	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
René Cannaò	983062e3da	Merge pull request #4317 from sysown/v2.6-CodeQL-fixes ... various warnings fixes	3 years ago
Rahim Kanji	b588798a08	Few fixes	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
Rahim Kanji	d2b8f7d54e	Fixed code style	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
Rahim Kanji	52f206d36c	Added writer_hostgroup in duplicate check.\n Added INSERT OR IGNORE on mysql_server_galera_log table.	3 years ago
Rahim Kanji	90e3247bf3	Added duplicate server check to prevent redundant server inspections, that can cause unique constraint error on mysql_server_galera_log table.	3 years ago
René Cannaò	2ddc8186b7	Revert "Revert "Remove trailing spaces and semicolon from SET statements #4341"" ... This reverts commit 707ec90f7b.	3 years ago
René Cannaò	707ec90f7b	Revert "Remove trailing spaces and semicolon from SET statements #4341" ... This reverts commit 5ccd4154f6.	3 years ago
René Cannaò	5ccd4154f6	Remove trailing spaces and semicolon from SET statements #4341	3 years ago
René Cannaò	06d4579654	More fixed on Set Parser 2	3 years ago
René Cannaò	454ab610f6	Minor improvement on generateRE_parse1v2	3 years ago
René Cannaò	7f75053926	Minor improvement on generateRE_parse1v2	3 years ago
René Cannaò	18d8e69b19	Changing default for set_parser_algorithm	3 years ago
René Cannaò	97b49849b8	Change default query_digests_groups_grouping_limit	3 years ago
René Cannaò	6b84b42a68	Note on set_parser_algorithm ... A commit just to trigger CI	3 years ago
René Cannaò	dc364eb254	Temporary reverse set_parser_algorithm to 1	3 years ago
René Cannaò	b93df2e958	Changing several defaults ... * monitor_history from 600000 to 7200000 (from 10 minutes to 2 hours) * use_tcp_keepalive from false to true * tcp_keepalive_time from 0 to 120 * set_parser_algorithm from 1 to 2 * server_version from 5.5.30 to 8.0.11 * have_ssl from false to true	3 years ago
Javier Jaramago Fernández	bb2b429bca	Simplify check introduced in commit '6c9e4c05' ... - Removed redundant part of check. - Updated comment, elaborating on 'POLLHUP' omission in the check.	3 years ago
Javier Jaramago Fernández	6c9e4c058b	Fix infinite loop for SSL connections - Closes #4314 ... If a peer closes the socket under certain timing conditions, e.g. during connection establishment, an infinite loop will take place if 'POLLHUP' and 'POLLIN' are set in the socket, and no data is present, just the final 'EOF'.	3 years ago
Miro Stauder	b1dc534757	refactor out pktH	3 years ago
Miro Stauder	917154bf93	fix pktH init/destructor	3 years ago
Miro Stauder	61f0c4636b	various warnings fixes	3 years ago
René Cannaò	ef17fca532	Merge pull request #4310 from sysown/v2.x_update_dns_records_count ... Increment DNS cache record count when the records are cleared from the DNS cache, given that both the MySQL servers and ProxySQL servers tables are empty	3 years ago
René Cannaò	9af1e9321a	Merge pull request #4308 from sysown/v2.x-4300 ... Fix Admin support for MySQL client `8.1.0` - Closes #4300	3 years ago
René Cannaò	970d06b98b	Merge pull request #4303 from sysown/v2.x-clickhouse230726 ... V2.x minor fixes for Clickhouse Server	3 years ago
Javier Jaramago Fernández	a9e8d7e657	Fix minor typo in 'get_dollar_quote_error'	3 years ago
Rahim Kanji	8792a64c0a	Increment DNS cache record count when the records are cleared from the DNS cache, given that both the MySQL servers and ProxySQL servers tables are empty.	3 years ago
René Cannaò	cc8888449a	Support for DECIMAL in Clickhouse ... A previous commit was not correctly handling date/time. Improved testing	3 years ago
Javier Jaramago Fernández	bfca112ca7	Merge branch 'v2.x' of github.com:sysown/proxysql into v2.x-4300	3 years ago
Javier Jaramago Fernández	600ddfa154	Make dollar sign support check '8.1' specific #4300	3 years ago
René Cannaò	07d09c0bab	Merge pull request #4306 from sysown/v2.x-4264 ... Fix `COMMIT|ROLLBACK` forwarding to backend connections - Closes #4264	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
René Cannaò	dc580e9f92	Graceful handle DB::Exception but not Illegal type ... Partial revert of commit bf87d8d911	3 years ago
Javier Jaramago Fernández	bb40e9e431	Fix 'COMMIT|ROLLBACK' forwarding to backend connections - Closes #4264 ... These commands are now forwarded to the backend connections from a session with potential transaction statuses, using the following priority order: 1. Connections flagged with 'SERVER_STATUS_IN_TRANS', or 'autocommit=0' when 'autocommit_false_is_transaction' is set. 2. Connections with 'autocommit=0' holding a 'SAVEPOINT'. 3. Connections with 'unknown transaction status', e.g: connections with errors.	3 years ago
René Cannaò	8686c3150c	Support for DECIMAL in Clickhouse	3 years ago
René Cannaò	bf87d8d911	Close clickhouse client in case of an exception from clickhouse server	3 years ago
Javier Jaramago Fernández	d3a34712df	Improve function resource acquisition readability ... - Improved readability for the locked map acquisition for function 'search_rules_fast_routing_dest_hg'. - Improved function documentation and added note about usage.	3 years ago
Javier Jaramago Fernández	4b5fe5888e	Fix race condition when reloading 'Query Rules Fast Routing'	3 years ago
Javier Jaramago Fernández	c3e932a641	Remove outdated commented code from Aurora implementation	3 years ago
Javier Jaramago Fernández	f5f56ef7cc	Fix crash during shutdown due to 'mysql_servers_v2' global checksum	3 years ago
Javier Jaramago Fernández	055176b4d0	Fix minor compiler warning in 'proxy_debug' call	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
René Cannaò	d15b40ab43	Merge pull request #4288 from sysown/v2.x_read_only_actions_offline_hard_servers ... Fixed potential crash when read_only_actions creates a server that is already present in hgm container in OFFLINE HARD state	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
René Cannaò	d450d86bcb	Adding "code" in mysql error code counters exported to Prometheus	3 years ago
René Cannaò	3ebf494eb4	Changing error type in MySQL_Monitor_State_Data::create_new_connection()	3 years ago
Rahim Kanji	d93da93376	Added hostgroup_manager_verbose check	3 years ago
Rahim Kanji	65c859659f	If a backend server, which has an active connection with a client, is removed, it remains in the hgm container until the client closes the connection. However, this can lead to a crash if the 'read_only_actions' function creates a server that already exists in the container but is in an OFFLINE state. ... To address this issue, the fix involves checking the host group container when a new server is added through 'read_only_actions.' If the server is found to be already present, it is marked as online instead of adding a new server.	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
René Cannaò	e02813c956	Merge pull request #4280 from sysown/v2.x_transaction_isolation_level_support ... Adding SET TRANSACTION ISOLATION LEVEL * support	3 years ago
René Cannaò	5c65fd150b	Merge pull request #4286 from sysown/v2.x-fix_stats_query_digests_timestamps ... Fix timestamps regression for `stats_mysql_query_digest`	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
René Cannaò	db632cd7f5	Preserve STATUS_MYSQL_CONNECTION_COMPRESSION after connection reset ... In MySQL_Connection::reset() we were forgetting the value of STATUS_MYSQL_CONNECTION_COMPRESSION. De-facto disabling compression if it was enabled.	3 years ago
Javier Jaramago Fernández	d13dda0543	Merge branch 'v2.x' of github.com:sysown/proxysql into v2.x-aurora_autodiscovery	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	5f53c185d0	Remove outdated comments and minor indentation fixes	3 years ago
Javier Jaramago Fernández	664fba97d4	Improve doc for 'pull_mysql_servers_v2_from_peer'	3 years ago
Javier Jaramago Fernández	253e309aa0	Cleanup left commented function 'update_runtime_mysql_servers_table'	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
Javier Jaramago Fernández	43d6274060	Fix servers resultsets not updated for empty config ... If these resultsets are not updated, checksums will always mismatch between the peer cluster nodes in case servers are deleted. The primary will hold the correct checksum ('0x0'), but will report the old resultset to the peer node, the second will compute a checksum different than the expected '0x0'. Cycle won't stop until config is updated in the target primary.	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	a908f2a17b	Added transaction_isolation_level and transaction_read_only variable support.	3 years ago
Rahim Kanji	a3d29863e8	Adding SET TRANSACTION ISOLATION LEVEL * support	3 years ago
Javier Jaramago Fernández	3fb6ab9146	Fix compilation on Centos 6 due to old GCC limitations with 'auto'	3 years ago
René Cannaò	e3865be3a8	Minor changes in branches ... Also added few FIXME to review part of the code	3 years ago
René Cannaò	9ede04de52	Merge branch 'v2.x' into v2.x_sha2pass_draft3	3 years ago
René Cannaò	fb53926cf5	Merge pull request #4274 from sysown/v2.x-4268 ... Reworking of SET parser	3 years ago
René Cannaò	a6ff9e33ba	Initialize thr_SetParser	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	97463ca96c	Fix invalid use of SHUNNED servers for checksum computation in 'read_only_action_v2'	3 years ago
Javier Jaramago Fernández	efe83fea55	Fix propagation of 'OFFLINE_HARD' servers due to 'read_only_action_v2'	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
Javier Jaramago Fernández	813355c3d4	Honor hostgroup attributes for AWS Aurora auto-discovery ... - Refactor of 'commit' checksums computation. - Refactor update of 'AWS_Aurora_Hosts_resultset'. - Fix invalid use of SHUNNED|SHUNNED_REPLICATION_LAG servers for checksum computation via 'MYSQL_SERVERS_CHECKSUM_QUERY'.	3 years ago
Javier Jaramago Fernández	2d5359a4a0	Fix invalid servers removal when present in multiple AWS Aurora clusters	3 years ago
Javier Jaramago Fernández	72cfd2452a	Fix AWS Aurora new writer not honoring 'new_reader_weight' ... When a writer is also placed in the reader hostgroup due to 'writer_is_also_reader', this new reader should also honor 'new_reader_weight'.	3 years ago
Javier Jaramago Fernández	4524bcba6c	Fix AWS Aurora replicas not being SHUNNED due to replication lag ... Since the same 'AWS_Aurora_status_entry' index was being used for computing the previous and current statuses, no difference was being found, and no action taken.	3 years ago
Javier Jaramago Fernández	9e3ab519e8	Add helper functions for server creation/destruction in hostgroup	3 years ago
Javier Jaramago Fernández	6ec2bbc1d2	Update 'mysql_servers' checksum when adding auto-discovered GR servers	3 years ago
Javier Jaramago Fernández	4f73331def	Add functions for breaking down 'commit' checksum generation	3 years ago
Javier Jaramago Fernández	bf5d8cbc73	Add functions for breaking down 'commit' checksum generation	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ò	38724bb401	Error handling for incomplete parsing in SetParser ... If parse1() or parse1v2() is not able to parse the whole query, it doesn't return any result (thus causes an error)	3 years ago
René Cannaò	536bd62f54	Add support for optimizer_switch syntax	3 years ago
René Cannaò	dcd4a4f72f	Make SetParser reusable ... Added set_query() to change the query. parse1v2() is now able to only once: - generate the pattern - compile the regex	3 years ago
René Cannaò	131d2e8792	Initial rewriting of SetParser	3 years ago
René Cannaò	5443b45f2e	Handle utf8mb3 as an alias for utf8 ... Fixes issue #4269 proxysql_find_charset_name() converts "utf8mb3" to "utf8". proxysql_find_charset_collate_names() also remove "mb3" from collation names.	3 years ago
René Cannaò	86ce115529	Merge pull request #4216 from sysown/v2.x-track_slow_query_vars ... Track some slow query variables	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ò	d39dacb575	Adding missing include	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ò	2e0c65cc5c	Merge pull request #4238 from sysown/v2.x-tap_tests_env_files ... add dotenv to libtap	3 years ago
René Cannaò	2600029d8f	Add SO_REUSEPORT for ClickHouse_Server too	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ò	e05ce099be	Merge pull request #4252 from sysown/v2.x-tap20230609-2 ... Add SO_REUSEPORT for SQLite3_Server and other minor changes	3 years ago
René Cannaò	d8275063b2	Better error handling when calling bind()/listen()	3 years ago
René Cannaò	7b5989b983	Merge pull request #4247 from sysown/v2.x_ssl_support_kill_query ... Added SSL connection support in kill_query_thread	3 years ago
René Cannaò	6396e1aa54	Merge pull request #4250 from sysown/v2.x_unix_socket_ssl ... SSL support on Unix Socket reinstated	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	ff722142bf	SSL support on Unix Socket reinstated	3 years ago
Javier Jaramago Fernández	e7a477aada	Merge branch 'v2.x' of github.com:sysown/proxysql into v2.x-aurora_autodiscovery	3 years ago
Rahim Kanji	95b22b96fb	Added SSL connection support in kill_query_thread	3 years ago
Rahim Kanji	ada4621401	Special handling for 'admin-ssl_keylog_file' is only filename is provided.	3 years ago
René Cannaò	0acf5bd94f	Merge pull request #4236 from sysown/v2.x_ssl_keylog_support ... Added support for SSLKEYLOGFILE	3 years ago
Rahim Kanji	dfd45f5071	* Updated NSS Key Log Format URL ... * Updated proxysql sslkeylogfile warning message	3 years ago