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

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,

Database 72

Database Servers Open Source Engineering 72

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

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

Percona

DECEMBER 23, 2022

Patroni is one of the most used high availability (HA) solutions with the PostgreSQL database. This is one of the most used backup tool used for PostgreSQL databases. Both these open source tools have been saviors for DBAs for achieving high availability and performing restoration in ample ways.

Open Source 61

Open Source Servers Database Availability 61

Percona

APRIL 28, 2023

We are a company of open source proponents. We’re also dedicated and active participants in the global open source community. Both open source and proprietary options have advantages. With open source database software , anyone in the general public can access the source code, read it, and modify it.

Open Source 110

Open Source Database Software Software 110

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

Adrian Cockcroft

NOVEMBER 26, 2023

The Pantheon in Rome — Extremely sustainable architecture — photo by Adrian I wrote a medium post after AWS re:Invent 2022 summarizing the (lack of) news and all the talks related to Sustainability. Programs like Open Data on AWS provide free, publicly available datasets, accelerating sustainability innovation. AWS speaker: T.

AWS 52

AWS Energy IoT Best Practices 52

Percona

DECEMBER 19, 2022

Easily restore your MongoDB databases to a previous state. One of the core principles of our open-source philosophy is transparency, and we are committed to sharing our roadmap openly and transparently with our users. Some of the key highlights of PMM V2.33 Updated Grafana to version 9.2.5 In PMM 2.33.0, release notes.

Metrics 52

Metrics Monitoring Servers Open Source 52

Dynatrace

APRIL 22, 2022

As a solution, teams often adopt open source observability tools like OpenTelemetry to gain situational awareness of their cloud-native environments. In a session at Dynatrace Perform 2022, Kopp joins Tim Gerlach, Product Owner of APM at SAP Business Platform to describe how. However, adding more tools can add yet another silo.

Open Source 173

Open Source Metrics Cloud Tuning 173

Percona

JUNE 15, 2023

The reason might be application requirements, compatibility issues, or MySQL bug fixes, or we want the same MySQL version to be installed on all database instances in the cluster, regardless of what actually is the latest version available. bullseye [112 MB] …… (Reading database. deb (Reading database.

Servers 81

Servers C++ Database Systems 81

O'Reilly

AUGUST 8, 2023

I’m sure that nobody will be surprised that the number of searches for ChatGPT on the O’Reilly learning platform skyrocketed after its release in November, 2022. It’s a widely used platform for building applications that generate queries programmatically and that connects LLMs with each other, with databases, and with other software.

Artificial Intelligence 72

Artificial Intelligence Programming Games Open Source 72

Alex Russell

JUNE 22, 2022

In 2022, you can have any default you like, as long as it's as buggy as Safari. "Compatibility" Despite being largely open source, browsers and their engines are not loss leaders. US Government websites from macOS devices from March 6 th to April 4 th , 2022 " width="600" height="380" decoding="async" loading="lazy" />.

Engineering 110

Engineering Traffic Government Google 110

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

JANUARY 30, 2023

As Ibrar Ahmed noted in his blog post on Transparent Database Encryption (TDE). PostgreSQL is a surprising outlier when it comes to offering Transparent Database Encryption. If database files are copied or otherwise exposed in their raw form, exposure does not happen. Does PostgreSQL Need TDE (Transparent Data Encryption)?

Database 122

Database Storage Government Open Source 122

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. Take a look!

Open Source 61

Open Source Azure Database Servers 61

Smashing Magazine

AUGUST 19, 2022

2022-08-19T10:00:00+00:00. 2022-08-19T10:32:45+00:00. Well, there’s even an open-source project that literally handles authentication from the ground up. You can construct this sentence anyhow you deem fit, as long as it does not reveal that the email or username they entered exists in the database. Dynamic Routes.

Processing 110

Processing Best Practices Availability Open Source 110

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 104

Availability Database Open Source Hardware 104

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. Take a look!

Monitoring 52

Monitoring Open Source Database Servers 52

Dynatrace

FEBRUARY 16, 2023

To solve this problem, Dynatrace launched Grail, its causational data lakehouse , in 2022. These details include all the relationships among data from different sources—or cardinality. This unified approach enables Grail to vault past the limitations of traditional databases. Open source solutions are also making tracing harder.

Analytics 185

Analytics Innovation Metrics Database 185

Dynatrace

SEPTEMBER 23, 2021

They predicted this figure would jump to 75% by 2022. Application developers commonly leverage open-source software when building containerized applications. In fact, the market research firm Forrester says that the average container image is comprised of 70% open-source software.[1] Image scanners.

Open Source 250

Open Source Benchmarking Best Practices Network 250

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

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. that fixes the security vulnerability CVE-2022-32149. that fixes the security vulnerability CVE-2022-32149.

Open Source 81

Open Source Storage AWS Cloud 81

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 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Therefore, DBAs must take a piecemeal approach to achieve HA with PostgreSQL, bringing together open source extensions and tools from multiple sources.

Availability 81

Availability Open Source Architecture Database 81

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 93

Architecture Availability Open Source Healthcare 93

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. Before looking at the problematic query, I will walk you through a little detail about the optimizer.

Efficiency 100

Efficiency Database Open Source Performance 100

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 a mega list!

Open Source 75

Open Source Servers AWS Database 75

Percona

FEBRUARY 14, 2023

The final PostgreSQL 10 release was published on November 10, 2022, according to the PostgreSQL versioning policy page. While planning the database upgrade, remember that Percona offers a range of professional services from the top of market experts. Please remember that the final PostgreSQL 11 release is planned for November 9, 2023.

Open Source 83

Open Source Database Availability Design 83

Dynatrace

JUNE 25, 2021

As a strong supporter of open source and open standards, I’m aware that the wide availability of standards, open-source tools, and some newly coined terms are causing a lot of confusion. I also serve as co-chair of the W3C Distributed Tracing working group , which works on standards like W3C Trace Context.

Open Source 199

Open Source Monitoring Google Systems 199

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. Image Source.

Blockchain 59

Blockchain IoT Development Serverless 59

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

O'Reilly

NOVEMBER 28, 2023

16% of respondents working with AI are using open source models. If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” 16% of the respondents report that their companies are building on top of open source models.

Open Source 109

Open Source Artificial Intelligence Google Infrastructure 109

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

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

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.

Open Source 76

Open Source Servers Scalability Cache 76

Dotcom-Montior

FEBRUARY 19, 2022

For that reason, the tools and platforms that an SRE uses can vary greatly from organization to organization, especially in 2022. Best of all, it is open-source and has a large support community behind it. Golang, or Go, is an open-source programming language created by Google in 2009 that is used to create software programs.

Engineering 52

Engineering Open Source Programming Monitoring 52