linux 安装小米soar-sql优化

linux 安装soar

1.下载安装包.

1.go安装包下载地址:

https://golang.org/dl/

2.上传到linux服务器.或者直接使用wget下载到服务器的zpf目录中.

mkdir -p /zpf/

3.创建解压目录,并且解压文件到目录中.

mkdir -p /usr/local/go

解压安装包:

tar xf go1.12.4.linux-amd64.tar.gz -C /usr/local/go/

4.添加环境变量.

vim /etc/profile

export PATH=$PATH:$HOME/bin:/usr/local/mysql/bin/:/usr/local/go/go/bin/

source /etc/profile

5.验证安装是否成功

[root@mysql-01 /usr/local/go]$ go

Go is a tool for managing Go source code.

Usage:

	go <command> [arguments]

The commands are:

	bug         start a bug report

	build       compile packages and dependencies

	clean       remove object files and cached files

	doc         show documentation for package or symbol

	env         print Go environment information

	fix         update packages to use new APIs

	fmt         gofmt (reformat) package sources

	generate    generate Go files by processing source

	get         download and install packages and dependencies

	install     compile and install packages and dependencies

	list        list packages or modules

	mod         module maintenance

	run         compile and run Go program

	test        test packages

	tool        run specified go tool

	version     print Go version

2.go安装完成

3.安装soar

1.安装依赖.安装go 1.10+上面安装完成

2.安装git.

yum install git -y

3.创建soar目录.用于存放编译所需代码.

mkdir -p /usr/local/go/go/src/github.com/XiaoMi/soar 

4.生成二进制文件

cd /usr/local/go/go/src/

go get -d github.com/XiaoMi/soar

5.编译文件

cd /usr/local/go/go/src/src/github.com/XiaoMi/soar && make

6.安装验证

echo 'select * from film' | ./soar

7.创建软连接到/usr/local/bin/   目录中

ln -s /usr/local/go/go/src/github.com/XiaoMi/soar/bin/soar /usr/local/bin/soar

echo 'select * from film' | soar

以上内容仅仅适合命令行进行有花的建议.没研究出来怎么进行改写.

4.使用docker启动soar,并进行web界面显示.并且可以进行部分的sql优化显示.

https://github.com/xiyangxixian/soar-web

​

docker 支持

地址：https://hub.docker.com/r/becivells/soar-web/

Dockerfile 见根目录 Dockerfile 文件

docker pull becivells/soar-web

docker run -d --name soar-web -p 5077:5077 becivells/soar-web

​

也可以使用 Dockerfile 自行构建

docker build --no-cache -t soar-web .