article thumbnail

Setting Up and Deploying PostgreSQL for High Availability

Percona

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Despite all its upside, PostgreSQL software presents such challenges. PostgreSQL software supports synchronous streaming replication, asynchronous streaming replication, and logical replication.

article thumbnail

Is It a Read Intensive or a Write Intensive Workload?

Percona

You can see in this case it happens to match the IO activity graph, with storage taking more time to serve write requests versus read requests. For an introduction to PMM, our free and open source management and monitoring software, you might find value in my recorded webinar, MySQL Troubleshooting and Performance Optimization with PMM.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Total Cost of Ownership and the Return on Agility - All Things.

All Things Distributed

An apples to apples comparison of the costs associated with running various usage patterns on-premises and with AWS requires more than a simple comparison of hardware expense versus always-on utility pricing for compute and storage.

AWS 118
article thumbnail

MongoDB Best Practices: Security, Data Modeling, & Schema Design

Percona

Since MongoDB usually works with a replica set, it is possible to increase this parameter to get better performance: # edit /etc/mongod.conf storage: journal: enabled: true commitIntervalMs: 300 WiredTiger cache For dedicated servers, it is possible to increase the WiredTiger(WT) cache. By default, it uses 50% of the memory + 1 GB.

article thumbnail

C++ safety, in context

Sutter's Mill

To talk about C++’s current safety problems and solutions well, I need to include the context of the broad landscape of security and safety threats facing all software. Software security ” (or “cybersecurity” or similar) means making software able to protect its assets from a malicious attacker.

C++ 139
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

This White Paper is for informational purposes only. ​​ The storage ​​ space that is required ​​ for the sparse file is only that of the actual bytes written to the file and not the ​​ maximum ​​ file ​​ size.

Servers 40
article thumbnail

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

This White Paper is for informational purposes only. Stable Media Stable media is often confused with physical storage. SQL Server defines stable media as storage that can survive system restart or common failure. Mirroring can be implemented at a software or hardware level. See the article for more details.

Servers 40