技术标签: openstack&ceph openstack 数据库
首先获取nova数据库的密码
控制节点执行:grep mysql /etc/kolla/nova-api/nova.conf
【目录不是固定的,可以通过find命令查找nova.conf文件查看】,如下,1Gr2qFT0LmZ46v0GrFUJmXEFTTBHWVWzofxkxLAn就是密码
[root@controller01 ~]# grep mysql /etc/kolla/nova-api/nova.conf
connection = mysql+pymysql://nova:[email protected]:3306/nova
connection = mysql+pymysql://nova_api:[email protected]:3306/nova_api
[root@controller01 ~]#
肯定会有一个数据库容器的,如我这是mariadb
[root@controller01 ~]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES openvswitch_vswitchd
...
0e12fe84c1d1 1.2.101.32:9980/kolla/centos-binary-iscsid:5.0.6.6 "kolla_start" 2 years ago Up 2 years iscsid
fcaf8d58d941 1.2.101.32:9980/kolla/centos-binary-mariadb:5.0.6.6 "kolla_start" 2 years ago Up 23 months mariadb
85cb175184b1 1.2.101.32:9980/kolla/centos-binary-memcached:5.0.6.6 "kolla_start" 2 years ago Up 23 months memcached
...
[root@controller01 ~]#
[root@controller01 ~]# docker exec -it mariadb /bin/bash
(mariadb)[mysql@controller01 /]$ mysql -unova -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 170661721
Server version: 10.0.38-MariaDB-wsrep MariaDB Server, wsrep_25.25.rc3fc46e
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
(mariadb)[mysql@controller01 /]$ mysql -unova -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 170666994
Server version: 10.0.38-MariaDB-wsrep MariaDB Server, wsrep_25.25.rc3fc46e
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> 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
MariaDB [nova]>
MariaDB [nova]> select * from instances where uuid= '19ec09a5-151b-4111-a4bd-636d10794912' \G
*************************** 1. row ***************************
created_at: 2022-01-18 14:15:33
updated_at: 2023-10-12 01:33:59
deleted_at: NULL
id: 3237
internal_id: NULL
user_id: cd7e88be84f14196a468f443b345288c
project_id: 22fce3ac5d094a32a652555584dd47fb
image_ref:
kernel_id:
ramdisk_id:
launch_index: 0
key_name: NULL
key_data: NULL
power_state: 0
vm_state: active
memory_mb: 65536
vcpus: 16
hostname: rms-database2
host: compute30
user_data: I2Nsb3VkLWNvbmZpZw0KZGlzYWJsZV9yb290OiBGYWxzZQ0KcGFzc3dvcmQ6IGlSbVNEYXRhQmFzZTNKIyEha2UmaiheXikNCmNocGFzc3dkOg0KICAgIGxpc3Q6IHwNCiAgICAgICAgICByb290OmlSbVNEYXRhQmFzZTNKIyEha2UmaiheXikNCiAgICBleHBpcmU6IEZhbHNlDQpzc2hfcHdhdXRoOiBUcnVl
reservation_id: r-zvgjpx0l
launched_at: 2022-01-18 14:16:02
terminated_at: NULL
display_name: rms-database2
display_description: rms-database2
availability_zone: core
locked: 0
os_type: NULL
launched_on: compute30
instance_type_id: 70
vm_mode: NULL
uuid: 19ec09a5-151b-4111-a4bd-636d10794912
architecture: NULL
root_device_name: /dev/vda
access_ip_v4: NULL
access_ip_v6: NULL
config_drive: True
task_state: NULL
default_ephemeral_device: NULL
default_swap_device: NULL
progress: 0
auto_disk_config: 0
shutdown_terminate: 0
disable_terminate: 0
root_gb: 200
ephemeral_gb: 0
cell_name: NULL
node: compute30
deleted: 0
locked_by: NULL
cleaned: 0
ephemeral_key_uuid: NULL
1 row in set (0.00 sec)
MariaDB [nova]>
[root@compute30 ~]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
0f14cdcf6f90 1.2.101.32:9980/kolla/centos-binary-neutron-openvswitch-agent:5.0.6.6 "kolla_start" 2 years ago Up 2 years neutron_openvswitch_agent
733b936d9a69 1.2.101.32:9980/kolla/centos-binary-openvswitch-vswitchd:5.0.6.6 "kolla_start" 2 years ago Up 2 years openvswitch_vswitchd
d3dfc7bd9741 1.2.101.32:9980/kolla/centos-binary-openvswitch-db-server:5.0.6.6 "kolla_start" 2 years ago Up 2 years openvswitch_db
cc979a6d2dc3 1.2.101.32:9980/kolla/centos-binary-nova-compute:5.0.6.6 "kolla_start" 2 years ago Up 4 months nova_compute
2fd8430c10fc 1.2.101.32:9980/kolla/centos-binary-nova-libvirt:5.0.6.6 "kolla_start" 2 years ago Up 2 years nova_libvirt
5317fd6f9dc4 1.2.101.32:9980/kolla/centos-binary-nova-ssh:5.0.6.6 "kolla_start" 2 years ago Up 2 years nova_ssh
63dc84cd0a08 1.2.101.32:9980/kolla/centos-binary-chrony:5.0.6.6 "kolla_start" 2 years ago Up 13 months chrony
c502dcb7f5d1 1.2.101.32:9980/kolla/centos-binary-cron:5.0.6.6 "kolla_start" 2 years ago Up 2 years cron
37f17293ad92 1.2.101.32:9980/kolla/centos-binary-kolla-toolbox:5.0.6.6 "kolla_start" 2 years ago Up 2 years kolla_toolbox
aa0a7798f731 1.2.101.32:9980/kolla/centos-binary-fluentd:5.0.6.6 "dumb-init --single-…" 2 years ago Up 2 years fluentd
[root@compute30 ~]#
/var/lib/nova/instances/
【你的如果不是就用find搜索instances即可】[root@compute30 ~]# docker exec -it nova_libvirt bash
(nova-libvirt)[root@compute30 /]# cd /var/lib/nova/instances/
(nova-libvirt)[root@compute30 instances]# ls
19ec09a5-151b-4111-a4bd-636d10794912 b0cc2a24-1c9c-46d3-bd3b-ef90b78c871c b7a9b013-d364-4588-b8ae-f6cbd4ba704f _base daaf62bf-ed53-4a16-892a-798ac427254b f8a41b8e-c989-4645-9f18-fdeee075c8d9
4fad6565-b24b-4617-bb8e-4110ebd43026 b3b091ee-fcbc-4a2a-8a09-7250ee144f3c b99dc9e3-0d6b-4b3b-965a-d4e10791c4f0 compute_nodes f76744d4-afbc-4d92-80e0-cbdb7b30be15 locks
(nova-libvirt)[root@compute30 instances]# cd 19ec09a5-151b-4111-a4bd-636d10794912/
(nova-libvirt)[root@compute30 19ec09a5-151b-4111-a4bd-636d10794912]# ls
console.log
(nova-libvirt)[root@compute30 19ec09a5-151b-4111-a4bd-636d10794912]#
[root@compute30 ~]# docker exec -it nova_compute bash
(nova-compute)[nova@compute30 /]$ cd /var/lib/nova/instances/
(nova-compute)[nova@compute30 /var/lib/nova/instances]$ ls
19ec09a5-151b-4111-a4bd-636d10794912 _base b3b091ee-fcbc-4a2a-8a09-7250ee144f3c b99dc9e3-0d6b-4b3b-965a-d4e10791c4f0 daaf62bf-ed53-4a16-892a-798ac427254b f8a41b8e-c989-4645-9f18-fdeee075c8d9
4fad6565-b24b-4617-bb8e-4110ebd43026 b0cc2a24-1c9c-46d3-bd3b-ef90b78c871c b7a9b013-d364-4588-b8ae-f6cbd4ba704f compute_nodes f76744d4-afbc-4d92-80e0-cbdb7b30be15 locks
(nova-compute)[nova@compute30 /var/lib/nova/instances]$ cd 19ec09a5-151b-4111-a4bd-636d10794912/
(nova-compute)[nova@compute30 /var/lib/nova/instances/19ec09a5-151b-4111-a4bd-636d10794912]$ ls
console.log
(nova-compute)[nova@compute30
[root@compute30 ~]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
0f14cdcf6f90 1.2.101.32:9980/kolla/centos-binary-neutron-openvswitch-agent:5.0.6.6 "kolla_start" 2 years ago Up 2 years neutron_openvswitch_agent
733b936d9a69 1.2.101.32:9980/kolla/centos-binary-openvswitch-vswitchd:5.0.6.6 "kolla_start" 2 years ago Up 2 years openvswitch_vswitchd
d3dfc7bd9741 1.2.101.32:9980/kolla/centos-binary-openvswitch-db-server:5.0.6.6 "kolla_start" 2 years ago Up 2 years openvswitch_db
cc979a6d2dc3 1.2.101.32:9980/kolla/centos-binary-nova-compute:5.0.6.6 "kolla_start" 2 years ago Up 4 months nova_compute
2fd8430c10fc 1.2.101.32:9980/kolla/centos-binary-nova-libvirt:5.0.6.6 "kolla_start" 2 years ago Up 2 years nova_libvirt
5317fd6f9dc4 1.2.101.32:9980/kolla/centos-binary-nova-ssh:5.0.6.6 "kolla_start" 2 years ago Up 2 years nova_ssh
63dc84cd0a08 1.2.101.32:9980/kolla/centos-binary-chrony:5.0.6.6 "kolla_start" 2 years ago Up 13 months chrony
c502dcb7f5d1 1.2.101.32:9980/kolla/centos-binary-cron:5.0.6.6 "kolla_start" 2 years ago Up 2 years cron
37f17293ad92 1.2.101.32:9980/kolla/centos-binary-kolla-toolbox:5.0.6.6 "kolla_start" 2 years ago Up 2 years kolla_toolbox
aa0a7798f731 1.2.101.32:9980/kolla/centos-binary-fluentd:5.0.6.6 "dumb-init --single-…" 2 years ago Up 2 years fluentd
[root@compute30 ~]#
[root@compute30 ~]# docker exec -it nova_libvirt bash
(nova-libvirt)[root@compute30 /]#
(nova-libvirt)[root@compute30 /]# virsh list --all
Id Name State
----------------------------------------------------
27 instance-00000c37 running
33 instance-00000cf0 running
41 instance-00000e08 running
45 instance-0000144d running
52 instance-00000c5a running
54 instance-00000c0a running
60 instance-00000d0e running
(nova-libvirt)[root@compute30 /]#
(nova-libvirt)[root@compute30 /]# virsh domuuid 27
b99dc9e3-0d6b-4b3b-965a-d4e10791c4f0
(nova-libvirt)[root@compute30 /]#
(nova-libvirt)[root@compute30 /]# virsh domuuid 33
b0cc2a24-1c9c-46d3-bd3b-ef90b78c871c
(nova-libvirt)[root@compute30 /]#
docker exec NAMES 命令
【docker ps 查看NAMES】[root@compute30 ~]# docker exec nova_libvirt virsh list --all
Id Name State
----------------------------------------------------
27 instance-00000c37 running
33 instance-00000cf0 running
41 instance-00000e08 running
45 instance-0000144d running
54 instance-00000c0a running
79 instance-00000ca5 running
[root@compute30 ~]#
[root@compute30 ~]# docker exec nova_libvirt virsh domuuid 27
b99dc9e3-0d6b-4b3b-965a-d4e10791c4f0
[root@compute30 ~]#
[root@compute30 ~]# docker exec nova_compute date
Thu Oct 12 17:40:38 CST 2023
[root@compute30 ~]#
文章浏览阅读451次。dev/mem: 物理内存的全镜像。可以用来访问物理内存。/dev/kmem: kernel看到的虚拟内存的全镜像。可以用来访问kernel的内容。调试嵌入式Linux内核时,可能需要查看某个内核变量的值。/dev/kmem正好提供了访问内核虚拟内存的途径。现在的内核大都默认禁用了/dev/kmem,打开的方法是在 make menuconfig中选中 device drivers --> ..._dev/mem 源码实现
文章浏览阅读7.1k次,点赞2次,收藏19次。vxe-table,一个小众但功能齐全并支持excel操作的vue表格组件_vxe-table
文章浏览阅读62次。参考:http://www.ruanyifeng.com/blog/2016/01/babel.htmlBabelBabel是一个广泛使用的转码器,可以将ES6代码转为ES5代码,从而在现有环境执行// 转码前input.map(item => item + 1);// 转码后input.map(function (item) { return item..._让开发环境支持bable
文章浏览阅读2.8k次,点赞6次,收藏29次。摘要:FPGA视频处理FIFO的典型应用,视频输入FIFO的作用,视频输出FIFO的作用,视频数据跨时钟域FIFO,视频缩放FIFO的作用_fpga 频分复用 视频
文章浏览阅读575次。【代码】R语言:设置工作路径为当前文件存储路径。_r语言设置工作目录到目标文件夹
文章浏览阅读452次。格式:background: linear-gradient(direction, color-stop1, color-stop2, ...);<linear-gradient> = linear-gradient([ [ <angle> | to <side-or-corner>] ,]? &l..._background线性渐变
文章浏览阅读1k次,点赞26次,收藏8次。第十三届蓝桥杯青少年组python编程省赛真题一、题目要求(注:input()输入函数的括号中不允许添加任何信息)1、编程实现给定一个正整数N,输出正整数N中各数位最大的那个数字。例如:N=132,则输出3。2、输入输出输入描述:只有一行,输入一个正整数N输出描述:只有一行,输出正整数N中各数位最大的那个数字输入样例:
文章浏览阅读2.2k次。一个网络协议主要由以下三个要素组成:1.语法数据与控制信息的结构或格式,包括数据的组织方式、编码方式、信号电平的表示方式等。2.语义即需要发出何种控制信息,完成何种动作,以及做出何种应答,以实现数据交换的协调和差错处理。3.时序即事件实现顺序的详细说明,以实现速率匹配和排序。不完整理解:语法表示长什么样,语义表示能干什么,时序表示排序。转载于:https://blog.51cto.com/98..._网络协议三要素csdn
文章浏览阅读153次。主要的思想,将所有的系统都可以看作两部分,真正的数据log系统和各种各样的query engine所有的一致性由log系统来保证,其他各种query engine不需要考虑一致性,安全性,只需要不停的从log系统来同步数据,如果数据丢失或crash可以从log系统replay来恢复可以看出kafka系统在linkedin中的重要地位,不光是d..._the log: what every software engineer should know about real-time data's uni
文章浏览阅读746次。伟大是熬出来的 目录 前言 引言 时间熬成伟大:领导者要像狼一样坚忍 第一章 内圣外王——领导者的心态修炼 1. 天纵英才的自信心 2. 上天揽月的企图心 3. 誓不回头的决心 4. 宠辱不惊的平常心 5. 换位思考的同理心 6. 激情四射的热心 第二章 日清日高——领导者的高效能修炼 7. 积极主动,想到做到 8. 合理掌控自己的时间和生命 9. 制定目标,马..._当狼拖着受伤的右腿逃生时,右腿会成为前进的阻碍,它会毫不犹豫撕咬断自己的腿, 以
文章浏览阅读285次。在当今的大数据时代,人们对高速度和高带宽的需求越来越大,迫切希望有一种新型产品来作为高性能计算和数据中心的主要传输媒质,所以有源光缆(AOC)在这种环境下诞生了。有源光缆究竟是什么呢?应用在哪些领域,有什么优势呢?易天将为您解答!有源光缆(Active Optical Cables,简称AOC)是两端装有光收发器件的光纤线缆,主要构成部件分为光路和电路两部分。作为一种高性能计..._aoc 光缆
文章浏览阅读2.2k次。在“桌面”上按快捷键“Ctrl+R”,调出“运行”窗口。接着,在“打开”后的输入框中输入“Gpedit.msc”。并按“确定”按钮。如下图 找到“用户配置”下的“Windows设置”下的“Internet Explorer 维护”的“连接”,双击选择“自动浏览器配置”。如下图 选择“自动启动配置”,并在下面的“自动代理URL”中填写相应的PAC文件地址。如下..._設置proxy腳本