CODEWITHSUNDEEP
relational-database
Ajay
Ajay

Reputation: 11

which database supports concurrent multiple read and write without the need of building separate replicated environments

which database product supports concurrent multiple read and write without the need of building separate replicated environments and what are the alternative to achive the same. Is replicating the environment heavy on resources ?

Thanks

Upvotes: 1

Views: 4137

Answers (1)

user330315
user330315

Reputation:

When using "up-to-date" versions, any DBMS will support that.

In Oracle and PostgreSQL a reader is never blocked if that is what you are referring to.

For SQL Server you will need to have at least version 2005 to get rid of some nasty locking behaviour.

DB2 offers a "readers are never blocked" mode starting with 9.7

For MySQL you will have to use InnoDB as MyISAM will greatly reduce the concurrency when reading and writing (apart from all the other problems that MyISAM has)

If you are more referring to a performance problem, that heavy writes will slow down other queries, then this is more of a hardware problem than a real DBMS problem. The most limiting factor (especially for large databases) is IO. Using high-end RAID systems (or solid state disks like FusionIO) this problem can be addressed as well - but that will be costly.

Upvotes: 1

Related Questions