766544 - mysql_rhel6 shouldn't have specific my.cnf files

Status: RESOLVED WONTFIX

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

Description

[Sheeri Cabral [:sheeri]]

We wanted to get rid of "specific" my.cnf files with the mysql_rhel6 package...

trunk/modules/mysql_rhel6/files/specific/engagement1.db.phx1.mozilla.com/my.cnf
trunk/modules/mysql_rhel6/files/specific/engagement2.db.phx1.mozilla.com/my.cnf
trunk/modules/mysql_rhel6/files/specific/internal1.db.phx1.mozilla.com/my.cnf
trunk/modules/mysql_rhel6/files/specific/internal2.db.phx1.mozilla.com/my.cnf

There's also:
trunk/modules/mysql_rhel6/templates/specific/internal1.db.phx1.mozilla.com/my.cnf

The 2nd thing wrong with this is that iirc, internal is a pg server, not a mysql server. :(

Jabba, let's work to figure out what exactly in engagement my.cnf files is different from the template, and parameterize what we need to (like we did with innodb_buffer_pool_size).

Comment 1

[Justin Dow [:jabba]]

Right, internal1/2 were mysql servers for a short period of time before we had to switch to postgres for confluence (don't remember the exact reasoning why - something about confluence required some weird settings with mysql to work right that I was advised against setting and atlassian recommended postgres as the DB that they actually test their code with)..

But yeah, for engagement, I think we should switch over to the mysql2 module so we just need to figure out what all it has in its my.cnf and make sure mysql2 supports that stuff.

Comment 2

[Dustin J. Mitchell [:dustin] (he/him)]

So this package is on the way out -- and in fact anything under modules/ needs to die soon anyway.  I think the fix here is to finish bug 717638.  Engagement already isn't using mysql_rhel6, so we could delete those files without much harm.

I'm game to just WONTFIX this, or dupe it to bug 717638, with plans to delete all that cruft once everything is on mysql2.

Comment 3

[Sheeri Cabral [:sheeri]]

WONTFIXing, assuming https://bugzilla.mozilla.org/show_bug.cgi?id=717638#c31 is the list of non-mysql2 puppet modules....

Comment 4

[Dustin J. Mitchell [:dustin] (he/him)]

dustin@euclid ~/code/moz/t/sysadmins-puppet [master*] $ git status
# On branch master
# Changes to be committed:
#   (use "git reset HEAD <file>..." to unstage)
#
#       deleted:    modules/mysql_rhel6/files/specific/engagement1.db.phx1.mozilla.com/my.cnf
#       deleted:    modules/mysql_rhel6/files/specific/engagement2.db.phx1.mozilla.com/slave.cnf
#       deleted:    modules/mysql_rhel6/files/specific/internal1.db.phx1.mozilla.com/my.cnf
#       deleted:    modules/mysql_rhel6/files/specific/internal2.db.phx1.mozilla.com/slave.cnf

if something breaks, we can just revert, but it should be fine.

Comment 5

[Sheeri Cabral [:sheeri]]

So far, nothing has broken...