proxysql

Commit Graph

Author	SHA1	Message	Date
René Cannaò	7e5b3e8045	Rememeber clear text password if provided by client Extended account_details_t to also store clear_text_password if client provides it during a full authentication in caching_sha2_password . De facto, this implements the "caching" part of caching_sha2_password .	3 years ago
René Cannaò	71e2510ef6	Code cleanup on MySQL_HostGroups_Manager Some rework to try to reduce duplicated code	3 years ago
Javier Jaramago Fernández	099c2a5f06	Cluster: Speedup of processing of MySQL Users and MySQL Servers - Cluster now syncs the server tables via 'incoming_*' tables generated during 'load_mysql_servers_to_runtime'. - Cluster now syncs 'mysql_users' table via a resultset generated via '__refresh_users'.	4 years ago
Javier Jaramago Fernández	4c4346a710	Add checksum computation after fetch to multiple cluster modules The following cluster modules now compute their expected checksums after fetch: - mysql_query_rules - mysql_users - mysql_servers - mysql_global_variables	4 years ago
--global	0e8830758b	Fix leak due to duplicate 'strdup' to 'default_schema' in 'dump_all_users'	4 years ago
René Cannaò	52f1d0f1ec	Per-user default transaction isolation level See issue #3465 If a user (configurable) connects to proxysql without specifying a session transaction isolation level, proxysql will automatically assigns one to that user connection. Of course, said user can override such default session transaction isolation level running `SET SESSION TRANSACTION ISOLATION LEVEL` on a per-connection basis. This feature can be configured extending `mysql_users.attributes` , adding an object named `default-transaction_isolation` . An example of configuration could be: ``` UPDATE mysql_users SET attributes='{"default-transaction_isolation":"READ COMMITTED"}' WHERE username='sbtest'; ``` This feature also requires input validation making sure that only valid isolation levels are used. Furthermore, both dash and space can be used. If the isolation level specified is not valid, it should be automatically removed from runtime.	5 years ago
René Cannaò	7c0bde5f99	Working prototype for SPIFFE	5 years ago
Javier Jaramago Fernández	42fa0f7945	Added new column 'attributes' to 'mysql_users' table	6 years ago
René Cannaò	ce4a4a2464	Code cleanup and speeding compile time	7 years ago
Carson Ip	1232a6382e	Fix minor typos	7 years ago
René Cannaò	54d32d4580	Implementation of AUTH SWITCH - if clients uses mysql_native_password, if LDAP is enabled and if the user doesn't exist, switch to mysql_clear_password. - if neither mysql_native_password or mysql_clear_password are used by the client: - if LDAP is not enabled, always switch to mysql_native_password - if LDAP is enabled: - if the user exists, switch to mysql_native_password - if the user doesn't exists, switch to mysql_clear_password Added MySQL variable mysql-add_ldap_user_comment to determine if a comment with the original username needs to be added in the queries. This commit also tracks the charset during the first handshake response.	7 years ago
René Cannaò	73f73b6c0a	Add column comment in mysql_users table #1633 Added online migration from previous table definition (1.3.0 and 1.4.0). LOAD MYSQL USERS TO RUNTIME and SAVE MYSQL USERS TO MEMORY handle the new field comment can be read also from config file ProxySQL Cluster reads comment from remote node	8 years ago
Nick Vyzas	2fd9407b95	Added default_schema to checksum criteria 2.0.0	8 years ago
René Cannaò	b57ff42b9c	Drafting again support for ClickHouse Introduced new ClickHouse Server module Introduced new ClickHouse Authentication module None of the two new modules are working yet: only initialized.	9 years ago
René Cannaò	21df8d1346	Return 0 checksum if mysql_users is empty If table `mysql_users` is empty, its checksum must be all zeros	9 years ago
René Cannaò	e3c4cb9964	A lot of changes all related to Cluster In `MySQL_Cluster` class added functions to sync with remote node, like: - `pull_mysql_query_rules_from_peer()` - `pull_mysql_servers_from_peer()` - `pull_mysql_users_from_peer()` - `pull_proxysql_servers_from_peer()` Added 8 new global variables in Admin. 4 variables determine after how many different checks the remote configuration will be synced: - cluster_mysql_query_rules_diffs_before_sync - cluster_mysql_servers_diffs_before_sync - cluster_mysql_users_diffs_before_sync - cluster_proxysql_servers_diffs_before_sync 4 variables determine if after a remote sync the changes need to be written to disk: - cluster_mysql_query_rules_save_to_disk - cluster_mysql_servers_save_to_disk - cluster_mysql_users_save_to_disk - cluster_proxysql_servers_save_to_disk Table `proxysql_servers` is now automatically loaded from disk to memory and into runtime at startup. Added new Admin's command `LOAD PROXYSQL SERVERS FROM CONFIG` to load `proxysql_servers` from config file to memory (not runtime). Internal structures with credentials in MySQL_Authentication moved from `unsorted_map` to `map` : this to ensure the right order when generating the checksum. Config file supports both `address` and `hostname` for `mysql_servers` and `proxysql_servers` , #1091 `ProxySQL_Admin::load_proxysql_servers_to_runtime()` now has a lock or no lock option, to avoid deadlock For now, Cluster module is quite verbose.	9 years ago
René Cannaò	708f14a6e6	More accurate memory metrics	9 years ago
René Cannaò	1414d4430f	Introduced new table stats_memory_metrics Here an example: ``` Admin> SELECT * FROM stats_memory_metrics ORDER BY variable_name; +----------------------+----------------+ \| Variable_Name \| Variable_Value \| +----------------------+----------------+ \| Auth_memory \| 836 \| \| SQLite3_memory_bytes \| 1636648 \| \| jemalloc_active \| 3469312 \| \| jemalloc_allocated \| 3055248 \| \| jemalloc_mapped \| 14680064 \| \| jemalloc_metadata \| 1480576 \| \| jemalloc_resident \| 4542464 \| \| jemalloc_retained \| 0 \| \| query_digest_memory \| 459 \| +----------------------+----------------+ 9 rows in set (0.00 sec) ```	9 years ago
René Cannaò	64eb4cda35	Remove spinlock from MySQL Auth #977	9 years ago
René Cannaò	6469ff269b	num_connections_used incorrectly reset	9 years ago
René Cannaò	f0f85a44fe	Introduced table stats.stats_mysql_users Example: ``` mysql> select * from stats_mysql_users; +----------+----------------------+--------------------------+ \| username \| frontend_connections \| frontend_max_connections \| +----------+----------------------+--------------------------+ \| root \| 0 \| 10000 \| \| user1 \| 0 \| 10000 \| \| user2 \| 1 \| 10000 \| +----------+----------------------+--------------------------+ 3 rows in set (0.00 sec) ```	9 years ago
René Cannaò	b449a3ffb4	Merge branch 'master' into v1.4.0	9 years ago
Christopher Troup	0f75916a2e	Ensure that users num_connections_used doesn't get incremented if connection rejected If the users connection is rejected we shouldn't be incrementing `num_connections_used` on the account_details object. This leads to `free_users` dropping below zero and _all_ subsequent requests getting rejected for that user. Refs #940	9 years ago
René Cannaò	a6c53d0d12	Revert "Refactor header includes."	10 years ago
Maxim Bublis	30dbcc21a8	Refactor header includes. * reduce build time by 25%; * remove circular dependency on `cpp.h` and other headers. * fixes issue with `my_global.h` from mariadbclient which redefines `__attribute__`, that leads to broken STL and GCC intrinsics if `<algorithm>` wasn't included prior including this header; * fixes another issue with redefined `__attribute__` which leads to `_conn_exchange_t` not being aligned to cache line size; * removes `pthread_setstacksize` calls as `my_global.h` redefines `pthread_setstacksize` to be `pthread_dummy(0)` which led to stack size being never adjusted; * add missing include guards to some headers; * remove unused proxysql_hash.h header.	10 years ago
Maxim Bublis	043a321e55	Cleanup legacy codebase.	10 years ago
René Cannaò	95a6ed5f26	Speed up the cleanup of MySQL_Authentication #802 This drastically reduces the time to gracefully shutdown proxysql in case of hundreds of thousands of mysql users	10 years ago
René Cannaò	1ca56c9b3e	Speeds up LOAD MYSQL USERS TO RUNTIME #802 MySQL_Authentication::add() used to delete a user, and then create it. This patch applied the change in place if possible. With 100k users, not it is around 7 times faster.	10 years ago
René Cannaò	d0d764533d	Specify when a mysql_users.max_connections is reached #794 It also fixes: * bug in deps/Makefile related to cleanall * crashing bug in HGCU_thread_run()	10 years ago
René Cannaò	c710f54987	Compiling optimization * converted MySQL_Authentication to use unsorted_map instead of btree_map * Query_Cache now uses pointers to KV_BtreeArray * removed some unnecesary headers	10 years ago
René Cannaò	b24d9e8d2b	Bugfixes on encrypted password	10 years ago
René Cannaò	60b3dcaadf	More on sha1_passs on MySQL_Authentication() MySQL_Authentication() is now able to keep track of sha1_pass between LOAD MYSQL USERS TO RUNTIME wothout the need of a new user uathentication	10 years ago
René Cannaò	625c969a5d	Use hash password in mysql_users This feature is not completed yet. libmariadb/password.c is patched to use either password or sha1(password) Class MySQL_Connection_userinfo() is expanded to also support sha1_pass Inroduced MySQL_Authentication::set_SHA1() to store this information at runtime only Added several auxiliary functions	10 years ago
René Cannaò	3f472d41aa	Fix on num_connections_used not initialized	11 years ago
René Cannaò	76edfb126f	Further implementation of libmariadb client	11 years ago
René Cannaò	d9a2df7039	Query Cache is not a plugin anymore	11 years ago
René Cannaò	59507675e5	MySQL_Thread, MySQL_Threads_Handler and MySQL_Authentication are no longer modules	11 years ago

37 Commits (2.7.2)