systemctl stop NetworkManager
service NetworkManager start

ufw allow 3306
ufw allow 6379

#config 1
upstream buying {
server localhost weight=3;
server 192.168.43.71 weight=3;#这里的ip换成另一个电脑2的ip
}

nginx -s reload

redis-server ./redis9004/redis.conf --protected-mode no
redis-server ./redis9005/redis.conf --protected-mode no
redis-server ./redis9006/redis.conf --protected-mode no
ps aux | grep redis

redis-server ./redis9001/redis.conf --protected-mode no
redis-server ./redis9002/redis.conf --protected-mode no
redis-server ./redis9003/redis.conf --protected-mode no

redis-cli --cluster create 192.168.43.154:9001 192.168.43.154:9002 192.168.43.154:9003 192.168.43.71:9004 192.168.43.71:9005 192.168.43.71:9006 --cluster-replicas 1
redis-cli -c -h 192.168.43.154 -p 9001 cluster nodes

[mysqld]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0
# Galera Provider Configuration
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so
# Galera Cluster Configuration
wsrep_cluster_name="my_cluster"
wsrep_cluster_address="gcomm://192.168.43.154,192.168.43.71"
# Galera Synchronization Configuration
wsrep_sst_method=rsync
# Galera Node Configuration
wsrep_node_address="192.168.43.154"
wsrep_node_name="fly"

galera_new_cluster

systemctl start mariadb

CREATE DATABASE 数据库名;
show databases;
use 数据库名; // 选择数据库
set names utf8; // 设置编码模式为utf8
source  数据库名.sql; // 导入sql文件，需要使用文件所在的路径

CREATE TABLE `Identitys` (
  `P_id` int(11) DEFAULT NULL,
  `U_id` int(11) DEFAULT NULL
)

CREATE TABLE `Pruduct` (
  `P_id` int(11) NOT NULL,
  `P_name` varchar(20) DEFAULT NULL,
  `Price` int(11) DEFAULT NULL,
  PRIMARY KEY (`P_id`)
)

CREATE TABLE `Users` (
  `U_id` int(11) NOT NULL AUTO_INCREMENT,
  `U_name` varchar(20) DEFAULT NULL,
  `U_type` int(11) DEFAULT NULL,
  PRIMARY KEY (`U_id`)
)

#删除缓存重新启动
rm -rf /var/lock/subsys/mysql
cd /var/lib/mysql
rm -rf galera.cache
rm -rf grastate.dat

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.3.8' IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'russell' WITH GRANT OPTION; FLUSH PRIVILEGES;
flush privileges;

mysql_secure_installation