Project Details

Key Results

• •Sub-second query with custom persist & load strategy.
• •Does not hog main service resource
• •Have additional capabilities like : sms blasting, comprehensive metrics
• •Extendable and future proof for this specific domain.
• •Enabled admin team to segment and target customers 10x faster.
• •Tighter policy between admin & marketing team. each now have different access, tigher security, prevent misuse of selling data

Challenge

as business grow, the dataset is also growing. i always monitor metrics, and when something doesn't adding up (e.g spiking or borderline slower than usual), i will spin up some benchmark and check the indexes. turns out the dataset have reached multi million. this is expected, as there's hundreds transaction happening every second (e.g player spinning the bet, doing deposit, or just playing the demo).

Solution

what started as integrated service, now i break them into microservice, there's multiple out of context requirement from stakeholder to justify breaking this part into micro service too. now that multi million data will have its own strategy to persist & load data, and will not slow down the main service.