摘要: # 4台机器上做如下操作:配置集群内主机的域名映射 cat >> /etc/hosts<<EOF 192.168.93.61 lpn061 192.168.93.62 lpn062 192.168.93.63 lpn063 192.168.93.64 lpn064 EOF # 解决因root远程访问 阅读全文
posted @ 2022-02-09 08:59 fromLaniakea 阅读(46) 评论(0) 推荐(0)
摘要: #配置文件 cat >/etc/my.cnf<<EOF [client] socket=/tmp/mysql.sock [mysql] prompt=(\u@\h) [\d]>\_ no-auto-rehash [mysqld] basedir=/usr/local/mysql port=3306 阅读全文
posted @ 2021-12-12 22:13 fromLaniakea 阅读(58) 评论(0) 推荐(0)
摘要: 修改charset和collation alter table tweets convert to character set utf8mb4 collate utf32_general_ci; 查看collation show collation; 阅读全文
posted @ 2021-12-11 19:15 fromLaniakea 阅读(50) 评论(0) 推荐(0)
摘要: 基本参数 #开启binlog log_bin = /data/binlog/mysql/bin binlog_format = row #隔离级别 transaction_isolation = read-committed #开启GTID gtid-mode = on enforce-gtid-c 阅读全文
posted @ 2021-11-30 11:27 fromLaniakea 阅读(43) 评论(0) 推荐(0)
摘要: 问题: 脚本报错如下 Nov 29 18:18:58 db53 systemd: Failed at step EXEC spawning /etc/rc.d/init.d/realserver: Exec format error Nov 29 18:18:58 db53 systemd: rea 阅读全文
posted @ 2021-11-29 18:34 fromLaniakea 阅读(4412) 评论(0) 推荐(0)
摘要: [root@db01 ~]# fdisk /dev/sda Welcome to fdisk (util-linux 2.23.2). Changes will remain in memory only, until you decide to write them. Be careful bef 阅读全文
posted @ 2021-11-27 12:56 fromLaniakea 阅读(41) 评论(0) 推荐(0)
摘要: zip -q -r Cnblogs-Theme-SimpleMemory.zip Cnblogs-Theme-SimpleMemory 阅读全文
posted @ 2021-11-27 12:52 fromLaniakea 阅读(439) 评论(0) 推荐(0)
摘要: pmm-server docker create \ -v /opt/prometheus/data \ -v /opt/consul-data \ -v /var/lib/mysql \ -v /var/lib/grafana \ --name pmm-data \ percona/pmm-ser 阅读全文
posted @ 2021-11-27 11:19 fromLaniakea 阅读(419) 评论(0) 推荐(0)