Building MySQL 8.0.x

Building MySQL 8.0.x

Below versions of MySQL are available in respective distributions at the time creation of these build instructions:

• RHEL (8.8, 8.10, 9.2, 9.4, 9.5) have 8.0.36
• Ubuntu (20.04, 22.04, 24.04) have 8.0.40

The instructions provided below specify the steps to build MySQL version 8.0.40 on Linux on IBM Z for the following distributions:

• RHEL (8.8, 8.10, 9.2, 9.4, 9.5)
• SLES 15 SP6

General Notes:

• When following the steps below please use a standard permission user unless otherwise specified.
• A directory /<source_root>/ will be referred to in these instructions, this is a temporary writable directory anywhere you'd like to place it.

Build MySQL

1. Build using script

If you want to build MySQL using manual steps, go to Step 2. Use the following commands to build MySQL using the build script. Please make sure you have wget installed.

wget -q https://raw.githubusercontent.com/linux-on-ibm-z/scripts/master/MySQL/8.0.40/build_mysql.sh
# Build MySQL
bash build_mysql.sh   [Provide -t option for executing build with tests]

If the build completes successfully, go to STEP 4. In case of error, check logs for more details or go to STEP 2 to follow manual build steps.

2. Install the dependencies

export SOURCE_ROOT=/<source_root>/
export PATCH_URL=https://raw.githubusercontent.com/linux-on-ibm-z/scripts/master/MySQL/8.0.40/patch

2.1. Install the required dependencies

• RHEL (8.8, 8.10)

  sudo yum install -y curl wget bison bzip2 gcc gcc-c++ git hostname ncurses-devel openssl openssl-devel pkgconfig tar procps zlib-devel doxygen cmake diffutils rpcgen make libtirpc-devel libarchive gcc-toolset-12-gcc gcc-toolset-12-gcc-c++ gcc-toolset-12-binutils net-tools
  sudo yum install -y xz python2 python2-pyyaml     # For Duktape
  source /opt/rh/gcc-toolset-12/enable

• RHEL (9.2, 9.4, 9.5)

  sudo yum install -y --allowerasing curl
  sudo yum install -y wget bison bzip2 bzip2-devel gcc gcc-c++ git xz xz-devel hostname ncurses ncurses-devel openssl procps openssl-devel pkgconfig tar wget zlib-devel doxygen cmake diffutils rpcgen make libtirpc-devel libarchive tk-devel gdb gdbm-devel sqlite-devel readline-devel libdb-devel libffi-devel libuuid-devel libnsl2-devel net-tools gcc-toolset-12-gcc gcc-toolset-12-gcc-c++ gcc-toolset-12-binutils
  source /opt/rh/gcc-toolset-12/enable

• SLES 15 SP6

  sudo zypper install -y curl make cmake bison gcc14 gcc14-c++ git hostname ncurses-devel openssl procps openssl-devel pkg-config gawk doxygen libtirpc-devel rpcgen tar wget net-tools-deprecated xz timezone
  sudo update-alternatives --install /usr/bin/cc cc /usr/bin/gcc-14 14
  sudo update-alternatives --install /usr/bin/gcc gcc /usr/bin/gcc-14 14
  sudo update-alternatives --install /usr/bin/g++ g++ /usr/bin/g++-14 14
  sudo update-alternatives --install /usr/bin/c++ c++ /usr/bin/g++-14 14
  sudo ln -sf /usr/bin/gcc /usr/bin/s390x-linux-gnu-gcc
  sudo ln -sf /usr/bin/cpp-14 /usr/bin/cpp
  

2.2. Install the additional dependencies

• Build Python 2.7.18 (Only on RHEL 9.x and SLES 15 SP6)

    cd $SOURCE_ROOT
    wget https://www.python.org/ftp/python/2.7.18/Python-2.7.18.tar.xz
    tar -xvf Python-2.7.18.tar.xz
    cd $SOURCE_ROOT/Python-2.7.18
    ./configure --prefix=/usr/local --exec-prefix=/usr/local
    make
    sudo make install
    sudo ln -sf /usr/local/bin/python /usr/bin/python2
    python2 -V
    # Install pip
    curl https://bootstrap.pypa.io/pip/2.7/get-pip.py --output get-pip.py 
    sudo python2 get-pip.py
    # Install PyYAML for Duktape
    python2 -m pip install --upgrade pip setuptools --force-reinstall
    python2 -m pip install PyYAML==3.13
  

• Build Duktape

  cd $SOURCE_ROOT
  wget https://duktape.org/duktape-2.7.0.tar.xz
  tar xfJ duktape-2.7.0.tar.xz
  cd duktape-2.7.0
  # Add s390x related code changes
  sed -i '/\/* Durango (Xbox One)/i \/* s390x *\/\n#if defined(__s390x__)\n#define DUK_F_S390X \n#endif' src/duk_config.h
  sed -i '/#elif defined(DUK_F_SPARC32)/i #elif defined(DUK_F_S390X)\n\/* --- s390x --- *\/\n#define DUK_USE_ARCH_STRING "s390x"\n#define DUK_USE_BYTEORDER 3\n#undef DUK_USE_PACKED_TVAL\n#define DUK_F_PACKED_TVAL_PROVIDED'  src/duk_config.h 
  sed -i 's/duk_memcpy_unsafe((void \*) p, (const void \*) ins, (size_t) (ins_end - ins));/duk_memcpy_unsafe((void *) p, (const void *) ins, (size_t) (ins_end - ins) * 4);/' src-input/duk_api_bytecode.c 
  sed -i 's/p += (size_t) (ins_end - ins);/p += (size_t) (ins_end - ins) * 4;/' src-input/duk_api_bytecode.c
  python2 tools/configure.py --output-directory src-duktape
  

3. Product Build - MySQL

3.1. Download the MySQL source code

cd $SOURCE_ROOT
git clone -b mysql-8.0.40 https://github.com/mysql/mysql-server.git
cd mysql-server
curl -sSL "${PATCH_URL}/NdbHW.patch" | git apply -
curl -sSL "${PATCH_URL}/router-test.patch" | git apply -
curl -sSL "${PATCH_URL}/ut0rnd.patch" | git apply -
# Copy Duktape files
rm $SOURCE_ROOT/mysql-server/extra/duktape/duktape-2.7.0/src/*
cp $SOURCE_ROOT/duktape-2.7.0/src-duktape/* $SOURCE_ROOT/mysql-server/extra/duktape/duktape-2.7.0/src/
mkdir build
cd build

3.2. Configure, Build and Install MySQL

• RHEL (8.x, 9.x), SLES (15 SP6)

  cmake .. -DDOWNLOAD_BOOST=1 -DWITH_BOOST=. -DWITH_SSL=system
  make -j $(nproc)
  sudo make install
  

  Note: For more MySQL source configuration options, please visit their official guide.

3.3. Run unit tests (Optional)

• Use the below command to run the whole test suite:

cd $SOURCE_ROOT/mysql-server/build
export LD_PRELOAD=$SOURCE_ROOT/mysql-server/build/library_output_directory/libprotobuf-lite.so.24.4.0:$LD_PRELOAD   # To fix routertest test failures
make test

• Use the below command to run an individual test case (for example routertest_component_routing_splicer):

ctest -VV -R routertest_component_routing_splicer

Note:

• Below test cases might fail if IPv6 is not enabled:
  • NdbGetInAddr-t
  • routertest_harness_net_ts_internet
  • routertest_component_http_server

4. Post installation Setup and Testing (Optional)

Refer to this guide for the Postinstallation Setup and Testing overview.

References:

• https://dev.mysql.com/doc/refman/8.0/en/ - MySQL 8.0 Reference Manual
• https://dev.mysql.com/doc/refman/8.0/en/source-installation.html - Installing MySQL from Source