MySQL DB and Kafka DB

MySQL DB – can store passbook data, user wallet transactions, and the wallet balance of users using tables and relationships.

1. Passbook Data: You can create a table called “passbook” to store passbook-related information. Each row in this table represents an entry in the passbook for a specific transaction or event.
2. User Wallet Transactions: To track user wallet transactions, you can create a table called “wallet_transactions.” Each row in this table represents a specific transaction made by a user.
3. Wallet Data Balance of Users: To store the wallet balance of users.

Kafka DB – Platform used for building real time data pipelines and streaming appilcations. ie, transfer data from various sources to target destinations in real time.

1. Backup: Kafka does not offer built-in backup functionality but can use Kafka Connect and external storage systems to create backups of Kafka topics.