786734 - Upgrade MySQL on bugzilla1/2.stage.db.scl3.mozilla.com to Maria DB 5.5

Status: RESOLVED FIXED

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

Description

[Shyam Mani [:fox2mike]]

This DB is currently being used by bugzilla-stage and bugzilla-stage-tip, we should upgrade this to 5.5 in preparation of Bugzilla moving to RHEL 6/4.2 and SCL3.

We should co-ordinate with the Bugzilla Devs for this.

Comment 1

[Shyam Mani [:fox2mike]]

glob/dkl - r?

Basically, we're already running RHEL 6.x on these DB servers. We will upgrade the MySQL version on this to MariaDB 5.5 as we prepare to move Bugzilla prod to SCL3 + 4.2

Comment 2

[David Lawrence [:dkl]]

What is the diff with Percona and MariaDB?
and why are we moving to the latter if we just upgraded to the former in production?

dave "not a db expert" lawrence

Comment 3

[Shyam Mani [:fox2mike]]

I'll let sheeri answer the why (now that you've asked, I'm curious too but have no clue :p), but Percona is only the current prod. The new prod in SCL3 will be Maria too (so everything will be in sync).

Comment 4

[Sheeri Cabral [:sheeri]]

Percona is not backwards-compatible with Oracle's MySQL, but MariaDB is. Plus MariaDB is in general a better community steward (though not perfect) - not just politically, but they send their patches back to Oracle for inclusion, Percona does not.

Also, Percona's build is a patch set - they take the Google/Facebook patches and their InnoDB storage engine. It's not a full-fledged fork. MariaDB is. So if in some alternate dimension, Oracle ever did kill off MySQL, MariaDB would be the software to use.

I was on the fence about MariaDB when I started the upgrade months ago, but as I learned more about MariaDB and Percona, I thought MariaDB was the best way to go.

BTW, the reason we're not going with Oracle's MySQL build is that both the Percona and MariaDB builds add extra features.

Now, with MariaDB changing their numbering around - http://blog.mariadb.org/explanation-on-mariadb-10-0/ - and basically saying they have too many new features, we may switch back to Oracle for MySQL 5.6. I always want to be able to have the choice to migrate to other software if needed.

But for now, the priority is to get off MySQL 5.0 :D

Comment 5

[Sheeri Cabral [:sheeri]]

is "bugzilla1/2.db.scl3.mozilla.com" accurate or are we talking about a stage cluster here?

Comment 6

[Shyam Mani [:fox2mike]]

My bad, this is for stage. Updated the subject. Please get a go ahead from the Bugzilla devs before we do this. Thanks for clarifying sheeri!

Comment 7

[Shyam Mani [:fox2mike]]

To double confirm :

This bug is for bugzilla1.stage.db.scl3.mozilla.com and bugzilla2.stage.db.scl3.mozilla.com

Comment 8

[David Lawrence [:dkl]]

Sunday evening, monday morning glob time, is fine with me. We will need the staging environment for production push tonight/tomorrow so this week is not good.

dkl

Comment 9

[:glob ✱]

(In reply to David Lawrence [:dkl] from comment #8)
> Sunday evening, monday morning glob time, is fine with me. We will need the
> staging environment for production push tonight/tomorrow so this week is not
> good.

+1, although i won't be online monday morning (or any morning).

Comment 10

[Sheeri Cabral [:sheeri]]

So, is Monday morning Sheeri time (Eastern US time, GMT-4 right now) OK?

Comment 11

[David Lawrence [:dkl]]

(In reply to Sheeri Cabral [:sheeri] from comment #10)
> So, is Monday morning Sheeri time (Eastern US time, GMT-4 right now) OK?

Yes

Comment 12

[Sheeri Cabral [:sheeri]]

bugzilla2 upgraded to MariaDB 5.5

Comment 13

[Sheeri Cabral [:sheeri]]

bugzilla1 has been upgraded.

Will take off downtimes and put load balancer back to the way it was.

Comment 14

[Sheeri Cabral [:sheeri]]

Nagios downtimes are off and the load balancer is back to the way it was, but I need to open a bug to check replication on these servers.

Comment 15

[Sheeri Cabral [:sheeri]]

Resolving, I have made bug 790375 for this.