Improve manual build instructions for centos7 (maybe add pre-built docker images)

[anton-povarov]

Here's the HOWTO from Alexey Medov building on centos7 + mariadb 10.2 A nice starting point.

Добавляем репозиторий нужной версии MariaDB по инструкции по ссылке https://downloads.mariadb.org/mariadb/repositories/#mirror=mephi&distro=CentOS&distro_release=centos7-amd64--centos7&version=10.2

На тот случай если ссылка не работает, нужно создать файл /etc/yum.repos.d/MariaDB.repo и прописать в него следующий текст:

MariaDB 10.2 CentOS repository list - created 2019-03-06 07:50 UTC

http://downloads.mariadb.org/mariadb/repositories/

[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.2/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1

Потом выполняем: sudo rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB yum clean metadata yum install MariaDB-backup MariaDB-client MariaDB-common MariaDB-compat MariaDB-server MariaDB-shared mysql --version

==========================================================================

yum install autoconf automake cmake make git libtool ncurses-devel openssl-devel yum install centos-release-scl yum install devtoolset-6-gcc* scl enable devtoolset-6 bash which gcc gcc --version yum install git -y mkdir /_install mkdir /build_folder cd /build_folder/

git clone https://github.com/anton-povarov/meow.git git clone https://github.com/badoo/pinba2.git git clone https://github.com/nanomsg/nanomsg.git wget https://dl.bintray.com/boostorg/release/1.69.0/source/boost_1_69_0_rc1.tar.gz tar -xzf boost_1_69_0_rc1.tar.gz rm -rf boost_1_69_0_rc1.tar.gz

Качаем нужную версию исходников MariaDB с официального сайта https://downloads.mariadb.org/mariadb/10.2.22/ wget http://mirror.mephi.ru/mariadb//mariadb-10.2.22/source/mariadb-10.2.22.tar.gz tar -xzf mariadb-10.2.22.tar.gz rm -rf mariadb-10.2.22.tar.gz cd mariadb-10.2.22 yum-builddep mariadb-server yum install bison libxml2-devel libevent-devel rpm-build scl enable devtoolset-6 bash ; rm -rf CMakeCache.txt ; make clean ; cmake -DRPM=centos7 . ; make -j 6

cd ../nanomsg cmake -DNN_STATIC_LIB=ON -DNN_ENABLE_DOC=OFF -NN_MAX_SOCKETS=4096 -DCMAKE_C_FLAGS="-fPIC -DPIC" -DCMAKE_INSTALL_PREFIX=/_install/nanomsg -DCMAKE_INSTALL_LIBDIR=lib . make ; make install

cd ../pinba2 ./buildconf.sh ./configure --prefix=/_install/pinba2 --with-mysql=/build_folder/mariadb-10.2.22/ --with-nanomsg=/_install/nanomsg --with-meow=/build_folder/meow/ --with-boost=/build_folder/boost_1_69_0 --enable-libmysqlservices systemctl start mariadb && systemctl enable mariadb && systemctl status mariadb yum install mariadb-devel mysql_secure_installation

Далее добавляем в файл /etc/my.cnf.d/server.conf в секцию [mysqld] строку: plugin_maturity=unknown service mysqld restart && service mariadb restart cp mysql_engine/.libs/libpinba_engine2.so mysql_config --plugindir semanage permissive -a mysqld_t echo "install plugin PINBA soname 'libpinba_engine2.so';" | mysql -uroot -p echo "create database pinba;" | mysql -uroot -p cat scripts/default_reports.sql | mysql -uroot -p cat scripts/default_tables/active.sql | mysql -uroot -p cat scripts/default_tables/info.sql | mysql -uroot -p cat scripts/default_tables/stats.sql | mysql -uroot -p

[GhOsTMZ]

Some improvements for decreasing a compilation time. MySQL can be built without a server binary. For example:

cmake -DWITH_BOOST=boost_1_59_0 -DWITHOUT_SERVER=1 && make

This checked on percona server.

And I don't understand why you installed nanomsg. You using static linking and nanomsg installing it is not necessary.

I can upload my ugly rpmspec-file if you want. This can be a good starting point for a building pinba engine.

[anton-povarov]

Nice tip, thanks. rpmspec is also welcome of course.

[GhOsTMZ]

https://github.com/badoo/pinba2/files/3886244/pinba-engine.txt

rpmspec checked on centos 7 and percona server 5.7. devtoolset-7 required but not listed in BuildRequires. mysql-devel needed only for mysql_config utility for determine mysql plugin directory.

[anton-povarov]

Thanks for the spec! At a brief glance, i think macro.patch file is referenced but missing from the upload?

[GhOsTMZ]

I can give a macro.patch. But it's a ugly hack for building from sources got by not a git clone command. If you getting sources by git clone you can exclude this patch.

diff -ru pinba2-2.5.0/mysql_engine/plugin.cpp pinba2-2.5.0.new/mysql_engine/plugin.cpp
--- pinba2-2.5.0/mysql_engine/plugin.cpp        2019-04-24 17:34:00.000000000 +0300
+++ pinba2-2.5.0.new/mysql_engine/plugin.cpp    2019-11-21 12:21:52.439922930 +0300
@@ -154,8 +154,8 @@

        // version and build info
        snprintf(vars->version_info, sizeof(vars->version_info),
-               "%s %s, git: %s, branch: %s, modified: %s",
-               PINBA_PACKAGE_NAME, PINBA_VERSION, PINBA_VCS_FULL_HASH, PINBA_VCS_BRANCH, PINBA_VCS_WC_MODIFIED);
+               "%s %s",
+               PINBA_PACKAGE_NAME, PINBA_VERSION);

        snprintf(vars->build_string, sizeof(vars->build_string), "%s", PINBA_BUILD_STRING);

@@ -262,7 +262,7 @@
                return std::make_shared<mysql_logger_t>(stderr, log_level);
        }();

-       LOG_NOTICE(logger, "version {0}, git: {1}, build: {2}", PINBA_VERSION, PINBA_VCS_FULL_HASH, PINBA_BUILD_STRING);
+       LOG_NOTICE(logger, "version {0}, build: {1}", PINBA_VERSION, PINBA_BUILD_STRING);

        try
        {