Forem: yuki777

Create a Virtual Office with WorkAdventure on Your Server

yuki777 — Wed, 24 May 2023 09:32:38 +0000

About WorkAdventure

WorkAdventure is a collaborative web application presented in the form of a 16-bit RPG video game. This innovative approach to remote collaboration offers a unique, engaging, and virtual office-like environment.

For more information, visit the Official Website or check out the project's GitHub page.

Motivation

Installing WorkAdventure can seem a bit challenging at first. I have written this guide to make the process simpler for others. If it can assist even one person, I will be satisfied.

Installation Guide

Prerequisites

Before we begin, it's worth mentioning that the steps in this guide have been tested and confirmed to work on a server with the following specifications:

Distribution: Canonical, Ubuntu Server Pro, 22.04 LTS, amd64 jammy image built on 2023-05-16
CPU Architecture: x86_64 (This guide does not support ARM-based CPUs)
AMI: ami-0702b27a97d5bbcba
Instance type: t2.medium (4GB Memory)
Storage: 20GB

Please note that while the steps should generally work on servers with different specifications, this guide cannot guarantee the same results for other configurations or CPU architectures. Always ensure your server meets the requirements of the software you are installing.

Set your environment with the following variables:

version=v1.15.11
domain=your.example.com

Step 1: Install Docker

We'll be using Docker for our installation. If you haven't installed Docker on your Ubuntu server yet, you can do so by following the instructions available on Docker's official documentation.

Alternatively, you can use the following script to install Docker:

$(cat << 'EOF' > ~/install-docker.sh

sudo apt-get remove docker docker-engine docker.io containerd runc
sudo apt-get update
sudo apt-get install -y ca-certificates curl gnupg
sudo install -m 0755 -d /etc/apt/keyrings
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo gpg --dearmor -o /etc/apt/keyrings/docker.gpg
sudo chmod a+r /etc/apt/keyrings/docker.gpg
echo \
  "deb [arch="$(dpkg --print-architecture)" signed-by=/etc/apt/keyrings/docker.gpg] https://download.docker.com/linux/ubuntu \
  "$(. /etc/os-release && echo "$VERSION_CODENAME")" stable" | \
  sudo tee /etc/apt/sources.list.d/docker.list > /dev/null
sudo apt-get update
sudo apt-get install -y docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin docker-compose
sudo docker run hello-world

EOF
)

/bin/bash ~/install-docker.sh

Step 2: Clone WorkAdventure Repository and Prepare Deployment Files

The next step is to clone the WorkAdventure repository and prepare the necessary deployment files. Use the following commands to achieve this:

cd

$(cat << EOF > ~/copy-deployment-files

mkdir -p ~/git
cd ~/git
sudo rm -fr ~/git/workadventure
git clone https://github.com/thecodingmachine/workadventure.git -b $version
cd ~/git/workadventure/contrib/docker
cp .env.prod.template .env
cp docker-compose.prod.yaml docker-compose.yaml

EOF
)

/bin/bash ~/copy-deployment-files

Step 3: Configure Your Environment

Once Docker is installed and the repository is cloned, configure your environment using the following script:

cd

$(cat << EOF > ~/configure-your-environment.sh

cd ~/git/workadventure/contrib/docker
sed -i 's/^SECRET_KEY=$/SECRET_KEY=foobar/' .env
sed -i "s/^DOMAIN=workadventure.localhost$/DOMAIN=${domain}/" .env
sed -i "s/workadventure.localhost/${domain}/" .env
sed -i "s/^VERSION=master$/VERSION=${version}/" .env
sed -i "s/^MAP_STORAGE_AUTHENTICATION_USER=$/MAP_STORAGE_AUTHENTICATION_USER=map-storage-user/" .env
sed -i "s/^MAP_STORAGE_AUTHENTICATION_PASSWORD=$/MAP_STORAGE_AUTHENTICATION_PASSWORD=map-storage-pass/" .env
sed -i 's/^ADMIN_API_URL=$/#ADMIN_API_URL=/' .env
echo PLAY_HOST=play.$domain >> .env

EOF
)

/bin/bash ~/configure-your-environment.sh

sed -i '/PROMETHEUS_AUTHORIZATION_TOKEN: "$PROMETHEUS_AUTHORIZATION_TOKEN"/a \
      AUTHENTICATION_STRATEGY: "Basic"\
      AUTHENTICATION_TOKEN: "token"\
      AUTHENTICATION_USER: "user"\
      AUTHENTICATION_PASSWORD: "pass"' ~/git/workadventure/contrib/docker/docker-compose.yaml

Step 4: Launch the WorkAdventure Environment

With your environment configured, start the WorkAdventure environment with the following command:

cd ~/git/workadventure/contrib/docker && sudo docker-compose up

Step 5: Create and Upload Your First Map

WorkAdventure operates with maps that define the virtual space. Here is how you can create your first map and upload it to your server:

# Delete old repository and clone repository
mkdir -p ~/git
cd ~/git
rm -fr workadventure-map-starter-kit
git clone https://github.com/thecodingmachine/workadventure-map-starter-kit.git -b v3.3.3
cd ~/git/workadventure-map-starter-kit

# volta pin node@20 # Use Node.js v20 via volta
npm ci

# Build
npm run build
mv dist map
zip -r map.zip map
cp map.zip ~/Desktop

Testing Your Installation

Now that you have installed WorkAdventure and uploaded your first map, it's time to test it out. Here are some useful links:

Upload map
- https://map-storage.YOUR.EXAMPLE.COM/
- user : pass
- Directory: /
View maps
- https://map-storage.YOUR.EXAMPLE.COM/maps
Play
- https://play.YOUR.EXAMPLE.COM/_/global/map-storage.YOUR.EXAMPLE.COM/map/map.tmj

Future Work

Integrate Jitsi for video conferencing capabilities
Set the correct timezone for server operations

Remember, installing and setting up WorkAdventure is just the beginning of the journey. Have fun exploring and creating your own unique virtual office!

Install multiple PHP versions and automatically switch versions for each directory

yuki777 — Thu, 17 Nov 2022 01:33:14 +0000

Description

Translated from Qiita
I want to use multiple versions of PHP
I want to automatically switch between different versions of PHP for each directory
I don't want to do php builds because they are too difficult
I want to support Mac and Ubuntu

Install brew

Install Brew
I thought brew was for macs only, but it can be installed on ubuntu too!

Install php

Install php
Additional packages can be installed as needed, such as imagemagick
In this article, *PHP is installed with brew. *

brew update
brew tap shivammathur/php
brew install php@8.1
brew install php@8.0
brew install php@7.4
brew install pkg-config
brew install imagemagick

Install phpenv

Install phpenv
phpenv is used to switch between PHP versions using phpenv global, phpenv local, etc.
In this article, phpenv does not install PHP.

# Install phpenv
curl -L https://raw.githubusercontent.com/phpenv/phpenv-installer/master/bin/phpenv-installer | bash

# Setup phpenv
$(cat << 'EOF' >> ~/.zshrc
# phpenv
export PHPENV_ROOT="$HOME/.phpenv"
if [ -d "${PHPENV_ROOT}" ]; then
  export PATH="${PHPENV_ROOT}/bin:${PATH}"
  eval "$(phpenv init -)"
fi
EOF
)

# restart shell
exec $SHELL -l

Link each version of php installed by brew to ~/.phpenv/versions

You need to link the php installed by brew so that phpenv can manage them. Manual work is tedious, so I wrote a script.

curl -fsSL https://gist.githubusercontent.com/yuki777/6244823b8aa8cf4457e97e6407ada5ad/raw/e988f8a1c112e4063768664104ba14d799e63782/link-phps.bash | bash

Source

#!/usr/bin/env bash

set -au

## Check cellar dir
cellarDir=$(brew --prefix)/Cellar
if [ ! -d "$cellarDir" ]; then
  echo "Not found. brew package path $cellarDir :("
  echo
  exit 1
fi

parentDirs=$(find $cellarDir/php* -type d -maxdepth 0)
echo "# Link the php installed by Brew to ~/.phpenv/versions"
for parentDir in $parentDirs
do
  childDirs=$(find "$parentDir"/* -type d -maxdepth 0)
  for childDir in $childDirs
  do
    phpPath=$childDir/bin/php
    if [ ! -f "$phpPath" ]; then
      continue
    fi
    major=$($phpPath -r 'echo PHP_MAJOR_VERSION;')
    minor=$($phpPath -r 'echo PHP_MINOR_VERSION;')
    patch=$($phpPath -r 'echo PHP_RELEASE_VERSION;')

    # unlink
    rm -f "$HOME"/.phpenv/versions/"$major"."$minor"
    rm -f "$HOME"/.phpenv/versions/"$major"."$minor"."$patch"

    # link
    linkCommand="ln -s $childDir $HOME/.phpenv/versions/$major.$minor"
    echo "$linkCommand"
    $linkCommand
    linkCommand="ln -s $childDir $HOME/.phpenv/versions/$major.$minor.$patch"
    echo "$linkCommand"
    $linkCommand
  done
done

Tests

Test that running php -v in global will use php 8.1
Test that php 7.4 is automatically switched to php 7.4 when you move to the /tmp/php7.4

cd /tmp && mkdir php74 php80 php81

# set version
cd /tmp         && phpenv global 8.1 # set 8.1 as a global
cd /tmp/php74   && phpenv local  7.4 # pin 7.4 in this dir
cd /tmp/php80   && phpenv local  8.0 # pin 8.0 in this dir
cd /tmp/php81   && phpenv local  8.1 # pin 8.1 in this dir

# test version
cd /tmp         && php -v # => 8.1
cd /tmp/php74   && php -v # => 7.4
cd /tmp/php80   && php -v # => 8.0
cd /tmp/php81   && php -v # => 8.1

Notes on brew upgrade

When php is upgraded by brew upgrade, symlink will be broken, so you need to re-run the link.

curl -fsSL https://gist.githubusercontent.com/yuki777/6244823b8aa8cf4457e97e6407ada5ad/raw/e988f8a1c112e4063768664104ba14d799e63782/link-phps.bash | bash

Summary

Want to use multiple versions of PHP => with phpenv.
Want to automatically switch between different versions of php for each directory => with phpenv.
Don't want to waste time with php builds => install php with brew.
I want to support Mac and Ubuntu => with brew and my own scripts.
Special thanks, uzulla-san's slide

and others

About pecl installation
This article is written assuming a clean installation, but there are cases where php, direnv, brew-php-switcher, etc. have already been installed.
About specifying php version in vscode and phpstorm
I will write more if there is demand for it.

Have you ever mistakenly created test data on production's admin panel?

yuki777 — Tue, 21 Jun 2022 05:37:18 +0000

I made so many mistakes, so I wrote a little code.
Hope it helps you.

Chrome extension: https://chrome.google.com/webstore/detail/peacekeeper/dfhhnlmecdgbidblhlidkgiagikjgfip

Source code: https://github.com/yuki777/peacekeeper

Bash script to make ECS Exec (aws ecs execute-command) useful

yuki777 — Mon, 08 Nov 2021 01:22:03 +0000

Translated from qiita.com
Bash script(gist)

Usage

# Download it, save it any name you like, `chmod` it.
curl https://gist.githubusercontent.com/yuki777/640cba3e0a68587c36165b8a87d25390/raw/5bfa8242ba00ed336da76711d602e6df4f76a452/sssh -o sssh
chmod 744 sssh
./sssh

# Select aws profile from `aws configure list-profiles`
Select aws profile.
1) default
2) foo-bar
#? 2
profile: foo-bar

# Select cluster from `aws ecs list-clusters`
Select cluster.
1) dev-foo-bar-cluster          9) prod-foo-app-cluster
2) prd-foo-hoge-ad-cluster      10) stg-foo-app-cluster
3) prd-foo-hoge-cluster         11) stg-foo-hoge-cluster
4) prd-foo-piyo2021-ad-cluster  12) stg-foo-piyo2021-cluster
5) prd-foo-piyo2021-cluster     13) stg-foo-bar-cluster
6) prd-foo-bar-ad-cluster       14) stg-foo-tags-cluster
7) prd-foo-bar-cluster          15) hoge-foo-bar-cluster
8) prd-foo-tags-cluster
#? 1
cluster: dev-foo-bar-cluster

# Select service from `aws ecs list-services`
 1) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1125-service
 2) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1206-service
 3) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1249-service
 4) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1275-service
 5) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1323-service
 6) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1348-service
 7) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1349-service
 8) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1384-service
 9) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1386-service
10) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1391-service
11) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1397-service
12) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1399-service
13) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1412-service
14) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1413-service
15) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1419-service
16) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-qa-1420-service
17) arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-service
#? 16
service: arn:aws:ecs:ap-northeast-1:************:service/dev-foo-bar-cluster/dev-foo-bar-qa-1420-service

# Select task from `aws ecs list-tasks`
1) arn:aws:ecs:ap-northeast-1:************:task/dev-foo-bar-cluster/********************************
#? 1
task: arn:aws:ecs:ap-northeast-1:************:task/dev-foo-bar-cluster/********************************

# Select container from `aws ecs describe-tasks`
1) container-foo
2) container-bar
3) container-hoge
4) container-piyo
#? 1
container: container-foo

# Show command
aws ecs execute-command --profile foo-bar --cluster dev-foo-bar-cluster --container container-foo --task arn:aws:ecs:ap-northeast-1:************:task/dev-foo-bar-cluster/******************************** --interactive --command '/bin/sh'

The Session Manager plugin was installed successfully. Use the AWS CLI to start a session.

# Start your session and run command from `aws ecs execute-command`
Starting session with SessionId: ecs-execute-command-*****************
/path/to/home # :)

Source

Bash script(gist)

#!/bin/bash

# Bash script to run ecs-exec on Amazon ECS Fargate containers.
#
# Usage: See --help.
#
# Installation: Download the script and `chmod u+x the script`.
#  curl https://gist.githubusercontent.com/yuki777/640cba3e0a68587c36165b8a87d25390/raw/5bfa8242ba00ed336da76711d602e6df4f76a452/sssh -o sssh && chmod u+x sssh
#  ./sssh
#
# Prerequisites (validated)
# - aws cli
# - session-manager-plugin
# - jq
#
# Special thanks to contributor
# - leewc

set -eu

selectProfile(){
    # profile parameter not supplied.
    if [ -z ${profile+x} ]; then
        # only works with AWS CLIv2.
        select selected in `aws configure list-profiles`
        do
            break
        done
        echo $selected
    else
        echo $profile
    fi
}

params(){
    echo "$(profileParam) $(regionParam)"
}

profileParam() {
    [[ $profile ]] &>/dev/null && echo "--profile $profile"
}

regionParam() {
    [[ $region ]] &>/dev/null && echo "--region $region"
}

selectCluster(){
    select selected in $(aws ecs list-clusters $(params)|jq -r ".clusterArns[]"|sort|cut -d "/" -f 2)
    do
        break
    done
    echo $selected
}

selectService(){
    select selected in $(aws ecs list-services $(params) --cluster $cluster|jq -r ".serviceArns[]"|sort)
    do
        break
    done
    echo $selected
}

selectTask(){
    select selected in $(aws ecs list-tasks $(params) --cluster $cluster --service-name $service --desired-status RUNNING |jq -r '.taskArns[]'|sort)
    do
        break
    done
    echo $selected
}

selectContainer(){
    select selected in $(aws ecs describe-tasks $(params) --cluster $cluster --tasks $task | jq -r ".tasks[].containers[].name"|sort)
    do
        break
    done
    echo $selected
}

colorEcho(){
    red='\033[0;31m'
    green='\033[0;32m'
    yellow='\033[0;33m'
    reset='\033[0m'

    if echo $@ | egrep -q "prd|prod|production"; then
        color=$red
    elif echo $@ | egrep -q "stg|stage|staging|beta|devo"; then
        color=$yellow
    else
        color=$green
    fi

    echo -e "${color}$@${reset}"
}

echo_stderr() {
    echo -e "$@" >&2
}

die() {
    echo_stderr "$@"
    exit 1
}

validatePrereq() {
    command -v jq  &>/dev/null || die "jq not installed on host. Please install jq. See https://stedolan.github.io/jq/download/"
    command -v session-manager-plugin &>/dev/null || die "session-manager-plugin not installed. See https://docs.aws.amazon.com/systems-manager/latest/userguide/session-manager-working-with-install-plugin.html"
    command -v aws &>/dev/null || die "AWS CLI not found, AWS CLI version 1.16.12 or later must be installed. See https://docs.aws.amazon.com/cli/latest/userguide/getting-started-install.html"
    # Checks if AWS CLI is outdated or not., v1 of AWS CLI pipes to std error, redirect
    AWS_CLI_VERSION=$(aws --version 2>&1 | awk '{ print $1 }' | cut -d/ -f2)
    echo_stderr "You have AWS CLI v$AWS_CLI_VERSION installed."
    # Do a best effort check for v1 (so that it's at least 1.10 and up.
    [[ $AWS_CLI_VERSION =~ ^1.1[0-9] || $AWS_CLI_VERSION =~ ^2 ]] &>/dev/null || die "AWS CLI version 1.16.12 or later must be installed to support ecs-exec, Run 'aws --version' to see what you have. See https://docs.aws.amazon.com/cli/latest/userguide/getting-started-install.html"
}

function print_help() {
    cat >&2 <<-END

This script simplifies the process of getting the required information to drop into an
interactive shell script on your container hosted on Fargate/ECS.

Example:

./sssh --region us-west-2
./sssh --profile default

Supported input parameters:
 -r | --region  : AWS Region to fetch the cluster, service, task
 -p | --profile : AWS Profile for credentials and region.
 -c | --command : Command to execute, defaults to '/bin/sh'/

The default command executed on the selected container is '/bin/sh'.
If a region is not provided, the script will attempt to use your region set in the profile.
If you want to execute a different command or shell, you can pass it in like so:

./sssh --command '/bin/bash'

You need active (unexpired) AWS credentials, otherwise, the script will crash.

Updates on https://gist.githubusercontent.com/leewc/e4c3a16551b06c2b0b4640fa5a3d9c00

END
}

main(){
    command='/bin/sh'
    while [[ "$#" -gt 0 ]]; do
        case $1 in
            -h|--help)
                print_help
                exit
                ;;
            -r|--region)
                shift
                region="${1:?Region must be specified in --region}"
                shift
                ;;
            -p|--profile)
                shift
                profile="${1:?Profile must be specified in --profile}"
                shift
                ;;
            -c|--command)
                shift
                command="${1:?Command must be specified in --command}"
                shift
                ;;
            *)
                die "Unknown param $1"
                ;;
        esac
    done

    echo_stderr "Validating pre-requisites...."
    validatePrereq

    # spaces matter :)
    if [[ $AWS_CLI_VERSION =~ ^2 ]] ; then
        echo_stderr "Select AWS Profile."
        profile=`selectProfile`
        colorEcho profile: $profile
    else echo_stderr "[INFO] AWS CLI is not v2, unable to select profile. --region or --profile must be set."
    fi
    echo_stderr

    echo_stderr "Select cluster."
    cluster=`selectCluster`
    colorEcho cluster: $cluster
    echo_stderr

    echo_stderr "Select service."
    service=`selectService`
    colorEcho service: $service
    echo_stderr

    echo_stderr "Select task."
    task=`selectTask`
    colorEcho task: $task
    echo_stderr

    echo_stderr "Select container."
    container=`selectContainer`
    colorEcho container: $container
    echo_stderr

    echo_stderr "Executing command (you might have to upgrade your AWS CLI if this fails)"
    cmd="aws ecs execute-command $(params) --cluster $cluster --container $container --task $task --interactive --command '$command'"
    colorEcho $cmd

    $cmd
}

# Execute main function and pass all params over
main $@

Start MySQL database server on Mac startup

yuki777 — Thu, 25 Mar 2021 06:47:22 +0000

Set cron by crontab

You can use @reboot in crontab.
crontab osx man page

crontab -e

# Start MySQL 8.0.23 with port 13306 on startup
@reboot cd ~/tmp/path-to-your-dir && cd mysql/versions/8.0.23 && dir=`pwd` && $dir/basedir/bin/mysqld --defaults-extra-file=$dir/datadir/mysql8-name1/my.cnf --daemonize --user=_dbdb_mysql --port=13306 --socket=/tmp/dbdb_mysql_13306.sock --basedir=$dir/basedir --plugin-dir=$dir/basedir/lib/plugin  --datadir=$dir/datadir/mysql8-name1 --log-error=$dir/datadir/mysql8-name1/mysqld.err --pid-file=$dir/datadir/mysql8-name1/mysql.pid

# Start MySQL 8.0.23 with port 23306 on startup
@reboot cd ~/tmp/path-to-your-dir && cd mysql/versions/8.0.23 && dir=`pwd` && $dir/basedir/bin/mysqld --defaults-extra-file=$dir/datadir/mysql8-name2/my.cnf --daemonize --user=_dbdb_mysql --port=23306 --socket=/tmp/dbdb_mysql_23306.sock --basedir=$dir/basedir --plugin-dir=$dir/basedir/lib/plugin --datadir=$dir/datadir/mysql8-name2 --log-error=$dir/datadir/mysql8-name2/mysqld.err --pid-file=$dir/datadir/mysql8-name2/mysql.pid

# Start MySQL 5.7.31 with port 33306 on startup
@reboot cd ~/tmp/path-to-your-dir && cd mysql/versions/5.7.31 && dir=`pwd` && $dir/basedir/bin/mysqld --defaults-extra-file=$dir/datadir/mysql5-name3/my.cnf --daemonize --user=_dbdb_mysql --port=33306 --socket=/tmp/dbdb_mysql_33306.sock --basedir=$dir/basedir --plugin-dir=$dir/basedir/lib/plugin  --datadir=$dir/datadir/mysql5-name3 --log-error=$dir/datadir/mysql5-name3/mysqld.err --pid-file=$dir/datadir/mysql5-name3/mysql.pid

# Start MySQL 5.7.31 with port 43306 on startup
@reboot cd ~/tmp/path-to-your-dir && cd mysql/versions/5.7.31 && dir=`pwd` && $dir/basedir/bin/mysqld --defaults-extra-file=$dir/datadir/mysql5-name4/my.cnf --daemonize --user=_dbdb_mysql --port=43306 --socket=/tmp/dbdb_mysql_43306.sock --basedir=$dir/basedir --plugin-dir=$dir/basedir/lib/plugin  --datadir=$dir/datadir/mysql5-name4 --log-error=$dir/datadir/mysql5-name4/mysqld.err --pid-file=$dir/datadir/mysql5-name4/mysql.pid

Delete multiple MySQL database server on local Mac

yuki777 — Tue, 23 Mar 2021 07:34:18 +0000

Delete MySQL datadir

The datadir contains your data.

cd ~/tmp/path-to-your-dir

# Delete "mysql8-name1"
rm -fr mysql/versions/8.0.23/datadir/mysql8-name1

# Delete "mysql8-name2"
rm -fr mysql/versions/8.0.23/datadir/mysql8-name2

# Delete "mysql5-name3"
rm -fr mysql/versions/5.7.31/datadir/mysql5-name3

# Delete "mysql5-name4"
rm -fr mysql/versions/5.7.31/datadir/mysql5-name4

Delete MySQL basedir(option)

The basedir contains MySQL programs.
If you want to delete basedir too, you can do that.

...

Connect multiple MySQL database server on local Mac

yuki777 — Fri, 19 Mar 2021 16:22:26 +0000

Connect MySQL with custom port and socket

# MySQL 8.0.23 with port 13306
cd ~/tmp/path-to-your-dir
cd mysql/versions/8.0.23
dir=`pwd`
$dir/basedir/bin/mysql \
 --user=root \
 --host=localhost \
 --port=13306 \
 --socket=/tmp/dbdb_mysql_13306.sock

# MySQL 8.0.23 with port 23306
cd ~/tmp/path-to-your-dir
cd mysql/versions/8.0.23
dir=`pwd`
$dir/basedir/bin/mysql \
 --user=root \
 --host=localhost \
 --port=23306 \
 --socket=/tmp/dbdb_mysql_23306.sock

# MySQL 5.7.31 with port 33306
cd ~/tmp/path-to-your-dir
cd mysql/versions/5.7.31
dir=`pwd`
$dir/basedir/bin/mysql \
 --user=root \
 --host=localhost \
 --port=33306 \
 --socket=/tmp/dbdb_mysql_33306.sock

# MySQL 5.7.31 with port 43306
cd ~/tmp/path-to-your-dir
cd mysql/versions/5.7.31
dir=`pwd`
$dir/basedir/bin/mysql \
 --user=root \
 --host=localhost \
 --port=43306 \
 --socket=/tmp/dbdb_mysql_43306.sock

Start and Stop multiple MySQL database server on local Mac

yuki777 — Wed, 17 Mar 2021 02:55:30 +0000

Create my.cnf

cd ~/tmp/path-to-your-dir
touch mysql/versions/8.0.23/datadir/mysql8-name1/my.cnf
touch mysql/versions/8.0.23/datadir/mysql8-name2/my.cnf
touch mysql/versions/5.7.31/datadir/mysql5-name3/my.cnf
touch mysql/versions/5.7.31/datadir/mysql5-name4/my.cnf

Start MySQL server with custom datadir and port

# MySQL 8.0.23 with port 13306
cd ~/tmp/path-to-your-dir
cd mysql/versions/8.0.23
dir=`pwd`
$dir/basedir/bin/mysqld \
 --defaults-extra-file=$dir/datadir/mysql8-name1/my.cnf \
 --daemonize \
 --user=_dbdb_mysql \
 --port=13306 \
 --socket=/tmp/dbdb_mysql_13306.sock \
 --basedir=$dir/basedir \
 --plugin-dir=$dir/basedir/lib/plugin  \
 --datadir=$dir/datadir/mysql8-name1 \
 --log-error=$dir/datadir/mysql8-name1/mysqld.err \
 --pid-file=$dir/datadir/mysql8-name1/mysql.pid

# MySQL 8.0.23 with port 23306
cd ~/tmp/path-to-your-dir
cd mysql/versions/8.0.23
dir=`pwd`
$dir/basedir/bin/mysqld \
 --defaults-extra-file=$dir/datadir/mysql8-name2/my.cnf \
 --daemonize \
 --user=_dbdb_mysql \
 --port=23306 \
 --socket=/tmp/dbdb_mysql_23306.sock \
 --basedir=$dir/basedir \
 --plugin-dir=$dir/basedir/lib/plugin  \
 --datadir=$dir/datadir/mysql8-name2 \
 --log-error=$dir/datadir/mysql8-name2/mysqld.err \
 --pid-file=$dir/datadir/mysql8-name2/mysql.pid

# MySQL 5.7.31 with port 33306
cd ~/tmp/path-to-your-dir
cd mysql/versions/5.7.31
dir=`pwd`
$dir/basedir/bin/mysqld \
 --defaults-extra-file=$dir/datadir/mysql5-name3/my.cnf \
 --daemonize \
 --user=_dbdb_mysql \
 --port=33306 \
 --socket=/tmp/dbdb_mysql_33306.sock \
 --basedir=$dir/basedir \
 --plugin-dir=$dir/basedir/lib/plugin  \
 --datadir=$dir/datadir/mysql5-name3 \
 --log-error=$dir/datadir/mysql5-name3/mysqld.err \
 --pid-file=$dir/datadir/mysql5-name3/mysql.pid

# MySQL 5.7.31 with port 43306
cd ~/tmp/path-to-your-dir
cd mysql/versions/5.7.31
dir=`pwd`
$dir/basedir/bin/mysqld \
 --defaults-extra-file=$dir/datadir/mysql5-name4/my.cnf \
 --daemonize \
 --user=_dbdb_mysql \
 --port=43306 \
 --socket=/tmp/dbdb_mysql_43306.sock \
 --basedir=$dir/basedir \
 --plugin-dir=$dir/basedir/lib/plugin  \
 --datadir=$dir/datadir/mysql5-name4 \
 --log-error=$dir/datadir/mysql5-name4/mysqld.err \
 --pid-file=$dir/datadir/mysql5-name4/mysql.pid

Stop MySQL

# MySQL 8.0.23 with port 13306
cd ~/tmp/path-to-your-dir
cd mysql/versions/8.0.23
dir=`pwd`
$dir/basedir/bin/mysqladmin \
 --user=root \
 --host=localhost \
 --port=13306 \
 --socket=/tmp/dbdb_mysql_13306.sock \
 shutdown

# MySQL 8.0.23 with port 23306
cd ~/tmp/path-to-your-dir
cd mysql/versions/8.0.23
dir=`pwd`
$dir/basedir/bin/mysqladmin \
 --user=root \
 --host=localhost \
 --port=23306 \
 --socket=/tmp/dbdb_mysql_23306.sock \
 shutdown

# MySQL 5.7.31 with port 33306
cd ~/tmp/path-to-your-dir
cd mysql/versions/5.7.31
dir=`pwd`
$dir/basedir/bin/mysqladmin \
 --user=root \
 --host=localhost \
 --port=33306 \
 --socket=/tmp/dbdb_mysql_33306.sock \
 shutdown

# MySQL 5.7.31 with port 43306
cd ~/tmp/path-to-your-dir
cd mysql/versions/5.7.31
dir=`pwd`
$dir/basedir/bin/mysqladmin \
 --user=root \
 --host=localhost \
 --port=43306 \
 --socket=/tmp/dbdb_mysql_43306.sock \
 shutdown

What's next?

Connect MySQL
or just try dbdb.

Create multiple MySQL database server on local Mac

yuki777 — Wed, 17 Mar 2021 02:50:55 +0000

Description

This section explains how to create multiple mysql servers locally.
However, if you don't want to read that already, you can use dbdb.

Download

First of all, Let's download MySQL source from mysql.com
Choose one or two what you want to use.

Install MySQL

Extract mysql source into separated directory for each version.

# 8.0.23
mkdir -p ~/tmp/path-to-your-dir
cd       ~/tmp/path-to-your-dir
mkdir -p mysql/versions/8.0.23/basedir
cd mysql/versions/8.0.23/basedir
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.23-macos10.15-x86_64.tar.gz
tar zxf mysql-8.0.23-macos10.15-x86_64.tar.gz --strip-components 1

# 5.7.31
mkdir -p ~/tmp/path-to-your-dir
cd       ~/tmp/path-to-your-dir
mkdir -p mysql/versions/5.7.31/basedir
cd mysql/versions/5.7.31/basedir
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.31-macos10.14-x86_64.tar.gz
tar zxf mysql-5.7.31-macos10.14-x86_64.tar.gz --strip-components 1

Initialize MySQL server with custom datadir and port

MySQL 8.0 server options
MySQL 5.7 server options
By separating the socket and port, each mysql can be started as a separate process.

# MySQL 8.0.23 with port 13306
cd ~/tmp/path-to-your-dir
mkdir -p mysql/versions/8.0.23/datadir/mysql8-name1
cd mysql/versions/8.0.23
dir=`pwd`
$dir/basedir/bin/mysqld \
  --initialize-insecure \
  --user=_dbdb_mysql \
  --port=13306 \
  --socket=/tmp/dbdb_mysql_13306.sock \
  --basedir=$dir/basedir \
  --plugin-dir=$dir/basedir/lib/plugin  \
  --datadir=$dir/datadir/mysql8-name1 \
  --log-error=$dir/datadir/mysql8-name1/mysqld.err \
  --pid-file=$dir/datadir/mysql8-name1/mysql.pid

# MySQL 8.0.23 with port 23306
cd ~/tmp/path-to-your-dir
mkdir -p mysql/versions/8.0.23/datadir/mysql8-name2
cd mysql/versions/8.0.23
dir=`pwd`
$dir/basedir/bin/mysqld \
  --initialize-insecure \
  --user=_dbdb_mysql \
  --port=23306 \
  --socket=/tmp/dbdb_mysql_23306.sock \
  --basedir=$dir/basedir \
  --plugin-dir=$dir/basedir/lib/plugin  \
  --datadir=$dir/datadir/mysql8-name2 \
  --log-error=$dir/datadir/mysql8-name2/mysqld.err \
  --pid-file=$dir/datadir/mysql8-name2/mysql.pid

# MySQL 5.7.31 with port 33306
cd ~/tmp/path-to-your-dir
mkdir -p mysql/versions/5.7.31/datadir/mysql5-name3
cd mysql/versions/5.7.31
dir=`pwd`
$dir/basedir/bin/mysqld \
  --initialize-insecure \
  --user=_dbdb_mysql \
  --port=33306 \
  --socket=/tmp/dbdb_mysql_33306.sock \
  --basedir=$dir/basedir \
  --plugin-dir=$dir/basedir/lib/plugin  \
  --datadir=$dir/datadir/mysql5-name3 \
  --log-error=$dir/datadir/mysql5-name3/mysqld.err \
  --pid-file=$dir/datadir/mysql5-name3/mysql.pid

# MySQL 5.7.31 with port 43306
cd ~/tmp/path-to-your-dir
mkdir -p mysql/versions/5.7.31/datadir/mysql5-name4
cd mysql/versions/5.7.31
dir=`pwd`
$dir/basedir/bin/mysqld \
  --initialize-insecure \
  --user=_dbdb_mysql \
  --port=43306 \
  --socket=/tmp/dbdb_mysql_43306.sock \
  --basedir=$dir/basedir \
  --plugin-dir=$dir/basedir/lib/plugin  \
  --datadir=$dir/datadir/mysql5-name4 \
  --log-error=$dir/datadir/mysql5-name4/mysqld.err \
  --pid-file=$dir/datadir/mysql5-name4/mysql.pid

What's next?

Start multiple MySQL database server on local Mac
or just use dbdb.