article thumbnail

Setting Up and Deploying PostgreSQL for High Availability

Percona

In general terms, to achieve HA in PostgreSQL, there must be: Redundancy: To ensure data redundancy and provide continuous performance when a primary server fails, multiple copies of the database reside in replica servers. When the primary server fails, a standby server takes over as the new primary.

article thumbnail

Deploy Django on Kubernetes With Percona Operator for PostgreSQL

Percona

I will use the regular kubectl approach: $ kubectl apply --server-side -f deploy/bundle.yaml Django application would require its own user and database. Read Our New White Paper: Why Customers Choose Percona for PostgreSQL In this blog post, we’ll explore what it takes to run Django on Kubernetes with Percona Operator.

Database 119
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

ChatGPT vs. MySQL DBA Challenge

Percona

Questions Q: I have a MySQL server with 500 GB of RAM; my data set is 100 GB. Keep in mind that setting the buffer pool size too high may result in other processes on your server competing for memory, which can impact performance. Q: I have a MySQL server, and my application is writing at a rate of 100 MB/hour in my redo logs.

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. This was followed by a greatly expanded second edition with some additional chapters by Rich Pettit.

Tuning 52
article thumbnail

An Introduction to MySQL Replication: Exploring Different Types of MySQL Replication Solutions

Percona

In this blog post, I provide an in-depth introduction to MySQL Replication, answering what it is, how it works , its benefits and challenges, as well as reviewing some of the MySQL replication concepts that are part of the MySQL environment (and Percona Server for MySQL specifically). Set the server-id to a unique value.

Servers 52
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

This White Paper is for informational purposes only. Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication.

Servers 40
article thumbnail

Is It a Read Intensive or a Write Intensive Workload?

Percona

This is helpful, for example, if you are considering to move some of the tables to a different server and want to clearly understand how your workload will be impacted. While our white paper Performance at Scale could provide useful insight if you are at the planning or review stage.