Closed Bug 741097 Opened 12 years ago Closed 12 years ago

Set up new getpersonas cluster with Percona 5.5 and get replication going between them.

Categories

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

Product:
Data & BI Services Team
Component:
DB: MySQL
Platform:
x86
macOS
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: scabral, Assigned: scabral)

References

Details

getpersonas1.db.scl3.mozilla.com
getpersonas2.db.scl3.mozilla.com
Put into puppet as a percona55 server.
Assignee: server-ops-database → scabral
Had do to stuff puppet should have done (in  order):
yum install Percona-Server-server-55 Percona-Server-shared-compat Percona-Server-client-55 percona-toolkit perl-DBD-mysql

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

put in grants for nagiosdaemon

--------

Manual stuff I did:
start mysql
delete all users except root@localhost
set root password
create a /root/.my.cnf
set replication password
set nagios grants
set replication going

The read_only setting is wrong for getpersonas2, despite having master=>false set appropriately.
Status: NEW → ASSIGNED
Done! jabba fixed the puppet issues yesterday.
Status: ASSIGNED → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.