Skip to content

Instantly share code, notes, and snippets.

Avatar

James Arthur thruflo

View GitHub Profile
@thruflo
thruflo / cluster-setup.sql
Created Oct 4, 2021 — forked from marcocitus/cluster-setup.sql
Basic geo-partitioning for Citus
View cluster-setup.sql
-- set up a global cluster
select citus_set_coordinator_host('us-coordinator-hostname', 5432);
select citus_add_node('us-worker1-hostname', 5432);
select citus_add_node('us-worker2-hostname', 5432);
select citus_add_node('eu-coordinator-hostname', 5432);
select citus_add_node('eu-worker1-hostname', 5432);
select citus_add_node('eu-worker2-hostname', 5432);
-- make sure we can run distributed queries on EU coordinator
select start_metadata_sync_to_node('eu-coordinator-hostname', 5432);
View gist:604178

I've made some changed to try and make it clearer, e.g.: putting summaries at the top of the main answers. In some cases I've edited a bit more. I hope the revisions make sense.

The main issue is the first main answer 1. The idea and its potential market impact. I've half revised and then made a note for you to finish off.

n.b.: I've changed references to Reputation Economy to Aggregated Micropayments -- for me it made much more sense to talk about a feature rather than a concept.

Please provide a short summary of the content and objectives of the project including what is innovative about it. Please refer to the Guidance for Applicants Section 4

Espra is an open source, web-based social platform built around two innovations: