741092 - Set up new devmo cluster with Percona 5.5 and get replication going between them.

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Sheeri Cabral [:sheeri]]

developer1.db.scl3.mozilla.com
developer2.db.scl3.mozilla.com

Comment 1

[Sheeri Cabral [:sheeri]]

Put into puppet as a percona55 server.

Comment 2

[Sheeri Cabral [:sheeri]]

Doing by hand because devmo is critical, not waiting for puppet:

yum install Percona-Server-server-55 Percona-Server-shared-compat Percona-Server-client-55 percona-toolkit perl-DBD-mysql

Comment 3

[Sheeri Cabral [:sheeri]]

Looks like puppet already ran, and we have the appropriate /etc/my.cnf files in place already.

Comment 4

[Sheeri Cabral [:sheeri]]

Had to do install the packages (as above) and do:

 mkdir /var/log/mysql; chown -R mysql:mysql /var/log/mysql

And MySQL is running. I am running puppet again to see if the MySQL grants for the nagiosdaemon will be put into place properly by puppet.

Comment 5

[Sheeri Cabral [:sheeri]]

Nagios grants were not put in, and read_only is incorrect for developer2 even though it's correct as "master=>false" in databases.pp.

Comment 6

[Sheeri Cabral [:sheeri]]

I've added nagios grants, hopefully the checks will clear up, and then this ticket is finished, other than making a related ticket for jabba about puppet.

Comment 7

[Sheeri Cabral [:sheeri]]

I also made a root password and a .my.cnf file, in addition to the replication user and password. These passwords are in dbpasswords.txt.gpg.

Comment 8

[Sheeri Cabral [:sheeri]]

Jabba fixed puppet yesterday, and things look good.