Adrian Cockcroft

JANUARY 17, 2022

I’d even use it to manage datacenter failover or failover for other cloud vendors, as what you really need is a highly available control plane that is totally independent of your own failure modes. link] For 2022 my focus is on sustainability, and I’m planning to present at events?—?primarily primarily virtual?—?and

Serverless 98

Serverless Hardware AWS Architecture 98

Percona

JANUARY 5, 2023

In PostgreSQL, vacuuming is a maintenance task that helps to optimize database performance and reclaim space. PostgreSQL and other database management systems use MVCC to ensure consistent reads and prevent data loss from concurrent updates. It is essential to run a vacuum to keep the database running smoothly periodically.

Database 105

Database Performance C++ Efficiency 105

Percona

JULY 7, 2023

With the average cost of unplanned downtime running from $300,000 to $500,000 per hour , businesses are increasingly using high availability (HA) technologies to maximize application uptime. Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges.

Availability 81

Availability Open Source Architecture Database 81

Percona

DECEMBER 14, 2023

I don’t know, but certainly, the launching of ChatGPT at the end of 2022 sparked a huge hype explosion around that technology throughout this year. I played a bit with ChatGPT in February to see how it would respond to random database-related inquiries, and I found it pretty impressive and annoying at the same time.

Database 84

Database Artificial Intelligence Servers Operating System 84

Percona

DECEMBER 12, 2022

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. Today’s post includes those releases and updates that have come out since November 28, 2022. was released on December 8, 2022.

Open Source 61

Open Source Azure Database Servers 61

Percona

DECEMBER 27, 2022

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. Today’s post includes those releases and updates that have come out since December 12, 2022. was released on December 19, 2022.

Monitoring 52

Monitoring Open Source Database Servers 52

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 93

Database C++ Servers Open Source 93

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 73

Open Source Database Storage Scalability 73

Dynatrace

MAY 27, 2022

At Dynatrace Perform 2022 , David Walker, a Lockheed Martin Fellow, and William Swofford, a full-stack engineer at Lockheed Martin, discuss how to create a self-diagnosing and self-healing IT server environment using this AIOps combination for auto-baselining, auto-remediation, monitoring as code, and more.

Artificial Intelligence 186

Artificial Intelligence Innovation Servers Database 186

Percona

DECEMBER 12, 2022

Table modifications are a common task for database administrators. 2022-12-09T05:44:23 Dropping new table. 2022-12-09T05:44:23 Dropped new table OK. 2022-12-09T05:57:10 Creating triggers. 2022-12-09T05:57:10 Created triggers OK. 2022-12-09T05:57:10 Copying approximately 10023 rows. Dry run complete.

Database 58

Database Engineering Testing Processing 58

Enprowess

JANUARY 12, 2022

The Top web development trends in 2022. Let’s dive deep into the top website development trends to expect in 2022. To make it easier for you, in this blog, we will discuss the latest web development trends that will evolve in 2022. List of Top Web Development Trends to Track in 2022. Single Page Applications (SPAs).

Blockchain 59

Blockchain IoT Development Serverless 59

Dynatrace

FEBRUARY 16, 2023

To solve this problem, Dynatrace launched Grail, its causational data lakehouse , in 2022. This unified approach enables Grail to vault past the limitations of traditional databases. And without the encumbrances of traditional databases, Grail performs fast. “In Logs on Grail Log data is foundational for any IT analytics.

Analytics 185

Analytics Innovation Metrics Database 185

Dynatrace

FEBRUARY 7, 2022

Starting with April 2022, Dynatrace is retiring TLS 1.0 General Availability (Build 1.234.107). General Availability (Build 1.234.107). Service and database list now displays correct value aggregation. Dynatrace news. Dynatrace SaaS release notes version 1.234. Announcements. end-of-support for RUM data. Resolved issues.

Infrastructure 192

Infrastructure Metrics Database Availability 192

Dynatrace

FEBRUARY 28, 2024

To that end, in 2022, Dynatrace released Grail , the auto-indexing, schema-on-read data lakehouse, along with Notebooks and Dashboards. Then when you have the metric, you want to explore it—what splits are available, how can I break it down, how can I aggregate it, and so on.” Discovery using the “explore data” interface.

Analytics 209

Analytics Metrics Media Monitoring 209

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

Percona

JANUARY 9, 2023

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. Today’s post includes those releases and updates that have come out since December 27, 2022. was released on December 28, 2022.

Open Source 84

Open Source Database Servers Software 84

Percona

MARCH 3, 2023

Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc. The person who tried to run this in production did not do the following: Run some previous backups of the rows to delete. Check if the table had referential integrity, child tables. Check the size of the table.

Database 96

Database Testing Servers Open Source 96

Dynatrace

JANUARY 20, 2022

Starting with April 2022, Dynatrace is retiring TLS 1.0 See Available metrics. New request attributes are now available: DL/I DB/LTERM name. DL/I segment name for DL/I databases. General Availability (Build 1.233.94). General Availability (Build 1.233.94). Dynatrace news. Announcements. Masking v1.

Lambda 180

Lambda AWS Metrics Azure 180

Dynatrace

FEBRUARY 2, 2023

In October 2022, Dynatrace and Microsoft extended their deep integration to include metrics and topology from Azure Monitor. This includes Azure services such as App Services & Functions, Azure Databases, Azure Load Balancers, Azure Storage, and many more (see the complete list of services ).

Azure 224

Azure Cloud Monitoring Metrics 224

Percona

MARCH 8, 2023

Over the years of being a DBA, I had to deal with all kinds of problems in the database. Still, the users keep falling into this trap, maybe because of a poorly configured database, a change in the application components, or just because of a sudden increase of connections in the application. A lot has been written about this error.

C++ 90

C++ Database Servers Open Source 90

Percona

JULY 3, 2023

Partitioning is the concept of splitting large tables logically into smaller pieces for better performance of the database. However, a rule of thumb is that the size of the table should exceed the physical memory of the database server. The exact point at which a table will benefit from partitioning depends on the application.

Storage 80

Storage Database Performance Open Source 80

Percona

DECEMBER 23, 2022

Patroni is one of the most used high availability (HA) solutions with the PostgreSQL database. It uses a Distributed Configuration Store (DCS) to keep the configuration in a centralized location available for all nodes making it an easy-to-use and reliable HA solution available in the market today.

Open Source 61

Open Source Servers Database Availability 61

Percona

JANUARY 30, 2023

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. was made available on January 23, 2023. that fixes the security vulnerability CVE-2022-32149. Take a look! Percona Toolkit 3.5.1

Open Source 81

Open Source Storage AWS Cloud 81

Percona

FEBRUARY 14, 2023

The final PostgreSQL 10 release was published on November 10, 2022, according to the PostgreSQL versioning policy page. There won’t be any public builds available from both community and Percona for bugs or security fixes. Please remember that the final PostgreSQL 11 release is planned for November 9, 2023.

Open Source 83

Open Source Database Availability Design 83

HammerDB

DECEMBER 14, 2022

The TPC publishes an official Docker image on Docker Hub to enable the rapid deployment and testing of databases with HammerDB. This image includes example scripts to build schemas and test your databases with a single command. hammerdb>librarycheck Checking database library for Oracle Success. Database Configuration.

C++ 62

C++ Virtualization Database Benchmarking 62

Percona

DECEMBER 5, 2022

The need to audit who is using a database and their activities is crucial in many environments. This functionality is available in the free, open source Audit Plugin that is included in Percona Server for MySQL. The prerequisite for installing Percona’s Audit Log Plugin is to first install Percona Server for MySQL.

Open Source 67

Open Source C++ Servers Database 67

SQL Performance

JULY 13, 2022

But sometimes a tool you need isn’t available, and you have to figure out a solution without it. Sometimes, you need to solve a T-SQL querying task, and you know the natural tool to solve it is a feature that’s part of the SQL standard but isn’t available in T-SQL. So you have to come up with a supported alternative. orderid , O1.

C++ 112

C++ Code Azure Database 112

HammerDB

MAY 26, 2022

If you are not already familiar with the programming languages that HammerDB uses, then this earlier post serves as an ideal introduction to what makes up the highest performing GIL free database benchmarking application. The database installation must include both the include and lib directories. linux-glibc2.12-x86_64/bin.

C++ 113

C++ Database Open Source Servers 113

Dynatrace

MAY 19, 2022

As the project matures, more robust sources for flag configuration could be used, perhaps a simple REST API, database, or structured configuration file. OpenFeature is under development, and as part of the industry consortium, we’re planning a general availability release for Fall 2022. What’s next?

Java 256

Java Cloud Code Technology 256

Percona

DECEMBER 2, 2022

Database-as-code service is a new concept and gaining some popularity in recent years. Now this concept is applied in the database domain as well, assuming SQL as a code to manage database changes (DDL, DML) the same way that applications handle code. To specifically list database changes in order, Liquibase employs a changelog.

Database 55

Database Java Open Source Code 55

SQL Performance

OCTOBER 18, 2022

Before SQL Server 2022, there was a workaround that enabled relying on index order, but besides being quite ugly, it had its cost, and the tradeoff wasn’t always acceptable. SQL Server 2022 introduces new ways to apply time-based grouping using the DATE_BUCKET and DATETRUNC functions.

Servers 144

Servers Code Best Practices Database 144

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. Most recently, in StackOverflow’s 2022 Stack Developer Survey , PostgreSQL took a slight lead over MySQL (46.48% to 45.68%) as the most popular database platform among professional developers. How-to documentation is readily available.

Open Source 76

Open Source Healthcare Social Media Database 76

Percona

DECEMBER 2, 2022

If there are multiple archive libraries available, we can switch from one library to another when the system is live. 2022-11-24 11:24:31.330 UTC [2323] ERROR: could not create file "/home/postgres/arch2/archtemp.00000001000000000000007B.2323.1669289071330": 00000001000000000000007B.2323.1669289071330": 00000001000000000000007B.2323.1669289071330,

Servers 85

Servers Systems Processing Database 85

InfoQ

JULY 14, 2023

Mei-Chin Tsai, Vinod discuss the internal architecture of Azure Cosmos DB and how it achieves high availability, low latency, and scalability. By Mei-Chin Tsai, Vinod Sridharan

Latency 52

Latency Azure Availability Scalability 52

Percona

APRIL 4, 2023

When executing the query, Perl was trying to quote an empty string instead of the bit representation of 0, causing the tool to fail (note this is output from the locally reproduced dummy schema/data): 2022-10-18T14:19:02 0 0 DBD::mysql::st execute failed: Truncated incorrect DOUBLE value: '' [for Statement "DELETE FROM `myd_test`.`gerald`

Open Source 104

Open Source Servers Engineering Scalability 104

Percona

APRIL 10, 2023

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. This update includes a fix to the security vulnerability CVE-2022-25834 with PXB-2977. It’s time for the release roundup!

Open Source 75

Open Source Servers AWS Database 75

Percona

MARCH 28, 2023

Every database system has to ensure durability and reliability. 33: Sun Mar 26 08:35:59 2022 (size 8 KB) file-size: 8 KB, checkpoint-size: 4 KB offset, size, checksum root : 8192, 4096, 3824871989 (0xe3faea35) alloc: 12288, 4096, 4074814944 (0xf2e0bde0) discard : 0, 0, 0 (0) available : 0, 0, 0 (0) WiredTigerCheckpoint.34:

Hardware 85

Hardware C++ Storage Cache 85