Project Overview
An enterprise has warehouses across the globe
Each warehouse has a local data center
A stock management application runs in each warehouse
A local MariaDB database keeps track of warehouse stock
Stock maintained by item and day - opening stock, receipts, and issues
Requirements
Create and manage a central, consolidated stock database
Item stock aggregated across locations on a daily basic
Batch processing to upload warehouse data into a central cloud and manage stock
Scalable to hundreds of warehouses