article thumbnail

Setting Up and Deploying PostgreSQL for High Availability

Percona

Also, in general terms, a high availability PostgreSQL solution must cover four key areas: Infrastructure: This is the physical or virtual hardware database systems rely on to run. Can you afford the necessary hardware, software, and operational costs of maintaining a PostgreSQL HA solution? there cannot be high availability.

article thumbnail

What Adrian Did Next?—?Part 2?—?Sun Microsystems

Adrian Cockcroft

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. We had specializations in hardware, operating systems, databases, graphics, etc.

Tuning 52
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

Is It a Read Intensive or a Write Intensive Workload?

Percona

Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as what techniques you can apply for performance optimization and scalability. While our white paper Performance at Scale could provide useful insight if you are at the planning or review stage.

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

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. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40
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