1. #获取集群状态
    2. dba.getCluster().status();
    4. #连接集群内其他实例
    5. shell.connect('root@server-1');
    7. #检查集群是否可用
    8. dba.checkInstanceConfiguration("root@node-1:3305");
    10. #删除节点
    11. cluster.removeInstance('root@host:3306',{force:true});  
    13. #加入节点
    14. cluster.addInstance("root@hostname:3306");
    16. #查看进程
    17. show processlist;
    19. #查看主节点状态
    20. show master status;
    22. #查询没有主键的表
    23. SELECT CONCAT(t.table_schema,".",t.table_name) as table_name
    25. FROM information_schema.TABLES t
    27. LEFT JOIN information_schema.TABLE_CONSTRAINTS tc
    29. ON t.table_schema = tc.table_schema
    31. AND t.table_name = tc.table_name
    33. AND tc.constraint_type = 'PRIMARY KEY'
    35. WHERE tc.constraint_name IS NULL
    37. AND t.table_type = 'BASE TABLE';