<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[lylaotang的博客]]></title><description><![CDATA[lylaotang的博客]]></description><link>https://blog.youkuaiyun.com/lylaotang</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; lylaotang]]></copyright><item><title><![CDATA[Linux MySQL专栏-Orchestrator]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/142781380</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/142781380</guid><author>lylaotang</author><pubDate>Wed, 09 Oct 2024 11:29:31 +0800</pubDate><description><![CDATA[注意：具体看https://github.com/openark/orchestrator/tree/master/docs。注意：在三台Orch机器上分别执行，通过sqlite做orch后端，通过Raft协议做orch高可用！#通过 -i 传递集群名称,打印拓扑实例树。#显示当前已知的集群(复制拓扑)]]></description><category></category></item><item><title><![CDATA[Linux MySQL专栏-InnoDB Cluster]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/142763767</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/142763767</guid><author>lylaotang</author><pubDate>Wed, 09 Oct 2024 10:28:29 +0800</pubDate><description><![CDATA[任一节点（rock8/alma8/cloudos8），创建集群。#将组复制(现有mgr)转换为InnoDB Cluster。所有节点,每个节点参数及权限配置预检测。#如果上面执行报错，删除集群如下。]]></description><category></category></item><item><title><![CDATA[Linux MySQL专栏-mgr]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138524078</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138524078</guid><author>lylaotang</author><pubDate>Tue, 07 May 2024 17:17:45 +0800</pubDate><description><![CDATA[注意：MGR环境下要求每个表都需要有主键，没有主键就会报错 (8.x)架构：最少3节点,最多9节点,基于paxos协议复制,支持单主或多主通过组内节点的通信协商(组通信协议基于Paxos算法)，实现数据的强一致性、故障探测、冲突检测、节点加组、节点离组等功能。]]></description><category></category></item><item><title><![CDATA[Linux 三剑客辅助-xargs]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138520649</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138520649</guid><author>lylaotang</author><pubDate>Tue, 07 May 2024 10:25:27 +0800</pubDate><description><![CDATA[total 0。]]></description><category></category></item><item><title><![CDATA[Linux MySQL专栏-pxc]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138470516</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138470516</guid><author>lylaotang</author><pubDate>Sun, 05 May 2024 22:50:16 +0800</pubDate><description><![CDATA[注意：本次实验3节点跑在同一主机上！]]></description><category></category></item><item><title><![CDATA[Linux MySQL专栏-监控(PMM)]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138443778</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138443778</guid><author>lylaotang</author><pubDate>Sun, 05 May 2024 09:55:10 +0800</pubDate><description><![CDATA[Agents:[mysqld]user=mysql。]]></description><category></category></item><item><title><![CDATA[Linux MySQL专栏-远程管理]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138437622</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138437622</guid><author>lylaotang</author><pubDate>Sat, 04 May 2024 11:48:02 +0800</pubDate><description><![CDATA[远程管理选项，容易卡住，耐心等一下就好！]]></description><category></category></item><item><title><![CDATA[Linux MySQL专栏-binlog]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138435602</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138435602</guid><author>lylaotang</author><pubDate>Sat, 04 May 2024 11:09:48 +0800</pubDate><description><![CDATA[binlog   单个大小默认1G，超过了1G就会新增一个mysql   重启一次就会增加一个新的。]]></description><category></category></item><item><title><![CDATA[Linux MySQL专栏-backup/restore]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138427206</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138427206</guid><author>lylaotang</author><pubDate>Sat, 04 May 2024 09:45:27 +0800</pubDate><description><![CDATA[mysqldump完备,+binlog日志（完备时间节点以后）建议周完备]]></description><category></category></item><item><title><![CDATA[Linux MySQL专栏-安装]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138400192</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138400192</guid><author>lylaotang</author><pubDate>Thu, 02 May 2024 21:42:35 +0800</pubDate><description><![CDATA[注意下glibc的版本。]]></description><category></category></item><item><title><![CDATA[Linux 三剑客辅助-tr、cut]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138390918</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138390918</guid><author>lylaotang</author><pubDate>Thu, 02 May 2024 13:51:24 +0800</pubDate><description><![CDATA[删除多余空格，按空格作为分隔符，取出第二列。查看文件系统磁盘占用情况。]]></description><category></category></item><item><title><![CDATA[Linux 三剑客-awk]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138380882</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138380882</guid><author>lylaotang</author><pubDate>Wed, 01 May 2024 22:18:02 +0800</pubDate><description><![CDATA[取出第5、6行后，按%进行划分，取出划分后的第1列。取出以"nologin"结尾的行。取出包含lp到包含games的行。取出第2列及最后一列NF的值。删除文件中的所有偶数行。取出第3行之后的所有行。取出包含root的行。]]></description><category></category></item><item><title><![CDATA[Linux 三剑客-sed]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138378200</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138378200</guid><author>lylaotang</author><pubDate>Wed, 01 May 2024 21:54:19 +0800</pubDate><description><![CDATA[末行下一行追加hello，第二行下一行追加空行，第三行下一行追加#key，第四行下一行追加空格#value。查找包含关键字ftp到包含关键字ssh的行。在第3行创建一行记录，原记录被替换。查找包含ntp或ftp关键字的行。将第三行的3替换成5。取反取出所有不是2,3行的行。在第3行上方增加一行记录。多点编辑，行首，行尾添加。取反删除2,3行以外的行。在第3行下方增加一行记录。]]></description><category></category></item><item><title><![CDATA[Linux 三剑客-grep]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138368562</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138368562</guid><author>lylaotang</author><pubDate>Wed, 01 May 2024 19:06:19 +0800</pubDate><description><![CDATA[匹配根 (\) 结尾，上下各1行。匹配根 (\) 结尾，向下1行。匹配根 (\) 结尾，向上1行。不区分大小写匹配非ssh的行。多点编辑，匹配开头，匹配结尾。显示行号精确匹配大写ssh。-i     忽略大小写。-C   匹配往上往下行。-r     递归查找。^     匹配开头行。$     匹配结尾行。不区分大小写匹配ssh。-w   显示匹配行。-n    显示行号。-v    反向匹配。-e    多点编辑。-A   匹配往下行。-B   匹配往上行。]]></description><category></category></item><item><title><![CDATA[Linux 服务管理-iptables]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138358878</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138358878</guid><author>lylaotang</author><pubDate>Wed, 01 May 2024 00:34:02 +0800</pubDate><description><![CDATA[状态检测，放行所有出站数据包，放行入站的回应数据包。拒绝入站的新连接请求与无效连接状态检测：NEW、ESTABLISHED、RELATED、INVALID除了从本机出去的数据包由NAT表的OUTPUT链处理外，其它所有的状态检测都在NAT表中的PREROUTING链中处理，具体状态信息如下：1、NEW状态：由外主动发起连接的第一个数据包2、ESTABLISHED状态：由内主动发起并收到对方响应返回的第一个数据包，从NEW变为ESTABLISHED，并且该状态会继续匹配这个连接后继数据包3、RELATED状态]]></description><category></category></item><item><title><![CDATA[Linux 系统管理-tar、gzip、bzip2、zip]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138353854</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138353854</guid><author>lylaotang</author><pubDate>Tue, 30 Apr 2024 18:28:51 +0800</pubDate><description><![CDATA[压缩解压查看压缩解压查看#压缩#压缩目录#解压。]]></description><category></category></item><item><title><![CDATA[Linux 系统管理-suid、sguid、sticky]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138348702</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138348702</guid><author>lylaotang</author><pubDate>Tue, 30 Apr 2024 16:12:18 +0800</pubDate><description><![CDATA[suid：以命令属主的权限来运行这一命令普通用户ceshi通过nmtui改主机名，可以修改了！-rwsr-xr-x. 1 root root 662320 10月  1 2020 /usr/bin/nmtui。]]></description><category></category></item><item><title><![CDATA[Linux 系统管理-setfacl]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138348168</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138348168</guid><author>lylaotang</author><pubDate>Tue, 30 Apr 2024 15:57:15 +0800</pubDate><description><![CDATA[删除文件 ACL，需要 -x  or  -b 参数；读/写/执行，权限之外的特殊权限控制；针对目录文件需要 -R 递归参数；针对普通文件需要 -m 参数；]]></description><category></category></item><item><title><![CDATA[Linux 系统管理-chattr、lsattr]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138347393</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138347393</guid><author>lylaotang</author><pubDate>Tue, 30 Apr 2024 15:41:38 +0800</pubDate><description><![CDATA[chattr

锁定关键系统文件，防止非法修改


i： 无法对文件进行修改

   若对目录设置了该参数，仅能修改其中的子文件内容而不能新建或删除文件
a:  仅允许追加内容，无法覆盖/删除内容
-R: 递归处理所有子文件



eg：
chattr +i   /etc/passwd  /etc/shadow  /etc/group  /etc/gshadow  /etc/inittab

mkdir     /yy

chattr -R +i /yy
]]></description><category></category></item><item><title><![CDATA[Linux 服务管理-firewall]]></title><link>https://blog.youkuaiyun.com/lylaotang/article/details/138336933</link><guid>https://blog.youkuaiyun.com/lylaotang/article/details/138336933</guid><author>lylaotang</author><pubDate>Tue, 30 Apr 2024 12:02:02 +0800</pubDate><description><![CDATA[firewall将所有的网络流量分类汇集到zones中，firewall通过zones管理防火墙规则。]]></description><category></category></item></channel></rss>