stonedb部署实践

1.使用docker部署，会有一些问题，启动失败：

xiuchenggong@xiuchengdeMacBook-Pro stonedb % docker logs 27a92a0510fd                                                                                                        
+ _main
+ '[' -f /opt/stonedb57/install/bin/mysqld -a -d '/opt/stonedb*/install/data/mysql' ']'
+ stonedb_note 'StoneDB not install,we will install StoneDB......'
++ date '+%Y-%m-%d %H:%M:%S'
+ echo '2023-09-08 03:29:48 [Note] StoneDB not install,we will install StoneDB......'
2023-09-08 03:29:48 [Note] StoneDB not install,we will install StoneDB......
+ stonedb_note docker_verify_minimum_env
++ date '+%Y-%m-%d %H:%M:%S'
+ echo '2023-09-08 03:29:48 [Note] docker_verify_minimum_env'
2023-09-08 03:29:48 [Note] docker_verify_minimum_env
+ docker_verify_minimum_env
+ '[' -z '' -a -z '' -a -z '' ']'
+ stonedb_error
++ date '+%Y-%m-%d %H:%M:%S'
+ echo '2023-09-08 03:29:48 [Error] '
2023-09-08 03:29:48 [Error] 
+ exit 1

2.使用centos环境安装部署：

下载安装包：

[root@node01 ~]# wget  https://github.com/stoneatom/stonedb/releases/download/5.7-v1.0.4-alpha/stonedb-ce-5.7-v1.0.4-alpha.el7.x86_64.rpm
 
[root@node01 ~]# rpm -ivh stonedb-ce-5.7-v1.0.4-alpha.el7.x86_64.rpm
Preparing...                          ################################# [100%]
	file /usr/lib64/libsnappy.so.1 from install of stonedb_5.7-1.0.4-1.el7.x86_64 conflicts with file from package snappy-1.1.0-3.el7.x86_64
 
 
[root@node01 ~]# yum list installed |grep "snappy"
Failed to set locale, defaulting to C
snappy.x86_64                               1.1.0-3.el7                installed
 
 
[root@node01 ~]# yum remove snappy.x86_64
Failed to set locale, defaulting to C
Loaded plugins: fastestmirror
Resolving Dependencies
--> Running transaction check
---> Package snappy.x86_64 0:1.1.0-3.el7 will be erased
--> Processing Dependency: libsnappy.so.1()(64bit) for package: kexec-tools-2.0.15-51.el7.x86_64
--> Running transaction check
---> Package kexec-tools.x86_64 0:2.0.15-51.el7 will be erased
--> Finished Dependency Resolution
 
Dependencies Resolved
 
 
[root@node01 ~]# rpm -ivh stonedb-ce-5.7-v1.0.4-alpha.el7.x86_64.rpm
Preparing...                          ################################# [100%]
Updating / installing...
   1:stonedb_5.7-1.0.4-1.el7          ################################# [100%]

[root@node01 ~]# /opt/stonedb57/install/bin/mysqld --defaults-file=/opt/stonedb57/install/my.cnf --initialize --user=mysql
/opt/stonedb57/install/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
[root@node01 ~]#  ldd /opt/stonedb57/install/bin/mysqld | grep 'not found'
	libaio.so.1 => not found

需要安装libaio包，yum install libaio

[root@node01 ~]# /opt/stonedb57/install/bin/mysqld --defaults-file=/opt/stonedb57/install/my.cnf --initialize --user=mysql
 
 
[root@node01 ~]#
 
[root@node01 ~]#
[root@node01 ~]# /opt/stonedb57/install/mysql_server start
Starting Stonedbbasedir::: /opt/stonedb57/install/
bindir::: /opt/stonedb57/install//bin
datadir::: /opt/stonedb57/install/data/
mysqld_pid::: /opt/stonedb57/install/data/mysqld.pid
.Logging to '/opt/stonedb57/install/data/node01.err'.
2023-09-10T14:51:02.153489Z mysqld_safe Starting mysqld daemon with databases from /opt/stonedb57/install/data
........... SUCCESS!

3.连接访问：

get password auto generate:

[root@node01 ~]# cat /opt/stonedb57/install/log/tianmu.log |grep "password"
[2023-09-10 22:49:02.788818] [2141] [WARN] [MYSQL:0] MSG: A temporary password is generated for root@localhost: Uf602
[2023-09-10 22:51:15.674585] [2839] [WARN] [MYSQL:0] MSG: Access denied for user 'root'@'localhost' (using password: NO)

connect to stonedb:

/opt/stonedb57/install/bin/mysql -uroot -p -S /opt/stonedb57/install/tmp/mysql.sock

alter the root default password:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'stonedb123';
mysql> FLUSH PRIVILEGES;

relogin using new password:

/opt/stonedb57/install/bin/mysqladmin -uroot -p -S /opt/stonedb57/install/tmp/mysql.sock shutdown
#输入更改后的 root 密码。

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| cache              |
| mysql              |
| performance_schema |
| sys                |
| sys_tianmu         |
+--------------------+
6 rows in set (0.00 sec)
 
mysql> use sys_tianmu;
Database changed
mysql>