MySQL 5.7 upgrade

Hi @team,

Finally, we’re upgrading our shared MySQL to 5.7 and this is going to happen in the next sprint (254).

We’ve already set up a new MySQL 5.7 instance, that replicates, and we’re going to move the fallback IP address to the new server. So, in theory, there will be no downtime. Check this message for details, code and host variables of a new server and this discovery document for an abstract plan.

Briefly, I’m going to:

  1. Wait till the end of this week for any possible concerns.
  2. Email clients.
  3. Move the fallback IP address.
  4. Rebuild replicas.
  5. Test backup restoration.

Do you have any concerns or suggestions?

Use BB-4049 to log time spent reading and replying to this post.


Yay! Hurray for HA setups :slight_smile:
Thank you for your careful planning and for getting this upgrade done!

Thanks for planning to test backup restoration, that’s very critical for us!

That’s great news @demid, thanks for taking care of this upgrade!

Just to confirm: This step will include standardizing disk space for /var/lib/mysql across cluster nodes, right?

(For context, we were originally planning to do this as part of FAL-1995, but ended up concluding that it would make more sense to take care of it as part of the MySQL upgrade; ref, ref.)

I’m asking because disk space usage on mysql-im-2-slave1 has increased quite a bit since the completion of FAL-1995. It’s at 86% currently, despite some intermediate actions that were taken a few weeks back (cf. this thread). So we’ll need to increase disk space for /var/lib/mysql on slave1 to match slave2 soon-ish, to avoid running out of disk space.

1 Like

@tikr, new master node already has the same disk size as mysql-im-2-slave2 and /var/lib/mysql is 420G.

For mysql-im-2-slave1, yes, I was going to purchase a new dedicated server and create a partition of the same size.

1 Like

@demid OK great :slight_smile: :+1:

Update here:

Unfortunately, due to new client onboarding and capacity limitation, we’ve had to postpone upgrading one more sprint.