Commit Graph

3879 Commits (2.6.6)

Author SHA1 Message Date
Javier Jaramago Fernández e91bcd2c81 Move Admin 'HTTP_Server' and 'RESTAPI' init to end of phase3 - Closes #4510
2 years ago
Rahim Kanji 8c92f9292a A hostgroup can now be configured to have a maximum number of online servers simultaneously. Once this limit is reached, any new connections attempting to access the connection pool will be denied, and existing connections will gradually be reassigned to the available connection pool until the number of online servers is reduced to meet or fall below the specified maximum.
2 years ago
René Cannaò 229b5d7d3f Some code cleanup
2 years ago
René Cannaò eb7a0e37f1 Moved legacy code away from c_tokenizer.cpp
2 years ago
René Cannaò dad6f0f344 Split of MySQL_Protocol.cpp into multiple files
2 years ago
René Cannaò e7aa5ff4c5 Split of MySQL_HostGroups_Manager.cpp into multiple files
2 years ago
René Cannaò 0a2cd03672 Refactoring to split Query_Processor.cpp into multiple files
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
Javier Jaramago Fernández ecff8d0cc2 Fix two memory leaks on SQLite3 prepared statements
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
Miro Stauder 965efe4103 use THERAD_PER_CONNECTION in REASTAPI server
2 years ago
Miro Stauder 39591b97a6 fix Makefile grep
2 years ago
Javier Jaramago Fernández 8d8f2eac8b Improve error message for 'process_discovered_topology'
2 years ago
Javier Jaramago Fernández 06bd34b48b Fix error message format on 'process_discovered_topology'
2 years ago
Javier Jaramago Fernández 93a5d2cefb Add missing Admin mutex locking during server discovery
2 years ago
Javier Jaramago Fernández 61d870b4f6 Add missing default init for local variable
2 years ago
Javier Jaramago Fernández f6aebcb637 Make range-based for loop variable a const reference
2 years ago
Javier Jaramago Fernández 2ac1e4069a Change function params into const references
2 years ago
Javier Jaramago Fernández 5d7e5d9e00
Merge pull request #4406 from anphucbui/v2.x
2 years ago
anphucbui bbb6176ebf Remove redundant exception guards, remove parseLong, add checksum computation after adding a new server, and other small changes based on feedback
2 years ago
René Cannaò 1f78c9e7f0
Merge pull request #4482 from sysown/v2.x-stmt_explain
2 years ago
René Cannaò 2df30b6641
Merge pull request #4479 from sysown/v2.x-sqlite3_pass_exts-2
2 years ago
René Cannaò 73a59f1764 Merge branch 'v2.x' into v2.x-stmt_explain
2 years ago
René Cannaò b5b49c2fd2
Merge pull request #4481 from sysown/v2.x-ps3371
2 years ago
Javier Jaramago Fernández a11b8f7234 Fix invalid free for 'caching_sha2_password' and 'CLIENT_COMPRESS'
2 years ago
René Cannaò 3790ce6d82 Do not print "Updating metadata for stmt" for EXPLAIN
2 years ago
René Cannaò 9b24fdf4b8 Prevent crash COM_STMT_EXECUTE and invalid stmt_id
2 years ago
Javier Jaramago Fernández 6c5bd0971c Add new SQLite3 functions for password generation
2 years ago
René Cannaò 6b9a787c45 Removed dead code
2 years ago
René Cannaò 45b517ac7b Removed dead code
2 years ago
René Cannaò 27a1bbb810 Adding MySQL_Session::set_previous_status_mode3()
2 years ago
René Cannaò acbedfb4b3 Call housekeeping_before_pkts() only if hgs_expired_conns.size()
2 years ago
René Cannaò 1bc9d9e5f4 Several code documentation
2 years ago
René Cannaò 9d788c04a9
Merge pull request #4467 from sysown/v2.6-4466
2 years ago
René Cannaò f7fbf2b17f Read mysql_servers_ssl_params from config file
2 years ago
René Cannaò 68da6dd29d Use of ssl_params in MySQL_Monitor
2 years ago
René Cannaò cf1705ba27
Merge pull request #4468 from sysown/v2.x-clang_cppdotenv
2 years ago
René Cannaò c971d401a4 Use of ssl_params in kill_query_thread()
2 years ago
René Cannaò b1e998ba71 Fix incorrect error handling in kill_query_thread
2 years ago
René Cannaò d92c2d2e29 Implementation of MySQL_Connection::set_ssl_params
2 years ago
Thomas Saunders 041c3d7d23
correct free/used typo in prometheus 'connection_pool' gauge cleanup
2 years ago
Miro Stauder 8a0e326ce5 warn about ASAN limitation ASLR > 28bits
2 years ago
Miro Stauder f6aea2f5f3 fix Makefile identations
2 years ago
Miro Stauder 8aee52740f fix type casts
2 years ago
Miro Stauder 0a9c1b6db8 fix pointer aritmetic
2 years ago
Miro Stauder 3e7e15bb50 fix brackets in comparison
2 years ago
Miro Stauder ee739edd8b fix format strings
2 years ago
Javier Jaramago Fernández a9e7af8a7b Add 'session_id' to server lost during query error msg
2 years ago
René Cannaò 8ab51c65e7 ssl_params: use NULL instead of empty string #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
2 years ago
René Cannaò ee4cd19a07
Merge pull request #4459 from sysown/v2.x_openssl_verify_load_cacert_duration
2 years ago
René Cannaò b7f53c10a2
Merge pull request #4258 from sysown/v2.x_sha2pass_draft3
2 years ago
Rahim Kanji ee3d24121e
Update MySQL_PreparedStatement.cpp
2 years ago
René Cannaò 548ededd4f Include MySQLServers_SslParams in MySQL_Connection
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
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'
2 years ago
Javier Jaramago Fernández 3f2a7aa693 Fix memory issues during 'chaching_sha2' auth
2 years ago
René Cannaò b3dcee9c53
Merge pull request #4448 from sysown/v2.6.0-update_to_openssl_v3.2.1
2 years ago
René Cannaò 6e18b04290
Merge pull request #4450 from sysown/v2.x_shun_replication_lag
2 years ago
René Cannaò 6a6807c07c
Merge pull request #4455 from sysown/v2.x_memleak_fix_stats_mysql_prepared_statements_info
2 years ago
René Cannaò 5c42db6696 If cluster synchnonization fails , wait 1 second
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
2 years ago
René Cannaò 984582eaae Renamed variable 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'
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
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
2 years ago
René Cannaò bb562ec484 Update copyright year
2 years ago
René Cannaò 7f57f20e5a
Merge pull request #4430 from sysown/v2.x-4241
2 years ago
René Cannaò 7d429c69ad
Merge pull request #4428 from sysown/v2.x-pause_status
2 years ago
René Cannaò acf2b7bd7e
Merge pull request #4427 from sysown/v2.x-4396
2 years ago
René Cannaò 26738b4c15
Merge pull request #4425 from sysown/v2.x-4355
2 years ago
René Cannaò 41cd740701 Added metric MultiplexDisabled_ext #4241
2 years ago
René Cannaò d2c8d655a8 Deprecate mysql-default_tx_isolation #4335
2 years ago
René Cannaò 53262987ac Added new status variable mysql_listener_paused
2 years ago
René Cannaò e958946b82 Handle STATUS command without backends
2 years ago
René Cannaò 93fca24914 Fast shutdown for TERM signal #4355
2 years ago
René Cannaò 496ee02cae Input validation for mysql-server_capabilities
2 years ago
René Cannaò 29b7cd0529 Modify generate_one_byte_pkt()
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
René Cannaò c0ea4d6392
Merge pull request #4414 from sysown/v2.x_issue_4399
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
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
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
3 years ago
Rahim Kanji 4af5dd2a1d Merge remote-tracking branch 'Master/v2.x' into v2.x_testing_ci_test_failures
3 years ago
René Cannaò 8fdc7f010e
Merge pull request #4340 from sysown/v2.x-2.6_new_defaults_2
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
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.
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
Rahim Kanji 045d6bcaeb * Execute all test cases with 'CLIENT_DEPRECATE_EOF' both enabled and disabled.
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.
3 years ago
René Cannaò eb2a1eccef
Merge pull request #4374 from sysown/v2.x_hostgroup_attr_settings
3 years ago
Javier Jaramago Fernández 437fcad1d4 Fix interactions between 'checksum_%' and '%_diffs_before_sync'
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'
3 years ago
René Cannaò f16290d78d Prevent assert after fcntl() for O_NONBLOCK
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.
3 years ago
René Cannaò 983062e3da
Merge pull request #4317 from sysown/v2.6-CodeQL-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:
3 years ago
Rahim Kanji d2b8f7d54e Fixed code style
3 years ago
Rahim Kanji 6b295477d6 Enhanced Warnings handling in ProxySQL:
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""
3 years ago
René Cannaò 707ec90f7b Revert "Remove trailing spaces and semicolon from SET statements #4341"
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