Backup and restore Openstack configuration MYSQL DB for Contrail Cloud - lujiang2016/contrail GitHub Wiki
Backup of all MySQL databases in the OpenStack node:
user@host:~# cat /etc/contrail/mysql.token
$ABC123
user@host::~# mysqldump -u root --password=<password< --all-databases > openstack.sql
For testing purposes only: Bring servers to a clean state
fab reset_config
Restore all MySQL OpenStack databases:
user@host:~# cat /etc/contrail/mysql.token $ABC123
user@host:~# mysql -u root --password=<password> < openstack.sql
Backup both Contrail Cassandra & Zookeeper DB + Openstack MySQL DB:
root@aio71:~# python /usr/lib/python2.7/dist-packages/cfgm_common/db_json_exim.py --export-to `hostname`-`date +"%Y%m%d-%H%M"`_db-dump.json
root@aio71:~#
root@aio71:~# cat /etc/contrail/mysql.token
ca214d5dcb2b7a7abae2
root@aio71:~#
root@aio71:~# mysqldump -uroot -pca214d5dcb2b7a7abae2 --all-databases > aio71-openstack-20190204.sql
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
root@aio71:~#
root@aio71:~# ls -alF *.sql
-rw-r--r-- 1 root root 976658 Feb 4 12:39 aio71-openstack-20190204.sql
root@aio71:~#
root@aio71:~# ls -alF *.json
-rw-r--r-- 1 root root 314639 Feb 4 12:38 aio71-20190204-1238_db-dump.json
Poll around the Openstack MySQL DBs:
root@aio70:~# cat /etc/contrail/mysql.token
8d54bd8151c836999f83
root@aio70:~# mysql -uroot -p8d54bd8151c836999f83
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19952
Server version: 5.5.37 MySQL Community Server (GPL), wsrep_25.10.r3990
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cinder |
| glance |
| heat |
| keystone |
| mysql |
| nova |
| nova_api |
| performance_schema |
| test |
+--------------------+
10 rows in set (0.01 sec)
mysql> use keystone;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+------------------------+
| Tables_in_keystone |
+------------------------+
| access_token |
| assignment |
| config_register |
| consumer |
| credential |
| domain |
| endpoint |
| endpoint_group |
| federated_user |
| federation_protocol |
| group |
| id_mapping |
| identity_provider |
| idp_remote_ids |
| implied_role |
| local_user |
| mapping |
| migrate_version |
| password |
| policy |
| policy_association |
| project |
| project_endpoint |
| project_endpoint_group |
| region |
| request_token |
| revocation_event |
| role |
| sensitive_config |
| service |
| service_provider |
| token |
| trust |
| trust_role |
| user |
| user_group_membership |
| whitelisted_config |
+------------------------+
37 rows in set (0.00 sec)
mysql> select * from project;
+----------------------------------+--------------------------+-------+----------------------------------------------------------+---------+--------------------------+-----------+-----------+
| id | name | extra | description | enabled | domain_id | parent_id | is_domain |
+----------------------------------+--------------------------+-------+----------------------------------------------------------+---------+--------------------------+-----------+-----------+
| 39faacac334744069ef523a9d2ded225 | invisible_to_admin | {} | NULL | 1 | default | default | 0 |
| 479249e4eb3540ea84a87b161cb9feba | demo | {} | NULL | 1 | default | default | 0 |
| 756fdd163a5949129fb3be6d1e9920f1 | admin | {} | NULL | 1 | default | default | 0 |
| <<keystone.domain.root>> | <<keystone.domain.root>> | {} | | 0 | <<keystone.domain.root>> | NULL | 1 |
| a41184f40d2e49d9ab6c1fe1b0f77ade | service | {} | NULL | 1 | default | default | 0 |
| default | Default | {} | Domain created automatically to support V2.0 operations. | 1 | <<keystone.domain.root>> | NULL | 1 |
+----------------------------------+--------------------------+-------+----------------------------------------------------------+---------+--------------------------+-----------+-----------+
6 rows in set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cinder |
| glance |
| heat |
| keystone |
| mysql |
| nova |
| nova_api |
| performance_schema |
| test |
+--------------------+
10 rows in set (0.00 sec)
mysql> use nova
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+--------------------------------------------+
| Tables_in_nova |
+--------------------------------------------+
| agent_builds |
| aggregate_hosts |
| aggregate_metadata |
| aggregates |
| allocations |
| block_device_mapping |
| bw_usage_cache |
| cells |
| certificates |
| compute_nodes |
| console_pools |
| consoles |
| dns_domains |
| fixed_ips |
| floating_ips |
| instance_actions |
| instance_actions_events |
| instance_extra |
| instance_faults |
| instance_group_member |
| instance_group_policy |
| instance_groups |
| instance_id_mappings |
| instance_info_caches |
| instance_metadata |
| instance_system_metadata |
| instance_type_extra_specs |
| instance_type_projects |
| instance_types |
| instances |
| inventories |
| key_pairs |
| migrate_version |
| migrations |
| networks |
| pci_devices |
| project_user_quotas |
| provider_fw_rules |
| quota_classes |
| quota_usages |
| quotas |
| reservations |
| resource_provider_aggregates |
| resource_providers |
| s3_images |
| security_group_default_rules |
| security_group_instance_association |
| security_group_rules |
| security_groups |
| services |
| shadow_agent_builds |
| shadow_aggregate_hosts |
| shadow_aggregate_metadata |
| shadow_aggregates |
| shadow_block_device_mapping |
| shadow_bw_usage_cache |
| shadow_cells |
| shadow_certificates |
| shadow_compute_nodes |
| shadow_console_pools |
| shadow_consoles |
| shadow_dns_domains |
| shadow_fixed_ips |
| shadow_floating_ips |
| shadow_instance_actions |
| shadow_instance_actions_events |
| shadow_instance_extra |
| shadow_instance_faults |
| shadow_instance_group_member |
| shadow_instance_group_policy |
| shadow_instance_groups |
| shadow_instance_id_mappings |
| shadow_instance_info_caches |
| shadow_instance_metadata |
| shadow_instance_system_metadata |
| shadow_instance_type_extra_specs |
| shadow_instance_type_projects |
| shadow_instance_types |
| shadow_instances |
| shadow_key_pairs |
| shadow_migrate_version |
| shadow_migrations |
| shadow_networks |
| shadow_pci_devices |
| shadow_project_user_quotas |
| shadow_provider_fw_rules |
| shadow_quota_classes |
| shadow_quota_usages |
| shadow_quotas |
| shadow_reservations |
| shadow_s3_images |
| shadow_security_group_default_rules |
| shadow_security_group_instance_association |
| shadow_security_group_rules |
| shadow_security_groups |
| shadow_services |
| shadow_snapshot_id_mappings |
| shadow_snapshots |
| shadow_task_log |
| shadow_virtual_interfaces |
| shadow_volume_id_mappings |
| shadow_volume_usage_cache |
| snapshot_id_mappings |
| snapshots |
| tags |
| task_log |
| virtual_interfaces |
| volume_id_mappings |
| volume_usage_cache |
+--------------------------------------------+
109 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 | last_seen_up | forced_down | version |
+---------------------+---------------------+------------+----+---------+--------------------+-------------+--------------+----------+---------+-----------------+---------------------+-------------+---------+
| 2018-05-18 14:11:31 | NULL | NULL | 1 | 0.0.0.0 | nova-ec2 | NULL | 0 | 0 | 0 | NULL | NULL | 0 | 9 |
| 2018-05-18 14:11:32 | NULL | NULL | 3 | 0.0.0.0 | nova-osapi_compute | NULL | 0 | 0 | 0 | NULL | NULL | 0 | 9 |
| 2018-05-18 14:11:32 | NULL | NULL | 8 | 0.0.0.0 | nova-metadata | NULL | 0 | 0 | 0 | NULL | NULL | 0 | 9 |
| 2018-05-18 14:11:36 | 2019-02-04 20:20:25 | NULL | 9 | aio70 | nova-scheduler | scheduler | 2171509 | 0 | 0 | NULL | 2019-02-04 20:20:25 | 0 | 9 |
| 2018-05-18 14:11:42 | 2019-02-04 20:20:28 | NULL | 10 | aio70 | nova-console | console | 2171535 | 0 | 0 | NULL | 2019-02-04 20:20:28 | 0 | 9 |
| 2018-05-18 14:11:48 | 2019-02-04 20:20:19 | NULL | 11 | aio70 | nova-consoleauth | consoleauth | 2171542 | 0 | 0 | NULL | 2019-02-04 20:20:19 | 0 | 9 |
| 2018-05-18 14:12:00 | 2019-02-04 20:20:26 | NULL | 12 | aio70 | nova-conductor | conductor | 2171637 | 0 | 0 | NULL | 2019-02-04 20:20:26 | 0 | 9 |
| 2018-05-18 14:18:23 | 2019-02-04 20:20:21 | NULL | 13 | aio70 | nova-compute | compute | 2171499 | 0 | 0 | NULL | 2019-02-04 20:20:21 | 0 | 9 |
| 2018-06-15 09:13:07 | 2019-02-04 20:20:23 | NULL | 14 | bcomp78 | nova-compute | compute | 1927695 | 0 | 0 | NULL | 2019-02-04 20:20:23 | 0 | 9 |
+---------------------+---------------------+------------+----+---------+--------------------+-------------+--------------+----------+---------+-----------------+---------------------+-------------+---------+
9 rows in set (0.00 sec)
mysql> select * from instances;
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-----------------------+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+--------------+---------------------+---------------------+-----------------------+-----------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+---------------------+---------+-----------+---------+--------------------+
| created_at | updated_at | deleted_at | id | internal_id | user_id | project_id | image_ref | kernel_id | ramdisk_id | launch_index | key_name | key_data | power_state | vm_state | memory_mb | vcpus | hostname | host | user_data | reservation_id | scheduled_at | launched_at | terminated_at | display_name | display_description | availability_zone | locked | os_type | launched_on | instance_type_id | vm_mode | uuid | architecture | root_device_name | access_ip_v4 | access_ip_v6 | config_drive | task_state | default_ephemeral_device | default_swap_device | progress | auto_disk_config | shutdown_terminate | disable_terminate | root_gb | ephemeral_gb | cell_name | node | deleted | locked_by | cleaned | ephemeral_key_uuid |
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-----------------------+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+--------------+---------------------+---------------------+-----------------------+-----------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+---------------------+---------+-----------+---------+--------------------+
| 2018-06-15 17:00:01 | 2018-08-08 05:55:57 | 2018-08-08 05:55:57 | 1 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 7374610b-b1f9-4652-95b3-2eaedc364c05 | | | 0 | NULL | NULL | 0 | deleted | 2048 | 1 | ubuntu-charging-2 | bcomp78 | IyEvYmluL3NoCnBhc3N3ZCB1YnVudHU8PEVPRgp1YnVudHUKdWJ1bnR1CkVPRgpzZWQgLWkgJ3MvUGFzc3dvcmRBdXRoZW50aWNhdGlvbiBuby9QYXNzd29yZEF1dGhlbnRpY2F0aW9uIHllcy9nJyAvZXRjL3NzaC9zc2hkX2NvbmZpZwpzZXJ2aWNlIHNzaCByZXN0YXJ0CmV4aXQgMAo= | r-87nq950o | NULL | 2018-06-15 17:00:12 | 2018-08-08 05:55:57 | ubuntu-charging-2 | NULL | bComp78-dpdk | 0 | NULL | bcomp78 | 6 | NULL | 34f4a451-a9a6-466e-9b67-4b3aec1bef7d | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 20 | 0 | NULL | bcomp78.localdomain | 1 | NULL | 1 | NULL |
| 2018-08-06 03:38:07 | 2019-01-23 08:10:01 | NULL | 2 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 171469a3-833a-41b4-b26c-5d2a0a21371b | | | 0 | NULL | NULL | 4 | stopped | 2048 | 1 | redhat-vm | bcomp78 | NULL | r-o5g4t571 | NULL | 2018-08-06 03:38:19 | NULL | redhat-vm | redhat-vm | bComp78-dpdk | 1 | NULL | bcomp78 | 6 | NULL | 6c797c7f-d975-49db-bdb4-92308f443ec3 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 1 | 0 | 0 | 20 | 0 | NULL | bcomp78.localdomain | 0 | owner | 0 | NULL |
| 2018-08-08 06:10:51 | 2018-08-08 06:14:23 | 2018-08-08 06:14:23 | 3 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 7374610b-b1f9-4652-95b3-2eaedc364c05 | | | 0 | NULL | NULL | 0 | error | 2048 | 1 | ubuntu-charging-2 | NULL | IyEvYmluL3NoCnBhc3N3ZCB1YnVudHU8PEVPRgp1YnVudHUKdWJ1bnR1CkVPRgpzZWQgLWkgJ3MvUGFzc3dvcmRBdXRoZW50aWNhdGlvbiBuby9QYXNzd29yZEF1dGhlbnRpY2F0aW9uIHllcy9nJyAvZXRjL3NzaC9zc2hkX2NvbmZpZwpzZXJ2aWNlIHNzaCByZXN0YXJ0CmV4aXQgMAo= | r-5rl5kab5 | NULL | NULL | NULL | ubuntu-charging-2 | NULL | bComp78-dpdk | 0 | NULL | bcomp78 | 6 | NULL | 65be9464-315b-4080-acf7-f4d221661d7f | NULL | /dev/vda | NULL | NULL | | deleting | NULL | NULL | 0 | 0 | 0 | 0 | 20 | 0 | NULL | NULL | 3 | NULL | 1 | NULL |
| 2018-08-08 06:16:26 | 2018-08-08 06:17:07 | 2018-08-08 06:17:07 | 4 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 7374610b-b1f9-4652-95b3-2eaedc364c05 | | | 0 | NULL | NULL | 0 | error | 2048 | 1 | ubuntu-charging-2 | NULL | IyEvYmluL3NoCnBhc3N3ZCB1YnVudHU8PEVPRgp1YnVudHUKdWJ1bnR1CkVPRgpzZWQgLWkgJ3MvUGFzc3dvcmRBdXRoZW50aWNhdGlvbiBuby9QYXNzd29yZEF1dGhlbnRpY2F0aW9uIHllcy9nJyAvZXRjL3NzaC9zc2hkX2NvbmZpZwpzZXJ2aWNlIHNzaCByZXN0YXJ0CmV4aXQgMAo= | r-m872gfsf | NULL | NULL | NULL | ubuntu-charging-2 | NULL | bComp78-dpdk | 0 | NULL | bcomp78 | 6 | NULL | a1cf8b16-a74b-4307-bd18-72d4f52f6939 | NULL | /dev/vda | NULL | NULL | | deleting | NULL | NULL | 0 | 0 | 0 | 0 | 20 | 0 | NULL | NULL | 4 | NULL | 1 | NULL |
| 2018-08-08 06:17:39 | 2018-08-08 06:18:14 | 2018-08-08 06:18:14 | 5 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 7374610b-b1f9-4652-95b3-2eaedc364c05 | | | 0 | NULL | NULL | 0 | error | 2048 | 1 | ubuntu-charging-2 | NULL | IyEvYmluL3NoCnBhc3N3ZCB1YnVudHU8PEVPRgp1YnVudHUKdWJ1bnR1CkVPRgpzZWQgLWkgJ3MvUGFzc3dvcmRBdXRoZW50aWNhdGlvbiBuby9QYXNzd29yZEF1dGhlbnRpY2F0aW9uIHllcy9nJyAvZXRjL3NzaC9zc2hkX2NvbmZpZwpzZXJ2aWNlIHNzaCByZXN0YXJ0CmV4aXQgMAo= | r-t51ycpzq | NULL | NULL | NULL | ubuntu-charging-2 | NULL | bComp78-dpdk | 0 | NULL | bcomp78 | 6 | NULL | e2870b85-2c04-4dc8-83ee-b4bb652761a3 | NULL | /dev/vda | NULL | NULL | | deleting | NULL | NULL | 0 | 0 | 0 | 0 | 20 | 0 | NULL | NULL | 5 | NULL | 1 | NULL |
| 2018-08-08 06:21:53 | 2018-08-08 06:36:10 | 2018-08-08 06:36:10 | 6 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 7374610b-b1f9-4652-95b3-2eaedc364c05 | | | 0 | NULL | NULL | 0 | deleted | 2048 | 1 | ubuntu-charging-2 | bcomp78 | IyEvYmluL3NoCnBhc3N3ZCB1YnVudHU8PEVPRgp1YnVudHUKdWJ1bnR1CkVPRgpzZWQgLWkgJ3MvUGFzc3dvcmRBdXRoZW50aWNhdGlvbiBuby9QYXNzd29yZEF1dGhlbnRpY2F0aW9uIHllcy9nJyAvZXRjL3NzaC9zc2hkX2NvbmZpZwpzZXJ2aWNlIHNzaCByZXN0YXJ0CmV4aXQgMAo= | r-ew6cs669 | NULL | 2018-08-08 06:21:56 | 2018-08-08 06:36:10 | ubuntu-charging-2 | NULL | bComp78-dpdk | 0 | NULL | bcomp78 | 6 | NULL | 70213dac-663b-44c1-81bc-22beba965b3e | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 20 | 0 | NULL | bcomp78.localdomain | 6 | NULL | 1 | NULL |
| 2018-08-08 06:37:44 | 2019-01-23 08:10:01 | NULL | 7 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 7374610b-b1f9-4652-95b3-2eaedc364c05 | | | 0 | NULL | NULL | 4 | stopped | 2048 | 1 | ubuntu-charging-2 | bcomp78 | IyEvYmluL3NoCnBhc3N3ZCB1YnVudHU8PEVPRgp1YnVudHUKdWJ1bnR1CkVPRgpzZWQgLWkgJ3MvUGFzc3dvcmRBdXRoZW50aWNhdGlvbiBuby9QYXNzd29yZEF1dGhlbnRpY2F0aW9uIHllcy9nJyAvZXRjL3NzaC9zc2hkX2NvbmZpZwpzZXJ2aWNlIHNzaCByZXN0YXJ0CmV4aXQgMAo= | r-yjf8nis6 | NULL | 2018-08-08 06:37:46 | NULL | ubuntu-charging-2 | NULL | bComp78-dpdk | 0 | NULL | bcomp78 | 6 | NULL | 0603f27e-8f94-400a-a043-38fd783ce108 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 20 | 0 | NULL | bcomp78.localdomain | 0 | NULL | 0 | NULL |
| 2018-08-08 06:56:15 | 2018-08-08 07:03:05 | 2018-08-08 07:03:05 | 8 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 73826a01-2de3-4031-a4a0-535feefa4a23 | | | 0 | NULL | NULL | 0 | deleted | 512 | 1 | ubuntu-charging | bcomp78 | IyEvYmluL3NoCnBhc3N3ZCB1YnVudHU8PEVPRgp1YnVudHUKdWJ1bnR1CkVPRgpzZWQgLWkgJ3MvUGFzc3dvcmRBdXRoZW50aWNhdGlvbiBuby9QYXNzd29yZEF1dGhlbnRpY2F0aW9uIHllcy9nJyAvZXRjL3NzaC9zc2hkX2NvbmZpZwpzZXJ2aWNlIHNzaCByZXN0YXJ0CmV4aXQgMAo= | r-bp33c0r4 | NULL | 2018-08-08 06:56:17 | 2018-08-08 07:03:04 | ubuntu-charging | NULL | bComp78-dpdk | 0 | NULL | bcomp78 | 8 | NULL | 93fc88d8-5f92-467b-83ce-b54222e2fbea | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 1 | 0 | NULL | bcomp78.localdomain | 8 | NULL | 1 | NULL |
| 2018-08-08 07:04:26 | 2019-01-23 08:10:01 | NULL | 9 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 7374610b-b1f9-4652-95b3-2eaedc364c05 | | | 0 | NULL | NULL | 4 | stopped | 2048 | 1 | ubuntu-charging | bcomp78 | IyEvYmluL3NoCnBhc3N3ZCB1YnVudHU8PEVPRgp1YnVudHUKdWJ1bnR1CkVPRgpzZWQgLWkgJ3MvUGFzc3dvcmRBdXRoZW50aWNhdGlvbiBuby9QYXNzd29yZEF1dGhlbnRpY2F0aW9uIHllcy9nJyAvZXRjL3NzaC9zc2hkX2NvbmZpZwpzZXJ2aWNlIHNzaCByZXN0YXJ0CmV4aXQgMAo= | r-h7q7kttb | NULL | 2018-08-08 07:04:28 | NULL | ubuntu-charging | NULL | bComp78-dpdk | 0 | NULL | bcomp78 | 6 | NULL | 58113f2f-d366-41cf-9f13-7516227db02a | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 20 | 0 | NULL | bcomp78.localdomain | 0 | NULL | 0 | NULL |
| 2018-09-05 00:13:54 | 2019-01-29 17:44:12 | NULL | 10 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 7374610b-b1f9-4652-95b3-2eaedc364c05 | | | 0 | NULL | NULL | 4 | stopped | 2048 | 1 | ubuntu-vm | aio70 | IyEvYmluL3NoCnBhc3N3ZCB1YnVudHU8PEVPRgp1YnVudHUKdWJ1bnR1CkVPRgpzZWQgLWkgJ3MvUGFzc3dvcmRBdXRoZW50aWNhdGlvbiBuby9QYXNzd29yZEF1dGhlbnRpY2F0aW9uIHllcy9nJyAvZXRjL3NzaC9zc2hkX2NvbmZpZwpzZXJ2aWNlIHNzaCByZXN0YXJ0 | r-2ijsfs5d | NULL | 2018-09-05 00:14:03 | NULL | ubuntu-vm | ubuntu-vm | aio70 | 0 | NULL | aio70 | 5 | NULL | 806de8d7-85c3-496e-95ae-39c085b3834f | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 1 | 0 | 0 | 20 | 0 | NULL | aio70.localdomain | 0 | NULL | 0 | NULL |
| 2018-10-11 16:37:43 | 2018-10-11 17:00:29 | 2018-10-11 17:00:30 | 11 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 73826a01-2de3-4031-a4a0-535feefa4a23 | | | 0 | NULL | NULL | 0 | deleted | 512 | 1 | cirros-vm01 | aio70 | NULL | r-np5ajok8 | NULL | 2018-10-11 16:37:46 | 2018-10-11 17:00:29 | cirros-vm01 | cirros-vm01 | aio70 | 0 | NULL | aio70 | 2 | NULL | 4c3e0888-4cab-4e80-b20d-e53c95feda55 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 1 | 0 | 0 | 1 | 0 | NULL | aio70.localdomain | 11 | NULL | 1 | NULL |
| 2018-10-11 20:07:04 | 2019-01-23 08:10:01 | NULL | 12 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 7374610b-b1f9-4652-95b3-2eaedc364c05 | | | 0 | NULL | NULL | 4 | stopped | 2048 | 1 | ubuntu-vm-v4v6 | bcomp78 | IyEvYmluL3NoCnBhc3N3ZCB1YnVudHU8PEVPRgp1YnVudHUKdWJ1bnR1CkVPRgpzZWQgLWkgJ3MvUGFzc3dvcmRBdXRoZW50aWNhdGlvbiBuby9QYXNzd29yZEF1dGhlbnRpY2F0aW9uIHllcy9nJyAvZXRjL3NzaC9zc2hkX2NvbmZpZwpzZXJ2aWNlIHNzaCByZXN0YXJ0 | r-laoic92f | NULL | 2018-10-11 20:07:06 | NULL | ubuntu-vm-v4+v6 | ubuntu-vm-v4+v6 | bComp78-dpdk | 0 | NULL | bcomp78 | 6 | NULL | 4a473dd8-30ec-4e79-bed4-6d8626e95938 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 1 | 0 | 0 | 20 | 0 | NULL | bcomp78.localdomain | 0 | NULL | 0 | NULL |
| 2019-01-18 21:52:30 | 2019-01-29 17:44:12 | NULL | 13 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 73826a01-2de3-4031-a4a0-535feefa4a23 | | | 0 | NULL | NULL | 4 | stopped | 512 | 1 | cirros-vm1-vn-1-jiang | aio70 | NULL | r-qai7kd1p | NULL | 2019-01-18 21:52:32 | NULL | cirros-vm1_VN-1-Jiang | cirros-vm1_VN-1-Jiang | aio70 | 0 | NULL | aio70 | 2 | NULL | ef679ce1-16d2-4fd2-989c-d4733bc94f5e | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 1 | 0 | 0 | 1 | 0 | NULL | aio70.localdomain | 0 | NULL | 0 | NULL |
| 2019-01-18 21:57:13 | 2019-01-29 17:44:12 | NULL | 14 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 73826a01-2de3-4031-a4a0-535feefa4a23 | | | 0 | NULL | NULL | 4 | stopped | 512 | 1 | cirros-vm2-vn-2-jiang | aio70 | NULL | r-36mo5nbk | NULL | 2019-01-18 21:57:15 | NULL | cirros-vm2_VN-2-Jiang | cirros-vm2_VN-2-Jiang | aio70 | 0 | NULL | aio70 | 2 | NULL | 0718bf1c-6cec-4e1b-846c-f9b593737cf7 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 1 | 0 | 0 | 1 | 0 | NULL | aio70.localdomain | 0 | NULL | 0 | NULL |
| 2019-01-23 01:43:10 | 2019-01-23 05:56:28 | 2019-01-23 05:56:28 | 15 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 73826a01-2de3-4031-a4a0-535feefa4a23 | | | 0 | NULL | NULL | 0 | deleted | 512 | 1 | cirros-vm-vn-test | bcomp78 | NULL | r-8obkubhl | NULL | 2019-01-23 01:43:12 | 2019-01-23 05:56:28 | cirros-vm-VN-TEST | cirros-vm-VN-TEST | bComp78-dpdk | 0 | NULL | bcomp78 | 8 | NULL | 6a496d72-8836-4b9e-8ab6-d17c6fa0d34b | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 1 | 0 | 0 | 1 | 0 | NULL | bcomp78.localdomain | 15 | NULL | 1 | NULL |
| 2019-01-23 06:00:22 | 2019-01-23 08:10:01 | NULL | 16 | NULL | 4ed108861477437aba80fb796c747958 | 756fdd163a5949129fb3be6d1e9920f1 | 73826a01-2de3-4031-a4a0-535feefa4a23 | | | 0 | NULL | NULL | 4 | stopped | 512 | 1 | vm-cirros | bcomp78 | NULL | r-zia48vu8 | NULL | 2019-01-23 06:00:24 | NULL | vm-cirros | vm-cirros | bComp78-dpdk | 0 | NULL | bcomp78 | 8 | NULL | c83f84d8-caee-4979-a81d-365ce2048098 | NULL | /dev/vda | NULL | NULL | | NULL | NULL | NULL | 0 | 1 | 0 | 0 | 1 | 0 | NULL | bcomp78.localdomain | 0 | NULL | 0 | NULL |
+---------------------+---------------------+---------------------+----+-------------+----------------------------------+----------------------------------+--------------------------------------+-----------+------------+--------------+----------+----------+-------------+----------+-----------+-------+-----------------------+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+--------------+---------------------+---------------------+-----------------------+-----------------------+-------------------+--------+---------+-------------+------------------+---------+--------------------------------------+--------------+------------------+--------------+--------------+--------------+------------+--------------------------+---------------------+----------+------------------+--------------------+-------------------+---------+--------------+-----------+---------------------+---------+-----------+---------+--------------------+
16 rows in set (0.00 sec)
mysqldump keystone DB table project from field and import into lab