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?

Testing 200

Testing Design Software Performance Database 200

The Netflix TechBlog

NOVEMBER 4, 2019

Specifically, how our team uses the relationships and schemas defined within GraphQL to automatically build and maintain a search database. Each service could potentially implement its own search database, but then we would still need an aggregator. To act on the change, we need a GraphQL server that supports introspection.

Cache 248

Cache Database Servers Performance 248

Percona

MARCH 23, 2023

When it comes to enterprise-level databases, there are several options available in the market, but PostgreSQL stands out as one of the most popular and reliable choices. PostgreSQL is a free and open source object-relational database management system (ORDBMS) that has existed since the mid-1990s.

Database 121

Database Open Source Traffic Small Business 121

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 213

Infrastructure Monitoring Virtualization Serverless 213

Percona

OCTOBER 10, 2023

Databases are different from a lot of software. This is not a general rule, but as databases are responsible for a core layer of any IT system – data storage and processing — they require reliability. Why choose Percona Server for MongoDB? Why release Percona Server for MongoDB 7 now?

Availability 107

Availability Servers Database Open Source 107

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 229

Technology Technology Metrics Infrastructure 229

Percona

JANUARY 17, 2023

The definition of Percona Advisors by ChatGPT is the following: Percona Advisors can help organizations implement robust security measures to protect their databases and sensitive data. For the sake of simplicity and speed, I will use Percona Operator for MySQL (based on Percona Server for MySQL which is in tech preview).

Database 111

Database Open Source Monitoring Testing 111

The Netflix TechBlog

JULY 22, 2024

A workflow definition is defined in a JSON format. Maestro combines user-supplied fields with those managed by Maestro to form a flexible and powerful orchestration definition. A Maestro workflow definition comprises two main sections: properties and versioned workflow including its metadata.

Strategy 260

Strategy Scalability Code Engineering 260

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 Database Storage Systems 185

SQL Shack

SEPTEMBER 6, 2021

In this article, we will explore in detail the factors that cause SQL Server stored procedures to be recompiled. Introduction SQL Server Stored procedures are the make-ready T-SQL codes that can be executed again and again by the database users to perform data manipulation commands and data definition commands.

Servers 90

Servers Database Code Performance 90

Percona

DECEMBER 13, 2024

Over the last few years, there have been many calls to evolve the Open Source Definition (OSD) to fit the modern world. Some would like to seenoncompetitive licenses such as the Server Side Public License (SSPL) or Elastic License considered open source.

Open Source 59

Open Source Software Software Servers 59

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 192

Lambda Media Open Source Metrics 192

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 233

Monitoring Metrics DevOps Scalability 233

The Netflix TechBlog

MAY 19, 2023

A cleanup process to prune stale relationships from the database. The community’s excitement and interest became apparent through comments, reactions, and conversations on the SpiceDB Discord server. SpiceDB is then responsible for figuring out which relations map back to the autoscaling group, e.g. name, environment, region, etc.

Cache 257

Cache Google Open Source Systems 257

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

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

Scalegrid

JUNE 14, 2024

Understanding Power BI Definition and Purpose Power BI is a business analytics service that can gather all your data in a single platform and enable users to analyze and visualize easily. Why connect Power BI to a MySQL Database? Enter the MySQL server address, port number, user name, and password. *

Database 130

Database Azure Efficiency Servers 130

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 122

Open Source Database Servers Scalability 122

Dynatrace

MAY 28, 2020

Keptn uses SLO definitions to automatically configure Dynatrace or Prometheus alerting rules. If you have a distributed environment with multiple servers hosting your webservers, app servers, and database, I suggest you install the OneAgent on all these servers to get full end-to-end visibility.

Engineering 200

Engineering Performance Metrics Best Practices 200

Percona

DECEMBER 9, 2024

First things first, a couple of definitions to clear up: ETL: Extract, Transform, Load. Transforms data before loading it into the target system extract raw data from various sources use a secondary processing server to transform that data load that data into a target database ELT: Extra, Load, Transform.

Performance 85

Performance Database Servers Processing 85

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

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 Servers Database Availability 117

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 102

Database Performance C++ Engineering 102

Dynatrace

APRIL 21, 2022

You can now enable a burn rate visualization during SLO creation either from the SLO wizard or from Service-level objective definitions by enabling Burn rate visualization enabled. Now you can extend your observability into data acquired from an Oracle Database using SQL queries. Burn rate visualization for service-level objectives.

Azure 228

Azure Metrics AWS Monitoring 228

Scalegrid

APRIL 5, 2024

Grasping the concept of Redis sharding is essential for expanding your Redis database. This method involves splitting data over various nodes to improve the database’s efficiency. Redis isn’t alone in utilizing sharding strategies — it’s a common concept found throughout database technologies to distribute workload efficiently.

Scalability 130

Scalability Efficiency Java Database 130

The Netflix TechBlog

JUNE 13, 2023

Migrating Critical Traffic At Scale with No Downtime — Part 2 Shyam Gala , Javier Fernandez-Ivern , Anup Rokkam Pratap , Devang Shah Picture yourself enthralled by the latest episode of your beloved Netflix series, delighting in an uninterrupted, high-definition streaming experience.

Traffic 287

Traffic Metrics Systems Strategy 287

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 109

Cache Hardware Servers Benchmarking 109

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 109

Database Servers Open Source Tuning 109

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

Database 126

Database Open Source Architecture Design 126

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 115

Availability Open Source Database Servers 115

SQL Performance

JUNE 9, 2021

That is, ones that are created as an object in the database, and stay there permanently unless dropped. In my examples I’ll use a sample database called TSQLV5. A table could be a base table defined as an object in the database, or it could be a table returned by an expression—more specifically, a table expression. USACustomers.

Database 140

Database Code Design Development 140

SQL Performance

SEPTEMBER 8, 2021

To understand the circumstances where you would want to use the CHECK OPTION as part of a view’s definition, we’ll first examine what can happen when you don’t use it. For years I used to think of the CHECK OPTION in a view as serving the same function as a CHECK constraint in a base table’s definition. CHECK OPTION. FastOrders.

Servers 130

Servers Code Engineering Database 130

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 101

Storage Database Engineering Open Source 101

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 128

Traffic Scalability Database Servers 128

SQL Performance

APRIL 8, 2020

As Grant repeatedly points out, many who use common table expressions in T-SQL think that SQL Server persists the inner query result set, and that the reason for this belief is the use of the term table in the construct's name. In my examples I'll use a sample database called TSQLV5. Physical data independence. Shippers. (

C++ 143

C++ Database Azure Servers 143

The Netflix TechBlog

NOVEMBER 4, 2019

Specifically, how our team uses the relationships and schemas defined within GraphQL to automatically build and maintain a search database. Each service could potentially implement its own search database, but then we would still need an aggregator. To act on the change, we need a GraphQL server that supports introspection.

Cache 115

Cache Database Servers Performance 115