Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 85

Database Hardware Open Source Strategy 85

Dynatrace

FEBRUARY 9, 2023

We recently extended the pre-shipped code-level API definitions to group logical parts of our code so they’re consistently highlighted in all code-level views. Another benefit of defining custom APIs is that the memory allocation and surviving object metrics are split by each custom API definition.

Java 214

Java Metrics Servers Code 214

Scalegrid

DECEMBER 19, 2019

It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. When PgBouncer receives a client connection, it first performs authentication on behalf of the PostgreSQL server. How Does PgBouncer Work?

Cache 246

Cache Database Architecture Servers 246

Speed Curve

FEBRUARY 5, 2024

Server-timing headers are a key tool in understanding what's happening within that black box of Time to First Byte (TTFB). Cue server-timing headers Historically, when looking at page speed, we've had the tendency to ignore TTFB when trying to optimize the user experience. I mean, why wouldn't we?

Servers 57

Servers Cache Retail Benchmarking 57

SQL Performance

JULY 19, 2022

The simplest definition of a log record: it describes a single change to a database. A single operation in the database may cause multiple changes , but each change will usually have its own log record to describe it. out of space on the log drive), the database must be set offline in the SUSPECT state. Log Record Types.

Servers 94

Servers Database Storage Engineering 94

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

DZone

JANUARY 29, 2021

Application Programming Interface acts as the center level between the database and presentation layer in the software development procedure. It is mainly the channel that links the client to the server, drives business procedures, and gives the services which give worth to users. What is API Test?

Testing 207

Testing Programming Performance Database 207

DZone

MARCH 24, 2021

We typically understand software testing by the everyday definition of the word: making sure a piece of software performs the way it is supposed to in a production-like environment. The first category would fall under integration testing, and you definitely need that. If so, the database is updated. Or is there?

Design 193

Design Testing Software Performance Database 193

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections.

Servers 130

Servers Best Practices Government Network 130

Percona

OCTOBER 10, 2023

Your MySQL connection id is 256 Server version: 8.0.32-24.2 mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 HaProxy was acting as a load balancer in front of the cluster. Commands end with ; or g.

Database 92

Database Performance C++ Engineering 92

SQL Performance

JANUARY 20, 2022

All through my career as a data professional, both inside Microsoft and as a consultant, I’ve found one of the most misunderstood parts of a SQL Server database is the transaction log. A transaction encompasses a change or a set of changes to a database. Logging, Log Records, and the SQL Server Transaction Log.

Servers 54

Servers Database Architecture Performance 54

SQL Performance

APRIL 17, 2020

When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. Rewrite some or all of the stored data to match the new definition. Improvements in SQL Server 2016. You get these undocumented improvements for free. Test2 ; GO.

Servers 63

Servers Database Testing Efficiency 63

Percona

APRIL 4, 2023

Those are a lot more common and may be in your table definitions, so your upgrade process will be harder. If you try to use a reserved word, the server will not explicitly admonish you that you are trying to use a reserved word. Instead, the server informs you that you have a syntax error. Yes, there is a workaround.

Open Source 114

Open Source Database Servers Scalability 114

Dynatrace

FEBRUARY 14, 2022

Among these, you can find essential elements of application and infrastructure stacks, from app gateways (like HAProxy), through app fabric (like RabbitMQ), to databases (like MongoDB) and storage systems (like NetApp, Consul, Memcached, and InfluxDB, just to name a few). Topology definition and entity extraction rules.

Technology 222

Technology Technology Metrics Infrastructure 222

SQL Performance

SEPTEMBER 29, 2021

A common requirement in ETL and various reporting scenarios is to quietly load a SQL Server staging table in the background, so users querying the data aren’t impacted by the writes and vice-versa. Refreshing Tables in SQL Server. SQL Server Partition Switching Example. definition , 500 ) FROM sys. session_id , o.

Servers 55

Servers Games Database Processing 55

Percona

OCTOBER 13, 2023

Purpose of.sdi files Serialized dictionary information (SDI) files store serialized metadata about various database objects, such as tables, indexes, and other schema-related details. mysql> create database test_rocksdb; Query OK, 1 row affected (0.01 mysql> create database test_rocksdb; Query OK, 1 row affected (0.01

Storage 90

Storage Database Engineering Open Source 90

Percona

DECEMBER 18, 2023

These days, there’s been a lot of talk in the industry about setting up one’s database system on PostgreSQL. It can perform ETL transforms from one database to another and, under certain special circumstances, can even be implemented as a poor man’s replication solution. MYSQL: OS: Ubuntu 16.04 MySQL version 5.7

Open Source 118

Open Source Database Architecture Design 118

Dynatrace

NOVEMBER 2, 2020

IT infrastructure is the heart of your digital business and connects every area – physical and virtual servers, storage, databases, networks, cloud services. This shift requires infrastructure monitoring to ensure all your components work together across applications, operating systems, storage, servers, virtualization, and more.

Infrastructure 205

Infrastructure Monitoring Virtualization Serverless 205

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. But changing this is possible only at the server startup. 20150623 (Red Hat 4.8.5-44),

Database 99

Database Servers Open Source Tuning 99

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. I have SQL Server 2019 CTP 3.2 Now that 2019 CTP 3.2

Servers 95

Servers C++ Testing Systems 95

Percona

JULY 25, 2023

The data is internally inconsistent because the server concurrently modifies the data files while they are being copied. Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again. The redo apply phase wouldn’t make the database consistent with respect to a transaction.

Cache 83

Cache Benchmarking Servers Design 83

Percona

SEPTEMBER 19, 2023

The effort has definitely paid off, as we can release shortly after upstream. To highlight some: Logical replication from standby servers is now supported natively by PostgreSQL. Added support for regular expression matching of user and database names in pg_hba.conf, and user names in pg_ident.conf.

Availability 105

Availability Open Source Database Servers 105

Dynatrace

MARCH 17, 2021

A single OneAgent instance can handle the monitoring of many types of entities, including servers, applications, services, databases, and more. You want to optimize your Citrix landscape with insights into user load and screen latency per server? Dynatrace Extensions 2.0 We also give you more value than just metrics and events.

Metrics 173

Metrics Monitoring Network Technology 173

Scalegrid

JANUARY 20, 2020

Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. It is not available for our in-memory database offerings like hosting for Redis™*. Database Dev/Test Setup. If your application passes on the test dataset, it is definitely fit to deploy in production!

Analytics 185

Analytics Storage Database Systems 185

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. The same tests have been executed in Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7

Cache 98

Cache Hardware Servers Benchmarking 98

Percona

JULY 19, 2023

I did the following: kubectl create namespace argocd kubectl apply -n argocd -f [link] Expose the ArgoCD server. Retrieve the admin password to log in using the CLI: argocd admin initial-password -n argocd Login to the server. Server Side sync Percona relies on OpenAPI v3.0 Server Side sync Percona relies on OpenAPI v3.0

Servers 76

Servers Best Practices DevOps Open Source 76

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself.

Open Source 79

Open Source Programming Database Servers 79

Percona

MAY 9, 2023

The term is inherently ominous, and a broad definition isn’t much cheerier. To determine whether that perception is warranted in the database software industry — and if so, how to avoid vendor lock-in pitfalls — let’s dig deeper. The organization’s apps, therefore, must run on one particular server.

Open Source 87

Open Source Database Innovation Cloud 87

Dynatrace

NOVEMBER 3, 2021

Monitoring , by textbook definition, is the process of collecting, analyzing, and using information to track a program’s progress toward reaching its objectives and to guide management decisions. Experienced database administrators learn to spot patterns that can lead to common problems. Monitoring vs. observability.

Monitoring 226

Monitoring Metrics DevOps Scalability 226

Percona

SEPTEMBER 6, 2023

Functional indexes are found in both of Percona’s relational databases, MySQL and PostgreSQL, but they are probably the least used and most understood index type, aside from geospatial. Definitions The examples below use MySQL, but it is helpful to check their competition’s documentation to help explain what a functional index is.

Speed 79

Speed Virtualization Storage Open Source 79

Percona

NOVEMBER 7, 2023

How to read this book The best way to read this book is from the first page to the last, as the author builds on previous definitions and explanations. Buy this book if you are looking for a deeper understanding of how the PostgreSQL server really works, and you will not be disappointed.

Cache 84

Cache Servers Operating System Database 84

SQL Performance

JULY 14, 2021

The code that I’ll be using in this article can be executed in any database, but in my demos, I’ll be using TSQLV5—the same sample database that I used in previous articles. When you create a view, SQL Server records metadata information in a number of catalog objects. Using SELECT * in the view’s inner query is a bad idea.

Code 117

Code Database Servers Availability 117

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. Normally this solution requires a full code redesign and could be quite difficult to achieve when it is injected after the initial code architecture definition.

Traffic 121

Traffic Scalability Database Servers 121

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. If all is good, perform the upgrade removing the –check flag.

C++ 81

C++ Open Source Database Programming 81

The Netflix TechBlog

JULY 30, 2019

The Netflix Media Database (NMDB) is one such example. Adoption As of writing this blog, Conductor orchestrates 600+ workflow definitions owned by 50+ teams across Netflix. To improve usability and operability, we added validations, which in practice has greatly helped find bugs during creation of workflow and task definitions.

Lambda 189

Lambda Media Open Source Metrics 189

Percona

JANUARY 4, 2023

MySQL index is a data structure used to optimize the performance of database queries at the expense of additional writes and storage space to keep the index data structure up to date. Unused indexes are indexes that are created in a database but are not being used in any queries. How to find the duplicate MySQL indexes?

Storage 86

Storage Database Engineering Testing 86

Percona

APRIL 4, 2023

” While this is definitely a valid use case, I hadn’t personally come across an issue in the wild where the application fix wasn’t trivial. To quickly set up the environment, ProxySQL was installed locally on the host running pt-archiver and set up with a single backend (the target testbed server).

Open Source 104

Open Source Servers Engineering Scalability 104