Skip to main content

Commit and Moveout

  • May 10, 2016
  • 4 replies
  • 21 views
NarayanV

Hi Team,

 

   Would like to know , whether COMMIT statment will invoke moveout process, so that the data in WOS (Memory) moves to ROS (Disk). Please explain.

    4 replies

    Gayatri_R
    Forum|alt.badge.img
    • Gayatri_R
    • Participating Frequently
    • May 10, 2016

    Hi,

     

    Issuing a COMMIT will not trigger a moveout. By default, TM Moveout runs every 300 seconds (this is governed by the configuration parameter 'MoveOutInterval'  - default is 300 seconds). Data will remain in WOS even after a  COMMIT until the next moveout run.

     

    Thanks

    Gayatri

    NarayanV
    • NarayanV
    • Author
    • Participating Frequently
    • May 10, 2016

    Hi,

     

       Thanks for getting back to me. So my understanding , is that there is slight possiblity of lossing the data even after commiting the data, like all nodes going down together in a cluster before the moveout happens.

     

        The real  safe point  as for us the data is concerned is that "The checkpoint epoch", which is the latest epoch for which there is no data in the WOS.  Please correct me , if my udnerstanding is wrong.

    eli_revach
    Forum|alt.badge.img+2
    • eli_revach
    • Participating Frequently
    • May 11, 2016
    Hi , Correct you still have a chance for data lost if all your nodes are failed (in case of clean showdown Vertica will make sure your WOS is clean before finish ) . The real safe point for you to recover is LGE ( last good epoch ) I hope you will find it useful Thanks
    NarayanV
    • NarayanV
    • Author
    • Participating Frequently
    • May 11, 2016

    Thanks, Now I am clear :) 

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement