Skip to content

Instantly share code, notes, and snippets.

@vilobhmm

vilobhmm/gist:1044d2598e3fe2b4d92d Secret

Last active August 29, 2015 14:19
Show Gist options
  • Save vilobhmm/1044d2598e3fe2b4d92d to your computer and use it in GitHub Desktop.
Save vilobhmm/1044d2598e3fe2b4d92d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> describe services;
+-----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+----------------+
| created_at | datetime | YES | | NULL | |
| updated_at | datetime | YES | | NULL | |
| deleted_at | datetime | YES | | NULL | |
| id | int(11) | NO | PRI | NULL | auto_increment |
| host | varchar(255) | YES | MUL | NULL | |
| binary | varchar(255) | YES | | NULL | |
| topic | varchar(255) | YES | | NULL | |
| report_count | int(11) | NO | | NULL | |
| disabled | tinyint(1) | YES | | NULL | |
| deleted | int(11) | YES | | NULL | |
| disabled_reason | varchar(255) | YES | | NULL | |
+-----------------+--------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)
mysql> select * from services;
+---------------------+---------------------+------------+----+------------------------------------------------+------------------+-------------+--------------+----------+---------+-----------------+
| created_at | updated_at | deleted_at | id | host | binary | topic | report_count | disabled | deleted | disabled_reason |
+---------------------+---------------------+------------+----+------------------------------------------------+------------------+-------------+--------------+----------+---------+-----------------+
| 2015-02-13 18:52:31 | 2015-04-21 23:08:11 | NULL | 1 | vapi8 | nova-conductor | conductor | 569118 | 0 | 0 | NULL |
| 2015-02-13 19:07:51 | 2015-04-21 23:08:11 | NULL | 2 | vapi8 | nova-consoleauth | consoleauth | 569109 | 0 | 0 | NULL |
| 2015-02-13 19:07:51 | 2015-04-21 23:08:11 | NULL | 3 | vapi8 | nova-network | network | 569111 | 0 | 0 | NULL |
| 2015-02-13 19:07:51 | 2015-04-21 23:08:11 | NULL | 4 | vapi8 | nova-scheduler | scheduler | 569106 | 0 | 0 | NULL |
| 2015-02-13 19:13:22 | 2015-04-21 20:25:34 | NULL | 5 | openstack-hv5 | nova-compute | compute | 439010 | 0 | 0 | NULL |
| 2015-02-19 01:32:49 | 2015-04-21 20:30:43 | NULL | 6 | openstack-hv6 | nova-compute | compute | 498735 | 0 | 0 | None |
| 2015-03-19 23:46:37 | 2015-04-21 20:20:43 | NULL | 7 | hv201 | nova-compute | compute | 130890 | 1 | 0 | NULL |
+---------------------+---------------------+------------+----+------------------------------------------------+------------------+-------------+--------------+----------+---------+-----------------+
7 rows in set (0.00 sec)
mysql>
[ ] $ sudo nova-manage service list
Password:
Binary Host Zone Status State Updated_At
nova-conductor vapi8 internal enabled :-) 2015-04-21 23:05:59
nova-consoleauth vapi8 internal enabled :-) 2015-04-21 23:06:00
nova-network vapi8 internal enabled :-) 2015-04-21 23:06:00
nova-scheduler vapi8 internal enabled :-) 2015-04-21 23:06:00
nova-compute openstack-hv5 nova enabled XXX 2015-04-21 20:25:34
nova-compute openstack-hv6 nova enabled XXX 2015-04-21 20:30:43
nova-compute hv201 nova disabled XXX 2015-04-21 20:20:43
[Tue Apr 21 23:06:03 :~ ] $
[Tue Apr 21 23:06:03 :~ ] $sudo nova-manage service disable --host openstack-hv6 --service nova-compute
Service nova-compute on host openstack-hv6 disabled.
mysql> select * from services;
+---------------------+---------------------+------------+----+------------------------------------------------+------------------+-------------+--------------+----------+---------+-----------------+
| created_at | updated_at | deleted_at | id | host | binary | topic | report_count | disabled | deleted | disabled_reason |
+---------------------+---------------------+------------+----+------------------------------------------------+------------------+-------------+--------------+----------+---------+-----------------+
| 2015-02-13 18:52:31 | 2015-04-21 23:11:20 | NULL | 1 | vapi8 | nova-conductor | conductor | 569137 | 0 | 0 | NULL |
| 2015-02-13 19:07:51 | 2015-04-21 23:11:20 | NULL | 2 | vapi8 | nova-consoleauth | consoleauth | 569128 | 0 | 0 | NULL |
| 2015-02-13 19:07:51 | 2015-04-21 23:11:11 | NULL | 3 | vapi8 | nova-network | network | 569129 | 0 | 0 | NULL |
| 2015-02-13 19:07:51 | 2015-04-21 23:11:20 | NULL | 4 | vapi8 | nova-scheduler | scheduler | 569125 | 0 | 0 | NULL |
| 2015-02-13 19:13:22 | 2015-04-21 20:25:34 | NULL | 5 | openstack-hv5 | nova-compute | compute | 439010 | 0 | 0 | NULL |
| 2015-02-19 01:32:49 | 2015-04-21 23:11:16 | NULL | 6 | openstack-hv6 | nova-compute | compute | 498735 | 1 | 0 | None |
| 2015-03-19 23:46:37 | 2015-04-21 20:20:43 | NULL | 7 | hv201 | nova-compute | compute | 130890 | 1 | 0 | NULL |
+---------------------+---------------------+------------+----+------------------------------------------------+------------------+-------------+--------------+----------+---------+-----------------+
7 rows in set (0.00 sec)
mysql>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment