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.

How to run Releem Agent manually

Releem Agent automatically collects metrics 2 times per day.

To run metrics collection manually just execute following command:
/bin/bash /opt/releem/mysqlconfigurer.sh

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 using Releem Agent

Steps to apply the Recommended configuration using Releem Agent.
To apply recommended configuration just run the following command:
/bin/bash /opt/releem/mysqlconfigurer.sh -a

How to rollback to the previous configuration using Releem Agent

Steps to rollback to previous configuration using Releem Agent.
Also, you can rollback to the previous configuration. To do that just run:
/bin/bash /opt/releem/mysqlconfigurer.sh -r

How to apply the Recommended Configuration Manually

Steps to apply the Recommended configuration manually. Use this instruction only in case you can't use Releem Agent options.
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

How to update Releem Agent

Steps to update Releem Agent
To update Releem Agent perform the following command:
    RELEEM_API_KEY=[your key] bash -c "$(curl -L https://releem.s3.amazonaws.com/install.sh)" -- -u​

    How to uninstall Releem Agent

    Steps to uninstall Releem Agent
    To uninstall Releem Agent from the server, you should perform the following step:
    1. Delete /opt/releem folder. To delete, run the following command:
      rm -r /opt/releem
    2. Edit crontab and remove commands containing 'releem'. To edit crontab, run the following command:
      crontab -e

    How to cancel Releem Subscription

    Releem is integrated with Paddle to automate subscriptions. You can cancel Releem subscription in Receipt Email you received from Paddle.