Percona

APRIL 28, 2023

Let’s start with a simple introductory comparison: With proprietary (closed source) database software, the public does not have access to the source code; only the company that owns it and those given access can modify it. Myth #2: Proprietary databases are better and therefore more suitable for large enterprises.

Open Source 134

Open Source Database Software Software 134

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 132

Availability Database Open Source Hardware 132

Dynatrace

APRIL 15, 2022

At Dynatrace Perform 2022 , David Catanoso, acting director of cloud and edge solutions at the U.S. The agency executed one of the largest email migrations from on-premises Exchange servers to Microsoft Office 365 — moving almost 480,000 mailboxes to the cloud. “We used Dynatrace to monitor that large increase in servers.

Cloud 245

Cloud Infrastructure Innovation Monitoring 245

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 107

Database Artificial Intelligence Servers Operating System 107

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 111

Database C++ Servers Open Source 111

Dynatrace

MAY 23, 2022

IDC predicted, by 2022, 90% of all applications will feature microservices architectures that improve the ability to design, debug, update, and use third-party code. Generally speaking, monolithic architecture is composed of three parts: Database. This is usually a relational database management system. Server-side application.

Architecture 263

Architecture DevOps Monitoring Programming 263

Percona

MARCH 3, 2023

23] (Slave_delay: 0) This means the following: A primary server, with Percona Server for MySQL installed (in Read/Write mode) version 8.0.31-23. Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc. mysqlserver01=127.0.0.2 [RW] RW] [ver: 8.0.31-23]

Testing 124

Testing Database Servers Open Source 124

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++ 114

C++ Database Servers Open Source 114

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

JUNE 15, 2023

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. bullseye amd64 1.7

Servers 98

Servers C++ Database Systems 98

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 64

Open Source Azure Servers Database 64

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++ 115

C++ Database Servers Open Source 115

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 98

Open Source Database Servers Software 98

Scalegrid

APRIL 10, 2025

was released in July 2022, marking the beginning of its lifecycle. Managing Your MongoDB Server After End of Life Once a MongoDB version reaches its EOL, managing your MongoDB server requires proactive steps to ensure continued stability and security. provides numerous benefits that enhance database management and efficiency.

Best Practices 130

Best Practices Benchmarking Strategy Database 130

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. This update to the release of Percona Distribution for MySQL using the Percona Server for MySQL includes a new version of Percona Toolkit 3.5.1

Open Source 110

Open Source Storage AWS Cloud 110

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 131

Open Source Servers Engineering Testing 131

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

Dynatrace

APRIL 21, 2022

Starting with April 2022, Dynatrace is retiring TLS 1.0 Now you can extend your observability into data acquired from an Oracle Database using SQL queries. High memory usage or potential OutOfMemory if the server is running without Elasticsearch connection for a prolonged time. (APM-362484). Dynatrace news. Announcements.

Azure 246

Azure Metrics AWS Monitoring 246

Percona

JUNE 12, 2023

When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied. The obvious answer is this: To achieve high availability.

Architecture 123

Architecture Availability Open Source Hardware 123

Percona

MARCH 17, 2023

2022 was an exciting year for Percona Monitoring and Management (PMM). These updates are designed to keep databases running at peak performance and simplify database operations. Planning for resources of a PMM Server host instance can be tricky because the numbers can change depending on the DB instances being monitored by PMM.

Monitoring 117

Monitoring Scalability Database Cache 117

SQL Performance

JULY 13, 2022

This could also happen if you need to migrate code written for another database platform with a different dialect of SQL to T-SQL. The sample row’s order date is 2022-01-11, so the first delimiter is 2022-01-09. Since this date doesn’t exist in the data, the actual first delimiter is the next existing date, 2022-01-10.

C++ 112

C++ Code Azure Database 112

Percona

JANUARY 5, 2023

Recently, we performed a database engine major version upgrade in one of our customers’ environments from MySQL 5.7.26 To begin with, we upgraded all the database nodes from 5.7.26 Physical backups are being taken using Percona XtraBackup (PXB) so it does not lock the database during the backup. With MySQL 5.7, –lock-ddl.

Database 79

Database Servers Open Source Engineering 79

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. Percona Distribution for MySQL (Percona Server for MySQL-based variation) 8.0.32 It’s time for the release roundup!

Open Source 105

Open Source Servers Database AWS 105

The Netflix TechBlog

SEPTEMBER 29, 2022

Arrows link all the components touched during a typical Timestone client-server interaction. Every write request (see Step 1 — note that this includes dequeue requests since they alter the state of the queue) that reaches the cluster (Step 2) is persisted to a transaction log before a response is sent back to the server (Step 3).

Latency 221

Latency Systems Media Serverless 221

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 98

Storage Database Performance Open Source 98

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

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

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 70

Open Source C++ Servers Database 70

Percona

MARCH 27, 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. It is an open source database monitoring, management, and observability solution for MySQL, PostgreSQL, and MongoDB. Take a look!

Open Source 98

Open Source Servers Scalability Cache 98

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 98

Availability Open Source Architecture Database 98

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. What is PostgreSQL used for? Is PostgreSQL enterprise-ready?

Open Source 98

Open Source Healthcare Social Media Database 98

High Scalability

JUNE 22, 2018

Charlie Demerjian : what does Intel have planned for their server roadmap? For the same reason the 14/10nm messaging is causing consternation among investors, but the server side is in much worse shape. using them to respond to storage events on s3 or database events or auth events is super easy and powerful. How bad is it?

Internet 113

Internet Internet Scalability Artificial Intelligence 113

Smashing Magazine

MAY 25, 2022

2022-05-25T09:30:00+00:00. 2022-05-25T14:33:15+00:00. Caching is a great means of improving software performance — it could save the costs of database usage, third-party API calls, and server-to-server requests. Understanding Weak Reference In JavaScript. Understanding Weak Reference In JavaScript.

Cache 128

Cache Programming Storage Code 128

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. TDE can be applied at various levels, such as at the database, column, or cell level, depending on the organization’s specific security needs. Database-level encryption.

Database 94

Database Storage Servers Strategy 94

Percona

DECEMBER 21, 2023

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. A Query Execution Plan is the way a database chooses to run a specific query. The global default can be set at server startup. This variable has global and session values and can be changed at runtime.

Efficiency 126

Efficiency Database Open Source Performance 126

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++ 63

C++ Virtualization Database Benchmarking 63

HammerDB

DECEMBER 1, 2022

For example on Windows an example of opening a new database. Copyright (C) 2003-2022 Steve Shaw Type "help" for a list of commands Initialized new SQLite on-disk database C:/Users/Hdb/AppData/Local/Temp/hammer.DB If disabled, the SQLite repository database is not opened, and it is not possible to query any jobs related data.

Virtualization 58

Virtualization C++ Storage Database 58