Shulou(Shulou.com)06/01 Report--

/ etc/my.cnf

Read_only=on

Add launch item-- relay-log-purge=off

/ etc/systemd/system/mysql.service

# Simple MySQL systemd service file

#

# systemd supports lots of fancy features, look here (and linked docs) for a full list:

# http://www.freedesktop.org/software/systemd/man/systemd.exec.html

#

# Note: this file (/ usr/lib/systemd/system/mysql.service)

# will be overwritten on package upgrade, please copy the file to

#

# / etc/systemd/system/mysql.service

#

# to make needed changes.

#

# systemd-delta can be used to check differences between the two mysql.service files.

#

[Unit]

Description=MySQL Community Server

After=network.target

After=syslog.target

[Install]

WantedBy=multi-user.target

Alias=mysql.service

[Service]

User=mysql

Group=mysql

# Execute pre and post scripts as root

PermissionsStartOnly=true

# Needed to create system tables etc.

# ExecStartPre=/usr/bin/mysql-systemd-start pre

# Start main service

ExecStart=/usr/local/mysql/bin/mysqld_safe-relay-log-purge=0

# Don't signal startup success before a ping works

# ExecStartPost=/usr/bin/mysql-systemd-start post

# Give up if ping don't get an answer

TimeoutSec=600

Restart=always

PrivateTmp=false

Do not clean up automatically relay log cleans up as a job

Call the mha_node tool purge_relay_logs during cleanup

Cat purge_relay_log.sh

#! / bin/bash

User=root

Passwd=123456

Port=3306

Log_dir='/data/masterha/log'

Work_dir='/data'

Purge='/usr/local/bin/purge_relay_logs'

If [!-d $log_dir]

Then

Mkdir $log_dir-p

Fi

$purge-user=$user-- password=$passwd-- disable_relay_log_purge-- port=$port-- workdir=$work_dir > > $log_dir/purge_relay_logs.log 2 > & 1

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.