2021 年 1月随笔档案 - InnoLeo

Kubernetes yaml 学习

摘要：分类：名称空间级别 kube-system 集群级别 role 元数据 HPA K8s 中所有的内容都抽象为资源，资源实例化之后，叫做对象名称空间级别资源（workload）: Pod,ReplicaSet,Deployment,StatefullSet,DaemonSet,Job,CronJ 阅读全文

posted @ 2021-01-27 08:24 InnoLeo 阅读(180) 评论(0) 推荐(0)

mysql INNODB 与MEM的区别

摘要：InnoDB： IOT MEM： HOT 不支持行锁，数据重启后清空，为防止主从不一致，在数据库重启之后，在binlog写入一行delete from tablename 建议内存临时表用MEM InnoDB 表的数据总是有序存放的，而内存表的数据就是按照写入顺序存放的；当数据文件有空洞的时候，I 阅读全文

posted @ 2021-01-21 23:48 InnoLeo 阅读(107) 评论(0) 推荐(0)

redis自动化安装

摘要：redis 自动化安装 #/bin/bin/ksh LOGFILE=/var/log/redis.log REDISSOURCE=/mnt/hgfs/Redis/ INSTALLDIR=/data REDISDIR=/data/redis VERISON=6.0.9 PORT=8000 RC=8 r 阅读全文

posted @ 2021-01-20 23:38 InnoLeo 阅读(195) 评论(0) 推荐(0)

RHEL8 Haproxy的读写分离

摘要：接上篇做双主https://www.cnblogs.com/tingxin/p/14290434.html 下载安装HAProxy mkdir /HAProxy /usr/local/haproxy wget http://www.haproxy.org/download/2.3/src/hapro 阅读全文

posted @ 2021-01-19 19:27 InnoLeo 阅读(201) 评论(0) 推荐(0)

MySQL8 Keepalived+双主

摘要：坑：用keepalived 时，双主或是主从的PORT是相同的，因为keepalived 不会转发PORT 1. 配置双主：双机名 win89.inno.com win88.inno.com 准备账号 SET SQL_LOG_BIN=0; set password for 'root'@'loca 阅读全文

posted @ 2021-01-17 22:00 InnoLeo 阅读(425) 评论(0) 推荐(0)

Last_SQL_Errno: 1050 Last_SQL_Error: Error 'Table 'events' already exists' on query. Default database: 'eygle'. Query: 'create table events

摘要：主从复制Last_SQL_Errno: 1050 mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master 阅读全文

posted @ 2021-01-17 20:10 InnoLeo 阅读(615) 评论(0) 推荐(0)

[MY-011522] [Repl] Plugin group_replication reported: 'The member contains transactions not present in the group.

摘要：error: mysql> start group_replication; ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more 阅读全文

posted @ 2021-01-17 12:10 InnoLeo 阅读(878) 评论(0) 推荐(0)

MYSQL8 裸机搭主从

摘要：步骤很我简单在主机上运行以下SQL SET SQL_LOG_BIN=0; ##关闭binlog grant all privileges on *.* to root@'localhost' with grant option; create user 'repl'@'192.168.68.89' 阅读全文

posted @ 2021-01-15 21:10 InnoLeo 阅读(154) 评论(0) 推荐(0)

MY-011292 MY-011300 MY-013597 MY-011300

摘要：error message [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible' [ERROR] [MY- 阅读全文

posted @ 2021-01-15 16:42 InnoLeo 阅读(2631) 评论(0) 推荐(0)

RHLE8 docker安装

摘要：yum install -y yum-utils device-mapper-persistent-data lvm2 yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo --RH 阅读全文

posted @ 2021-01-10 19:43 InnoLeo 阅读(181) 评论(0) 推荐(0)

docker harbor x509: certificate signed by unknown authority action: push: unauthorized to access repository

摘要：action: push: unauthorized to access repository;x509: certificate signed by unknown authority action 阅读全文

posted @ 2021-01-10 19:30 InnoLeo 阅读(1654) 评论(0) 推荐(0)

harbor配置https访问

摘要：安装准备 rpm -ivh /mnt/hgfs/Docker/RPM/epel-release-8-8.el8.noarch.rpm yum install python3-pip pip3 install --upgrade pip pip install -U -i https://pypi.t 阅读全文

posted @ 2021-01-10 17:14 InnoLeo 阅读(724) 评论(0) 推荐(0)

action: push: unauthorized to access repository

摘要：在配置完Harbor 后发现push 功能不可用出现以下问题 unauthorized: unauthorized to access repository: xuegod-web/redis-photon, action: push: unauthorized to access reposito 阅读全文

posted @ 2021-01-08 22:50 InnoLeo 阅读(13834) 评论(5) 推荐(0)

unlock DDIC for HANADB

摘要：su - siadm >hdbsql -U DEFAULT Welcome to the SAP HANA Database interactive terminal. Type: \h for help with commands \q to quit hdbsql T4X=> update us 阅读全文

posted @ 2021-01-06 22:59 InnoLeo 阅读(243) 评论(0) 推荐(0)