Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. High cardinality keys can also reduce the likelihood of data hotspots and improve query performance by evenly distributing query traffic across shards. This helps prevent the creation of jumbo chunks and promotes better load balancing among shards.

Best Practices 71

Best Practices Traffic Database Servers 71

Brendan Gregg

DECEMBER 31, 2017

My last talk for 2017 was at AWS re:Invent, on "How Netflix Tunes EC2 Instances for Performance," an updated version of my [2014] talk. WARNING: These tunables were developed in late 2017, for Ubuntu Xenial instances on EC2.** Casey Rosenthal (traffic and chaos) Models of Availability. We help where we can. schedtool –B PID.

Tuning 61

Tuning AWS Best Practices Network 61

Brendan Gregg

DECEMBER 30, 2017

My last talk for 2017 was at AWS re:Invent, on "How Netflix Tunes EC2 Instances for Performance," an updated version of my [2014] talk. WARNING: These tunables were developed in late 2017, for Ubuntu Xenial instances on EC2.** Casey Rosenthal (traffic and chaos) Models of Availability. We help where we can. schedtool –B PID.

Tuning 52

Tuning AWS Best Practices Network 52

IO River

NOVEMBER 2, 2023

Delta Air Lines experienced a severe system outage in 2017, resulting in flight cancellations and delays across their network. The stakes are even higher during high-traffic periods such as Black Friday or Cyber Monday. High availability is a business imperative in this sector.

Availability 52

Availability Social Media Traffic Games 52

IO River

NOVEMBER 2, 2023

Delta Air Lines experienced a severe system outage in 2017, resulting in flight cancellations and delays across their network. The stakes are even higher during high-traffic periods such as Black Friday or Cyber Monday. High availability is a business imperative in this sector.

Availability 52

Availability Social Media Traffic Games 52

Brendan Gregg

SEPTEMBER 25, 2021

Since instances of both CentOS and Ubuntu were running in parallel, I could collect flame graphs at the same time (same time-of-day traffic mix) and compare them side by side. Amazon even provides an official [recommendation] (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source.

Speed 126

Speed Java AWS Virtualization 126

Percona

JULY 7, 2023

StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. Such a proxy acts as the traffic cop between the applications and the database servers. PostgreSQL has rapidly gained favor among professional developers in recent years. Configure load balancing.

Availability 83

Availability Open Source Architecture Database 83