Tag - High Availability

Removing PostgreSQL Bottlenecks Caused by High Traffic

PostgreSQL Bottlenecks High Traffic

Taking our cue from Peter Zaitsev’s article on MySQL Performance Bottlenecks, I’m going to talk a little about the PostgreSQL perspective of removing bottlenecks caused by high traffic.
Many stacks these days are implemented by trusting the Object Relational Mapper, ORM, to do the right thing with PostgreSQL while one creates critical business logic on […]

Read more

Evaluating Percona XtraDB Cluster 8.0 in I/O Bound Workload

Percona XtraDB Cluster 8.0 in I:O Bound Workload

Percona XtraDB Cluster 8.0 is in the final stretch before GA release and we have pre-release packages available for testing, and I wanted to see how Percona XtraDB Cluster 8.0 performs in CPU and IO-bound scenarios, like in my previous posts about MySQL Group Replication.
In this blog, I want to evaluate Percona XtraDB Cluster 8.0 […]

Read more

Evaluating Percona XtraDB Cluster 8.0 Scaling Capabilities

Percona XtraDB Cluster Scaling

Percona XtraDB Cluster 8.0 is on the final stretch before GA release, and we have pre-release packages available for testing.
I wanted to see how Percona XtraDB Cluster 8.0 performs in CPU and IO-bound scenarios, like in my previous posts about MySQL Group Replication.
In this blog, I want to evaluate Percona XtraDB Cluster 8.0 scaling […]

Read more

18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part Three)

MySQL high traffic

This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here, and part two can be found here.  
13. Configure MySQL Server Properly
Complexity:Medium
Potential Impact: High 
A poorly configured MySQL Server can cause severe issues, especially under high load during a traffic […]

Read more

18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part Two)

MySQL High Traffic

This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here and part three can be found here.
7. Get More Memory
Complexity: Low
Potential Impact: High
If your data does not fit into memory well, your MySQL performance is likely to be […]

Read more