Date
Participants / Internal Stakeholders
Retrospective
It’s great that Chongsun Ahn (Unlicensed) was able to finish the data pump so quickly.
Aleksandra Ciesińska focused on supporting OpenLMIS-Angola, while Mateusz Kwiatkowski concentrated on the longterm goal of introducing an aggregated approval page. Chongsun’s ticket was therefore, understandably, the only one were were able to close.
Showcase
The data pump syncs/streams data between the original requisition service and the new batch-requisition one. Our database image now includes Debezium, which uses Kafka to stream changes. You can currently see Kafka’s state, along with the data that it’s streaming, via port 8000. The port is publicly accessible at the moment, though can be essentially closed via AWS' security group and/or load balancer’s settings. There's no guarantee of the order in which streaming messages will be received. There can thus be foreign-key violations/exceptions if data arrives out of order and is attempted to be inserted into the new service accordingly. To handle this, we use multiple connectors configured to retry their insertions.
Confluent is a platform which has Zookeeper and several other things we're using. Kafta connect's port is 8083.
Kafka doesn’t just stream data - it streams schema changes as well. Although this allows it to automatically update schema within the target database, it has no way of knowing whether and how indexes should be applied within the updated tables. We therefore don’t rely on automatic schema updates, and instead manually make them via migrations.
Planning
The UAT is still slated for the 17th and 18th.
The primary ways in which the dev team can currently support the UAT is by focusing on https://openlmis.atlassian.net/browse/SELV3-148 , https://openlmis.atlassian.net/browse/SELV3-147, and https://openlmis.atlassian.net/browse/SELV3-150.
https://openlmis.atlassian.net/browse/SELV3-124 can be considered done.
Action Items
- Ben Leibert will create a ticket dedicated to restricting access to Kafka’s streaming data.