Percona

SEPTEMBER 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. 2 came out on August 25, 2023. was released on August 31, 2023. Take a look.

Open Source 75

Open Source Scalability Database Software 75

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. Today’s post includes those releases and updates that have come out since February 13, 2023. Take a look! was released.

Monitoring 68

Monitoring Open Source Database Software 68

Dynatrace

MAY 4, 2023

According to the Dynatrace 2023 CIO Report , 34% of CIOs reported that they must sacrifice security to meet the demand for faster innovation. Integrating security into development and operations frameworks also improves testing, validation, and distribution practices with a continual feedback loop.

DevOps 206

DevOps Speed Innovation Open Source 206

Dynatrace

DECEMBER 5, 2023

On July 26, 2023, the U.S. The SEC cybersecurity mandate will go into effect on December 15, 2023, and cybersecurity organizations are still figuring out how to properly prepare themselves. To learn more about application security challenges and best practices in global organizations, download the free 2023 Global CISO Report.

Best Practices 245

Best Practices Government C++ Education 245

Dynatrace

JUNE 15, 2023

Open source software To produce applications rapidly, developers often rely on open source software for the application’s primary building blocks. Using open source software can help accelerate development because developers don’t need to reinvent the wheel with every new application build.

Cloud 171

Cloud Open Source Architecture Monitoring 171

Percona

DECEMBER 22, 2023

was released on December 21, 2023. pt - galera - log - explainer takes raw log files, usually very verbose as the one available in the regression test suite , and makes short summary out of them: $./bin/pt-galera-log-explainer tests/logs/merge_rotated_daily/node1.20230315.log tests/logs/merge_rotated_daily/node1.20230315.log

Operating System 93

Operating System Programming Open Source Testing 93

Tech News Gather

APRIL 18, 2023

An MVP will allow you to: Collect valuable feedback from early users Approve your idea with actual users Analyse audience needs and demands Pitch investors for funding to develop a fully functional business app It’s best to start with an app with 2-3 important features and test the app in the market before investing more money to make a mobile app.

Mobile 52

Mobile Small Business Open Source Entertainment 52

Percona

DECEMBER 12, 2023

In my lab, we have two test nodes with replication setup, and both servers will have Debian 11 and Percona Server for MySQL 8.0.33 (with Percona Toolkit) installed. Creating the test tables and the AFTER INSERT trigger Create the below table and trigger on PRIMARY, and it will replicate down to REPLICA. The print result is good.

Servers 88

Servers Database Testing Open Source 88

Percona

DECEMBER 20, 2023

The following is a sample PMM dashboard that shows the multiple buffer pool resize operations during my tests. 2023-12-05T16:51:29.610886Z 65 [Note] [MY-012398] [InnoDB] Requested to resize buffer pool. 2023-12-05T16:51:29.620707Z 0 [Note] [MY-011885] [InnoDB] disabled adaptive hash index.

Monitoring 84

Monitoring Code Open Source Cache 84

Percona

SEPTEMBER 19, 2023

Now, since backup speed and compactness are important for busy, important databases, Percona’s open source physical backup solution – Percona XtraBackup (PXB) , takes into account all these aspects and benefits MySQL world with its exceptional capabilities! Copyright (c) 2016, 2023, Oracle and/or its affiliates.

C++ 101

C++ Servers Storage Speed 101

Dynatrace

MARCH 3, 2020

By 2023, over 500 million digital apps and services will be developed and deployed using cloud-native approaches. One way to apply improvements is transforming the way application performance engineering and testing is done. Dynatrace has many capabilities and out-of-the-box features that support performance engineering and test.

Performance 237

Performance Education Innovation Software Architecture 237

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. sec) Grafana data source Now that we have the power production data in MySQL, we need to configure Grafana to access the MySQL server.

Monitoring 74

Monitoring Open Source Database Metrics 74

Percona

SEPTEMBER 19, 2023

PostgreSQL Community released PostgreSQL 16 on September 14, 2023. We’re hoping to share some good news in this regard and provide an MVP for all of you to try and test by the end of this year. In years past, we’ve released our Distribution for PostgreSQL a few months later. The plan is to start with version 16.

Availability 105

Availability Open Source Database Servers 105

Percona

MARCH 3, 2023

We are going to do the necessary tests for this to be carried out successfully, for which we will use the following test environment: Below is the test topology (as you can see, we’re using the same version of Percona Server for MySQL ). PS8_Primary=192.168.0.70 [RW] [ver: 8.0.31-23] PS8_Replica=192.168.0.71 [SR] [ver: 8.0.31-23]

Database 95

Database Testing Servers Open Source 95

Percona

AUGUST 3, 2023

And try now the SELECT * again: mysql> SELECT * FROM articles; + -+ + + | id | ts | article | + -+ + + | 1 | 2023-07-28 13:15:03 | This is first article | | 2 | 2023-07-28 13:15:03 | This is second article | | 3 | 2023-07-28 13:15:03 | This is third article | + -+ + + You see, the column is not returned.

Best Practices 76

Best Practices Open Source Code Engineering 76

Percona

OCTOBER 4, 2023

was released on October 3, 2023. Quality improvements Perl tools in Percona Toolkit come with a regression test suite that uses its own module that fires up MySQL sandbox ( lib / Sandbox. pm ) and extended Perl module Test :: More ( lib / PerconaTest. Fix for PT-2156: Fix tests for lib finishes this effort.

Open Source 96

Open Source Code Testing Systems 96

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ). It has evolved steadily, however, during 25 years as an open source project.

Open Source 77

Open Source Healthcare Social Media Database 77

Percona

MARCH 1, 2023

has had a good, long run, but the official End of Life is October of 2023. Add in INVISIBLE INDEXes, and you can test the efficiency of an index without risking a disastrous rebuild after a delete. Oracle’s MySQL 5.7 The Era of MySQL 5.x x will be over, and only MySQL 8.0 will be officially supported. Yup, six months away.

Servers 115

Servers Open Source Tuning C++ 115

Percona

AUGUST 18, 2023

I tried the in-place upgrade on my test VM for my own curiosity and got some redo log format errors/Data Dictionary errors. 2023-05-12T08:10:38.946611Z 1 [ERROR] [MY-013894] [InnoDB] Found redo log file./ib_logfile0 2023-05-12T08:10:38.946683Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.

Open Source 65

Open Source Database Storage Engineering 65

Percona

MARCH 13, 2023

In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 Linux (x86_64) (revision id: 14f007fb) 2023-02-28T23:05:23.994404-05:00 0 [Note] [MY-011825] [Xtrabackup] cd to /var/lib/mysql/ 2023-02-28T23:05:24.001029-05:00 0 [Note] [MY-011825] [Xtrabackup] This target seems to be not prepared yet.

Servers 100

Servers C++ Storage Systems 100

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Advantages of migrating to open source For many reasons mentioned earlier, organizations are increasingly shifting towards open source databases for their data management needs.

Open Source 89

Open Source Database Hardware Strategy 89

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. Let’s start and test on Debian 11. 2023-06-05T23:31:46.511283Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.28-20) Update the package repositories $ sudo apt update 1.2

Servers 82

Servers C++ Database Systems 82

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 96

Cache Database Virtualization Servers 96

Percona

APRIL 6, 2023

The first step is to have a working PMM environment for our tests, so we’ll use anydbver to deploy three containers: one with a PMM server, another with Percona Server for MySQL and a PMM client, and a third one with PostgreSQL and a PMM client. Verify that Loki and Promtail is configured properly.

Monitoring 85

Monitoring Servers Metrics Database 85

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

JULY 27, 2023

on July 17th, 2023. is in October of 2023. Our engineers need to test, optimize, add the enterprise features, and then get it all ready for your use. This is a Quick Peek at what Oracle delivered with MySQL 8.0.34 Please note that comments in italics are mine and do not reflect the views of Percona and possibly not anyone else.

Servers 81

Servers Open Source Tuning Cache 81

Percona

APRIL 17, 2023

So the federated URL for exposing “*_up” metrics will be [link] I can test in on my PMM while being logged into it. Percona Monitoring and Management is a best-of-breed open source database monitoring solution. The next step I need to do is to feed the Datadog agent with data from PMM. openmetrics.d/conf.yaml

Monitoring 69

Monitoring Metrics Database Open Source 69

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

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 109

Open Source Database Software Software 109

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. was released on December 12, 2023. was released on December 5, 2023.

Monitoring 84

Monitoring Open Source Servers Scalability 84

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. MariaDB is a popular SQL open source relational database management system that originated as a fork of MySQL after MySQL was acquired by Sun Microsystems in 2008 and later Oracle in 2010. What is MariaDB? Contact us to learn more!

Open Source 52

Open Source Servers Storage Scalability 52

Percona

NOVEMBER 13, 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. came out on November 2, 2023. was released on November 1, 2023. Take a look.

Innovation 83

Innovation Open Source Scalability Database 83

Percona

AUGUST 21, 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. was released on August 14, 2023. 47 was released on August 17, 2023.

Open Source 81

Open Source AWS Servers Database 81

Percona

OCTOBER 31, 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. PMM) was released on October 20, 2023. was released on October 16, 2023.

Monitoring 76

Monitoring Open Source Scalability Database 76

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 76

Open Source Servers Scalability Database 76

Percona

JUNE 12, 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. was released on June 5, 2023. was announced on June 5, 2023. Take a look!

Open Source 82

Open Source Servers Database Scalability 82

Percona

SEPTEMBER 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. was released on September 14, 2023. was released on September 11, 2023.

Open Source 77

Open Source Servers Database Scalability 77