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

Implement Graceful Restart in Startup script

    XMLWordPrintable

    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