Author Archives: fencatn

创建ceph存储时常见问题汇总

背景 OS:Ubuntu 16.04 修改了osd的一些配置,修改后,需要重启osd服务才能生效。第一次重启后,配置立刻生效。再改了一些配置,重启osd服务后,配置却不再生效了。ps命令查看进程,发现osd进程都没有启动。 分析 osd进程未启动,第一直觉就是配置出错,osd进程启动后又挂掉。于是,进入/var/log/ceph目录,查看ceph-osd.0.log,发现日志末尾只有关闭进程的相关日志,并没有osd启动的信息。再查看该日志的时间,时间就是关闭服务时的时间。换句话说,第二次重启服务后,osd没有启动。既然没有启动,那就不是osd本身的问题,而是和重启服务的命令systemctl restart ceph-osd.target相关了。 先检查下osd服务的状态。 $ systemctl status ceph-osd.target ● ceph-osd.target – ceph target allowing to start/stop all [email protected] instances at once Loaded: loaded (/lib/systemd/system/ceph-osd.target; enabled; vendor preset: enabled) Active: inactive (dead) since Sun 2017-03-05 16:52:04 … Continue reading

Posted in ceph | Tagged | Leave a comment

Ceph块存储和对象存储

1 案例1:块存储应用案例 1.1 问题 延续Day04的实验内容,演示块存储在KVM虚拟化中的应用案例,实现以下功能: Ceph创建块存储镜像 客户端安装部署ceph软件 客户端部署虚拟机 客户端创建secret 设置虚拟机配置文件,调用ceph存储 1.2 方案 使用Ceph存储创建镜像。 KVM虚拟机调用Ceph镜像作为虚拟机的磁盘。 1.3 步骤 实现此案例需要按照如下步骤进行。 1)创建磁盘镜像。 [root@node1 ~]# rbd create vm1-image –image-feature layering –size 10G [root@node1 ~]# rbd create vm2-image –image-feature layering –size 10G [root@node1 ~]# rbd list … Continue reading

Posted in ceph | Tagged | Leave a comment

创建ceph集群时常见问题徽宗

问题一: 时间不同步 [root@node1 ~]# ceph -s cluster 29908a48-7574-4aac-ac14-80a44b7cffbf health HEALTH_WARN clock skew detected on mon.node2, mon.node3 Monitor clock skew detected monmap e1: 3 mons at {node1=192.168.4.11:6789/0,node2=192.168.4.12:6789/0,node3=192.168.4.13:6789/0} election epoch 10, quorum 0,1,2 node1,node2,node3 osdmap e36: 6 osds: 6 up, 6 in … Continue reading

Posted in ceph | Tagged | Leave a comment

创建ceph集群

创建ceph集群 使用4台虚拟机,1台客户端、3台存储集群服务器,IP规划如下 client 192.168.4.10 node1 192.168.4.11 node2 192.168.4.12 node3 192.168.4.13 步骤一:安装前准备 1)物理机为所有节点配置yum源,注意所有的虚拟主机均需要挂载安装光盘。 [root@root9pc01 ~]# yum -y install vsftpd [root@root9pc01 ~]# mkdir /var/ftp/ceph ################################## 把cluster解压并挂载到FTP目录 [root@room9pc52 ~]# cd cluster/ [root@room9pc52 cluster]# ll 总用量 968676 drwxr-xr-x 2 root root 4096 6月 12 … Continue reading

Posted in ceph | Tagged | Leave a comment

创建LVS集群

案例:练习使用ipvsadm 先配置yum源 [root@60 ~]# yum-config-manager –add ftp://192.168.4.254/rhel7 已加载插件:langpacks, product-id adding repo from: ftp://192.168.4.254/rhel7 [192.168.4.254_rhel7] name=added from: ftp://192.168.4.254/rhel7 baseurl=ftp://192.168.4.254/rhel7 enabled=1 [root@60 ~]# echo “gpgcheck=0” >> /etc/yum.repos.d/ 192.168.4.254_rhel7.repo redhat.repo [root@60 ~]# echo “gpgcheck=0” >> /etc/yum.repos.d/192.168.4.254_rhel7.repo 开始装包ipvsadm [root@60 ~]# yum install -y ipvsadm … Continue reading

Posted in ceph | Tagged | Leave a comment

Msql扩展查询操作练习

–创建测试数据 create table Student(S# varchar(10),Sname nvarchar(10),Sage datetime,Ssex nvarchar(10)) insert into Student values(’01’ , N’赵雷’ , ‘1990-01-01′ , N’男’) insert into Student values(’02’ , N’钱电’ , ‘1990-12-21′ , N’男’) insert into Student values(’03’ , N’孙风’ , ‘1990-05-20′ , N’男’) insert into … Continue reading

Posted in mysql | Tagged | Leave a comment

案例:Mysql基本查询练习

+++++++++++++++++++++++++++++++++++++++++++++++++++ 表基本操作练习题 1 复制user表的所有记录到teadb库的teacher表里 只复制user表的表结构给新teadb库的tea2表 mysql> create table teacher select * from teadb; Query OK, 41 rows affected (0.32 sec) Records: 41  Duplicates: 0  Warnings: 0   mysql> select * from teacher; +—-+———————+——+——+——–+———-+——-+——-+—————————————————————–+—————————+—————-+———-+ | id | name                | sex  | age  | s_year | password | uid   | gid   | comment                                                         | homedir                   | shell          | pay      | +—-+———————+——+——+——–+———-+——-+——-+—————————————————————–+—————————+—————-+———-+ |  1 | root                | boy  |   21 |   1990 | x        |     0 |     0 | root                                                            | /root                     | /sbin/nologin  | 30000.00 | |  2 | bin                 | boy  |   21 |   1990 | x        |     1 |     1 | bin                                                             | /bin                      | /sbin/nologin  |  5000.00 | |  4 | adm                 | boy  |   21 |   1990 | x        |     3 |     4 | adm                                                             | /var/adm                  | /sbin/nologin  |  5000.00 | |  5 | lp                  | boy  |   21 |   1990 | x        |     4 |     7 | lp                                                              | /var/spool/lpd            | /sbin/nologin  |  5000.00 | |  6 | sync                | boy  |   21 |   1990 | x        |     5 |     0 | sync                                                            | /sbin                     | /sbin/nologin  |  5000.00 | |  7 | shutdown            | boy  |   21 |   1990 | x        |     6 |     0 | shutdown                                                        | /sbin                     | /sbin/shutdown |  5000.00 | |  8 | halt                | boy  |   21 |   1990 | x        |     7 |     0 | halt                                                            | /sbin                     | /sbin/halt     |  5000.00 | |  9 | mail                | boy  |   21 |   1990 | x        |     8 |    12 | mail                                                            | /var/spool/mail           | /sbin/nologin  |  5000.00 | | 10 | operator            | girl |   21 |   1990 | x        |    11 |     0 | operator                                                        | /root                     | /sbin/nologin  | 10000.00 | | 11 | games               | girl |   21 |   1990 | x        |    12 |   100 | games                                                           | /root                     | /sbin/nologin  | 10000.00 | | 12 | ftp                 | girl |   21 |   1990 | x        |    14 |    50 | FTP User                                                        | /var/ftp                  | /sbin/nologin  | 10000.00 | | 13 | nobody              | girl |   21 |   1990 | x        |    99 |    99 | Nobody                                                          | /                         | /sbin/nologin  | 10000.00 | | 14 | systemd-network     | girl |   21 |   1990 | x        |   192 |   192 | systemd Network Management                                      | /root                     | /sbin/nologin  | 10000.00 | | 16 | polkitd             | girl |   21 |   1990 | x        |   999 |   998 | User for polkitd                                                | /                         | /sbin/nologin  | 10000.00 | | 17 | libstoragemgmt      | girl |   21 |   1990 | x        |   998 |   996 | daemon account for libstoragemgmt                               | /var/run/lsm              | /sbin/nologin  | 10000.00 | | 18 | rpc                 | girl |   21 |   1990 | x        |    32 |    32 | Rpcbind Daemon                                                  | /var/lib/rpcbind          | /sbin/nologin  | 10000.00 | | 19 | colord              | girl |   21 |   1990 | x        |   997 |   995 | User for colord                                                 | /var/lib/colord           | /sbin/nologin  | 10000.00 | | 20 | saslauth            | girl |   21 |   1990 | x        |   996 |    76 | Saslauthd user                                                  | /run/saslauthd            | /sbin/nologin  | 10000.00 | | 21 | abrt                | girl |   21 |   1990 | x        |   173 |   173 |                                                                 | /root                     | /sbin/nologin  | 10000.00 | | 22 | rtkit               | girl |   21 |   1990 | x        |   172 |   172 | RealtimeKit                                                     | /root                     | /sbin/nologin  | 10000.00 | | 23 | radvd               | girl |   21 |   1990 | x        |    75 |    75 | radvd user                                                      | /                         | /sbin/nologin  | 10000.00 | | 24 | chrony              | girl |   21 |   1990 | x        |   995 |   993 |                                                                 | /var/lib/chrony           | /sbin/nologin  | 10000.00 | | 25 | tss                 | girl |   21 |   1990 | x        |    59 |    59 | Account used by the trousers package to sandbox the tcsd daemon | /dev/null                 | /sbin/nologin  | 10000.00 | | 26 | usbmuxd             | girl |   21 |   1990 | x        |   113 |   113 | usbmuxd user                                                    | /root                     | /sbin/nologin  | 10000.00 | | 27 | geoclue             | girl |   21 |   1990 | x        |   994 |   991 | User for geoclue                                                | /var/lib/geoclue          | /sbin/nologin  | 10000.00 | | 28 | qemu                | girl |   21 |   1990 | x        |   107 |   107 | qemu user                                                       | /root                     | /sbin/nologin  | 10000.00 | | 29 | rpcuser             | girl |   21 |   1990 | x        |    29 |    29 | RPC Service User                                                | /var/lib/nfs              | /sbin/nologin  | 10000.00 | | 30 | nfsnobody           | girl |   21 |   1990 | x        | 65534 | 65534 | Anonymous NFS User                                              | /var/lib/nfs              | /sbin/nologin  | 10000.00 | … Continue reading

Posted in mysql | Tagged | Leave a comment

Day05.Mysql备份与恢复

物理备份 rm -rf /var/lib/mysql/* systemctl stop mysqld rm -rf /var/lib/mysql 把刚才的备份文件拷贝到的当前库下 scp 192.168.4.50:/root/mysql.bak /var/lib/mysql/ 重启正常 重新初始化数据库 1、停数据库服务 systemctl stop mysqld 2、删除库 rm -rf /var/lib/mysql/* 3、重新启动,mysql数据库会自己检测 [root@51 mysql]# grep password /var/log/mysqld.log | tail 2018-09-13T02:33:34.691299Z 0 [Note] Shutting down plugin ‘sha256_password’ 2018-09-13T02:33:34.691305Z … Continue reading

Posted in mysql | Tagged | Leave a comment

Day04.Mysql查询

复制表 1、把整张表,包括数据,全部复制 mysql> create table tea8 select * from tea7; Query OK, 8 rows affected (0.32 sec) Records: 8 Duplicates: 0 Warnings: 0 mysql> select * from tea8; +—-+—–+——–+———+————-+ | id | age | name | sex | hobby | … Continue reading

Posted in mysql | Tagged | Leave a comment

Day03.Mysql字段值操作

mysql> show engines; +——————–+———+—————————————————————-+————–+——+————+ | Engine | Support | Comment | Transactions | XA | Savepoints | +——————–+———+—————————————————————-+————–+——+————+ | InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | MRG_MYISAM | … Continue reading

Posted in mysql | Tagged | Leave a comment