GreatDB存储过程管理接口（6）
查看所有 GreatDB 用户存储过程
[root@greatdb1 ~]# greatsql -ugreatdb -pgreatdb -h192.168.0.81 -P3306 GreatDB Cluster[(none)]> SHOW PROCEDURE STATUS like 'greatdb%'; +-------+--------------------------------------------------+-----------+-----------------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-------+--------------------------------------------------+-----------+-----------------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | mysql | greatdb_add_backup_node | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_add_datanode | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_add_sqlnode | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_auto_migrate_tables_after_upscale | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_auto_migrate_tables_before_downscale | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_build_group_replication | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_change_shard_primary_node | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_check_upgrade | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_drop_backup_node | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_drop_backup_task | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_drop_datanode | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_drop_shard | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_drop_sqlnode | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_force_restart_cluster | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_force_restart_shard | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_init_cluster | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_init_shard | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_install_clone_plugin | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_mgr_check | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_migrate_table | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_persist_variables | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_plugin_check | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_purge_binlog_before_seconds_for_datanode | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_restart_cluster | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_restart_datanode_server | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_restart_sqlnode_server | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_restore_shard_from_backup | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_restore_sqlnode_from_backup | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_set_var_for_all_sqlnodes | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_set_var_for_datanode | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_start_full_backup | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_start_group_replication | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_start_inc_backup | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_stop_backup_task | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_stop_datanode_server | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_stop_migrate_task | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | | mysql | greatdb_stop_sqlnode_server | PROCEDURE | greatdb.sys@localhost | 2021-02-26 09:17:11 | 2021-02-26 09:17:11 | DEFINER | | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_unicode_ci | +-------+--------------------------------------------------+-----------+-----------------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 37 rows in set (0.00 sec)相关文章