Tue.Jan 02, 2024

article thumbnail

Architecture Patterns: Sharding

DZone

What Is Sharding? Sharding, a database architecture pattern, involves partitioning a database into smaller, faster, more manageable parts called shards. Each shard is a distinct database, and collectively, these shards make up the entire database. Sharding is particularly useful for managing large-scale databases, offering significant improvements in performance, maintainability, and scalability.

article thumbnail

Is Thread Pool Plugin the Right Choice for Your Workload?

Percona

TL&DR : Depending on the workload, the thread pool plugin can cause serious performance drops. This post was motivated by two recent cases I’ve worked with. Two setups running in cluster mode: one in MariaDB+Galera and one with Percona XtraDB Cluster (Percona Server+Galera). In both cases, the clusters had the thread pool plugin enabled and were serving requests coming from ProxySQL.

Insiders

Sign Up for our Newsletter

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

article thumbnail

BankNext Case Study: JUnit Mockito Automation

DZone

BankNext ’s massive production environment has more than 300 live microservices. Multiple squads working concurrently on these SVCs heightens the risk of breaking functionality. Adding JUnits and code coverage manually to existing and new code is arduous and painfully slow. Challenges With Manual JUnits Time-intensive activity to write proper useful JUnits manually.

Code 256
article thumbnail

Audit DROP Statements in Percona Server for MySQL

Percona

Managing database servers involves different aspects, among which security is critical. We know that we should always grant the minimal required permissions to the different user accounts in the database, as having a user with high-level permission can lead to unexpected results, such as having an index drop affecting the system performance or even more disastrous events such as having a table or a database dropped causing the system to crash and possible data loss.

Servers 89
article thumbnail

Architecture Patterns: Publish/Subscribe

DZone

The Publish/Subscribe (Pub/Sub) pattern is a widely-used software architecture paradigm, particularly relevant in the design of distributed, messaging-driven systems. The communication framework is decoupled, scalable, and dynamic, making it useful for addressing complex software requirements in modern application development. At its core, the Pub/Sub pattern is about decoupling the message producer (publisher) from the message consumer (subscriber).

article thumbnail

How to find (and fix!) INP interactions on your pages

Speed Curve

Andy Davies – fellow SpeedCurver and web performance consultant extraordinaire – recently shared an impressive Interaction to Next Paint (INP) success: Andy has promised us a more in-depth post on debugging Interaction to Next Paint. While he's working on that, I'll try not to steal his thunder while I share a tip that may help you identify element(s) causing INP issues for your pages.

Metrics 59
article thumbnail

Human-Centered Approach to Service Reliability: Building Culture, Communication, and Collaboration

DZone

In the complex world of service reliability, the human element remains crucial despite the focus on digital metrics. Culture, communication, and collaboration are essential for organizations to deliver reliable services. In this article, I am going to dissect the integral role of human factors in ensuring service reliability and demonstrate the symbiotic relationship between technology and the individuals behind it.

Metrics 147