Percona

OCTOBER 10, 2023

Performing an operation is always challenging when dealing with K8s. You can perform a DIRECT ALTER, use a tool such as pt-osc, or even, for certain cases where async replication is in use, perform changes on replicas and failover. You can just connect to the MySQL service POD and perform the ALTER. drop_triggers:10000:0.25,copy_rows:10000:0.25,swap_tables:10000:0.25,update_foreign_keys:10000:0.25,analyze_table:10000:0.25

Database 97

Database Performance C++ Engineering 97

Percona

DECEMBER 15, 2022

JSON data and relational databases have traditionally been diametric opposites. So many folks were surprised when relational databases started adding a JSON data type to their products. In this multi-part blog series, we will start with an overview of using JSON in a relational database. JSON is popular. Very popular.

Database 91

Database Servers Processing Efficiency 91

Percona

JULY 31, 2023

Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the database has little or no effect on the data quality.

Database 76

Database Open Source Servers Code 76

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 94

Open Source Database Hardware Strategy 94

Scalegrid

JULY 17, 2019

July 17, 2019 – ScaleGrid, a leader in the Database-as-a-Service (DBaaS) space, has just announced support for PostgreSQL hosting in the cloud. The database is also widely loved for PostgreSQL extensions which enable users to extend the functionality of their database. PALO ALTO, Calif.,

Azure 182

Azure AWS Open Source Database 182

Percona

DECEMBER 4, 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. Find more information in the Telemetry on Percona Server for MySQL document.

Open Source 81

Open Source Azure Servers Programming 81

Dynatrace

OCTOBER 6, 2022

OpenTelemetry is an exciting open source observability standard that provides a common collection of tools, APIs, and SDKs to help collect observability signals. You can ingest OpenTelemetry data in two ways: using Dynatrace OneAgent technology or using OpenTelemetry Protocol (OTLP), which relies exclusively on open source technology.

Open Source 171

Open Source Metrics Tuning Technology 171

HammerDB

APRIL 19, 2023

Predicting application performance is a difficult art, but an important one when choosing the target deployment environment. Among the different components of modern software solutions, the database is one of the most critical. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench.

Performance 54

Performance Benchmarking Cache Storage 54

Percona

JANUARY 3, 2024

A couple of weeks ago, we announced the first GA release of the PMM Dump : a new support tool that dumps Percona Monitoring and Management (PMM) metrics and Query Analytics (QAN) data to transfer to the expert engineer for review and performance suggestions. After you create multiple dumps, you may want to perform bulk actions on them.

Monitoring 92

Monitoring Open Source Database Servers 92

Dynatrace

FEBRUARY 10, 2021

The latest enhancement enables our customers to automatically detect and assess open-source and third-party vulnerabilities in Node.js and Java workloads are automatically detected at runtime along the entire dependency tree of open-source and third-party libraries. To learn more, see the documentation.

Java 242

Java Open Source Engineering Database 242

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 80

Open Source Healthcare Social Media Database 80

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. Take a look. Percona Monitoring and Management 2.38.1 was released.

Open Source 74

Open Source Scalability Database Monitoring 74

Percona

JUNE 30, 2023

Percona, a leading provider of open-source database software and services, announced the general availability of Percona Operator for PostgreSQL version 2. The solution is 100% open source and automates the deployment and management of PostgreSQL clusters on Kubernetes. Please refer to our documentation.

Availability 95

Availability Open Source Azure Hardware 95

Percona

JUNE 9, 2023

I will assume you already have an environment set up and running in which the PMM client is already monitoring the PostgreSQL database. If needed, refer to the online documentation on this: [link] Adding the Patroni metrics to PMM Since version 2.1.0, Download Percona Monitoring and Management Today

Monitoring 127

Monitoring Metrics Open Source Database 127

Percona

MARCH 7, 2023

The goal is to simplify the provisioning and management of database capacity. It’s an open source alternative to AWS Aurora Postgres that utilizes a serverless architecture. This is because the compute nodes are stateless in this architecture, meaning they can be scaled without affecting the system’s performance.

Serverless 112

Serverless Storage Open Source Architecture 112

Official Blog - World Web Technology

AUGUST 27, 2023

It is a server-side scripting language that is highly secure, open-source, and versatile. PHP is Open Source Language The most important thing for a business is to optimize costs to make operations more cost-effective and improve profit margins. You can use PHP limitlessly.

Development 98

Development Ecommerce Open Source Website 98

Percona

OCTOBER 10, 2023

Databases are different from a lot of software. This is not a general rule, but as databases are responsible for a core layer of any IT system – data storage and processing — they require reliability. Think of us as the extra set of eyes, the extra layer of QA to ensure your safety passage to the next database version.

Availability 101

Availability Servers Database Open Source 101

Percona Community

JANUARY 3, 2023

Percona’s XtraBackup is a beautiful tool that allows for the backup and restoration of MySQL databases. From the documentation: The Percona XtraBackup tools provide a method of performing a hot backup of your MySQL data while the system is running.

Open Source 58

Open Source Database Servers Systems 58

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

C++ 95

C++ Open Source Servers Database 95

Scalegrid

JANUARY 3, 2020

Monitoring your MySQL database performance in real-time helps you immediately identify problems and other factors that could be causing issues now or in the future. It’s also a good way to determine which components of the database can be enhanced or optimized to increase your efficiency and performance.

Monitoring 164

Monitoring Metrics Servers Database 164

Percona

DECEMBER 29, 2022

While working as a DBA, we perform many regular tasks, and one of them is upgrading our database systems. There are some techniques to perform a PostgreSQL database upgrade, such as data dump and import, logical replication, or in-site upgrade using pg_upgrade. ii postgresql-11 11.18-1.pgdg20.04+1

C++ 82

C++ Open Source Database Programming 82

Percona

SEPTEMBER 26, 2023

As MySQL database administrators, we are well aware of the significance of implementing a primary key within a table. Primary keys play an indispensable role in sound database design by uniquely identifying individual rows and significantly enhancing data retrieval, manipulation, and overall system performance.

Database 102

Database Engineering Best Practices Open Source 102

Dynatrace

NOVEMBER 16, 2021

The dashboard was built during my recent Performance Clinic on k8s monitoring at Scale with Prometheus and Dynatrace. Prometheus is an open-source software toolkit used for event monitoring and alerting. Prometheus is an open-source software toolkit used for event monitoring and alerting. What is Prometheus?

Metrics 200

Metrics Infrastructure Open Source Database 200

Percona

SEPTEMBER 28, 2023

Memory Our usual recommendation is to use specific memory parameters, which we suggest to ensure optimal performance. Changing the value directly influences the performance of the Linux system. This can negatively impact performance and cause delays. If you haven’t, please install it ( Percona Toolkit documentation ).

Servers 114

Servers Best Practices Database Open Source 114

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. Percona Monitoring and Management is a best-of-breed open source database monitoring solution.

Monitoring 78

Monitoring Open Source Database Servers 78

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

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.

Open Source 76

Open Source Database Storage Scalability 76

Percona

AUGUST 1, 2023

In the world of database management, ALTER TABLE operations are a crucial part of modifying database structures. MySQL, a popular database management system, offers online operations since version 5.6, providing a convenient way to perform these alterations without locking the table. However, there are caveats.

Storage 81

Storage Database Open Source Engineering 81

Percona

APRIL 19, 2023

The Performance Shema now has a Server Telemetry Traces service. We are directed to the Server telemetry traces service section in the MySQL Source Code documentation The SSL library has been updated to OpenSSL version 1.1.1t. Hopefully, UTF8MB4 is good enough. Try Percona Distribution for MySQL today!

Open Source 94

Open Source Servers Scalability Database 94

Percona

JANUARY 19, 2023

While the technologies have evolved and matured enough, there are still some people thinking that MySQL is only for small projects or that it can’t perform well with large tables. With disks being faster nowadays and CPU and memory resources being cheaper, we could easily say MySQL can handle TBs of data with good performance.

Open Source 90

Open Source Storage Database Big Data 90

Percona

NOVEMBER 9, 2023

These graphs and panels not only show changes in usage and workload patterns but also changes in configuration, which can help during root cause analysis and performance reviews. WAL usage section The last section pertains to write-ahead logs, which are another source of potential performance bottlenecks.

Monitoring 91

Monitoring Tuning Metrics Servers 91

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

SEPTEMBER 12, 2023

If the changes are not made considering the necessary precautions, you may face unwanted outages on the database that can cause serious problems to your business. Another important fact to consider is that having a metadata lock on a highly concurrent table can cause major locking issues in the database and can cause outages.

Database 88

Database Traffic Open Source Monitoring 88

Percona

AUGUST 3, 2023

As an experienced database developer, you should know that these kinds of queries should not exist in any production code. For further details, you can have a look at the documentation: [link] Generated Invisible Primary Keys This feature has been deployed in MySQL 8.0.30; it’s more recent.

Best Practices 79

Best Practices Open Source Code Engineering 79

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 72

Monitoring Metrics Database Open Source 72

Percona Community

JANUARY 14, 2019

MongoDB® is database software that stores data in the same format as JSON. The data structure of the database can be changed when required. The performance of the database is good and developers can easily use to it to connect their code to the database.

Open Source 52

Open Source Database Code Software 52

The Netflix TechBlog

JULY 30, 2019

and beyond By Anoop Panicker and Kishore Banala Conductor is a workflow orchestration engine developed and open-sourced by Netflix. If you’re new to Conductor, this earlier blogpost and the documentation should help you get started and acclimatized to Conductor. The Netflix Media Database (NMDB) is one such example.

Lambda 189

Lambda Media Open Source Metrics 189