<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[wl21787的博客]]></title><description><![CDATA[Hello MySQL!]]></description><link>https://blog.youkuaiyun.com/wl21787</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; wl21787]]></copyright><item><title><![CDATA[gitlab使用外部nginx反向代理]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/124166406</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/124166406</guid><author>wl21787</author><pubDate>Thu, 14 Apr 2022 10:51:01 +0800</pubDate><description><![CDATA[1. vim /etc/gitlab/gitlab.rb

编辑nginx['listen_port'] = 8888

此处的8888端口将用于proxy_pass处

2. 编辑外部nginx，在http区加入server段


server {
    listen 80;
    server_name git.corp.doumi.com;

    location / {
            # 这个大小的设置非常重要，如果 git 版本库里面有大文件，设置的太小，文件push 会失败，根]]></description><category></category></item><item><title><![CDATA[lookup vindex]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/108536235</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/108536235</guid><author>wl21787</author><pubDate>Fri, 11 Sep 2020 15:54:10 +0800</pubDate><description><![CDATA[create lookup vindex]]></description><category></category></item><item><title><![CDATA[Vindex]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/108533946</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/108533946</guid><author>wl21787</author><pubDate>Fri, 11 Sep 2020 14:35:57 +0800</pubDate><description><![CDATA[vindex简介]]></description><category></category></item><item><title><![CDATA[判断丑数]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/108511152</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/108511152</guid><author>wl21787</author><pubDate>Thu, 10 Sep 2020 11:41:06 +0800</pubDate><description><![CDATA[丑数：只包含2,3,5一个或多个质因子的数
14 不是丑数

python代码如下，判断一个数是否为丑数：

def isUglyNum(num):
    lst = [2, 3, 4]
    n = 0
    if num &lt;= 1:
        return 0
    elif num in lst:
        print('{} is Ugly number'.format(num))
    else:
        for j in [2, 3, 5]:
        ]]></description><category></category></item><item><title><![CDATA[Vitess本地安装]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/108468521</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/108468521</guid><author>wl21787</author><pubDate>Tue, 08 Sep 2020 14:49:28 +0800</pubDate><description><![CDATA[MySQL中间件Vitess本地测试安装部署]]></description><category></category></item><item><title><![CDATA[MySQL分库分表dble初次尝试]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/107672176</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/107672176</guid><author>wl21787</author><pubDate>Wed, 29 Jul 2020 18:22:07 +0800</pubDate><description><![CDATA[文章目录安装MySQL配置MySQL安装zookeeper安装haproxy安装DBLE下载并安装配置DBLE全局唯一序列日志清理配置dble集群配置MySQL-HA开启DBLE参数配置MHA启动MHA启动DBLEsysbench压测DBLE使用规范智能ER表schema规范
安装MySQL

MySQL的安装过程省略，请自行安装。
MySQL版本：5.7.29

MySQL结构如下：

    
        
            主库IP
            主库端口
            ]]></description><category></category></item><item><title><![CDATA[openssl生成自签证书]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/107227403</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/107227403</guid><author>wl21787</author><pubDate>Thu, 09 Jul 2020 14:12:28 +0800</pubDate><description><![CDATA[文章目录openssl基础信息查看openssl版本查看版本更详细的信息生成自签证书在确定配置为CA的服务器上生成一个自签证书生成CA根密钥生成CA自签证书要用到证书进行安全通信的服务器，需要向CA请求签署证书生成私钥生成证书签署请求将请求通过可靠方式发送给CA主机在CA主机上签发证书遇到的问题：吊销证书在客户端获取要吊销的证书的serial在CA服务器吊销证书根据上一步查到的serial，吊销相应的证书生成吊销证书的吊销编号（第一次吊销证书时执行）更新证书吊销列表查看crl文件
openssl基础信息
查]]></description><category></category></item><item><title><![CDATA[在线开启mongodb分片集群的密码认证]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/107206352</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/107206352</guid><author>wl21787</author><pubDate>Wed, 08 Jul 2020 15:06:59 +0800</pubDate><description><![CDATA[概览

mongodb版本3.4以上
不停服务

创建keyfile密钥文件
openssl rand -base64 512 &gt; mongodb.key
chmod 400 mongodb.key

配置分片集群管理账号和客户端账号
1. 创建管理账号
db.createUser(
  {
    user: "admin",
    pwd: passwordPrompt(),
    roles: [
      { role: "clusterAdmin", db: "admin" },
  ]]></description><category></category></item><item><title><![CDATA[更改表的字符集（utf8 to utf8mb4）]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/107090351</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/107090351</guid><author>wl21787</author><pubDate>Thu, 02 Jul 2020 18:11:57 +0800</pubDate><description><![CDATA[环境要求：

MySQL: 5.6.23
	字符集：utf8
	操作系统：centos6
测试数据：

# 测试表


CREATE TABLE `t2` (
  `id` int(11) NOT NULL,
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '姓名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

# 测试数据


insert into t2 values(1,'...]]></description><category></category></item><item><title><![CDATA[理解MySQL主从复制之realy_log_recovery]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/85002785</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/85002785</guid><author>wl21787</author><pubDate>Fri, 14 Dec 2018 14:06:52 +0800</pubDate><description><![CDATA[理解MySQL主从复制之realy_log_recovery

参数含义:当slave重启之后会根据slave_relay_log_info重新创建一个文件,SQL线程会根据这个文件进行恢复复制,IO线程会读取SQL线程的POS点,根据这个POS点向主库申请拉取数据

该参数是默认打开的，在数据库启动后立即启动自动relay log恢复。在恢复过程中，创建一个新的relay log,并将IO线程初...]]></description><category></category></item><item><title><![CDATA[记一次ptosc造成meta lock案例]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/84970207</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/84970207</guid><author>wl21787</author><pubDate>Wed, 12 Dec 2018 11:53:43 +0800</pubDate><description><![CDATA[故障场景：

ptosc操作一张表时pt进程hang住不动，并且从库监控告警running threads飙升。

pt脚本：


time pt-online-schema-change --alter 'create index idx_create_at(create_at)' --print --charset utf8 --chunk-time 0.500000 --critical-l...]]></description><category></category></item><item><title><![CDATA[利用MySQL延时复制恢复误操作数据]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/80984489</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/80984489</guid><author>wl21787</author><pubDate>Tue, 10 Jul 2018 13:28:58 +0800</pubDate><description><![CDATA[ip数据库角色数据库端口数据库版本192.168.102.168master33085.7.11192.168.102.169slave33085.7.11主库生成测试数据：create database test;use test;CREATE TABLE `t1` (  `id` int(11) NOT NULL,  `name` varchar(2) NOT NULL DEFAULT '',...]]></description><category></category></item><item><title><![CDATA[记一次git clone的报错以及对CentOS上的git版本更新]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/80205616</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/80205616</guid><author>wl21787</author><pubDate>Sat, 05 May 2018 14:41:35 +0800</pubDate><description><![CDATA[Centos版本：CentOS6.5当前git版本：git1.7.1git clone 报错信息如下：github fatal: HTTP request failed查看git版本git --version先安装依赖包：yum install curl-devel expat-devel gettext-devel openssl-devel zlib-devel asciidoc
yum in...]]></description><category></category></item><item><title><![CDATA[Zabbix for MySQL: item(	Query Time Count 00....)]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/80177683</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/80177683</guid><author>wl21787</author><pubDate>Thu, 03 May 2018 11:46:24 +0800</pubDate><description><![CDATA[参考文章：https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.htmlZabbix监控MySQL，有几个监控项不是太明白，专门研究了一下。监控项如下：以上几个监控项监控的是MySQL Query Response TimePercona官方介绍：Query responsetime distributio...]]></description><category></category></item><item><title><![CDATA[线上部署Django: nginx + uwsgi +Django]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/80066616</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/80066616</guid><author>wl21787</author><pubDate>Tue, 24 Apr 2018 17:15:18 +0800</pubDate><description><![CDATA[参考：http://uwsgi-docs-zh.readthedocs.io/zh_CN/latest/tutorials/Django_and_nginx.html线上环境部署Django 环境：操作系统：centos6django: 1.101、上传代码至工作目录：/data/python-project/blogproject目录结构如下：2、修改配置文件settings.py+ ALLOW...]]></description><category></category></item><item><title><![CDATA[Zabbix监控MySQL错误日志]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/79893538</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/79893538</guid><author>wl21787</author><pubDate>Wed, 11 Apr 2018 11:20:12 +0800</pubDate><description><![CDATA[一、创建监控项配置&amp;gt;主机&amp;gt;监控项&amp;gt;创建监控项二、查看监控项是否正常观察监控项状态是否为已启用]]></description><category></category></item><item><title><![CDATA[sed 替换双引号（“”）中的字符串中的数字]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/79879181</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/79879181</guid><author>wl21787</author><pubDate>Tue, 10 Apr 2018 12:02:16 +0800</pubDate><description><![CDATA[sed 替换双引号（“”）中的字符串中的数字#!/bin/bash
cat spec.txt |
sed -e '
:begin
s/,&quot;\([^&quot;,]*\)[0-9]\([^&quot;]*\)&quot;/,&quot;\1@\2&quot;/g
t begin

'替换重复的字符只保留一个sed -r 's/(@)\1*\1/\1/g' spec.txt1...]]></description><category></category></item><item><title><![CDATA[MySQL 获取某个字段中的数字]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/79879016</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/79879016</guid><author>wl21787</author><pubDate>Tue, 10 Apr 2018 11:51:21 +0800</pubDate><description><![CDATA[MySQL 获取某个字段中的数字，函数如下：DELIMITER $$

USE `test` $$

DROP FUNCTION IF EXISTS `GetNum` $$

CREATE  FUNCTION `getnum` (Varstring VARCHAR (500)) RETURNS VARCHAR (30) CHARSET utf8mb4 
BEGIN
  DECLARE v_leng...]]></description><category></category></item><item><title><![CDATA[mysqldump 导出的是全库  alldb.sql  导入的时候可不可以只导其中的一个表]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/79866037</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/79866037</guid><author>wl21787</author><pubDate>Mon, 09 Apr 2018 14:30:16 +0800</pubDate><description><![CDATA[mysqldump 导出的是全库  alldb.sql  导入的时候可不可以只导其中的一个表

法1：perl extract_sql.pl -t mytable -r mydumpfile &amp;gt; mytable.sql 
法2：cat test1db.sql | sed -n ‘/Table structure for table .test1./,/Table structure for ...]]></description><category></category></item><item><title><![CDATA[MySQL并发操作insert产生锁等待]]></title><link>https://blog.youkuaiyun.com/wl21787/article/details/79835257</link><guid>https://blog.youkuaiyun.com/wl21787/article/details/79835257</guid><author>wl21787</author><pubDate>Fri, 06 Apr 2018 17:48:13 +0800</pubDate><description><![CDATA[环境描述：操作系统：CentOS6.5MySQL版本：5.7.12事务隔离级别：READ-COMMITTED实验过程：1）表结构：CREATE TABLE test.`saleorder` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '记录ID',
  `vendorId` BIGINT(20) UNSIGNED NOT...]]></description><category></category></item></channel></rss>