Installation and Details of MySQL Pinba storage engine

Pinba accumulates data in a set of read-only MySQL tables, consisting of two types:

1) Raw data tables: These tables are used to generate custom reports. Accessing raw data is relatively slow if there are a large number of records with no index except for primary keys.

2) Reports: These are already aggregated data that updates on-the-fly as new request data arrives.

The Pinba working stack comprises two parts: the Pinba engine and the PHP extension. The Pinba Engine acts as a pluggable storage engine for MySQL or MariaDB, while clients such as the PHP Pinba Extension and the Nginx Pinba Module feed data into it. The engine itself provides access to reports and raw data. There is a GUI available called “Pinboard”.

Advantages

1) Powerful
2) Provides live metrics in production with no impact on performance
3) Helps detect bottlenecks
4) Used to find bugs (e.g., excessive backend usage in certain routes)
5) Enables the creation of graphs and integration with alerting systems to detect regressions after a release.

 

Installing Pinba Server on CentOS

1) Download the package

   # wget http://pinba.org/files/pinba_engine-1.1.0.tar.gz

2) Extract the files

   # tar xzvf pinba_engine-1.1.0.tar.gz

3) Change to the directory

    # cd pinba_engine-1.1.0

4) Install the required dependencies

   # yum install Judy.x86_64 protobuf.x86_64 libevent.x86_64 Judy-devel.x86_64 protobuf-devel.x86_64 libevent-devel.x86_64

5) Download the source code of the corresponding MySQL version from the official site (to check the version, use “mysql -V”)

   # wget http://downloads.mysql.com/archives/get/file/mysql-5.5.44.tar.gz

# tar xzvf mysql-5.5.44.tar.gz

# cd mysql-5.5.44

6) Install pinba_engine and return to the pinba-engine source folder

   # ./configure –with-mysql =. / mysql-5.5.44 –with-judy = / usr –with-protobuf = / usr –libdir = / usr / lib64 / mysql / plugin /

7) Use the make commands

  # make

# make install

9) Create a database

   mysql -u root -p

mysql> INSTALL PLUGIN pinba SONAME ‘libpinba_engine.so’;

mysql> CREATE DATABASE pinba;

mysql> exit;

mysql -D pinba <default_tables.sql

10) Add pinba-server to /etc/my.cnf

   pinba_port = 3300

pinba_stats_gathering_period = 10000

pinba_stats_history = 900

pinba_temp_pool_size = 10000

pinba_request_pool_size = 1000000

11) Restart mysqld

   # service mysqld restart

If you require further assistance, please contact our support department.