Trending Articles

article thumbnail

Essential Relational Database Structures and SQL Tuning Techniques

DZone

Understanding the structures within a Relational Database Management System (RDBMS) is critical to optimizing performance and managing data effectively. Here's a breakdown of the concepts with examples. RDBMS Structures 1. Partition Partitioning in an RDBMS is a technique to divide a large database table into smaller, more manageable pieces, called partitions, without changing the application's SQL queries.

Database 224
article thumbnail

The benefits of unified observability and security for BizDevSecOps use cases

Dynatrace

BizDevSecOps might sound like a mouthful, but it marks a necessary evolution. As business goals and technology efforts continue to converge, organizations need to ensure teams are performing to their full potential. Business considerations are now part of the security, operations, and development framework. During a session at Dynatrace Perform 2024 , Dynatrace colleagues Kristof Renders, director of innovation services, and Brian Chandler, principal solutions architect, demonstrated four BizD

Insiders

Sign Up for our Newsletter

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

article thumbnail

Logging and Monitoring in a Docker Environment

DZone

Docker, the main containerization technology, has transformed application packaging and deployment. While Docker makes it easier to execute apps, it is also critical to monitor and log your Dockerized environments to ensure they are working properly and stay safe. In this post, we’ll go into the realm of Docker logging and monitoring, looking at the best practices, tools, and techniques for keeping your containerized apps operating smoothly.

article thumbnail

The future of work: How to zig, zag, and steer your career in the AI era

Dynatrace

Today’s macroeconomic environment is dynamic and uncertain, generating many questions about the future of work. New technologies are disrupting the landscape, while company mergers, acquisitions, and economic volatility abound. As artificial intelligence becomes more pervasive in organizations, the workforce senses that the future of work is undergoing massive shifts.

article thumbnail

Introducing SafeTest: A Novel Approach to Front End Testing

The Netflix TechBlog

by Moshe Kolodny In this post, we’re excited to introduce SafeTest, a revolutionary library that offers a fresh perspective on End-To-End (E2E) tests for web-based User Interface (UI) applications. The Challenges of Traditional UI Testing Traditionally, UI tests have been conducted through either unit testing or integration testing (also referred to as End-To-End (E2E) testing).

Testing 239
article thumbnail

What I've been reading since re:Invent

All Things Distributed

After a busy conference season, I've taken some time to catch up on reading and make a dent in the pile of books on my nightstand. Here's what I've started, finished, and picked up since re:Invent.

128
128
article thumbnail

Can Disk Space Be Saved in MySQL by Adding a Primary Key?

Percona

Historically, MySQL does not require explicit primary key defined on tables, and it’s like that by default till this day (MySQL version 8.3.0). Such a requirement is imposed through two replication methods, though: Group Replication and Percona XtraDB Cluster (PXC), where using tables without a primary key is not allowed by default.

110
110

More Trending

article thumbnail

Announcing bpftop: Streamlining eBPF performance optimization

The Netflix TechBlog

By Jose Fernandez Today, we are thrilled to announce the release of bpftop , a command-line tool designed to streamline the performance optimization and monitoring of eBPF applications. As Netflix increasingly adopts eBPF [ 1 , 2 ], applying the same rigor to these applications as we do to other managed services is imperative. Striking a balance between eBPF’s benefits and system load is crucial, ensuring it enhances rather than hinders our operational efficiency.

article thumbnail

Pinterest Open-Sources a Production-Ready PubSub Java Client for Kafka, Flink, and MemQ

InfoQ

Pinterest open-sourced its generic PubSub client library, PSC, which has been heavily used in production for a year and a half. The library helped the engineering teams by increasing developer velocity, and the scalability and stability of services using it. Over 90% of Java applications have migrated to PSC with minimal changes.

article thumbnail

PostgreSQL Column Alignment and Padding – How To Improve Performance With Smarter Table Design

Percona

In this blog post, we are going to briefly discuss the reasons why column order matters when creating tables -or relations- in PostgreSQL.

Design 116
article thumbnail

Mastering Prometheus: Unlocking Actionable Insights and Enhanced Monitoring in Kubernetes Environments

DZone

In the dynamic world of cloud-native technologies, monitoring and observability have become indispensable. Kubernetes, the de-facto orchestration platform, offers scalability and agility. However, managing its health and performance efficiently necessitates a robust monitoring solution. Prometheus, a powerful open-source monitoring system, emerges as a perfect fit for this role, especially when integrated with Kubernetes.

article thumbnail

What are quality gates? How to use quality gates to deliver better software at speed and scale

Dynatrace

To remain competitive in today’s fast-paced market, organizations must not only ensure that their digital infrastructure is functioning optimally but also that software deployments and updates are delivered rapidly and consistently. Thus, to meet demands and stay ahead of competitors, teams should strive to accelerate releases as much as possible. But how can organizations avoid sacrificing quality while maintaining a fast deployment pace?

Speed 213
article thumbnail

HammerDB v4.10 New Features: Partitioning and Advanced Statistics for SQL Server TPROC-H

HammerDB

HammerDB v4.10 adds performance enhancements for the SQL Server TPROC-H workload in the form of partitioning for the orders and lineitem tables as well as the option to create advanced statistics. Enabling Partitioning and Advanced Statistics These can be selected with a checkbox in the GUI. or the following options being set to true in the CLI. mssqls_tpch_partition_orders_and_lineitems = true mssqls_tpch_advanced_stats = true Benefits of Partitioning and Advanced Statistics When partitioning i

Servers 62
article thumbnail

Percona Monthly Bug Report: January 2024

Percona Community

At Percona, we believe that transparency is key to improving our products. We are dedicated to creating top-of-the-line open-source database solutions and providing support for any issues that may arise. We encourage feedback and bug reports to help us continually improve. We stay updated on bug reports through our own platform as well as other sources to ensure we have the most up-to-date information.

article thumbnail

Exploring the Kubernetes Application Lifecycle With Percona

Percona

This post was originally published on the Percona Community blog.If you are in the world of application development, you know that every application has a lifecycle. An application lifecycle refers to the stages that our application goes through, from initial planning, building, deployment, monitoring, and maintenance in different environments where our application can be executed.

article thumbnail

Creating a Hybrid Disaster Recovery Solution Utilizing Availability Group and Log-Shipping

DZone

SQL Server Always on availability group is a great addition to SQL Server for providing high availability and disaster recovery. Always-on availability group support failover the environment for a discrete set of user databases, known as availability databases, that failover together. They also support a set of read-write primary databases and several sets of corresponding secondary databases.

article thumbnail

Partner Summit 2024: Observability for digital transformation success

Dynatrace

The 4th Industrial Revolution is not slowing down. In fact, it’s only getting faster and more complicated. Digital transformation – which is necessary for organizations to stay competitive – and the adoption of machine learning, artificial intelligence, IoT, and cloud is completely changing the way organizations work. However, with digital transformation comes new challenges for teams – especially CIOs – at an unprecedented pace.

article thumbnail

HammerDB v4.10 New Features: Schema and Consistency Checks

HammerDB

The HammerDB TPROC-C and TPROC-H workloads are derived from the TPC-C and TPC-H workloads respectively. Although the HammerDB workloads are not identical to TPC-C and TPC-H it is still important that the workloads implemented maintain the same data consistency as the official workloads. For this reason HammerDB has implemented the data consistency checks for TPC-C and TPC-H to be run against all databases.

C++ 62
article thumbnail

Release Roundup February 21, 2024

Percona Community

Percona software releases and updates February 5 - February 21, 2024. Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability.

article thumbnail

Backing up and Restoring to AWS S3 With Percona Kubernetes Operators

Percona

In our last post, we looked into the lifecycle of applications in Kubernetes. We see that Kubernetes doesn’t handle database backups itself. This is where Kubernetes Operators come into action. They add additional functions to Kubernetes, enabling it to set up, configure, and manage complex applications like databases within a Kubernetes environment for the user.

AWS 90
article thumbnail

Practical business process monitoring for real-time business observability

Dynatrace

Recent platform enhancements in the latest Dynatrace, including business events powered by Grail™, make accessing the goldmine of business data flowing through your IT systems easier than ever. One of the more popular use cases is monitoring business processes, the structured steps that produce a product or service designed to fulfill organizational objectives.

article thumbnail

HammerDB v4.10 New Features: Purge and Write back for MariaDB TPROC-C

HammerDB

Many of the HammerDB TPROC-C workloads have included features to prevent the database doing maintenance tasks for the previous run whilst another run is taking place. This is particularly important when running automated workloads back-back to generate a performance profile for a progressively increasing number of virtual users. An example of this is the “Checkpoint when complete” option for Oracle which will flush all dirty/modified data blocks in the in-memory buffer cache to disk

C++ 62
article thumbnail

Revolutionize Your Web Presence: Explore The Potential Of WordPress Page Builders!

Official Blog - World Web Technology

Convert your online presence with the dynamic proficiencies of WordPress page builders! These spontaneous tools revolutionize the structure of web design. It empowers WordPress designers to create stunning websites without complex coding. You may unleash your creativity and elevate your digital identity as a web designer. It provides limitless possibilities for WordPress website builders.

Website 52
article thumbnail

Decoupling Backup and Expiry Operations in PostgreSQL With pgBackRest

Percona

Backup management is the backbone of any reliable database administration strategy, and while pgBackRest simplifies this process, its default configuration often combines backup and expiry together. At times, due to slow network bandwidth, huge database sizes, or any other resource crunch, expiring backups (i.e., deleting the older backups) require more than taking backups for databases.

article thumbnail

Top Secrets Management Tools for 2024

DZone

Managing your secrets well is imperative in software development. It's not just about avoiding hardcoding secrets into your code, your CI/CD configurations, and more. It's about implementing tools and practices that make good secrets management almost second nature. A Quick Overview of Secrets Management What is a secret? It's any bit of code, text, or binary data that provides access to a resource or data that should have restricted access.

Database 256
article thumbnail

Advanced security analytics to resolve incidents quickly and streamline threat hunting

Dynatrace

The growing complexity of modern multicloud environments has created a pressing need to converge observability and security analytics. Security analytics is a discipline within IT security that focuses on proactive threat prevention using data analysis. As attackers become more skilled, threats can become more detrimental to organizations if they go undetected.

Analytics 188
article thumbnail

How to Implement an Indoor Navigation Feature in Your Mobile App

Tech News Gather

The proliferation of smartphones has made navigation much easier. Technological advancements now allow you to easily locate everything from a tiny store to a large transportation hub and even virtual explore these facilities from the inside and out. While this is immensely helpful, users rightly want to be able to navigate inside a facility once they’re actually there.

Mobile 52
article thumbnail

Effective Concurrency: Live online course in April

Sutter's Mill

I generally give one or two courses a year on C++ and related technologies. This year, on April 22-25, I’ll be giving a live online public course for four half-days, on the topic of high-performance low-latency coding in C++ — and the early registration discount is available for a few more days until this Thursday: Effective Concurrency with Herb Sutter High performance and low latency code, via concurrency and parallelism 22-25th April 2024, from 14:00 – 18:00 CEST daily Participants in t

C++ 40
article thumbnail

Why Migrating to Open Source is Essential to Your Business Growth

Percona

The strategic adoption of different database technologies can make or break a company’s success and long-term viability. Among the many types of database software that companies can choose from, one type stands out for its ability to drive innovation, cut costs, and offer unparalleled flexibility: open source software.

article thumbnail

Advanced Architecture for AI Application (AKA AAAA!)

DZone

Surprise! This is a bonus blog post for the AI for Web Devs series I recently wrapped up. If you haven’t read that series yet, I’d encourage you to check it out. This post will look at the existing project architecture and ways we can improve it for both application developers and the end user.

article thumbnail

Dynatrace SaaS release notes version 1.285

Dynatrace

We have released Dynatrace version 1.285. To learn what’s new, have a look at the release notes. The post Dynatrace SaaS release notes version 1.285 appeared first on Dynatrace news.

191
191
article thumbnail

Sequential A/B Testing Keeps the World Streaming Netflix Part 1: Continuous Data

The Netflix TechBlog

Michael Lindon , Chris Sanden , Vache Shirikian , Yanjun Liu , Minal Mishra , Martin Tingley 1. Spot the Difference Can you spot any difference between the two data streams below? Each observation is the time interval between a Netflix member hitting the play button and playback commencing, i.e., play-delay. These observations are from a particular type of A/B test that Netflix runs called a software canary or regression-driven experiment.

Testing 234
article thumbnail

What is a Distributed Storage System

Scalegrid

A distributed storage system is foundational in today’s data-driven landscape, ensuring data spread over multiple servers is reliable, accessible, and manageable. This guide delves into how these systems work, the challenges they solve, and their essential role in businesses and technology. Understanding distributed storage is imperative as data volumes and the need for robust storage solutions rise.

Storage 130
article thumbnail

Using Percona Backup for MongoDB in Replica Set and Sharding Environment: Part One

Percona

Backups are crucial for every database system, and having a reliable, fast, and hot backup is the demand for next-generation database systems. Percona Backup for MongoDB (PBM) is a backup management tool that enhances the existing backup capability of MongoDB by providing various layers of backups such as physical, logical, incremental, PITR, etc.

article thumbnail

Understanding Status Page Aggregation: Inside the Technology of a Typical Status Page Aggregator

DZone

To explore status page aggregation, we’ll share our experience building a status page aggregator tool – StatusGator, which has been availble for eight years. We will share our technical insights and also share how you can build your own aggregator.

article thumbnail

How to achieve the pillars of zero trust at federal agencies

Dynatrace

The White House’s Executive Order on Improving the Nation’s Cybersecurity and the Office of Management and Budget (OMB) memo, Moving the U.S. Government Toward Zero Trust Cybersecurity Principles , have increased federal IT and security leaders’ urgency to implement zero trust (ZT). The OMB memo states that agencies must meet specific goals based on the five pillars of the Cybersecurity and Infrastructure Security Agency (CISA) Zero Trust Maturity Model : identity, devices, networks,

article thumbnail

Debugging Interaction to Next Paint (INP)

Speed Curve

Interaction to Next Paint (INP) will become a Core Web Vital on March 12th. Not surprisingly, most of the conversations I've had with SpeedCurve users over the last few months have focused on improving INP. INP measures how responsive a page is to visitor interactions. It measures the elapsed time between a tap, a click, or a keypress and the browser next painting to the screen.