分类目录归档:Linux

resize2fs: Bad magic number in super-block while trying to open /dev/mapper/vg1-lvMysql

resize2fs 对xfs无效问题

resize2fs 1.42.9 (28-Dec-2013)
resize2fs: Bad magic number in super-block while trying to open /dev/mapper/vg1-lvMysql
Couldn’t find valid filesystem superblock.

xfs_growfs /dev/centos/root
df -h

ref:https://www.cnblogs.com/pinganzi/p/6478255.html

[root@web5 ~]# xfs_growfs /mnt/mysql
meta-data=/dev/mapper/vg1-lvMysql isize=512    agcount=4, agsize=7864320 blks
         =                       sectsz=512   attr=2, projid32bit=1
         =                       crc=1        finobt=0 spinodes=0
data     =                       bsize=4096   blocks=31457280, imaxpct=25
         =                       sunit=0      swidth=0 blks
naming   =version 2              bsize=4096   ascii-ci=0 ftype=1
log      =internal               bsize=4096   blocks=15360, version=2
         =                       sectsz=512   sunit=0 blks, lazy-count=1
realtime =none                   extsz=4096   blocks=0, rtextents=0
data blocks changed from 31457280 to 44564480

org.apache.solr.common.SolrException: Exception writing document id 663b167f2d661568 to the index; possible analysis error: cannot change DocValues type from SORTED_SET to NUMERIC for field “is_original”

org.apache.solr.common.SolrException: Exception writing document id 663b167f2d661568 to the index; possible analysis error: cannot change DocValues type from SORTED_SET to NUMERIC for field "is_original"

我这里修改tints类型为tint类型,导致新数据无法写入,字段删除完毕了,也reload了没有,只要清理的数据才行

<delete><query>*:*</query></delete>
<commit/>

xtrabackup 快速增量备份教程

xtrabackup –backup –compress –target-dir=/mysqlbackup/full –user=aaa –host=hostname –password=xxxx –databases=ggggg

xtrabackup –backup –compress –target-dir=/mysqlbackup/incr –incremental-basedir=/mysqlbackup/full –user=aaa –host=hostname –password=xxxx –databases=ggggg

 

–compress 压缩

Centos7开放端口

开启防火墙
systemctl enable firewalld.service
# 启用某服务
firewall-cmd --permanent --zone=public --add-service=http
firewall-cmd --permanent --zone=public --add-service=https
# 移除某端口
firewall-cmd --zone=public --remove-port=80/tcp --permanent
# reload 使修改生效
firewall-cmd --reload
# 查看生效的配置
firewall-cmd --list-all
# 查看防火墙是否启动
firewall-cmd --stat
# 开放80端口
firewall-cmd --zone=public --add-port=80/tcp --permanent
# reload生效
firewall-cmd --reload

mongodb 3.4 官方资源导航

1. keyfiles内部验证
https://docs.mongodb.com/manual/core/security-internal-authentication/#keyfiles

2. 使用keyfile进行复制集之间的验证
https://docs.mongodb.com/manual/tutorial/enforce-keyfile-access-control-in-existing-replica-set/

3. 用户权限规矩
https://docs.mongodb.com/manual/reference/built-in-roles/#built-in-roles