Dynatrace

OCTOBER 13, 2021

Examples of such weaknesses are errors in application code, misconfigured network devices, and overly permissive access controls in a database. NMAP is an example of a well-known open-source network scanner. That said, vulnerability databases such as CVE , help identify known vulnerabilities. Analyze findings.

Infrastructure 165

Infrastructure Open Source Virtualization Operating System 165

Percona

FEBRUARY 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’s an open source database monitoring, management, and observability solution for MySQL, PostgreSQL, and MongoDB.

Monitoring 68

Monitoring Open Source Database Software 68

Percona

SEPTEMBER 20, 2023

As a MySQL database administrator, you’re likely familiar with the SHOW REPLICA STATUS command. By grasping these key binlog coordinates, you can confidently manage MySQL replication, resolve issues efficiently, and keep your databases in sync. Download Percona Monitoring and Management Today

Open Source 81

Open Source Monitoring Database Architecture 81

Percona

APRIL 20, 2023

It should be noted that while the technical aspects of the upgrade process are beyond the scope of this blog post, it is crucial to create a testing environment to verify the upgrade before proceeding to upgrade your production servers, particularly with MySQL 8.

Open Source 88

Open Source Best Practices Servers Database 88

Percona

JULY 31, 2023

Support for Various SQL Statements: SQL statements can be executed using prepared statements, including statements like DROP DATABASE, TRUNCATE TABLE, FLUSH TABLES, and KILL. You should consider implementing some additional testing and error handling to help mitigate this issue. Download Percona Monitoring and Management Today

Open Source 79

Open Source Database Monitoring Development 79

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 102

Performance Monitoring Traffic Database 102

Percona

DECEMBER 7, 2023

Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our open source backup solution for all versions of MySQL, is designed to make backups a seamless procedure without disrupting the performance of your server in a production environment. and Percona XtraBackup 2.4

C++ 91

C++ Open Source Servers Database 91

Percona

AUGUST 4, 2023

Percona has bundled together some great open source pieces of software to create Percona Monitoring and Management (PMM), a very flexible and powerful monitoring solution. If you have deployed PMM, chances are you have an application using a database like MySQL or PostgreSQL. Download Percona Monitoring and Management Today

Monitoring 74

Monitoring Open Source Database Metrics 74

HammerDB

JULY 17, 2019

A very common request is for HammerDB to add support for a new database. Before reaching out with a request your first reference should be the DB-Engines Ranking to gauge the relative popularity of a database. Therefore this series of posts explains how any contributor can add support for a new database in HammerDB.

Database 44

Database Open Source Code Testing 44

Percona

DECEMBER 19, 2023

TOKEN: xoxb-5840606778679-6229228252662-teofbDQUiFCnrp3cZT08epyL ## Bot Api Token Recipient: test ###channel name On successful testing we should see some test alerts. BOT API TOKEN: 6396505873:AAEQT5DCFAlzpqqdh9p69YwiQermTespfDA CHAT ID: -4013864418 On successful testing we should see some test alerts.

Monitoring 87

Monitoring Database Open Source Java 87

Percona

SEPTEMBER 29, 2023

Let’s test this. To test this, create a new user, “app_user,” with only the privileges for DDL/DML. beta2) Running the test with following options: Number of threads: 10 Initializing random number generator from current time Initializing worker threads. Download Percona Monitoring and Management Today

C++ 93

C++ Servers Open Source Database 93

Percona

JANUARY 26, 2023

The author of this bug, Markus Winand, is well-known in the database world and wrote a beautiful, clear example of reporting a bug. He describes the problem, identifies the error, and provides a test script. And then comes an indication that he really has tested this issue. I would encourage you to test your non-8.0.32

Database 95

Database Open Source Monitoring Testing 95

Percona

FEBRUARY 13, 2023

I recreated the issue in my lab with a simple create database statement, as you will see below. Default database: 'lab'. Query: 'create database test' The interesting thing to note here is the character set ‘#255’. Download Percona Distribution for MySQL Today for the UTF8MB4 character set.

Database 87

Database AWS Open Source Servers 87

Scalegrid

MAY 22, 2020

This way, the load on the master is tremendously reduced, and at the same time, the binlog server serves the binlogs more efficiently to slaves since it does not have to do any other database server processing. Ripple is an open source binlog server developed by Pavel Ivanov. That’s the report for now from my quick testing.

Servers 262

Servers Transportation Database Availability 262

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. And did I mention they are open source?!

Cache 97

Cache Database Virtualization Servers 97

HammerDB

JULY 14, 2021

However, as the two databases diverged from a shared common codebase, this presented a challenge in that it was not possible to modify the workload for MySQL or MariaDB without also changing the other. Also, the additional installation of the MySQL client libraries was needed when testing MariaDB. Prior to HammerDB v4.2 HammerDB v4.2

Testing 57

Testing C++ Virtualization Tuning 57

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

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. Conclusion.

Open Source 67

Open Source C++ Servers Database 67

Percona

JUNE 27, 2023

Percona Alerting was introduced in Percona Monitoring and Management (PMM) 2.31, and it brought a range of custom alerting templates that makes it easier to create Alert rules to monitor your databases. At this point, you can go ahead and test your configuration using the “Test” button on the contacts point settings page.

Monitoring 75

Monitoring Open Source Database Servers 75

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52

Percona

APRIL 17, 2023

Still, as DBA, you want to use Percona Monitoring and Management (PMM) for better database insights and maintain a common policy of Datadog as a standard alerting or high-level observability tool. We’ll use here “up” metrics for different databases to reflect database status. We are looking for your feedback.

Monitoring 69

Monitoring Metrics Database Open Source 69

Percona

NOVEMBER 9, 2023

Again, demonstrating it by example, let’s see how much of an impact correctly sizing the shared_buffers has on our test workload. Percona Monitoring and Management is a best-of-breed open source database monitoring solution. Download Percona Monitoring and Management Today

Monitoring 88

Monitoring Tuning Metrics Servers 88

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. Download specific Percona Server for MySQL 8 tarball packages and install them manually. Let’s start and test on Debian 11. bullseye [112 MB] …… (Reading database.

Servers 82

Servers C++ Database Systems 82

Percona

APRIL 6, 2023

In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to get not only metrics and queries from our database servers but also text-based information like logs. Download Percona Monitoring and Management Today Loki is a log aggregation tool developed by Grafana Labs.

Monitoring 85

Monitoring Servers Metrics Database 85

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. So to test I took a system with Skylake CPUs and all storage on a P4800X SSD. In the recent MySQL 8.0.16

Testing 48

Testing Tuning Latency Storage 48

Percona

DECEMBER 14, 2023

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. significantly enhanced downgrade compatibility by introducing changes that make it easier for downgraded databases to interoperate with older MongoDB versions.

Database 84

Database Artificial Intelligence Servers Operating System 84

Scalegrid

SEPTEMBER 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. Why Use a GUI Tool?

Open Source 262

Open Source Database Azure Cloud 262

Percona

FEBRUARY 2, 2023

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 121

Database Servers Testing Programming 121

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 114

Database Open Source Traffic Small Business 114

Percona

OCTOBER 16, 2023

In the spirit of open and transparent communication, we would appreciate your feedback and invite PostgreSQL users to test the extension and provide feedback either via the GitHub repository or in the forum. This is something that is available in other databases but not provided in upstream, vanilla Postgres. What is TDE?

Open Source 109

Open Source Testing Database Design 109

Percona

SEPTEMBER 13, 2018

Download the slow log(s) that match the time that you are interested to investigate, and optionally concatenate them. Run pt-query-digest on the downloaded logs and check the results. Download the log file. Depending on the size of the chosen log file, the above command will take some time to complete the download.

C++ 42

C++ AWS Open Source Testing 42

Percona

OCTOBER 19, 2023

In this guide, we will demonstrate how to establish a Citus database spanning multiple nodes by using Percona Distribution for PostgreSQL. This setup empowers your database to efficiently manage increased data volumes, enhance performance, and maintain availability. Use the following procedure for all the three nodes. 1ubuntu1~20.04.1)

Scalability 83

Scalability Database Open Source Traffic 83

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 123

Database Storage Government Open Source 123

Percona

DECEMBER 18, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download Percona Monitoring and Management 2.41.0 Take a look.

Monitoring 84

Monitoring Open Source Servers Scalability 84

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

Percona

AUGUST 2, 2023

Restoring a MySQL database backup is a crucial task that can sometimes be time-consuming, especially for large databases. Linux native Input/Output (I/O) statistics Pipe viewer utility By following these approaches, we can effectively monitor the restoration process and manage your MySQL database restoration efficiently.

Database 81

Database Monitoring C++ Speed 81