Percona

JULY 10, 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. Today’s post includes those releases and updates that have come out since June 26, 2023.

Monitoring 75

Monitoring Open Source Scalability Database 75

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

MAY 29, 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. Today’s post includes those releases and updates that have come out since May 8, 2023.

Open Source 75

Open Source Servers Scalability Database 75

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 82

Availability Open Source Architecture Database 82

Percona

OCTOBER 10, 2023

Assuming that there is already a Secrets object holding all system user passwords, the concept is really simple. Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02

Database 92

Database Performance C++ Engineering 92

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. Today’s post includes those releases and updates that have come out since January 9, 2023. was made available on January 23, 2023.

Open Source 81

Open Source Storage AWS Cloud 81

Percona

JULY 24, 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. Today’s post includes those releases and updates that have come out since July 10, 2023.

Open Source 71

Open Source Scalability Database Monitoring 71

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 110

Open Source Database Software Software 110

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. was released on January 6, 2023. The InnoDB_doublewrite system has two new settings: DETECT_ONLY. Take a look!

Open Source 84

Open Source Database Servers Software 84

Dynatrace

APRIL 10, 2023

And according to recent data from Enterprise Strategy Group, 59% of survey respondents indicated spending on public cloud applications would increase in 2023. discussed the 85-year-old retailer’s cloud migration journey and the importance of multicloud observability at Dynatrace Perform 2023. Further, as Tractor Supply Co.

Cloud 176

Cloud Ecommerce Performance Retail 176

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 89

Open Source Database Hardware Strategy 89

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

Dynatrace

JULY 11, 2023

The MOVEit vulnerability is a critical SQL injection flaw in the web application MOVEit Transfer , which MITRE published as CVE-2023-34362 on May 31, 2023. When exploiting the vulnerability, attackers can gain remote code injection capabilities in the MOVEit server and modify or steal sensitive data from its database.

Database 163

Database Government Games Servers 163

Dynatrace

JANUARY 31, 2024

Monitoring SAP products can present challenges Monitoring SAP systems can be challenging due to the inherent complexity of using different technologies—such as ABAP, Java, and cloud offerings—and the sheer amount of generated data. SAP Basis teams have established best practices for managing their SAP systems.

Java 194

Java Analytics Best Practices Monitoring 194

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. 1ubuntu1~20.04.1) 1ubuntu1~20.04.1)

Scalability 82

Scalability Database Open Source Traffic 82

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. In this blog post, we dig into the steps to track down the DROP statements in our database server. sec) We will narrow down the events to log only the drop events for the database-related objects. How does it work?

Servers 81

Servers Database Open Source Scalability 81

Percona

DECEMBER 29, 2023

Not everything can be addressed on the database side. Unrestricted connection settings: Leaving connection settings, such as max_connections and per-user limits, wide open exposes the system to malicious Denial-of-Service (DoS) attacks. App-Dev often demands unrestricted, uncontrolled access to the database.

Servers 78

Servers Database C++ Airlines 78

Percona

OCTOBER 11, 2023

Atlas atlas-mhnnqy-shard-0 [primary] test> To install MongoShake, follow these steps: Step 1: Install Go Ensure that Go is installed on your system. Below is the sample log when you start MongoShake: [2023/09/25 21:09:13 UTC] [INFO] New session to mongodb+srv://gautam: @cluster0.teeeayh.mongodb.net/ cd MongoShake.

Database 84

Database Open Source Testing Servers 84

Percona

JUNE 26, 2023

We have faced different levels of corruption related to databases in PostgreSQL. So we need to check whether this base / 16384 / 16391 file is available in / base location.

Hardware 73

Hardware C++ Database Open Source 73

Dynatrace

MAY 17, 2023

For that, we focused on OpenTelemetry as the underlying technology and showed how you can use the available SDKs and libraries to instrument applications across different languages and platforms. We’d like to get deeper insight into the host, the underlying operating system, and any third-party services used by our application.

Metrics 176

Metrics Monitoring Database Network 176

Percona

NOVEMBER 30, 2023

pgBackRest is the backup tool used to perform Postgres database backup, restoration, and point-in-time recovery (PITR). In this demonstration, it is assumed that the pgBackRest is already installed and configured on the dedicated backup node and configured to take backups from the remote database node.

Open Source 76

Open Source Database Processing Performance 76

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. Check the available Percona Server for MySQL 8.0 bullseye amd64 1.7 13+deb11u6).

Servers 82

Servers C++ Database Systems 82

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning?

Tuning 52

Tuning Efficiency Database Performance 52

Dynatrace

MAY 8, 2023

In fact, the Dynatrace 2023 CIO Report found that 78% of respondents deploy software updates every 12 hours or less. The process involves monitoring various components of the software delivery pipeline, including applications, infrastructure, networks, and databases. Help systems meet SLAs.

DevOps 225

DevOps Efficiency Monitoring Infrastructure 225

Percona

DECEMBER 12, 2023

sec) mysql> select * from test_tab; select * from test_tab_log; + -+ --+ + | id | test_data | op_time | + -+ --+ + | 1 | lt1 | 2023-11-26 09:59:19 | + -+ --+ + 1 row in set (0.00 sec) + -+ --+ -+ + | id | test_data | op_user | op_time | + -+ --+ -+ + | 1 | lt1 | root@localhost | 2023-11-26 09:59:19 | + -+ --+ -+ + 1 row in set (0.00

Servers 88

Servers Database Testing Open Source 88

Percona

JULY 17, 2023

MongoDB Community Edition software might set the stage for achieving your high-volume database goals, but you quickly learn that its features fall short of your enterprise needs. The popularity of MongoDB MongoDB has emerged as a popular database platform. 5 among all database management systems and No. It ranks No.

Open Source 74

Open Source Database Scalability Software 74

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database.

Tuning 52

Tuning Database Performance Hardware 52

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. As a MongoDB user, it’s crucial to ensure that your data is safe and secure in the event of a disaster or system failure. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups.

Best Practices 52

Best Practices Database Storage Servers 52

Dynatrace

DECEMBER 21, 2023

You might optimize your cooling system or move your data center to a colder region with reduced cooling demands. Reduce the volume of data volumes requested from databases (for example, request all, filter in memory). Next, we consider possible energy savings in the data center. Reduce inter-process communications overhead.

Cloud 214

Cloud Energy Best Practices Cache 214

Percona

AUGUST 30, 2023

In this blog, I am trying to list the options available for users and list them in increasing order of priority. This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. cat /usr/lib/systemd/system/postgresql-14.service. The purpose is to give a high-level view to users.

Database 99

Database Servers Open Source Tuning 99

Percona

DECEMBER 20, 2023

we have been able to resize the InnoDB buffer pool online, which allows administrators to adjust the buffer pool size dynamically without requiring a server restart, offering a flexible solution for optimizing system resources. This is available only for the log_error_verbosity=3.

Monitoring 84

Monitoring Code Open Source Cache 84

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What are the differences between Aurora and RDS?

AWS 52

AWS Database Serverless Storage 52

Official Blog - World Web Technology

APRIL 12, 2023

Because WordPress is one of the most preferred content management systems to develop highly user-friendly, competitive, and dynamic websites. Of all websites available across the globe, WordPress powers more than 65.1%. There are more than 59,208 WordPress plugins available as of now. Why WordPress?

Development 52

Development Website Ecommerce Programming 52

Official Blog - World Web Technology

JUNE 13, 2023

A WordPress developer should also be good at various content management systems such as Joomla and Drupal. It includes downloading and setting up the software on a server, database configuration, and theme and plugin installation. Mostly, clients choose themes and plugins from available resources. There is no other option.

Development 52

Development Website Ecommerce Code 52

Percona

DECEMBER 27, 2023

As we at Percona wind down 2023 and look into what the next year holds, our attention is drawn to the cloud-native landscape and how it is maturing, growing, and evolving. KubeCon NA 2023 recap The theme for KubeCon NA was very clear — AI and Large Language Models (LLMs).

Cloud 77

Cloud Open Source Strategy Best Practices 77

Percona

OCTOBER 17, 2023

Many changes and new features are brought to the system, and as part of keeping in tune with the changes and how they can impact us, we go through the changes to better understand them. As almost a tradition, a newer major release of MongoDB is born every year, and this year, it’s no different. From that, this article is born.

Metrics 98

Metrics C++ Storage 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. How-to documentation is readily available.

Open Source 76

Open Source Healthcare Social Media Database 76