Skip to main content

Moving Vertica to a fusion io card

  • September 17, 2013
  • 4 replies
  • 13 views
Alex_Braylyan
Hello After strugling with poor Vertica performance our comapny has decided to upgrade the drives that Vertica resides on. We have installed fussion io cards that have about 500MB/s read and 200MB/s write. So the question is how do we move Vertica from the old drives to the new ones? Does it require uninstall and reinstall? Or can we just point Vertica to the new drives and make the data files live there? Thanks in advance.

    4 replies

    Daniel_Leybovic
    Forum|alt.badge.img+1
    • Daniel_Leybovic
    • Participating Frequently
    • September 17, 2013
    Hi! Working With Storage Locations: https://my.vertica.com/docs/6.1.x/HTML/index.htm#12383.htm
    Alex_Braylyan
    • Alex_Braylyan
    • Author
    • New Participant
    • September 17, 2013
    Thank you
    Sharon_Cutter
    Forum|alt.badge.img
    • Sharon_Cutter
    • Participating Frequently
    • September 18, 2013
    Hi Alex - do you have a good understanding of the root cause of the performance issue? High i/o often means there are projection design or data model issues. Or you could just have complex queries that spill to disk. Fusion io will help performance, but worth making sure that there aren't design issues. --Sharon
    Alex_Braylyan
    • Alex_Braylyan
    • Author
    • New Participant
    • October 2, 2013
    Hi Sharon
    Our Vertica set up has many problems. First problem is the the lack of ram. We have a four node cluster and each box has 32GB of ram. We get spill over all the time. Second problem is when we ran vioprobe on our boxes the IO was under 100. So the plan was to go to fusion io but we finally decided to spend some money and buy some new boxes with ample ram and drive speed.

    Alex
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement