Optimizing Real-Time Payment Authorization with Memgraph

Paysure Solutions transitioned to using Memgraph as a graph database to enhance their real-time payment authorization processes after experiencing challenges with previous architectures that used PostgreSQL and Redis. The webinar led by Martin Vo, CTO of Paysure Solutions, highlighted how Memgraph's capabilities helped the company efficiently manage complex payment transactions by overcoming issues like data locking and synchronization. The switch to Memgraph improved system performance and stability, allowing Paysure to handle transactions within tens of milliseconds, a crucial requirement given their 200-millisecond time constraint for transaction approvals. Martin detailed the technical implementation, discussing challenges such as optimizing performance with indexing and caching strategies, and handling Memgraph updates during peak times. Despite not using complex graph algorithms, Memgraph's ability to manage self-referencing allowances and related conditions in real-time was a significant advantage over traditional SQL databases. The session also covered operational challenges, performance results, and addressed a series of questions regarding the choice of Memgraph, handling data replication, and tips for optimizing queries.