Percona

JANUARY 17, 2023

The definition of Percona Advisors by ChatGPT is the following: Percona Advisors can help organizations implement robust security measures to protect their databases and sensitive data. Percona Advisors is an open source framework, meaning you can create your own checks by following our documentation. It is partially true.

Database 103

Database Open Source Monitoring Innovation 103

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 96

Database C++ Servers Open Source 96

Percona

DECEMBER 8, 2023

In this article, we will demonstrate how to achieve asynchronous replication automatic source failover when our replica is a Percona Server for MySQL (PS) and the source is a Percona XtraDB Cluster (PXC) cluster, using virtual IP (VIP) managed by Keepalived. The only value currently accepted is GroupReplication.

Servers 86

Servers Virtualization Open Source Scalability 86

Scalegrid

AUGUST 22, 2019

It is an open-source tool suite, written in Python, for managing high availability of PostgreSQL clusters. On the first node, Patroni initializes the database, obtains the leader lock from DCS, and ensures the node is being run as the master. For test purposes, DCS can be installed on same nodes running PostgreSQL.

Availability 277

Availability Servers Network Open Source 277

Percona

JUNE 1, 2023

In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. the same does not happen with MariaDB, which from a specific version, we could say in some way, distanced itself from MySQL and Percona Server for MySQL. Upload that dump to the Percona Server for MySQL using myloader.

Servers 73

Servers Database Testing Open Source 73

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 92

Open Source Database Hardware Strategy 92

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 79

Open Source Azure Servers Programming 79

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++ 93

C++ Open Source Servers Database 93

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. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. bullseye amd64 1.7

Servers 83

Servers C++ Database Systems 83

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 104

Performance Monitoring Traffic Database 104

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 90

Open Source Best Practices Servers Database 90

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. What is PostgreSQL used for?

Open Source 78

Open Source Healthcare Social Media Database 78

Percona

OCTOBER 17, 2023

MySQL Clone plugin simplifies new replica provisioning but does not simplify server restore after failure unless you are ready to re-install your MySQL instance from scratch. Since you decided to clone a replica from another server, you agreed to lose your current data. After that, start the server.

Open Source 98

Open Source Servers Database Strategy 98

Scalegrid

MARCH 12, 2019

In Part II, we’re introducing you to an alternative open source tool, Replication Manager from 2ndQuadrant, to be closely followed by Part III where we dive into our third alternative, Patroni by Zalando. When a server is configured, it needs to be registered with repmgr using repmgr primary/standby register command.

Availability 147

Availability Servers Open Source Database 147

Percona

JUNE 23, 2023

Both MySQL and PostgreSQL do the basics very well From a high level, one relational database management system is pretty much like every other relational database management system. It does not follow the SQL Standard as closely as other databases, and some useful functions such as MERGE() are missing.

Database 119

Database Transportation Servers Cloud 119

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. Take a look! Percona Monitoring and Management 2.38

Monitoring 77

Monitoring Open Source Scalability Database 77

Percona

MAY 1, 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. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Efficiency Database Performance 52

Percona

NOVEMBER 6, 2023

localhost The use of the characters % and _ as wildcards in database-level grants is now deprecated. TO dave will grant user dave access to all the tables in database dave_ but not dave1, davex, or davey. Also deprecated is the use of % by the server as a synonym for localhost when checking privileges. release of version 8.0.35

Open Source 110

Open Source Database Servers Scalability 110

Percona

OCTOBER 3, 2023

While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability. What are Transparent Huge Pages? In this case, THP is enabled.

Database 88

Database Servers Open Source C++ 88

Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 server with Percona XtraBackup. In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 server instances are ready for an upgrade. and xtrabackup 2.4

Servers 103

Servers C++ Storage Systems 103

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. The same tests have been executed in Percona Server for MySQL 5.7

Cache 101

Cache Hardware Servers Benchmarking 101

Percona

SEPTEMBER 29, 2023

This is a global and dynamic variable, and we can set this mode when the server is running. Let’s test this. To test this, create a new user, “app_user,” with only the privileges for DDL/DML. sec) Conclusion The offline_mode is a good option to put the server in maintenance mode.

C++ 95

C++ Servers Open Source Database 95

Percona

SEPTEMBER 19, 2023

To highlight some: Logical replication from standby servers is now supported natively by PostgreSQL. Added support for regular expression matching of user and database names in pg_hba.conf, and user names in pg_ident.conf. PostgreSQL 16 comes packed with features. Parallelization for transactions for logical replication subscribers.

Availability 108

Availability Open Source Database Servers 108

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 99

Cache Database Virtualization Servers 99

Dynatrace

NOVEMBER 16, 2021

Prometheus is an open-source software toolkit used for event monitoring and alerting. It records real-time metrics in a time series database with flexible queries and real-time alerting. It then compresses and stores them in a time-series database on a regular cadence. How to test the configuration?

Metrics 200

Metrics Infrastructure Open Source Database 200

Official Blog - World Web Technology

NOVEMBER 9, 2023

PHP is a language that has weathered the test of time and is still frequently used by web developers. PHP is a popular server-side programming language due to its simplicity of use, vast functionality, and robust community support. Regarding command-line and server-side scripts, PHP is easy for users to understand and use.

Website 59

Website Development Open Source Database 59

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Percona

SEPTEMBER 12, 2023

The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and reliability in data management. Compared to MySQL 5.7,

Servers 110

Servers Storage Database Open Source 110

Percona

OCTOBER 13, 2023

Purpose of.sdi files Serialized dictionary information (SDI) files store serialized metadata about various database objects, such as tables, indexes, and other schema-related details. Let’s test it with InnoDB using the ibd2sdi tool. 1 mysql mysql 0 Sep 18 08:15 test_table.MYD [root@db3-node test]# RocksDb also supports SDI.

Storage 93

Storage Database Engineering Open Source 93

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. PMM relies on Grafana for its dashboards.

Monitoring 76

Monitoring Open Source Database Metrics 76

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 69

Monitoring Open Source Database Software 69

Percona

FEBRUARY 13, 2023

Recently, I was working with my colleagues Edwin Wang and Taras Onishchuk and found an interesting edge case involving a situation where a replica running Percona Server for MySQL 5.7 , external to AWS Aurora instance version 2.10.2 (5.7-compatible), Default database: 'lab'. compatible), broke. for the UTF8MB4 character set.

AWS 89

AWS Database Open Source Servers 89

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. Let’s test this.

Database 100

Database Engineering Best Practices Open Source 100

Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. sec) db1 test> CREATE TABLE tb3 (id int auto_increment primary key, test_text tinytext); Query OK, 0 rows affected (0.13

Open Source 88

Open Source Storage Database Big Data 88

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:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.

Open Source 66

Open Source Database Storage Engineering 66

The Netflix TechBlog

MAY 21, 2019

using RL agents for test case scheduling By: Stanislav Kirdey , Kevin Cureton , Scott Rick , Sankar Ramanathan Introduction Netflix brings delightful customer experiences to homes on a variety of devices that continues to grow each day. Detect a regression in a test case. These problems could be solved in several different ways.

Testing 163

Testing AWS Lambda Network 163

Percona

SEPTEMBER 19, 2023

This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Physical backups are the backups that consist of raw copies of the directories and files that store database contents. Your MySQL connection id is 10 (X protocol) Server version: 8.0.33-25 Press ^C to stop.

C++ 104

C++ Servers Storage Speed 104