- A+
所属分类:kingshard
平滑上(下)线后端DB
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
#添加一个新的slave到node1 admin node(opt,node,k,v) values(‘add’,’node1’,’slave’,’127.0.0.1:3306’) #删除node1上的一个slave。注意:只能删除slave,不能删除master admin node(opt,node,k,v) values(‘del’,’node1’,’slave’,’127.0.0.1:3306’) #将一个slave设置为下线状态 admin node(opt,node,k,v) values(‘down’,’node1’,’slave’,’127.0.0.1:3306’) #将一个slave设置为上线状态 admin node(opt,node,k,v) values(‘up’,’node1’,’slave’,’127.0.0.1:3306’) #将master设置为下线状态 admin node(opt,node,k,v) values(‘down’,’node1’,’master’,’127.0.0.1:3306’) #将master设置为上线状态 admin node(opt,node,k,v) values(‘up’,’node1’,’master’,’127.0.0.1:3306’) |
查看kingshard配置
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
#查看kingshard全局配置 mysql> admin server(opt,k,v) values('show','proxy','config'); +-------------+----------------+ | Key | Value | +-------------+----------------+ | Addr | 127.0.0.1:9696 | | User | kingshard | | Password | kingshard | | LogLevel | debug | | Nodes_Count | 2 | | Nodes_List | node1,node2 | +-------------+----------------+ 6 rows in set (0.00 sec) #查看node状态 mysql> admin server(opt,k,v) values('show','node','config'); +-------+---------------------+--------+-------+-------------------------------+-------------+----------+ | Node | Address | Type | State | LastPing | MaxIdleConn | IdleConn | +-------+---------------------+--------+-------+-------------------------------+-------------+----------+ | node1 | 127.0.0.1:3306 | master | up | 2015-08-07 15:54:44 +0800 CST | 16 | 1 | | node2 | 192.168.59.103:3307 | master | up | 2015-08-07 15:54:44 +0800 CST | 16 | 1 | +-------+---------------------+--------+-------+-------------------------------+-------------+----------+ 2 rows in set (0.00 sec) #查看schema配置 mysql> admin server(opt,k,v) values('show','schema','config'); +-----------+------------------+---------+------+--------------+-----------+---------------+ | DB | Table | Type | Key | Nodes_List | Locations | TableRowLimit | +-----------+------------------+---------+------+--------------+-----------+---------------+ | kingshard | | default | | node1 | | 0 | | kingshard | test_shard_hash | hash | id | node1, node2 | 4, 4 | 0 | | kingshard | test_shard_range | range | id | node1, node2 | 4, 4 | 10000 | +-----------+------------------+---------+------+--------------+-----------+---------------+ 3 rows in set (0.00 sec) |
项目地址
github: https://github.com/flike/kingshard/

微信公众号
扫一扫关注运维生存时间公众号,获取最新技术文章~