-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.html
289 lines (240 loc) · 35.2 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
<!DOCTYPE html><html lang="zh-CN" data-theme="light"><head><meta charset="UTF-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=device-width, initial-scale=1.0,viewport-fit=cover"><title>菜鸡运维 - 只会摸鱼</title><meta name="author" content="Eddie"><meta name="copyright" content="Eddie"><meta name="format-detection" content="telephone=no"><meta name="theme-color" content="#ffffff"><meta name="description" content="这是我的博客网站">
<meta property="og:type" content="website">
<meta property="og:title" content="菜鸡运维">
<meta property="og:url" content="https://starli.co/index.html">
<meta property="og:site_name" content="菜鸡运维">
<meta property="og:description" content="这是我的博客网站">
<meta property="og:locale" content="zh_CN">
<meta property="og:image" content="https://starli.co/img/1.jpg">
<meta property="article:author" content="Eddie">
<meta property="article:tag" content="菜鸡运维">
<meta name="twitter:card" content="summary">
<meta name="twitter:image" content="https://starli.co/img/1.jpg"><link rel="shortcut icon" href="/img/1.jpg"><link rel="canonical" href="https://starli.co/index.html"><link rel="preconnect" href="//cdn.jsdelivr.net"/><link rel="preconnect" href="//busuanzi.ibruce.info"/><link rel="stylesheet" href="/css/index.css"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@fortawesome/fontawesome-free/css/all.min.css" media="print" onload="this.media='all'"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@fancyapps/ui/dist/fancybox/fancybox.min.css" media="print" onload="this.media='all'"><script>const GLOBAL_CONFIG = {
root: '/',
algolia: undefined,
localSearch: {"path":"/search.xml","preload":false,"top_n_per_article":1,"unescape":false,"languages":{"hits_empty":"找不到您查询的内容：${query}","hits_stats":"共找到 ${hits} 篇文章"}},
translate: undefined,
noticeOutdate: undefined,
highlight: {"plugin":"highlighjs","highlightCopy":true,"highlightLang":true,"highlightHeightLimit":false},
copy: {
success: '复制成功',
error: '复制错误',
noSupport: '浏览器不支持'
},
relativeDate: {
homepage: false,
post: false
},
runtime: '天',
dateSuffix: {
just: '刚刚',
min: '分钟前',
hour: '小时前',
day: '天前',
month: '个月前'
},
copyright: undefined,
lightbox: 'fancybox',
Snackbar: undefined,
source: {
justifiedGallery: {
js: 'https://cdn.jsdelivr.net/npm/flickr-justified-gallery/dist/fjGallery.min.js',
css: 'https://cdn.jsdelivr.net/npm/flickr-justified-gallery/dist/fjGallery.min.css'
}
},
isPhotoFigcaption: false,
islazyload: false,
isAnchor: false,
percent: {
toc: true,
rightside: false,
},
autoDarkmode: false
}</script><script id="config-diff">var GLOBAL_CONFIG_SITE = {
title: '菜鸡运维',
isPost: false,
isHome: true,
isHighlightShrink: false,
isToc: false,
postUpdate: '2023-08-03 18:39:40'
}</script><noscript><style type="text/css">
#nav {
opacity: 1
}
.justified-gallery img {
opacity: 1
}
#recent-posts time,
#post-meta time {
display: inline !important
}
</style></noscript><script>(win=>{
win.saveToLocal = {
set: function setWithExpiry(key, value, ttl) {
if (ttl === 0) return
const now = new Date()
const expiryDay = ttl * 86400000
const item = {
value: value,
expiry: now.getTime() + expiryDay,
}
localStorage.setItem(key, JSON.stringify(item))
},
get: function getWithExpiry(key) {
const itemStr = localStorage.getItem(key)
if (!itemStr) {
return undefined
}
const item = JSON.parse(itemStr)
const now = new Date()
if (now.getTime() > item.expiry) {
localStorage.removeItem(key)
return undefined
}
return item.value
}
}
win.getScript = url => new Promise((resolve, reject) => {
const script = document.createElement('script')
script.src = url
script.async = true
script.onerror = reject
script.onload = script.onreadystatechange = function() {
const loadState = this.readyState
if (loadState && loadState !== 'loaded' && loadState !== 'complete') return
script.onload = script.onreadystatechange = null
resolve()
}
document.head.appendChild(script)
})
win.getCSS = (url,id = false) => new Promise((resolve, reject) => {
const link = document.createElement('link')
link.rel = 'stylesheet'
link.href = url
if (id) link.id = id
link.onerror = reject
link.onload = link.onreadystatechange = function() {
const loadState = this.readyState
if (loadState && loadState !== 'loaded' && loadState !== 'complete') return
link.onload = link.onreadystatechange = null
resolve()
}
document.head.appendChild(link)
})
win.activateDarkMode = function () {
document.documentElement.setAttribute('data-theme', 'dark')
if (document.querySelector('meta[name="theme-color"]') !== null) {
document.querySelector('meta[name="theme-color"]').setAttribute('content', '#0d0d0d')
}
}
win.activateLightMode = function () {
document.documentElement.setAttribute('data-theme', 'light')
if (document.querySelector('meta[name="theme-color"]') !== null) {
document.querySelector('meta[name="theme-color"]').setAttribute('content', '#ffffff')
}
}
const t = saveToLocal.get('theme')
if (t === 'dark') activateDarkMode()
else if (t === 'light') activateLightMode()
const asideStatus = saveToLocal.get('aside-status')
if (asideStatus !== undefined) {
if (asideStatus === 'hide') {
document.documentElement.classList.add('hide-aside')
} else {
document.documentElement.classList.remove('hide-aside')
}
}
const detectApple = () => {
if(/iPad|iPhone|iPod|Macintosh/.test(navigator.userAgent)){
document.documentElement.classList.add('apple')
}
}
detectApple()
})(window)</script><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/static-butterfly/dist/css/index.min.css"><link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/[email protected]/mainColor/heoMainColor.css"><link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/[email protected]/poem/poem.css"><link rel="stylesheet" href="/css/progress_bar.css?v1"><link rel="stylesheet" href="/css/MyStyle.css?v1"><meta name="generator" content="Hexo 6.3.0"></head><body><div id="sidebar"><div id="menu-mask"></div><div id="sidebar-menus"><div class="avatar-img is-center"><img src="/img/1.jpg" onerror="onerror=null;src='/img/friend_404.gif'" alt="avatar"/></div><div class="sidebar-site-data site-data is-center"><a href="/archives/"><div class="headline">文章</div><div class="length-num">14</div></a><a href="/tags/"><div class="headline">标签</div><div class="length-num">10</div></a><a href="/categories/"><div class="headline">分类</div><div class="length-num">3</div></a></div><hr/><div class="menus_items"><div class="menus_item"><a class="site-page" href="/"><i class="fa-fw fas fa-home"></i><span> 首页</span></a></div><div class="menus_item"><a class="site-page" href="/archives/"><i class="fa-fw fas fa-archive"></i><span> 时间线</span></a></div><div class="menus_item"><a class="site-page" href="/tags/"><i class="fa-fw fas fa-tags"></i><span> 标签</span></a></div><div class="menus_item"><a class="site-page" href="/categories/"><i class="fa-fw fas fa-folder-open"></i><span> 分类</span></a></div><div class="menus_item"><a class="site-page group" href="javascript:void(0);"><i class="fa-fw fas fa-list"></i><span> 休闲</span><i class="fas fa-chevron-down"></i></a><ul class="menus_item_child"><li><a class="site-page child" href="/music/"><i class="fa-fw fas fa-music"></i><span> 音乐</span></a></li><li><a class="site-page child" href="/movies/"><i class="fa-fw fas fa-video"></i><span> 电影</span></a></li></ul></div><div class="menus_item"><a class="site-page" href="/link/"><i class="fa-fw fas fa-link"></i><span> 友链</span></a></div><div class="menus_item"><a class="site-page" href="/about/"><i class="fa-fw fas fa-heart"></i><span> 关于</span></a></div></div></div></div><div class="page" id="body-wrap"><header class="full_page" id="page-header" style="background-image: url('/img/index.jpeg')"><nav id="nav"><span id="blog-info"><a href="/" title="菜鸡运维"><span class="site-name">菜鸡运维</span></a></span><div id="menus"><div id="search-button"><a class="site-page social-icon search" href="javascript:void(0);"><i class="fas fa-search fa-fw"></i><span> 搜索</span></a></div><div class="menus_items"><div class="menus_item"><a class="site-page" href="/"><i class="fa-fw fas fa-home"></i><span> 首页</span></a></div><div class="menus_item"><a class="site-page" href="/archives/"><i class="fa-fw fas fa-archive"></i><span> 时间线</span></a></div><div class="menus_item"><a class="site-page" href="/tags/"><i class="fa-fw fas fa-tags"></i><span> 标签</span></a></div><div class="menus_item"><a class="site-page" href="/categories/"><i class="fa-fw fas fa-folder-open"></i><span> 分类</span></a></div><div class="menus_item"><a class="site-page group" href="javascript:void(0);"><i class="fa-fw fas fa-list"></i><span> 休闲</span><i class="fas fa-chevron-down"></i></a><ul class="menus_item_child"><li><a class="site-page child" href="/music/"><i class="fa-fw fas fa-music"></i><span> 音乐</span></a></li><li><a class="site-page child" href="/movies/"><i class="fa-fw fas fa-video"></i><span> 电影</span></a></li></ul></div><div class="menus_item"><a class="site-page" href="/link/"><i class="fa-fw fas fa-link"></i><span> 友链</span></a></div><div class="menus_item"><a class="site-page" href="/about/"><i class="fa-fw fas fa-heart"></i><span> 关于</span></a></div></div><div id="toggle-menu"><a class="site-page" href="javascript:void(0);"><i class="fas fa-bars fa-fw"></i></a></div></div></nav><div id="site-info"><h1 id="site-title">菜鸡运维</h1><div id="site_social_icons"><a class="social-icon" href="https://github.com/lihc520" target="_blank" title="Github"><i class="fab fa-github"></i></a></div></div><div id="scroll-down"><i class="fas fa-angle-down scroll-down-effects"></i></div></header><main class="layout" id="content-inner"><div class="recent-posts" id="recent-posts"><div class="recent-post-item"><div class="post_cover left"><a href="/posts/33744e0d.html" title="ubuntu22编译安装php7"><img class="post-bg" src="/img/php.png" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="ubuntu22编译安装php7"></a></div><div class="recent-post-info"><a class="article-title" href="/posts/33744e0d.html" title="ubuntu22编译安装php7">ubuntu22编译安装php7</a><div class="article-meta-wrap"><span class="post-meta-date"><i class="far fa-calendar-alt"></i><span class="article-meta-label">发表于</span><time datetime="2023-05-31T03:05:11.000Z" title="发表于 2023-05-31 11:05:11">2023-05-31</time></span></div><div class="content">ubuntu22 编译安装php74ub22 with openssl 1.1.1u123./Configure --prefix=/usr/local/openssl --openssldir=/usr/local/openssl -fPIC -shared linux-x86_64make -j8 && make installecho /usr/local/openssl/lib > /etc/ld.so.conf.d/openssl.conf
curl 7.88.112./configure --prefix=/usr/local/curl --with-ssl=/usr/local/opensslmake -j 8 && make install
install icu 70.x12./configure --prefix=/usr/localmake -j 8 && make install
install php123456789101112131415161718192021222324252627282930 ...</div></div></div><div class="recent-post-item"><div class="post_cover right"><a href="/posts/34dfb976.html" title="mysql查看数据库空间大小"><img class="post-bg" src="/img/mysql.jpg" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="mysql查看数据库空间大小"></a></div><div class="recent-post-info"><a class="article-title" href="/posts/34dfb976.html" title="mysql查看数据库空间大小">mysql查看数据库空间大小</a><div class="article-meta-wrap"><span class="post-meta-date"><i class="far fa-calendar-alt"></i><span class="article-meta-label">发表于</span><time datetime="2022-07-08T09:00:49.000Z" title="发表于 2022-07-08 17:00:49">2022-07-08</time></span></div><div class="content">123# 查看总大小mysql> use information_schema;mysql> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES;
1234# 查看每个库的大小SELECTtable_schema,SUM(AVG_ROW_LENGTH*TABLE_ROWS+INDEX_LENGTH)/1024/1024 AS total_mbFROM information_schema.TABLES group by table_schema;
12# 选库查看select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES where table_schema='tdm_uat';
123456789# 查看所有数据库各容量大小selecttable_schema as '数据库',sum(table_ ...</div></div></div><div class="recent-post-item"><div class="post_cover left"><a href="/posts/5c09c70b.html" title="nginx日志分析"><img class="post-bg" src="/img/nginx.png" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="nginx日志分析"></a></div><div class="recent-post-info"><a class="article-title" href="/posts/5c09c70b.html" title="nginx日志分析">nginx日志分析</a><div class="article-meta-wrap"><span class="post-meta-date"><i class="far fa-calendar-alt"></i><span class="article-meta-label">发表于</span><time datetime="2022-07-08T04:42:07.000Z" title="发表于 2022-07-08 12:42:07">2022-07-08</time></span><span class="article-meta"><span class="article-meta-separator">|</span><i class="fas fa-inbox"></i><a class="article-meta__categories" href="/categories/nginx/">nginx</a></span></div><div class="content">统计PV,UV数
统计所有的PV数
cat access.log | wc -l
统计当天的PV数
cat access.log | sed -n /date “+%d/%b/%Y”/p | wc -l
统计指定某一天的PV数
cat access.log | sed -n '/20\/Aug\/2019/p' | wc -l
根据访问IP统计UV
awk '{print $1}' access.log|sort | uniq -c |wc -l
统计指定某一天访问IP统计UV
cat access.log | grep "07/Apr/2019:0[4-5]" | awk '{print $1}' access.log|sort | uniq -c |wc -l
IP相关统计
统计IP访问量（独立ip访问数量）
awk '{print $1}' access.log | sort -n | uniq | wc -l
查看 ...</div></div></div><div class="recent-post-item"><div class="post_cover right"><a href="/posts/273b3b5.html" title="rsync传输工具"><img class="post-bg" src="/img/rsync.png" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="rsync传输工具"></a></div><div class="recent-post-info"><a class="article-title" href="/posts/273b3b5.html" title="rsync传输工具">rsync传输工具</a><div class="article-meta-wrap"><span class="post-meta-date"><i class="far fa-calendar-alt"></i><span class="article-meta-label">发表于</span><time datetime="2022-07-08T04:38:34.000Z" title="发表于 2022-07-08 12:38:34">2022-07-08</time></span><span class="article-meta"><span class="article-meta-separator">|</span><i class="fas fa-inbox"></i><a class="article-meta__categories" href="/categories/linux/">linux</a></span></div><div class="content">1234567891011121314151617# 拷贝本地文件。当SRC和DES路径信息都不包含有单个冒号”:”分隔符时就启动这种工作模式。如：rsync -a /data /backuprsync [OPTION]... SRC DEST # 使用一个远程shell程序(如rsh、ssh)来实现将本地机器的内容拷贝到远程机器。当DST路径地址包含单个冒号”:”分隔符时启动该模式。如：rsync -avz *.c foo:srcrsync [OPTION]... SRC [USER@]HOST:DEST # 使用一个远程shell程序(如rsh、ssh)来实现将远程机器的内容拷贝到本地机器。当SRC地址路径包含单个冒号”:”分隔符时启动该模式。如：rsync -avz foo:src/bar /datarsync [OPTION]... [USER@]HOST:SRC DEST # 从远程rsync服务器中拷贝文件到本地机。当SRC路径信息包含”::”分隔符时启动该模式。如：rsync -av [email protected]::www /databackrsync [OPTI ...</div></div></div><div class="recent-post-item"><div class="post_cover left"><a href="/posts/98419899.html" title="nginx匹配规则"><img class="post-bg" src="/img/nginx.png" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="nginx匹配规则"></a></div><div class="recent-post-info"><a class="article-title" href="/posts/98419899.html" title="nginx匹配规则">nginx匹配规则</a><div class="article-meta-wrap"><span class="post-meta-date"><i class="far fa-calendar-alt"></i><span class="article-meta-label">发表于</span><time datetime="2022-07-08T04:28:07.000Z" title="发表于 2022-07-08 12:28:07">2022-07-08</time></span><span class="article-meta"><span class="article-meta-separator">|</span><i class="fas fa-inbox"></i><a class="article-meta__categories" href="/categories/linux/">linux</a></span></div><div class="content">123456789~ #波浪线表示执行一个正则匹配，区分大小写~* #表示执行一个正则匹配，不区分大小写^~ #^~表示普通字符匹配，如果该选项匹配，只匹配该选项，不匹配别的选项，一般用来匹配目录= #进行普通字符精确匹配@ #"@" 定义一个命名的 location，使用在内部定向时，例如 error_page, try_file
location 匹配的优先级(与location在配置文件中的顺序无关)
= 精确匹配会第一个被处理。如果发现精确匹配，nginx停止搜索其他匹配。普通字符匹配，正则表达式规则和长的块规则将被优先和查询匹配，也就是说如果该项匹配还需去看有没有正则表达式匹配和更长的匹配。^~ 则只匹配该规则，nginx停止搜索其他匹配，否则nginx会继续处理其他location指令。最后匹配理带有”“和”*”的指令，如果找到相应的匹配，则nginx停止搜索其他匹配；当没有正则表达式或者没有正则表达式被匹配的情况下，那么匹配程度最高的逐字匹配指令会被使用。
location 优先级官方文档
123456781. Directives wit ...</div></div></div><div class="recent-post-item"><div class="post_cover right"><a href="/posts/b0f371d5.html" title="mysql备份"><img class="post-bg" src="/img/mysql.jpg" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="mysql备份"></a></div><div class="recent-post-info"><a class="article-title" href="/posts/b0f371d5.html" title="mysql备份">mysql备份</a><div class="article-meta-wrap"><span class="post-meta-date"><i class="far fa-calendar-alt"></i><span class="article-meta-label">发表于</span><time datetime="2022-07-08T04:27:03.000Z" title="发表于 2022-07-08 12:27:03">2022-07-08</time></span><span class="article-meta"><span class="article-meta-separator">|</span><i class="fas fa-inbox"></i><a class="article-meta__categories" href="/categories/linux/">linux</a></span></div><div class="content">[MySql数据库备份的几种方式]mysqldump工具备份备份整个数据库
12$> mysqldump -u root -h host -p dbname > backdb.sql
备份数据库中的某个表
12$> mysqldump -u root -h host -p dbname tbname1, tbname2 > backdb.sql
备份多个数据库
12$> mysqldump -u root -h host -p --databases dbname1, dbname2 > backdb.sql
备份系统中所有数据库
12$> mysqldump -u root -h host -p --all-databases > backdb.sql
直接复制整个数据库目录(对于InnoDB存储引擎不适用)备份windowns: installpath/mysql/data
linux: /var/lib/mysql
在复制前需要先执行如下命令：
12345MYSQL> ...</div></div></div><div class="recent-post-item"><div class="post_cover left"><a href="/posts/1ebd6834.html" title="nginx中文乱码"><img class="post-bg" src="/img/nginx.png" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="nginx中文乱码"></a></div><div class="recent-post-info"><a class="article-title" href="/posts/1ebd6834.html" title="nginx中文乱码">nginx中文乱码</a><div class="article-meta-wrap"><span class="post-meta-date"><i class="far fa-calendar-alt"></i><span class="article-meta-label">发表于</span><time datetime="2022-07-08T03:14:44.000Z" title="发表于 2022-07-08 11:14:44">2022-07-08</time></span><span class="article-meta"><span class="article-meta-separator">|</span><i class="fas fa-inbox"></i><a class="article-meta__categories" href="/categories/linux/">linux</a></span></div><div class="content">12345678910111213upstream you.domainName.com {server 127.0.0.1:8080;}server { listen 80; server_name you.domainName.com; charset utf-8; ##添加这段 location /examples { return 403; }}
修改后，重启Nginx服务。
</div></div></div><div class="recent-post-item"><div class="post_cover right"><a href="/posts/b930f663.html" title="ssh端口转发"><img class="post-bg" src="/img/ssh.png" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="ssh端口转发"></a></div><div class="recent-post-info"><a class="article-title" href="/posts/b930f663.html" title="ssh端口转发">ssh端口转发</a><div class="article-meta-wrap"><span class="post-meta-date"><i class="far fa-calendar-alt"></i><span class="article-meta-label">发表于</span><time datetime="2022-07-07T20:30:20.000Z" title="发表于 2022-07-08 04:30:20">2022-07-08</time></span><span class="article-meta"><span class="article-meta-separator">|</span><i class="fas fa-inbox"></i><a class="article-meta__categories" href="/categories/linux/">linux</a></span></div><div class="content">本地端口转发命令：
ssh -L <local port>:<remote host>:<remote port> <SSH hostname>
例如，需要把本地8080端口转发到172.18.247.180这台机器上的8888端口，只需要执行下面的命令即可：
ssh -L 8080:172.18.247.180:8888 172.18.247.180
这个命令可以稍微优化一下：
ssh -CfNg -L 8081:172.18.247.180:8888 172.18.247.180
但是这样每次都要去记忆IP和端口也不是很方便，所以可以考虑使用脚本来完成，下面就是一个我临时写的脚本，命令为forward.sh：
#!/bin/bash if [ $1 == "start" ]; then echo "port forwarding starting..." ssh -CfNg -L 8081:172.18.247.180:8888 172.18.247.180 ssh -C ...</div></div></div><div class="recent-post-item"><div class="post_cover left"><a href="/posts/9279f870.html" title="mysql主从同步"><img class="post-bg" src="/img/mysql.jpg" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="mysql主从同步"></a></div><div class="recent-post-info"><a class="article-title" href="/posts/9279f870.html" title="mysql主从同步">mysql主从同步</a><div class="article-meta-wrap"><span class="post-meta-date"><i class="far fa-calendar-alt"></i><span class="article-meta-label">发表于</span><time datetime="2021-11-02T09:00:24.000Z" title="发表于 2021-11-02 17:00:24">2021-11-02</time></span><span class="article-meta"><span class="article-meta-separator">|</span><i class="fas fa-inbox"></i><a class="article-meta__categories" href="/categories/linux/">linux</a></span></div><div class="content">
Hosts
CPU
MEM
HD
OS
192.168.1.102 db01
8
16G
100G
Ubuntu20.04
192.168.1.105 db02
8
16G
100G
Ubuntu20.04
192.168.1.108 db03
8
16G
100G
Ubuntu20.04
安装前修改两台服务器的hosts
12345# 三臺台服务器都要操作sudo vim /etc/hosts192.168.1.102 db01192.168.1.105 db02192.168.1.108 db03
創建MySQL存儲位置及日誌位置
12sudo mkdir -p /data/mysql && sudo mkdir -p /data/logs/mysqlsudo chmod -R mysql:mysql /data/mysql && sudo chmod -R mysql:mysql /data/logs/mysql
MySql5.7安装(三臺服務器進行同樣操作)1234567##下载所需安装包cd /optsud ...</div></div></div><div class="recent-post-item"><div class="post_cover right"><a href="/posts/484abec3.html" title="elk日志收集"><img class="post-bg" src="/img/elk.png" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="elk日志收集"></a></div><div class="recent-post-info"><a class="article-title" href="/posts/484abec3.html" title="elk日志收集">elk日志收集</a><div class="article-meta-wrap"><span class="post-meta-date"><i class="far fa-calendar-alt"></i><span class="article-meta-label">发表于</span><time datetime="2021-07-01T03:39:28.000Z" title="发表于 2021-07-01 11:39:28">2021-07-01</time></span><span class="article-meta"><span class="article-meta-separator">|</span><i class="fas fa-inbox"></i><a class="article-meta__categories" href="/categories/linux/">linux</a></span></div><div class="content">ELK客户端部署目前的架构是elasticsearch+logstash+filebeat+kibana+redis
通过filebeat收集数据发送到redis，然后logstash从redis中取数据发送到elasticsearch，最后通过kibana展示。
本文章讲述如何收集客户端日志。
es：10.168.2.44 端口9200
redis: 10.168.2.205 端口30379
安装logstash下载安装包： wget https://artifacts.elastic.co/downloads/logstash/logstash-7.13.2-linux-x86_64.tar.gz
解压：tar zxvf logstash-7.13.2-linux-x86_64.tar.gz && mv logstash-7.13.2 /usr/local/logstash
创建logstash.conf文件，添加以下内容
123456789101112131415161718192021222324252627282930inp ...</div></div></div><nav id="pagination"><div class="pagination"><span class="page-number current">1</span><a class="page-number" href="/page/2/#content-inner">2</a><a class="extend next" rel="next" href="/page/2/#content-inner"><i class="fas fa-chevron-right fa-fw"></i></a></div></nav></div><div class="aside-content" id="aside-content"><div class="card-widget card-info"><div class="is-center"><div class="avatar-img"><img src="/img/1.jpg" onerror="this.onerror=null;this.src='/img/friend_404.gif'" alt="avatar"/></div><div class="author-info__name">Eddie</div><div class="author-info__description">这是我的博客网站</div></div><div class="card-info-data site-data is-center"><a href="/archives/"><div class="headline">文章</div><div class="length-num">14</div></a><a href="/tags/"><div class="headline">标签</div><div class="length-num">10</div></a><a href="/categories/"><div class="headline">分类</div><div class="length-num">3</div></a></div><a id="card-info-btn" target="_blank" rel="noopener" href="https://github.com/lihc520"><i class="fab fa-github"></i><span>Follow Me</span></a><div class="card-info-social-icons is-center"><a class="social-icon" href="https://github.com/lihc520" target="_blank" title="Github"><i class="fab fa-github"></i></a></div></div><div class="card-widget card-announcement"><div class="item-headline"><i class="fas fa-bullhorn fa-shake"></i><span>公告</span></div><div class="announcement_content">偶尔记录一下</div></div><div class="sticky_layout"><div class="card-widget card-recent-post"><div class="item-headline"><i class="fas fa-history"></i><span>最新文章</span></div><div class="aside-list"><div class="aside-list-item"><a class="thumbnail" href="/posts/33744e0d.html" title="ubuntu22编译安装php7"><img src="/img/php.png" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="ubuntu22编译安装php7"/></a><div class="content"><a class="title" href="/posts/33744e0d.html" title="ubuntu22编译安装php7">ubuntu22编译安装php7</a><time datetime="2023-05-31T03:05:11.000Z" title="发表于 2023-05-31 11:05:11">2023-05-31</time></div></div><div class="aside-list-item"><a class="thumbnail" href="/posts/34dfb976.html" title="mysql查看数据库空间大小"><img src="/img/mysql.jpg" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="mysql查看数据库空间大小"/></a><div class="content"><a class="title" href="/posts/34dfb976.html" title="mysql查看数据库空间大小">mysql查看数据库空间大小</a><time datetime="2022-07-08T09:00:49.000Z" title="发表于 2022-07-08 17:00:49">2022-07-08</time></div></div><div class="aside-list-item"><a class="thumbnail" href="/posts/5c09c70b.html" title="nginx日志分析"><img src="/img/nginx.png" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="nginx日志分析"/></a><div class="content"><a class="title" href="/posts/5c09c70b.html" title="nginx日志分析">nginx日志分析</a><time datetime="2022-07-08T04:42:07.000Z" title="发表于 2022-07-08 12:42:07">2022-07-08</time></div></div><div class="aside-list-item"><a class="thumbnail" href="/posts/273b3b5.html" title="rsync传输工具"><img src="/img/rsync.png" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="rsync传输工具"/></a><div class="content"><a class="title" href="/posts/273b3b5.html" title="rsync传输工具">rsync传输工具</a><time datetime="2022-07-08T04:38:34.000Z" title="发表于 2022-07-08 12:38:34">2022-07-08</time></div></div><div class="aside-list-item"><a class="thumbnail" href="/posts/98419899.html" title="nginx匹配规则"><img src="/img/nginx.png" onerror="this.onerror=null;this.src='/img/404.jpg'" alt="nginx匹配规则"/></a><div class="content"><a class="title" href="/posts/98419899.html" title="nginx匹配规则">nginx匹配规则</a><time datetime="2022-07-08T04:28:07.000Z" title="发表于 2022-07-08 12:28:07">2022-07-08</time></div></div></div></div><div class="card-widget card-categories"><div class="item-headline">
<i class="fas fa-folder-open"></i>
<span>分类</span>
</div>
<ul class="card-category-list" id="aside-cat-list">
<li class="card-category-list-item "><a class="card-category-list-link" href="/categories/kubernetes/"><span class="card-category-list-name">kubernetes</span><span class="card-category-list-count">1</span></a></li><li class="card-category-list-item "><a class="card-category-list-link" href="/categories/linux/"><span class="card-category-list-name">linux</span><span class="card-category-list-count">9</span></a></li><li class="card-category-list-item "><a class="card-category-list-link" href="/categories/nginx/"><span class="card-category-list-name">nginx</span><span class="card-category-list-count">1</span></a></li>
</ul></div><div class="card-widget card-tags"><div class="item-headline"><i class="fas fa-tags"></i><span>标签</span></div><div class="card-tag-cloud"><a href="/tags/nginx/" style="font-size: 1.5em; color: #99a9bf">nginx</a> <a href="/tags/mysql/" style="font-size: 1.5em; color: #99a9bf">mysql</a> <a href="/tags/ftp/" style="font-size: 1.1em; color: #999">ftp</a> <a href="/tags/rsync/" style="font-size: 1.1em; color: #999">rsync</a> <a href="/tags/elk/" style="font-size: 1.1em; color: #999">elk</a> <a href="/tags/ntp/" style="font-size: 1.1em; color: #999">ntp</a> <a href="/tags/ssh/" style="font-size: 1.1em; color: #999">ssh</a> <a href="/tags/vim/" style="font-size: 1.1em; color: #999">vim</a> <a href="/tags/nfs/" style="font-size: 1.1em; color: #999">nfs</a> <a href="/tags/ubuntu22/" style="font-size: 1.1em; color: #999">ubuntu22</a></div></div><div class="card-widget card-archives"><div class="item-headline"><i class="fas fa-archive"></i><span>归档</span></div><ul class="card-archive-list"><li class="card-archive-list-item"><a class="card-archive-list-link" href="/archives/2023/05/"><span class="card-archive-list-date">五月 2023</span><span class="card-archive-list-count">1</span></a></li><li class="card-archive-list-item"><a class="card-archive-list-link" href="/archives/2022/07/"><span class="card-archive-list-date">七月 2022</span><span class="card-archive-list-count">7</span></a></li><li class="card-archive-list-item"><a class="card-archive-list-link" href="/archives/2021/11/"><span class="card-archive-list-date">十一月 2021</span><span class="card-archive-list-count">1</span></a></li><li class="card-archive-list-item"><a class="card-archive-list-link" href="/archives/2021/07/"><span class="card-archive-list-date">七月 2021</span><span class="card-archive-list-count">1</span></a></li><li class="card-archive-list-item"><a class="card-archive-list-link" href="/archives/2021/06/"><span class="card-archive-list-date">六月 2021</span><span class="card-archive-list-count">3</span></a></li><li class="card-archive-list-item"><a class="card-archive-list-link" href="/archives/2021/05/"><span class="card-archive-list-date">五月 2021</span><span class="card-archive-list-count">1</span></a></li></ul></div><div class="card-widget card-webinfo"><div class="item-headline"><i class="fas fa-chart-line"></i><span>网站资讯</span></div><div class="webinfo"><div class="webinfo-item"><div class="item-name">文章数目 :</div><div class="item-count">14</div></div><div class="webinfo-item"><div class="item-name">已运行时间 :</div><div class="item-count" id="runtimeshow" data-publishDate="2021-05-18T16:00:00.000Z"><i class="fa-solid fa-spinner fa-spin"></i></div></div><div class="webinfo-item"><div class="item-name">本站访客数 :</div><div class="item-count" id="busuanzi_value_site_uv"><i class="fa-solid fa-spinner fa-spin"></i></div></div><div class="webinfo-item"><div class="item-name">本站总访问量 :</div><div class="item-count" id="busuanzi_value_site_pv"><i class="fa-solid fa-spinner fa-spin"></i></div></div><div class="webinfo-item"><div class="item-name">最后更新时间 :</div><div class="item-count" id="last-push-date" data-lastPushDate="2023-08-03T10:39:40.312Z"><i class="fa-solid fa-spinner fa-spin"></i></div></div></div></div></div></div></main><footer id="footer"><div id="footer-wrap"><div class="copyright">©2020 - 2023 By Eddie</div><div class="framework-info"><span>框架 </span><a target="_blank" rel="noopener" href="https://hexo.io">Hexo</a><span class="footer-separator">|</span><span>主题 </span><a target="_blank" rel="noopener" href="https://github.com/jerryc127/hexo-theme-butterfly">Butterfly</a></div></div></footer></div><div id="rightside"><div id="rightside-config-hide"><button id="darkmode" type="button" title="浅色和深色模式转换"><i class="fas fa-adjust"></i></button><button id="hide-aside-btn" type="button" title="单栏和双栏切换"><i class="fas fa-arrows-alt-h"></i></button></div><div id="rightside-config-show"><button id="rightside_config" type="button" title="设置"><i class="fas fa-cog fa-spin"></i></button><button id="go-up" type="button" title="回到顶部"><span class="scroll-percent"></span><i class="fas fa-arrow-up"></i></button></div></div><div><script src="/js/utils.js"></script><script src="/js/main.js"></script><script src="https://cdn.jsdelivr.net/npm/@fancyapps/ui/dist/fancybox/fancybox.umd.min.js"></script><div class="js-pjax"></div><script src="/js/weather.js" async></script><canvas class="fireworks" mobile="true"></canvas><script src="https://cdn.jsdelivr.net/npm/butterfly-extsrc/dist/fireworks.min.js"></script><script src="https://cdn.jsdelivr.net/npm/butterfly-extsrc/dist/activate-power-mode.min.js"></script><script>POWERMODE.colorful = true;
POWERMODE.shake = true;
POWERMODE.mobile = false;
document.body.addEventListener('input', POWERMODE);
</script><script async data-pjax src="//busuanzi.ibruce.info/busuanzi/2.3/busuanzi.pure.mini.js"></script><div id="local-search"><div class="search-dialog"><nav class="search-nav"><span class="search-dialog-title">搜索</span><span id="loading-status"></span><button class="search-close-button"><i class="fas fa-times"></i></button></nav><div class="is-center" id="loading-database"><i class="fas fa-spinner fa-pulse"></i><span> 数据库加载中</span></div><div class="search-wrap"><div id="local-search-input"><div class="local-search-box"><input class="local-search-box--input" placeholder="搜索文章" type="text"/></div></div><hr/><div class="no-result" id="local-search-results"></div><div id="local-search-stats-wrap"></div></div></div><div id="search-mask"></div><script src="/js/search/local-search.js"></script></div></div></body></html>