mysqlshell-plugins

mysqlshell-plugins copied to clipboard

check common unused indexes in replica set or innodb cluster

AmiasLi

Used the proxysql plugin to configure proxysql 2.5.x with a mysql 8.x innodb cluster, but proxysql failed to connect to the backend servers: ``` ERROR 9001 (HY000) at line 1:...

sun-rui

mohsindba

Validate_password plugin

2

Hi Lefred, Please let me know if this is okay. Thanks, Han

tripplea-sg

``` JS  heatwave_utils.list_secondary_engine_tables('airline') heatwave_utils.list_secondary_engine_tables: User-defined function threw an exception: Traceback (most recent call last): File "init.py", line 158, in list_sec_engine_tables AttributeError: unknown attribute: get_schema (ScriptingError) ```

lefred

add automated test for each plugins

lefred

Hi Lefred, Finally I can do pull request. Please find the code and let me know. I added more checking, bug fixes, group_replication_ip_allowlist, etc. Thank you. Regards, Hananto

tripplea-sg

config.get_persisted_variables use performance_schema.variables_info where VARIABLE_SOURCE = 'PERSISTED' condition to check variables, which source info is not collect any more (i chould not find the reason but i do check), i...

gilbertwu

``` [root@mydb ~]# mysqlsh /root/.mysqlsh/plugins/user/grants.py:83: SyntaxWarning: invalid escape sequence '\.' grant_stmt_tmp = re.sub(" ON .*\..* TO .*$", "", grant_stmt_tmp) /root/.mysqlsh/plugins/user/grants.py:210: SyntaxWarning: invalid escape sequence '\.' grant_stmt_tmp = re.sub(" ON .*\..*...

Jerry-Freelancer