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. Rich became co-author of the second edition of the Sun Performance Tuning book, to describe how it worked.

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

This white paper provides a detailed view of the comparable costs of running various workloads on-premises and in the AWS Cloud and offers guidance on how to work out an apples-to-apples comparison of the TCO of running web applications in the AWS Cloud versus running them on-premises.Below are some highlights of the Web Applications white paper.

AWS 118
article thumbnail

Setting Up and Deploying PostgreSQL for High Availability

Percona

It enables businesses and organizations to meet uptime and service level objectives, protect business-critical data, and maintain performant databases. Failover: This functionality is all about switching — in both unplanned and planned situations — from a failed primary server to a standby server.

article thumbnail

ABAC on SpiceDB: Enabling Netflix’s Complex Identity Types

The Netflix TechBlog

Netflix Modeling Challenges Before Caveats SpiceDB, being a Relationship Based Access Control (ReBAC) system, expected authorization checks to be performed against the existence of a specific relationship between objects. This is a Caveated SpiceDB relationship. Users fit this model — they have a single user ID to describe who they are.

Cache 249
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

C++ safety, in context

Sutter's Mill

Kubernetes Secrets on public GitHub repos), misconfigured servers (e.g., Do configure your servers correctly, especially public Internet-facing ones. Many of 2023’s worst data breaches did not involve malware, but were caused by inadequately stored credentials (e.g., Do use package management for library dependencies.

C++ 139