Forum Stats

  • 3,782,248 Users
  • 2,254,622 Discussions


Reboot windows server in a cluster

LewisLL12257 Member Posts: 3
edited Nov 3, 2018 9:06AM 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.


  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 370 Employee
    edited Nov 3, 2018 9:06AM

    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.

    Dave Stokes

    MySQL Community Manager