https://cloud.google.com/blog/ja/products/databases/get-started-with-alloydb-omni
https://cloud.google.com/alloydb/docs/omni
https://arkgame.com/2022/03/24/post-306307/
https://cloud.google.com/sdk/docs/install?hl=ja#rpm
システム要件
2 CPUs
16 GB of RAM
Docker version 20.10 or higher
Linux kernel version 4.18 or higher
Linux cgroup v2 enabled
The Google Cloud CLI
OS: Rocky Linux 9
-- 1. 前作業
-- 1.1 Docker インストール
dnf config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo
dnf repolist
dnf clean all
dnf install -y docker-ce --allowerasing
systemctl enable docker
systemctl start docker
systemctl status docker
docker --version
docker run hello-world
-- 1.2 Linux kernel version 4.18 or higherの確認
uname -a
-- 1.3 Linux cgroup v2 enabledの確認
If cgroup v2 is enabled, the command output shows cgroup2fs
stat -fc %T /sys/fs/cgroup/
-- 1.4 The Google Cloud CLI インストール
sudo tee -a /etc/yum.repos.d/google-cloud-sdk.repo << EOM
[google-cloud-cli]
name=Google Cloud CLI
baseurl=https://packages.cloud.google.com/yum/repos/cloud-sdk-el8-x86_64
enabled=1
gpgcheck=1
repo_gpgcheck=0
gpgkey=https://packages.cloud.google.com/yum/doc/rpm-package-key.gpg
EOM
dnf -y install google-cloud-cli
gcloud --version
-- 2. AlloyDB Omni インストール
docker pull gcr.io/alloydb-omni/pg-service:latest
docker pull gcr.io/alloydb-omni/memory-agent:latest
gsutil cp -r gs://alloydb-omni-install/$(gsutil cat gs://alloydb-omni-install/latest) .
cd $(gsutil cat gs://alloydb-omni-install/latest)
tar -xzf alloydb_omni_installer.tar.gz && cd installer
sudo bash install_alloydb.sh
-- 3. AlloyDB Omni セットアップ
ls -l /var/alloydb/config
cat /var/alloydb/config/dataplane.conf
cat /var/alloydb/config/pg_hba.conf
cat /var/alloydb/config/postgresql.conf
mkdir /AlloyDB
sudo sed -i "s|^\(DATADIR_PATH=\).*|\1/AlloyDB|" /var/alloydb/config/dataplane.conf
-- 4. AlloyDB Omni の起動と接続
sudo systemctl restart alloydb-dataplane
sudo systemctl status alloydb-dataplane
sudo systemctl enable alloydb-dataplane
docker exec -it pg-service psql -h localhost -U postgres