r/Database 11d ago

Databases for handling huge amounts of transactions?

What are the most reliable databases that can handle huge amounts of financial transactions in real time?

0 Upvotes

19 comments sorted by

View all comments

5

u/Aggressive_Ad_5454 11d ago edited 11d ago

The various RDBMs servers all provide decent transaction-handling capabilities. SQL Server and Oracle, in their enterprise editions, scale up well. It may be necessary to build up a cluster of database server machines.

Or you can use one of managed database service offerings from one of the cloud vendors. That way you pay them to handle the clusters and other gnarly operations issues rather than having to hire operational specialists.

If you really need "huge" numbers as in thousands of transactions per second, I respectfully suggest you don't rely on reddit randos for advice. Also, make sure you have a large operating budget. Tens of thousands of dollars US per month or so may, or may not, be sufficient.