MariaDB 安装配置记录

1.集群搭建记录

 iptables --append INPUT --protocol tcp \

      --source 192.168.126.129 --jump ACCEPT

 iptables --apend INPUT --protocol tcp \

      --source 192.168.126.130 --jump ACCEPT

 iptables --append INPUT --protocol tcp \

      --source 192.168.126.131 --jump ACCEPT

iptables-save> /etc/sysconfig/iptables-config

grant usage on *.* to sst@'%' identified by 'ssTT-488';

flush privileges;

修改后

[mysqld]

binlog_format = ROW

#bind-address = 192.168.126.129

default_storage_engine = innodb

innodb_autoinc_lock_mode =

innodb_flush_log_at_trx_commit =

innodb_buffer_pool_size = 122M

wsrep_provider=/usr/lib64/galera/libgalera_smm.so

wsrep_provider_options ="gcache.size = 300M; gcache.page_size = 300M"

wsrep_cluster_name ="MyCluster"

wsrep_cluster_address="gcomm://192.168.126.129"

wsrep_sst_method = rsync

wsrep_node_name = Node11

wsrep_node_address ="192.168.126.129"

wsrep_sst_auth=sst:ssTT-    #节点N的数据库账户和密码--创建账号密码

wsrep_on=ON

[mysql_safe]

log-error = /var/log/mysqld.log

pid-file = /var/run/mysqld/mysqld.pid

swapon --summary

fallocate -l 512M /swapfile

dd if=/dev/zero of=/swapfile bs=1M count=

chmod  /swapfile

ls -a / | grep swapfile

mkswap /swapfile

swapon /swapfile

vi /etc/fstab

/swapfile none swap defaults  

swapon --summary

galera_new_cluster

show variables like 'character%';

set character_set_server = utf8;

set character_set_database = utf8;

cp /usr/share/mysql/wsrep.cnf /etc/my.cnf.d/

vi /etc/my.cnf.d/wsrep.cnf

garbd -a gcomm://192.168.126.129 -g MyCluster -d

journalctl -xe

2.使用记录

查看服务器连接池使用情况：

show global status like 'thread%';
show variables like 'thread_cache_size';
show PROCESSLIST;

查看配置情况：

show variables like "max_connections";
show global variables like 'wait_timeout';
show global variables like 'interactive_timeout';

巴特西

MariaDB 安装配置记录

最新文章

热门文章