Skip to content

Instantly share code, notes, and snippets.

@danicuki

danicuki/columnstore-remove.sh

Created May 30, 2017 14:06
Show Gist options
  • Save danicuki/b1214d5a003754d95c1489a99487d892 to your computer and use it in GitHub Desktop.
Save danicuki/b1214d5a003754d95c1489a99487d892 to your computer and use it in GitHub Desktop.
Download ZIP
Mariadb Columnstore - remove PM steps
Raw
columnstore-remove.sh
# example, removing pm3, moving its dbroot to pm1
# using google cloud
# run commands on pm1 server
ma stopsystem y
ma movePMDbrootConfig pm3 3 pm1
ma removeModule pm3
# now we shut down and destroy the removed module server, and attach its data disk to pm1 server
echo "/dev/sdc /usr/local/mariadb/columnstore/data3 ext2 noatime,nodiratime,auto 0 0" >> /etc/fstab
mount /dev/sdc
ma startsystem
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment