Forum Stats

  • 3,733,007 Users
  • 2,246,671 Discussions
  • 7,856,463 Comments

Discussions

Reboot windows server in a cluster

LewisLL12257
LewisLL12257 Member Posts: 3
edited November 2018 in MySQL Community Space

Can we just schedule a reboot for both the source and replicate, as a scheduled task at the same time vs the manual steps to do that?

It seems that we do this on a monthly basis on windows and need to reboot the servers.

Manually we stop the mem agent, backups and then the instances of mysql.

On the source we stop the mem agent, backups, full and binlog and the instance of mysql, then bounce the box.

Verify the everything is back online with the source then bounce the replicate server and ensure that mysql is back online, then start the slave process within the replicate instance.

Just trying to cut down on unnecessary administrative tasks if there is a more efficient method to do this, programmatically.

Answers

  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 350 Employee
    edited November 2018

    There are several tools to do reboots for the Windows platforms but I do not know any of them well enough to make a recommendation.  On the Linux side you can go months/years without reboots so I am wondering why the systems here need such frequent reboots.

Sign In or Register to comment.