Would running multiple server processes increase performance or security? - Source

Revision: 102914
User: Micha Cassola
Date: 2021-01-05 18:03

Answer

If you are short on hardware resources, cpus memory etc, there will be increased overhead as the OS context switched (small) or paging out of swap (large) between instances resulting in a degraded of performance.

The PHP approach of pooling allows a fixed amount of resources to be available for each application. MariaDB is very good and ensuring a fair use of resources between multiple connections however inadequite tuning/monitoring of connections/table cache elements can cause some contention between different applications. Running separate instances will still require these to be tuned per application.

MariaDB access control with a user per db application (with limited grants) does a very good job of security for many applications. For protection against unknown MariaDB vulnerabilities there are reasonable amount of security benefits of running multiple instances in protecting the security of one application from similar exploitation in a different application (assuming that they are a different applications meaning the same web application exploit that results in a database security issues cannot be applied by the same user to a different instance).

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Would running multiple server processes increase performance or security? - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB