CExpert, or Connection Expert is a simple library that allows checking MySQL bases health.
It consists of two parts - daemon and client library. CExpert daemon is a light process, which periodically checks mysql's health and report it to all clients interested. Communication between processes is implemented using POSIX shared memory - so, reading health status is simply checking one memory byte.
Compiling
At first, download latest version of cexpert to working directory. We need to extract it and prepare for building. Open a terminal in the source directory and type the following commands:
ls .
tar -zxvf cexpert-0.8.tar.gz
ls -al
cd cexpert-0.8
mkdir build
cd build
It's time to run standard building procedure:
../configure
make && make check
If everything is ok, you should see something like that:
...........
make check-TESTS
make[2]: Entering directory `/home/moriarty/work/ce/cexpert-0.8/build/tests'
shmem check: 0.1.2.3.4.5.6
shmem check: 0.1.2.3.4.5.6
DBChecker check 0
DBChecker check 1
DBChecker check 2
DBChecker check 3
DBChecker check 4
PASS: test_server
start client test
initiated, check now
PASS: test_cexpert_lib
==================
All 2 tests passed
==================
............
Now, run sudo make install, which places libraries and headers to right places.
Product's homepage