RELEEM HELP CENTER

Documentation

Installation and Usage

Installation

Releem Agent Installation
Use this instruction to install Releem Agent on every database server. Releem Agent will automatically collect metrics and recommend configuration.

1. Create ~/.my.cnf file with the following content:
[client] 
user=root
password=[your password]
2. Run our easy one-step install:
RELEEM_MYSQL_MEMORY_LIMIT=0 RELEEM_API_KEY=[Key] RELEEM_CRON_ENABLE=1 
bash -c "$(curl -L https://releem.s3.amazonaws.com/install.sh)"
After this step Releem will periodically collect metrics and recommend performance-optimized configuration taillored for this server.

Current MySQL Performance Score of your servers you can see on Metrics page.

Use this instruction to install Releem Agent on every database server.

When to apply the Recommended Configuration

Releem recommends the best performance optimized MySQL configuration at this time.

You can apply Recommended Configuration in case of MySQL Performance Score of your server goes down.

How to apply the Recommended Configuration

Steps to apply the Recommended configuration manually
Releem Agent automatically stores Recommended Configuration at
/tmp/.mysqlconfigurer/z_aiops_mysql.cnf

To apply Recommended Configuration perform the following steps:
1. Copy Recommended Configuration to MySQL configuration folder:
cp /tmp/.mysqlconfigurer/z_aiops_mysql.cnf /etc/mysql/conf.d/ 
In CentOS instead /etc/mysql/conf.d you should use /etc/my.cnf.d/ folder.

2. Restart MySQL to apply configuration:
service mysqld restart
In case of change 'innodb_log_file_size' only in MySQL 5.6.7 or earlier perform the following commands:
mysql -e"SET GLOBAL innodb_fast_shutdown = 1" 
service mysql stop
mv /var/lib/mysql/ib_logfile[01] /tmp
service mysql start