参考文献: 次世代高速オープンソースRDB Tsurugi (神林飛志 et al. 著)
OS: Ubuntu 22.04
-- 1. Java11インストール
sudo apt -y update
sudo apt purge -y needrestart
sudo apt -y install openjdk-11-jdk
sudo sh -c "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. Tsurugiインストール
git clone https://github.com/project-tsurugi/tsurugidb.git
cd tsurugidb
git submodule update --init --recursive
sudo ./apt-install.sh
mkdir -p $HOME/tsurugi
sudo ./install.sh --prefix=$HOME/tsurugi
echo 'export TSURUGI_HOME="$HOME/tsurugi/tsurugi-snapshot-202311021013-11293d0"' >> ~/.bash_profile
echo 'export PATH=$PATH:$TSURUGI_HOME/bin' >> ~/.bash_profile
source ~/.bash_profile
-- 3. 動作確認
tgctl start
tgsql --connection tcp://localhost:12345
begin long transaction include ddl;
create table tab1 (
col1 bigint primary key,
col2 varchar(30) not null,
col3 int
);
commit;
begin long transaction write preserve tab1;
insert into tab1 values(1,'A',51);
insert into tab1 values(2,'B',52);
insert into tab1 values(3,'C',53);
commit;
begin read only;
select * from tab1;
commit;
\exit
tgctl shutdown