CitusData Notes

citus-data.md

Citus Docs

• Citus Doc
  • Single machine docker
  • Single machine deb
  • Multi-node setup on Ubuntu or Debian
  • Multi-tenant Applications
    • Data model and sample data
    • Creating tables
    • Distributing tables and loading data
  • Real-time Analytics
    • Data model and sample data
    • Creating tables
    • Distributing tables and loading data
  • Append

Multi-node install

Steps to be executed on all nodes

curl https://install.citusdata.com/community/deb.sh | sudo bash
sudo apt-get -y install postgresql-9.6-citus-6.1
sudo pg_conftool 9.6 main set shared_preload_libraries citus
sudo pg_conftool 9.6 main set listen_addresses '*'
echo "host    all             all             10.0.1.0/24              trust" | sudo tee -a /etc/postgresql/9.6/main/pg_hba.conf
sudo service postgresql restart
sudo update-rc.d postgresql enable
sudo -i -u postgres psql -c "CREATE EXTENSION citus;"

Steps to be executed on the master node

sudo -i -u postgres psql -c "SELECT * from master_add_node('10.0.1.7', 5432);"
sudo -i -u postgres psql -c "SELECT * from master_add_node('10.0.1.6', 5432);"
sudo -i -u postgres psql -c "SELECT * FROM master_get_active_worker_nodes();"
sudo -i -u postgres psql