Friday 30 November 2018

Node Cluster: Database Concurrency Options

While deploying my app and clustering with PM2 I noticed, that sqlite does not like concurrency when writing to the db. In this case clustering is not essential which is why this is a simple fix for me but I am wondering what options I would have if it would be required:Use a different DB System: Preferably SQL and meant for concurrent writing. Postgres?Seperate instance of node only for writing to the DB? (not very nice).Master/Slave instances where one is a designated DB-writer and all other instances pass the data on?

Submitted November 30, 2018 at 10:58PM by Vivida

No comments:

Post a Comment