Sync a users subscriptions to new 'Vitess' database
Goal
Cassandra, ElasticSearch and Redis do not allow us to do simple join queries. This makes 'mutual friends' and other such queries very difficult. Vitess is a CloudNative project that brings high availability to MySQL.
What needs to be done
We already have an event stream for all subscribe actions 'event-action-subscribe'. We can tab into this and keep in sync with Vitess via a background runner.
Prior to this, we can import a list of all 'friends' (subscriptions) by dumping a CSV from Cassandra and importing into Vitess.
QA
N/A
UX/Design
N/A
Personas
Devs
Experiments
N/A
Acceptance Criteria
-
Update minds/php image to support PDO driver -
A new Data\SQL\Client
that will point to our Vitess cluster -
Schemas for our 'friends' table -
A background runner that subscribes to 'event-action-subscribe' and sync to our SQL friends table -
Manual bulk job to copy from cassandra to vitess -
Documentation
Definition of Ready Checklist
-
Definition Of Done (DoD) -
Acceptance criteria -
Weighted -
QA -
UX/Design -
Personas -
Experiments