【SequoiaDB】安装配置
巨杉.png
SequoiaDB 巨杉数据库作为分布式数据库，由数据库存储引擎与数据库实例两大模块构成。其中，数据库存储引擎模块是数据存储的核心，负责提供整个数据库的读写服务、数据的高可用与容灾、ACID与分布式事务等全部核心数据服务能力。
##学习网站：
【初级】：http://www.sequoiadb.com/cn/university-detail-id-75
【】：http://www.sequoiadb.com/cn/university-detail-id-89
##一、图形化安装
【前期准备】
修改主机名：vi etc/hostname
配置主机名/IP地址映射：vi etc/hosts
systemctl stop firewalld.service
systemctl disable firewalld.service
关闭防火墙：# systemctl stop firewalld.service # 临时关闭防火墙# systemctl disable firewalld.service # 设置开机禁用防火墙
【官方说明】http://doc.sequoiadb.com/cn/sequoiadb-cat_id-1561381803-edition_id-500
下载安装包：http://download.sequoiadb.com/cn/sequoiadb
# tar zxvf sequoiadb-5.0.1-linux_x86_64.tar.gz
# cd sequoiadb-5.0.1
# chmod u+x sequoiadb-5.0.1-linux_x86_64-installer.run
# chmod u+x sequoiasql-mysql-5.0.1-linux_x86_64-installer.run
# chmod u+x sequoiasql-postgresql-5.0.1-x86_64-installer.run
# chmod u+x setup.sh
./sequoiadb-5.0.1-linux_x86_64-installer.run --help
./sequoiadb-5.0.1-linux_x86_64-installer.run --SMS true
【--SMS true：安装OM service】
安装完成之后登录浏览器访问SAC页面。访问地址：ip+8000端口
如果访问不了，可能是防火墙没关。账户：admin 密码：admin
##卸载
【顺序】：先实例、再分布式存储、后主机
##一、手动安装
备注：
1、主机名的修改：（记得重启reboot）
Centos7：直接修改/etc/hostname就可以了
(其他版本修改、/etc/hosts ,/etc/sysconfig/network)
命令：hostnamectl set-hostname node_master
2、所有节点在/etc/hosts文件中写入本地解析
192.168.56.107 SDB1 node1
192.168.56.108 SDB2 node2
192.168.56.109 SDB3 node3
3、关闭防火墙：
# systemctl stop firewalld.service # 临时关闭防火墙
# systemctl disable firewalld.service # 设置开机禁用防火墙
下载并安装巨杉存储引擎：
【SDB1】：
上传安装包、解压
tar zxvf sequoiadb-5.0.1-linux_x86_64.tar.gz
cd sequoiadb-5.0.1
# chmod u+x sequoiadb-5.0.1-linux_x86_64-installer.run
# chmod u+x sequoiasql-mysql-5.0.1-linux_x86_64-installer.run
# chmod u+x sequoiasql-postgresql-5.0.1-x86_64-installer.run
# chmod u+x setup.sh
scp sequoiadb-5.0.1-linux_x86_64-installer.run root@SDB2:/root
scp sequoiadb-5.0.1-linux_x86_64-installer.run root@SDB3:/root
【SDB1、SDB2、SDB3】：
./sequoiadb-5.0.1-linux_x86_64-installer.run --mode text --SMS false
创建零时协调节点：
【SDB1】：
su - sdbadmin
sdb
var oma = new Oma( "localhost", 18900 )
oma.help()
oma.createCoord(18900,"/opt/sequoiadb/database/tmpCoord/18900");
oma.startNode(18900)
##连接零时协调节点
var db = new Sdb( "localhost", 18900 )
db.help()
db.createCataRG("sdb1",11800,"/opt/sequoiadb/database/catalog/11800");##编目节点组
var rg = db.getRG(1)
var node = rg.createNode("sdb2",11800,"/opt/sequoiadb/database/catalog/11800")
node.start()
var node = rg.createNode("sdb3",11800,"/opt/sequoiadb/database/catalog/11800")
node.start()
var rg = db.createRG("group1")
rg.createNode("sdb1",11820,"/opt/sequoiadb/database/data/11820")
rg.createNode("sdb2",11820,"/opt/sequoiadb/database/data/11820")
rg.createNode("sdb3",11820,"/opt/sequoiadb/database/data/11820")
rg.start()
var rg = db.createRG("group2")
rg.createNode("sdb1",11830,"/opt/sequoiadb/database/data/11830")
rg.createNode("sdb2",11830,"/opt/sequoiadb/database/data/11830")
rg.createNode("sdb3",11830,"/opt/sequoiadb/database/data/11830")
rg.start()
##协调节点
var rg = db.createCoordRG()
rg = db.getRG(2)
rg.createNode("sdb1",11810,"/opt/sequoiadb/database/data/11810")
rg.createNode("sdb2",11810,"/opt/sequoiadb/database/data/11810")
rg.createNode("sdb3",11810,"/opt/sequoiadb/database/data/11810")
rg.start()
db ##获取当前端口
oma.stopNode(18900)
oma.removeCoord(18900)
quit;
安装MYSQL实例：
【SDB1、SDB2、SDB3】：
./sequoiasql-mysql-5.0.1-linux_x86_64-installer.run --mode text
su - sdbadmin
cd opt/sequoiasql/mysql
mkdir database
/opt/sequoiasql/mysql/bin/sdb_sql_ctl addinst mytest -D opt/sequoiasql/mysql/database/3306
【尽量服务器上有安装有netstat】
/opt/sequoiasql/mysql/bin/sdb_sql_ctl listinst
/opt/sequoiasql/mysql/bin/sdb_sql_ctl status mytest
mysql -uroot --socket=/opt/sequoiasql/mysql/database/3306/mysqld.sock
同步工具：
/opt/sequoiasql/mysql/tools/metaSync/README.md
mysql -uroot --socket=/opt/sequoiasql/mysql/database/3306/mysqld.sock
CREATE USER 'sdbadmin'@'%' IDENTIFIED BY 'sdbadmin';
GRANT all on *.* TO 'sdbadmin'@'%' with grant option;
cp opt/sequoiasql/mysql/tools/lib/release/server_audit.so opt/sequoiasql/mysql/lib/plugin/
cd opt/sequoiasql/mysql/database
mkdir auditlog
vi opt/sequoiasql/mysql/database/3306/auto.cnf
---------【加入】
# 加载审计插件
plugin-load=server_audit=server_audit.so
# 审计记录的审计，建议只记录需要同步的DCL和DDL操作
server_audit_events=CONNECT,QUERY_DDL,QUERY_DCL
# 开启审计
server_audit_logging=ON
# 审计日志路径及文件名
server_audit_file_path=/opt/sequoiasql/mysql/database/auditlog/server_audit.log
# 强制切分审计日志文件
server_audit_file_rotate_now=OFF
# 审计日志文件大小10MB，超过该大小进行切割，单位为byte
server_audit_file_rotate_size=10485760
# 审计日志保留个数，超过后会丢弃旧的
server_audit_file_rotations=999
# 输出类型为文件
server_audit_output_type=file
# 限制每行查询日志的大小为100kb，若表比较复杂，对应的操作语句比较长，建议增大该值
server_audit_query_log_limit=102400
/opt/sequoiasql/mysql/bin/sdb_sql_ctl restart mytest
cd opt/sequoiasql/mysql/tools/metaSync
cp config.sample config
cp log.config.sample log.config
python /opt/sequoiasql/mysql/tools/metaSync/meta_sync.py &
crontab -e
*/1 * * * * /usr/bin/python /opt/sequoiasql/mysql/tools/metaSync/meta_sync.py >/dev/null 2>&1 &
相关文章