article thumbnail

Setting Up and Deploying PostgreSQL for High Availability

Percona

Backup and continuous archiving: PostgreSQL asynchronous replication relies on the write-ahead log (WAL) stream, and it’s vital to have centralized storage that all nodes can access. Also, check out our white paper — Percona Distribution for PostgreSQL: High Availability With Streaming Replication.

article thumbnail

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

Adrian Cockcroft

In 1991 I wrote a white paper on performance that was widely read, and in 1993 (with help from Brian Wong) that got me a job in the USA, working alongside Brian for Mike Briggs in technical product marketing. Later on after some re-orgs we ended up reporting to Greg Papadopoulos, who was CTO of the server organization at the time.

Tuning 52
Insiders

Sign Up for our Newsletter

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

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. While our white paper Performance at Scale could provide useful insight if you are at the planning or review stage.

article thumbnail

Designing Better Links For Websites And Emails: A Guideline

Smashing Magazine

if the information is read-only or editable); The file size is crucial for people with costly internet, slow connection, or limited local storage. Get the white paper”. A good practice for download links is to show the file format and size. Large preview ). Buy tickets”. Download the recording”. Large preview ).

Website 141
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

Tuning Autovacuum in PostgreSQL and Autovacuum Internals

Percona

An important point to note is that this behaviour can be overridden by setting the storage parameters of individual tables, which would subsequently ignore the global settings. Our white paper discusses how your company’s DBA staff needs to adapt to their new cloud database environment and more.

Tuning 45