以下是 多 vrrp_instance 配置 ,主备只需调整 优先级即可
# Configuration File for keepalived
global_defs {
router_id
HA1
}
vrrp_script chk_mysql {
script
'sh /etc/keepalived/chk_mysql'
interval
2
weight
15
}
标签：
openssh
sshd
tcp_wrappers
|
分类：
*nux
|
想用 hosts.deny
限制某些机器 ssh 登录, 结果怎么都不行
ldd /usr/sbin/sshd 没有发现
libwrap.so 文件. google 后发现
linux-vdso.so.1 => (0x00007fffaa7e0000)
libpam.so.0 => /lib64/libpam.so.0
(0x00007fe92b084000)
libcrypto.so.1.0.0 => /usr/local/ssl/lib/libcrypto.so.1.0.0
(0x00007fe92ac4c000)
librt.so.1 => /lib64/librt.so.1 (0x00007fe92aa43000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fe92a83f000)
libutil.so.1 => /lib64/libutil.so.1
(0x00007fe92a63c000)
libz.so.1 => /usr/lib/libz.so.1 (0x00007fe92a423000)
libcrypt.so.1 => /lib64/libcrypt.so.1
(0x00007fe92a1ec000)
libresolv.so.2 => /lib64/libresolv.so.2
(0x00007fe929fd2000)
libc.so.6 => /lib64/libc.so.6 (0x00007fe929c3e000)
libaudit.so.1 => /lib64/libaudit.so.1
(0x00007fe929a22000)
在mysql 5.6中新增了 这个参数
innodb_buffer_pool_instances,
一直不太理解这个参数的意义,知道在国外的一篇 mysql 5.7 的性能测试文档中看到了端倪, 之前 此参数都是默认配置,
即 为1 ,后来看了国外的文档后才 恍然大悟,
借用官方的文档吧
The number of regions that the InnoDB buffer pool is divided
into. For systems with buffer pools in the multi-gigabyte range,
dividing the buffer pool into separate instances can improve
concurrency, by reducing contention as different threads read and
write to cached pages. Each page that is stored in or read from the
buffer pool is assigned to one of the buffer pool instances
randomly, using a hashing function. Each buffer pool manages its
own free lists, flush lists, LRUs, and all other data structures
connected to a buffer pool, and is protected by its own buffer pool
mutex.
This option takes effect only when you set the
innodb_buffer_pool_size to a size of 1 gigabyte or more
在标准化 nginx log_format 时,碰到这个问题, 于是搜索了下,发现
记录日志时是完全不同的
直接看日志吧
'192.168.160.1' http_host:'192.168.160.159:808'
host:'192.168.160.159' '[08/Apr/2016:15:37:06 +0800]' 'GET /
HTTP/1.1' '304' '0' '171' '-' '-' 'Mozilla/5.0 (Windows NT 6.1;
WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.110
Safari/537.36' '-' '-' '-' '0.000'
(2015-10-18 15:06)
标签：
mysql
mysql修改密码
mysql修改密码方法汇
|
分类：
database
|
1) 用mysqladmin 设置或修改密码
[root@mysql ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 2
Server version: 5.5.46 MySQL Community Server (GPL)
Copyright (c) 2000, 2015, 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> \q
Bye
从上边可以看到登陆mysql不需要密码,
接下来是mysql 首次安装后 设置密码
[root@mysql ~]# /opt/soft/mysql/bin/mysqladmin -u root
password 'password';
设置成功后不会有任何提示信息. 再尝试登陆发现无法登陆了.
标签：
linux查看阵列卡信息
linux查看raid信息方
|
分类：
网路存储
|
利用linux系统内置命令 lspci -v 来查看
[root@svn-slave ~]# lspci -v
00:00.0 Host bridge: Intel Corporation Clarkdake DRAM Controller
(rev 12)
Subsystem: Giga-byte
Technology Unknown device 5000
Flags: bus master, fast
devsel, latency 0
Capabilities: [e0]
Vendor Specific Information
00:01.0 PCI bridge: Intel Corporation Clarkdale PCI Express x16
Root Port (rev 12) (prog-if 00 [Normal decode])
Flags: bus master, fast
devsel, latency 0
Bus: primary=00,
secondary=01, subordinate=01, sec-latency=0
I/O behind bridge:
0000d000-0000dfff
Memory behind bridge:
f6000000-f9ffffff
&nb
linux网站服务器 在上去维护的时候意外发现,执行某些命令的时候就提示 bus
error,执行last w
等等 都提示 执行失败,用 uptime
查看开机时间,发现已经连续运行205天了,怀疑是系统问题或者别入侵了
于是 用 shutdown -r now 重启,没反应,用halt 关闭不好用,用 poweroff
无反应, 用 poweroff -f 机器直接关闭电源了.然后去机房开机,接着就提示 disk
error ,又关闭电源重启还是不行,索性将电源线拔了,等了1分钟开机,看到了久违的centos开机画面.
开机后 赶紧备份数据.估计硬盘到寿了.
(2013-01-27 21:43)
标签：
excel2007
大小写转换
excel人民币大小写转
it
|
|
引言
,在公司经常需要写资金申请单,在最后金额总计处总会涉及人民币大小写的选项,有的时候非常忙,经常搞的焦头烂额的,改了小写的金额,忘了改大写的金额,找领导签字时被领导一顿K是难免的.怎么办呢,其实很简单只要一个函数或者是财务人员excel功夫了得,在涉及表格的时候就该为我们设计好贴心的申请表格.没办法,我们公司的财务表格使用的不是很好.自己来解决吧.
首先根据公司资金申请表的形式做了如下修改.
1
实现每次当想填写资金申请表时都显示当前的时间,这个在网上搜索了下,只要在要显示日期的位置加入一个函数即可
如 =TODAY()
,但是这样显示的是2013/*/*,不合适,还需手工将短日期格式改成长日期格式.
http://s12/mw690/647a104ftd445bdfd571b&690
2 对于人民币大小写 一直是个头痛的问题,在excelhome
转载▼
加载中…