Trove mysql5.6 mirroring based on CENTOS7

Source: Internet
Author: User
Tags gpg percona virtualenv aliyun

This document is a trove image of the manual authoring mysql5.6

OpenStack version is Newton

1. Create the underlying virtual machine

Login OpenStack to create a virtual machine, this virtual machine is used to make trove image, the root disk of the virtual machine will eventually be uploaded to the glance for trove use, the root disk capacity of the virtual machine is set according to the needs, here to skip the detailed operation of this step.

The following actions are logged on to this virtual machine

2. Configure SSH

Cat/etc/ssh/sshd_configusedns No

3. Add MySQL Source

Yum Install Http:// Remove Mariadb-libs

4. Edit/etc/yum.repos.d/mysql-community.repo disable mysql5.7, enable mysql5.6

# Enable to use MySQL 5.6[mysql56-community]name=mysql 5.6 Community serverbaseurl= mysql-5.6-community/el/7/$basearch/enabled=1gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/rpm-gpg-key-mysql[ Mysql57-community]name=mysql 5.7 Community serverbaseurl=$ Basearch/enabled=0gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/rpm-gpg-key-mysql

5, Installation mysql5.6

Yum Install Mysql-community-server

6. Configure MySQL
6.1, edit/etc/my.cnf, add the following line at the end of the file, include this line has a row of blank

...! includedir/etc/mysql/conf.d/

6.2. Create a directory


7, Installation Percona-xtrabackup

Innobackupexyum Install Percona-release-0.1-4.noarch.rpmyum Install percona-xtrabackup-24

8. Source code Installation Trove-agent
8.1. Install related software packages

Yum Install git python-virtualenv

8.2. Create user

Useradd-m trove# Set trove sudocat/etc/sudoers.d/trove defaults:trove!requirettytrove all= (All) NOPASSWD:ALL

8.3. Download trove Source code

Su-trovegit Clone Https://

8.4. Integration Code
Due to the bug:1649592 when backing up on CentOS, the master branch has been consolidated, and commits need to be integrated into the Stable/newton branch

Commit c1fd3e3a4c643dba524656c8d53d3506233beaf3merge:880c707 f5d1caeauthor:jenkins <[email protected]>Date: Thu Jan 16:07:48 +0000 Merge "Fix backup of MySQL variants on Centos" ... commit f5d1caea889f85196dfc1efe4892560f 0b145191author:doug Shelley <[email protected]> 2016-01-20 04:22:03committer:doug Shelley <[email protected]& Gt 2016-12-14 00:29:41

8.5. Integrated Submission

git config--global "youre mail" git config--global "yuoure name" git checkout stable/newtongit cherr Y-pick F5d1cae

8.6, installation trove
8.6.1, installation trove

Yum install GCCCD ~virtualenv vensource ven/bin/activatepip install pip--upgradecd trovepip install-r requirements.txt --index-url mirrors.aliyun.compython Install

8.6.2, creating a startup file

mkdir -p /etc/trove/conf.dchown -r trove:trove /etc/trovemkdir -p /var/lib/ trovechown -r trove:trove /var/lib/trovemkdir -p /var/log/trovechown -r  trove:trove /var/log/trove#  If trove-guestagent.conf,guest_info.conf is not pre-created,#  and set/etc/ Trove owner is trove, after creating instance,#  the two files injected by Nova will have root privileges #  file pre-existing,nova  injected files do not change the file's user and group, Will change the file's read and Write permissions Touch /etc/trove/conf.d/trove-guestagent.conftouch /etc/trove/conf.d/guest_info.confchown  -r trove:trove /etc/trovecat /usr/lib/systemd/system/trove-guestagent.service[unit] Description=openstack trove guestagent[service] type=simpleuser=troveexecstart=/home/trove/ven/bin/trove-guestagent --config-file /etc/trove/conf.d/ Trove-guestagent.conf --config-file /etc/trove/conf.d/guest_info.confrestart=on-failure[install] Wantedby=multi-user.targetsystemctl daEmon-reloadsystemctl enable trove-guestagent 

9. Upload Image
9.1. Cleaning system


9.2. Create a snapshot of the image
10, configuration trove use made good image

Trove-manage--config-file/etc/trove/trove.conf datastore_version_update mysql mysql-5.6 mysql 0eb9 9bad-ad41-420c-bab5-844d84421c23 ' 1

This article is from the "Wuling Grassland" blog, please make sure to keep this source

Trove mysql5.6 mirroring based on CENTOS7

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.