Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5295

Implement Graceful Restart in Startup script

    Details

    • Type: Improvement
    • Status: On Hold
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Packaging
    • Labels:
      None

      Description

      Many users are interested to restart MySQL with as little downtime as possible. Default start script only offers "restart" which can take 30min+ on large buffer pools with large amount of dirty buffers.

      We should implement the "graceful" restart mode in the script and possibly in server which would focus on restart while minimizing downtime and existing transactions.

      The process probably should be agressively flushing buffer pool (reducing throughput if needed) and when later waiting for some time to ensure there are no active transactions to go down. There should be some timeout waiting for no active transactions before we go to restart.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                evgeniy.patlan Evgeniy Patlan
                Reporter:
                pz Peter Zaitsev
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 2 minutes
                  2m