前言

在CentOS 7上編譯ClickHouse 24.8可能會遇到一些挑戰，主要是因為CentOS 7的默認軟件版本較舊。本文將詳細介紹從零開始構建ClickHouse 24.8的完整過程，包括依賴安裝和環境配置。

準備工作

首先確保系統已更新到最新版本：

yum update -y

1. 安裝CMake

ClickHouse需要CMake 3.1.7以上版本，我們安裝3.25.3：

wget --no-check-certificate https://cmake.org/files/v3.25/cmake-3.25.3-linux-x86_64.sh
mkdir /usr/local/cmake && ./cmake-3.25.3-linux-x86_64.sh --prefix=/usr/local/cmake --skip-license
ln -s /usr/local/cmake/bin/cmake /usr/local/bin/cmake
ln -s /usr/local/cmake/bin/cpack /usr/local/bin/cpack
ln -s /usr/local/cmake/bin/ctest /usr/local/bin/ctest

2. 安裝GCC 10

CentOS 7默認GCC 4.8太舊，需要升級到GCC 10：

# 配置阿里云鏡像源
sudo cp /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.bak
sudo curl -o /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo# 配置SCL源
yum install -y centos-release-scl
sed -i 's/mirrorlist/#mirrorlist/g' /etc/yum.repos.d/CentOS-SCLo-scl.repo
sed -i 's/mirrorlist/#mirrorlist/g' /etc/yum.repos.d/CentOS-SCLo-scl-rh.repo
sed -i 's|baseurl=http://mirror.centos.org/centos|baseurl=https://mirrors.aliyun.com/centos|g' /etc/yum.repos.d/CentOS-SCLo-scl*.repoyum clean all && yum makecache
yum install -y centos-release-scl
yum install -y devtoolset-10-gcc*# 啟用GCC 10
scl --list
scl enable devtoolset-10 bashecho "source /opt/rh/devtoolset-10/enable" >> ~/.bashrc
source ~/.bashrc
gcc --version

3. 安裝Python 3

wget --no-check-certificate https://www.python.org/ftp/python/3.8.19/Python-3.8.19.tgz
tar xvf Python-3.8.19.tgz
yum -y install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel gdbm-devel db4-devel libpcap-devel xz-develcd Python-3.8.19
./configure --enable-optimizations --prefix=/usr/local/python3
make -j$(nproc)
make installln -s /usr/local/python3/bin/python3.8 /usr/bin/python3

4. 安裝LLVM

使用LLVM來編譯ClickHouse，安裝18.1.8版本：

git clone --depth=1 --branch=llvmorg-18.1.8 https://github.com/llvm/llvm-project.git
cd llvm-project
mkdir build && cd buildcmake -G "Unix Makefiles" \
-DCMAKE_BUILD_TYPE=Release \
-DLLVM_ENABLE_PROJECTS="clang;lld" \
-DLLVM_TARGETS_TO_BUILD='X86' \
-DCMAKE_INSTALL_PREFIX=/usr/local/llvm-18.1.8 \
../llvm-project/llvmmake -j$(nproc)
make installecho 'export PATH=/usr/local/llvm-18.1.8/bin:$PATH' >> ~/.bashrc
echo 'export LD_LIBRARY_PATH=/usr/local/llvm-18.1.8/lib:$LD_LIBRARY_PATH' >> ~/.bashrc
source ~/.bashrcln -s /usr/local/llvm-18.1.8/bin/clang /usr/local/bin/clang
ln -s /usr/local/llvm-18.1.8/bin/clang++ /usr/local/bin/clang++

5. 安裝NASM和YASM

# 安裝NASM
wget --no-check-certificate http://www.nasm.us/pub/nasm/releasebuilds/2.16.03/nasm-2.16.03.tar.gz
tar zxvf nasm-2.16.03.tar.gz && cd nasm-2.16.03
./configure --prefix=/usr/local/nasm
make && make install
ln -s /usr/local/nasm/bin/nasm /usr/local/bin/nasm# 安裝YASM
wget --no-check-certificate http://www.tortall.net/projects/yasm/releases/yasm-1.3.0.tar.gz
tar -zxvf yasm-1.3.0.tar.gz && cd yasm-1.3.0
./configure --prefix=/usr/local/yasm
make && make install
ln -s /usr/local/yasm/bin/yasm /usr/local/bin/yasm

6. 編譯ClickHouse

git clone --branch=v24.8.14.39-lts --recurse-submodules https://github.com/ClickHouse/ClickHouse
cd ClickHouse
git checkout -b v24.8.14.39-lts origin/v24.8.14.39-lts
git submodule update --init --recursive# 解決可能出現的mariadb-connector-c問題
rm -rf contrib/mariadb-connector-c
git submodule update --init --force contrib/mariadb-connector-c# 設置編譯環境
export CC=/usr/local/bin/clang
export CXX=/usr/local/bin/clang++
yum install -y ccache# 編譯
mkdir build && cd build
cmake -DCMAKE_BUILD_TYPE=RelWithDebInfo \
-DCMAKE_C_COMPILER=$(which clang) \
-DCMAKE_CXX_COMPILER=$(which clang++) \
-DENABLE_TESTS=OFF \
-G Ninja ..ninja

7. 運行ClickHouse

編譯完成后，可以運行ClickHouse服務器：

./clickhouse-server --config-file=/path/to/config.xml --daemon

常見問題解決

1. mariadb-connector-c配置錯誤：

   rm -rf contrib/mariadb-connector-c
   git submodule update --init --force contrib/mariadb-connector-c

2. 內存不足：編譯過程需要大量內存，建議至少有16GB內存或設置交換空間。

3. 依賴缺失：如果編譯過程中提示缺少依賴，可以使用yum provides查找并安裝相應包。