Has anyone migrated a Vertica DB to a new storage area before?

Ben_HaworthBen_Haworth Registered User
We want to move our Vertica database which is currently stored on a VM to our SAN, but I can't appear to find any documentation about migrating a db from one storage area to another. I've followed up this with our account manager, and haven't had much luck finding documentation. The db server itself is to remain intact, it's just the data files we want to move. As I'm new to Vertica (and indeed have been out of the industry for a while so have rusty db admin skills), the only parallel I can draw from memory is that in SQL Server, you can unmount the db, move it, and then remount it. I can only presume there is something similar in Vertica, but can't find how to do this. Any help would be greatly appreciated. Thanks Ben

Comments

  • Sajan_SangraulaSajan_Sangraula Registered User
    Hi Ben, The following steps should help migrate your data to the new storage location: -> Add the new storage location to Vertica using the add_location function. Make sure you assign appropriate label to this storage location. -> For all the schema/ tables you want to migrate, create new schema/ tables and associate these tables to the new storage location using SET_OBJECT_STORAGE_POLICY. -> Use the MOVE_PARTITIONS_TO_TABLES function to move data from old tables to new tables. -> Retire the old storage using DROP_LOCATION once all the data has been moved. You can look for the functions I mentioned in the administrative guide, and may also find my notes on storage location @ http://bit.ly/13TlRL7 helpful. /Sajan
  • Ben_HaworthBen_Haworth Registered User
    Thank you Sajan, I shall take a look at this now.
  • Roman_KorobeiniRoman_Korobeini Registered User
    Hi Sajan.

    Could you let know if steps are the same for multi-node cluster?

    Thank you in advance
  • Daniel_LeybovicDaniel_Leybovic Registered User
    Yes, steps are same.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file