压缩文件
bzip2 -z filename
作者归档:杨龙
Got fatal error 1236 from master when reading data from binary log: ‘Binary log is not open’
Got fatal error 1236 from master when reading data from binary log: ‘Binary log is not open’
Master没有开启log_bin
https://dev.mysql.com/doc/refman/5.6/en/replication-howto-masterbaseconfig.html
[mysqld] log-bin=mysql-bin server-id=1 innodb_flush_log_at_trx_commit=1 sync_binlog=1
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
Nginx常规配置
server_tokens off;
client_max_body_size 1024M;
nginx和php版本号隐藏
Nginx版本隐藏
| Syntax: | server_tokens on | off | build | string; |
|---|---|
| Default: |
server_tokens on; |
| Context: | http, server, location |
PHP版本隐藏
; Decides whether PHP may expose the fact that it is installed on the server
; (e.g. by adding its signature to the Web server header). It is no security
; threat in any way, but it makes it possible to determine whether you use PHP
; on your server or not.
; http://php.net/expose-php
expose_php = Off
authorized_keys
chmod 600 .ssh/authorized_keys
chmod 700 .ssh
com.zend.verifier_13.6.1.v20170623-1730.jar
–slave-skip-errors 不支持下列值
1007,1008,1050,1051,1054,1060,1061,1068,1094,1146.
LVM新安装初始化
/dev/vdb 为空白新磁盘
创建pv
pvcreate /dev/vdb
创建vg
vgcreate vg1 /dev/vdb
创建lv
lvcreate -L 100G -n lvMongodb vg1
或者(使用100%的剩余空间)
lvcreate -l 100%Free -n lvMysql vg1
LVM LV热扩容[ext4]
lvextend -L +5G /dev/mapper/vg1-lvMysql
resize2fs /dev/mapper/vg1-lvMysql
当然前提是PV还有PFree可以使用