Dynatrace

DECEMBER 27, 2022

As more organizations embrace microservices-based architecture to deliver goods and services digitally, maintaining customer satisfaction has become exponentially more challenging. Implementing service-level objectives (SLOs) has become a vital method for meeting service-level agreements that ensure great user experiences. A service-level objective is a key element within a larger service-level agreement, or contract of sorts, between a provider and a customer.

Software 277

Software Software Benchmarking Latency 277

DZone

DECEMBER 30, 2022

DevOps, as initially conceived, was more of a philosophy than a set of practices—and it certainly wasn't intended to be a job title or a role spec. Yet today, DevOps engineers, site reliability engineers, cloud engineers, and platform engineers are all in high demand—with overlapping skillsets and with recruiters peppering role descriptions with liberal sprinklings of loosely related keywords such as "CI/CD pipeline," "deployment engineering," "cloud provisioning," and "Kubernetes.

DevOps 133

DevOps Engineering Cloud 133

Percona

DECEMBER 28, 2022

Recently I came across an interesting investigation about long-running transactions getting killed on an Aurora Reader instance. In this article, I will explain why it is advisable to avoid long-running transactions on Aurora readers when executing frequent DDL operations on the Writer, or at least be aware of how a DDL can impact your Aurora readers.

Storage 94

Storage Servers AWS Database 94

SQL Shack

DECEMBER 30, 2022

In this article, we are going to learn some best practices that help to write more efficient SQL queries. Introduction Queries are used to communicate with the databases and perform the database operations. Such as, we use the queries to update data on a database or retrieve data from the database. Because of these functions […].

Best Practices 92

Best Practices Database Efficiency Performance 92

InfoQ

DECEMBER 29, 2022

Anderson Parra, Vitor Pellegrino discuss how their ticketing systems work and cover the virtual waiting room – the primary component that allows them to handle high-traffic ticket on-sales. By Anderson Parra, Vitor Pellegrino.

Virtualization 52

Virtualization Traffic Systems Design 52

Simform

DECEMBER 28, 2022

Organizations mainly want to modernize apps for better performance, scalability, and security. But it’s natural to get daunted by the required expenses. Here's everything you should know to save big on costs and avoid the risks on the way.

Scalability 52

Scalability Performance 52

Percona

DECEMBER 27, 2022

Encrypting data at rest in a database management system (DBMS) refers to securing data by encrypting it when it is not being used or accessed. This is often done to protect sensitive data from unauthorized access or theft. With transparent data encryption (TDE), the encryption process is transparent to the user, allowing them to access and manipulate the data as usual without worrying about the encryption and decryption process.

Database 94

Database Storage Servers Strategy 94

n0derunner

DECEMBER 29, 2022

fio on Windows Download pre-compiled fio binary for Windows Example fio windows file, single drive This will create a 1GB file called fiofile on the F: Drive in Windows then read the file. Notice that the specification is “Driveletter” “Backslash” “Colon” “Filename” In fio terms we are “escaping” the : which fio traditionally uses as … The post Specifying Drive letters with fio for Windows. appeared first on n0derunner.

40

40

Simform

DECEMBER 26, 2022

Lift and shift is moving an application and its data to a cloud platform without redesigning the app. Know everything about it in this blog.

Cloud 52

Cloud 52

Percona

DECEMBER 27, 2022

There are eight configuration options related to the character_set in MySQL, as shown below. Without reading the MySQL Character Set documentation carefully, it could be hard to know what these configuration options are used for. In addition, for some of the options, unless there is further testing, it could be hard to know how MySQL uses them. mysql> show variables like 'character_set%'; + --+ -+. | Variable_name | Value |. + --+ -+. | character_set_

Servers 90

Servers Database Testing Processing 90

Percona

DECEMBER 29, 2022

While working as a DBA, we perform many regular tasks, and one of them is upgrading our database systems. There are some techniques to perform a PostgreSQL database upgrade, such as data dump and import, logical replication, or in-site upgrade using pg_upgrade. The last is a good option when you can afford some downtime and desire to reuse the same server where your current instance is running.

C++ 84

C++ Open Source Database Programming 84

Percona

DECEMBER 28, 2022

In managed services , we get requests to migrate from traditional to GTID-based replication. However, the customer does not want to first enable the GTID on the source node (production). Before MySQL 8.0.23, replication from the disabled GTID source to an enabled GTID replica was impossible. In this blog, I will talk about a new MySQL feature introduced in 8.0.23, which allows MySQL to replicate from a GTID-disabled source to GTID-enabled replica.

Servers 67

Servers 67

Percona

DECEMBER 27, 2022

It’s time for the release roundup! Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software.

Monitoring 52

Monitoring Open Source Database Servers 52