fromLaniakea

摘要： # 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远程访问 阅读全文

摘要： #配置文件 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 阅读全文

摘要： 修改charset和collation alter table tweets convert to character set utf8mb4 collate utf32_general_ci; 查看collation show collation; 阅读全文

摘要： 基本参数 #开启binlog log_bin = /data/binlog/mysql/bin binlog_format = row #隔离级别 transaction_isolation = read-committed #开启GTID gtid-mode = on enforce-gtid-c 阅读全文

摘要： 问题： 脚本报错如下 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 阅读全文

摘要： [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 阅读全文

摘要： zip -q -r Cnblogs-Theme-SimpleMemory.zip Cnblogs-Theme-SimpleMemory 阅读全文

摘要： 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 阅读全文