<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[MUDXT的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ereriy</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ereriy]]></copyright><item><title><![CDATA[docker-harbor仓库]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/138475341</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/138475341</guid><author>ereriy</author><pubDate>Sun, 05 May 2024 22:16:44 +0800</pubDate><description><![CDATA[在第二台harbor服务器中项目，选择都有的项目，新建规则，如图，然后点击测试连接，点击确定。5.回到第一台harbor做同样的操作，新建目标，新建规则。重启  systemctl restart docker。6.两台机器去项目中，点击复制，启用规则，两个都开启。nginx服务器 192.168.157.92。四、配置文件中有两类参数：所需参数和可选参数。上传镜像，上传一台，另一个也有。打标签，上传镜像，验证查看。]]></description><category></category></item><item><title><![CDATA[docker安装LNMP]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/138288366</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/138288366</guid><author>ereriy</author><pubDate>Sun, 28 Apr 2024 19:16:13 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[docker容器与镜像]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/138160335</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/138160335</guid><author>ereriy</author><pubDate>Wed, 24 Apr 2024 15:28:24 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[docker（一）]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/138099008</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/138099008</guid><author>ereriy</author><pubDate>Tue, 23 Apr 2024 01:01:23 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[zabbix]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137789043</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137789043</guid><author>ereriy</author><pubDate>Mon, 15 Apr 2024 17:40:50 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[kafka]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137688059</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137688059</guid><author>ereriy</author><pubDate>Fri, 12 Apr 2024 17:18:14 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[zookeeper]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137646648</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137646648</guid><author>ereriy</author><pubDate>Thu, 11 Apr 2024 17:32:14 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[ELK日志]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137597976</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137597976</guid><author>ereriy</author><pubDate>Wed, 10 Apr 2024 15:28:13 +0800</pubDate><description><![CDATA[​​​​​​​。]]></description><category></category></item><item><title><![CDATA[GFS存储]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137518206</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137518206</guid><author>ereriy</author><pubDate>Tue, 09 Apr 2024 14:15:25 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[rsync]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137507223</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137507223</guid><author>ereriy</author><pubDate>Mon, 08 Apr 2024 14:13:30 +0800</pubDate><description><![CDATA[将client服务器数据备份到slave服务器。一、rsync基础知识。]]></description><category></category></item><item><title><![CDATA[redis集群]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137478277</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137478277</guid><author>ereriy</author><pubDate>Sun, 07 Apr 2024 21:21:04 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[redis主从复制和哨兵模式]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137345579</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137345579</guid><author>ereriy</author><pubDate>Wed, 03 Apr 2024 16:27:40 +0800</pubDate><description><![CDATA[1.主从服务器都安装redis服务。]]></description><category></category></item><item><title><![CDATA[redis持久化]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137287645</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137287645</guid><author>ereriy</author><pubDate>Tue, 02 Apr 2024 20:09:17 +0800</pubDate><description><![CDATA[一、redis持久化

二、RDB





三、AOF



四、性能优化


]]></description><category></category></item><item><title><![CDATA[Redis]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137239265</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137239265</guid><author>ereriy</author><pubDate>Mon, 01 Apr 2024 17:33:46 +0800</pubDate><description><![CDATA[1.关闭防火墙和核心防护2.安装rediscd /opt#由于Redis源码包中直接提供了 Makefile 文件，所以在解压完软件包后，不用先执行 ./configure 进行配置，可直接执行 make 与 make install 命令进行安装。make#执行软件包提供的 install_server.sh 脚本文件设置 Redis 服务所需要的相关配置文件......                                        #一直回车。]]></description><category></category></item><item><title><![CDATA[Mysql故障和优化]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137233684</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137233684</guid><author>ereriy</author><pubDate>Mon, 01 Apr 2024 16:08:51 +0800</pubDate><description><![CDATA[CPU：推荐使用SMP架构的多路对称CPU。磁盘：RAID-0+1磁盘阵列或固态硬盘。架构选择：主从、主主、一主多从、多主多从。内存：4GB以上的物理内存。GROUP BY 优化。尽量使用索引进行查询。4，MySQL架构优化。]]></description><category></category></item><item><title><![CDATA[MySQL的MHA]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137150625</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137150625</guid><author>ereriy</author><pubDate>Sat, 30 Mar 2024 13:30:07 +0800</pubDate><description><![CDATA[2.MHA Manager 会定时探测集群中的master节点，当master出现故障时，它可以自动将最新数据的slave 提升为新的master，然后将所有其他的slave重新指向新的master，整个故障转移过程对应用程序完全透明。2.使用半同步复制 ，可以大大降低数据丢失的风险，如果只有一个slave已经收到了最新的二进制日志，MHA可以将最新的二进制日志应用于其它所有的slave服务器上，因此可以保证所有节点的数据一致性。3、应用差异的中继日志（relay log）到其他的slave。]]></description><category></category></item><item><title><![CDATA[MySQL主从复制和读写分离]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137117017</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137117017</guid><author>ereriy</author><pubDate>Thu, 28 Mar 2024 21:53:25 +0800</pubDate><description><![CDATA[比如增大innodb_buffer_pool_size，让更多操作在Mysql内存中完成，减少磁盘操作。避免使用虚拟云主机，使用物理主机，这样提升了i/o方面性。通过主数据库变化记录到二进制日志中，然后从库读取主库的二进制日志来存放到本地，基本的原理是让主数据库处理事务性操作，而从数据库处理 select 查询。数据库复制被用来把主数据库上事务性操作导致的变更同步到集群中的从数据库。最后sql线程，把数据导入到自己的二进制（类似）中，保持主从数据一致。读写分离就是只在主服务器上写，只在从服务器上读。]]></description><category></category></item><item><title><![CDATA[MySQL高级SQL2]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137077311</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137077311</guid><author>ereriy</author><pubDate>Wed, 27 Mar 2024 18:05:11 +0800</pubDate><description><![CDATA[三、null值和空值区别。]]></description><category></category></item><item><title><![CDATA[Mysql备份与恢复]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137049141</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137049141</guid><author>ereriy</author><pubDate>Tue, 26 Mar 2024 17:57:28 +0800</pubDate><description><![CDATA[一周一次完全备份，2天一次增量备份，定时任务01-05点。]]></description><category></category></item><item><title><![CDATA[MySQL高级语句]]></title><link>https://blog.youkuaiyun.com/ereriy/article/details/137040602</link><guid>https://blog.youkuaiyun.com/ereriy/article/details/137040602</guid><author>ereriy</author><pubDate>Tue, 26 Mar 2024 12:18:03 +0800</pubDate><description><![CDATA[一、查询语句



1. 判断与模糊查询













2.order by







3.group by



4.distinct



5.as

7.having



8.limit









二、聚合函数








]]></description><category></category></item></channel></rss>