Tsurugi アーリーアクセス版

Ogawayama : PostgreSQLフロントエンド
Iceaxe : 高レベルJava-API
Tsubakuro : 低レベルJava-API
Belayer : Webサービス用API
Tanzawa : CLI

Tetayama : アプリケーション管理フレームワーク
Jogasaki : ジョブスケジューラ
Mizugaki : SQL分散処理用コンパイラ
Shirakami : トランザクションエンジン
Yakushima : インメモリインデックス
Limestone : ログストア

OS: Ubuntu 22.04

rootユーザで実行

-- 1. Java11インストール
sudo su -

apt -y update
apt purge -y needrestart

apt -y install openjdk-11-jdk

cat > /etc/profile.d/java.sh <<'EOF'
export JAVA_HOME=$(dirname $(dirname $(readlink $(readlink $(which java)))))
export PATH=$PATH:$JAVA_HOME/bin
EOF

source /etc/profile.d/java.sh

java -version
javac -version

-- 2. ソースアーカイブからのインストール

作業ディレクトリ(/root/tsurugi)を作成しtsurugi.tar.gzを格納

cd
mkdir tsurugi
cd /root/tsurugi

tar xzf tsurugi.tar.gz

apt -y update

apt -y install cmake

apt -y install libgoogle-glog-dev libgflags-dev protobuf-compiler libprotobuf-dev

apt -y install libboost-all-dev

apt -y install libleveldb-dev

apt -y install libtbb-dev

apt -y install libmpdec-dev

apt -y install pkg-config

apt -y install uuid-dev

apt -y install flex

apt -y install bison

apt -y install libmsgpack-dev

apt -y install *crypto*

apt -y install likwid

apt update -y
apt install -y -V ca-certificates lsb-release wget
wget https://apache.jfrog.io/artifactory/arrow/$(lsb_release --id --short | tr 'A-Z' 'a-z')/apache-arrow-apt-source-latest-$(lsb_release --codename --short).deb
apt install -y -V ./apache-arrow-apt-source-latest-$(lsb_release --codename --short).deb
apt update -y
apt install -y -V libarrow-dev # For C++
apt install -y -V libarrow-glib-dev # For GLib (C)
apt install -y -V libarrow-dataset-dev # For Apache Arrow Dataset C++
apt install -y -V libarrow-dataset-glib-dev # For Apache Arrow Dataset GLib (C)
apt install -y -V libarrow-acero-dev # For Apache Arrow Acero
apt install -y -V libarrow-flight-dev # For Apache Arrow Flight C++
apt install -y -V libarrow-flight-glib-dev # For Apache Arrow Flight GLib (C)
apt install -y -V libarrow-flight-sql-dev # For Apache Arrow Flight SQL C++
apt install -y -V libarrow-flight-sql-glib-dev # For Apache Arrow Flight SQL GLib (C)
apt install -y -V libgandiva-dev # For Gandiva C++
apt install -y -V libgandiva-glib-dev # For Gandiva GLib (C)
apt install -y -V libparquet-dev # For Apache Parquet C++
apt install -y -V libparquet-glib-dev # For Apache Parquet GLib (C)

apt -y install libpq-dev

apt -y install libjemalloc-dev

apt -y install doxygen

./install.sh --prefix=/root/tsurugi

vi /root/.bashrc

export TSURUGI_HOME="/root/tsurugi/tsurugi-0.202309011418-alpha"

source /root/.bashrc

-- 3. Tsurugiの動作確認

-- 3.1 Tsurugiサーバの起動

cd /root/tsurugi/tsurugi-0.202309011418-alpha

GLOG_logtostderr=1 ./bin/tgctl start --conf=var/etc/tsurugi.ini --v=30

-- 3.2 Tsurugi CLIでサーバに接続

tgsql.zipを作業ディレクトリ(/root/tsurugi)へ転送して解凍

cd /root/tsurugi/tgsql

./bin/tgsql --no-auth -c ipc:tsurugi

-- 3.3 疎通確認用のクエリ発行

BEGIN;
CREATE TABLE tab1(col1 INT PRIMARY KEY, col2 INT);
INSERT INTO tab1(col1, col2) VALUES(1,100);
SELECT * FROM tab1;
COMMIT;

BEGIN;
DROP TABLE tab1;
COMMIT;

(Ctrl+D)で終了

-- 3.4 Tsurugiサーバの停止

cd /root/tsurugi/tsurugi-0.202309011418-alpha
./bin/tgctl shutdown --conf=var/etc/tsurugi.ini