Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. However, we know having a “runaway” grant is always a possibility, especially in environments with a large number of servers. Fortunately, in Percona Server for MySQL , this feature is free to use. How does it work?

Servers 83

Servers Database Open Source Scalability 83

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 74

Database Open Source Servers Code 74

Dynatrace

MARCH 22, 2023

This method involves providing the lowest level of access by default, deleting inactive accounts, and auditing server activity. For example, ensuring software stacks don’t use default accounts or passwords, error handling doesn’t reveal sensitive information, and application server frameworks use secure settings.

Open Source 197

Open Source Artificial Intelligence Internet Internet 197

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

JANUARY 24, 2023

Databases on Kubernetes continue their rising trend. For example, for GKE, you must create a VolumeSnapshotClass resource first. For example, for my MongoDB cluster, I have six PVCs: three x replica set nodes and three x config server nodes. Apart from public clouds, there are open source solutions like Ceph (rook.io

Database 66

Database Storage Open Source AWS 66

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

DECEMBER 28, 2023

Starting with Percona Server for MySQL 8.0.34-26 You can filter events based on a user account, audit event class name, audit event subclass name, and audit event fields (database name, table name, operation status, and so on). A server restart is not required to add or adjust existing filtering rules.

Open Source 104

Open Source Database Servers Storage 104

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 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. The following are a few examples of decisions that came from this data and some of what comes next in terms of additional telemetry in Percona products. One such feature was managed backups.

Open Source 89

Open Source Database Operating System Programming 89

Percona

FEBRUARY 14, 2023

Recently, we released Percona Monitoring and Management 2.34 (PMM) which includes upgrades for backup and Database as a Service (DBaaS) features, and we are seeking ways to simplify PMM deployment. Percona Monitoring and Management is a best-of-breed open source database monitoring solution.

Monitoring 121

Monitoring Infrastructure Open Source AWS 121

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

MAY 2, 2023

The common use cases involve sharing pt-mysql-summary, pt-stalk, and other OS-related details to assist Support Engineers or any other third-party team troubleshoot database-related issues. Let’s look at a couple of examples where the sensitive data has been altered or masked. shell> /home/vagrant/pt -rw -. shell> sudo.

Database 92

Database Systems Open Source Engineering 92

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

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

JANUARY 11, 2023

PostgreSQL is a powerful and flexible open-source database management system that allows users to install and use extensions to add additional functionality to their databases. In this tutorial, we will cover the process of installing and upgrading PostgreSQL extensions using the example of the pg_stat_monitor extension.

Database 98

Database Open Source Monitoring Servers 98

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

Official Blog - World Web Technology

NOVEMBER 9, 2023

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. PHP can work perfectly on shared hosting and private servers, making it an excellent choice for building websites.

Website 59

Website Development Open Source Database 59

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

Official Blog - World Web Technology

AUGUST 27, 2023

For example, website design is very crucial to impress your website visitors. It is a server-side scripting language that is highly secure, open-source, and versatile. Mostly, web servers are created with PHP. In PHP, code is directly executed on the server and generates HTML to send to the client.

Development 98

Development Ecommerce Open Source Website 98

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

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

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 collect Prometheus metrics.

Metrics 200

Metrics Infrastructure Open Source Database 200

Dynatrace

AUGUST 18, 2022

During development, vulnerabilities can arise when developers use third-party open source code or make an error in application logic. Such scans enable teams to detect SQL injection attacks that allow someone to maliciously inject code into a database query. Vulnerability scanning tools can help in both of these cases.

Traffic 163

Traffic Java Network DevOps 163

Percona

JULY 19, 2023

For example, a table statistics limit is introduced to avoid querying information_schema.tables that may impact DB performance, especially with a high number of DBs / tables present in an instance. Below is an example of an alternative approach to re-adding the instance. In the example, we run PMM server in a docker container.

Monitoring 81

Monitoring Entertainment Open Source Tuning 81

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 Results for Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7

Cache 101

Cache Hardware Servers Benchmarking 101

Dynatrace

NOVEMBER 23, 2020

Nevertheless, there are related components and processes, for example, virtualization infrastructure and storage systems (see image below), that can lead to problems in your Kubernetes infrastructure. After applying the first manifests (which are likely copied and pasted from a how-to tutorial ), a web server is up and running within minutes.

Virtualization 160

Virtualization Infrastructure Monitoring Cloud 160

Percona

SEPTEMBER 29, 2023

This is a global and dynamic variable, and we can set this mode when the server is running. sec) If you try to connect the DB with app_user when offline_mode=1 , it will not allow the connections and get an error message that the server is currently in offline mode. But by using this mode, we can avoid the new connections.

C++ 95

C++ Servers Open Source Database 95

Percona

JUNE 20, 2023

Percona Operator for PostgreSQL offers a powerful solution for managing and scaling PostgreSQL databases in a Kubernetes environment, making it an ideal choice for developer use cases. I will use the regular kubectl approach: $ kubectl apply --server-side -f deploy/bundle.yaml Django application would require its own user and database.

Database 114

Database Open Source Engineering Efficiency 114

Percona

AUGUST 8, 2023

and offers a convenient method for cloning data from either a local or remote MySQL server instance. The clone plugin allows for easy provisioning of MySQL servers by generating a fully functional data directory. Ensure that you add this option each time the server starts when using this plugin-loading method.

Servers 85

Servers Monitoring Open Source Database 85

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. Example (using the employee sample DB ): Suppose we have the following schema: db1 employees> show create table employeesG 1.

Open Source 88

Open Source Storage Database Big Data 88

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

Percona

APRIL 14, 2023

A shared characteristic in most (if not all) databases, be them traditional relational databases like Oracle, MySQL, and PostgreSQL or some kind of NoSQL-style database like MongoDB, is the use of a caching mechanism to keep (a copy of) part of the data in memory. So, how do you know if your hot data is in memory? MySQL does.

Cache 90

Cache Efficiency Database Monitoring 90

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. These are not in this blog’s scope to keep this example simple.

C++ 82

C++ Open Source Database Programming 82

Percona

JULY 25, 2023

The data is internally inconsistent because the server concurrently modifies the data files while they are being copied. Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again. The redo apply phase wouldn’t make the database consistent with respect to a transaction.

Cache 85

Cache Benchmarking Servers Design 85

Percona

NOVEMBER 9, 2023

With this data, we’ll be able to better understand and tune our Postgres servers. The main idea is to be able to easily detect what the server is doing at any point in time so we can better understand how it reacts to the workload and tune accordingly. Conclusion This is another example of how tunable and powerful PMM is.

Monitoring 90

Monitoring Tuning Metrics Servers 90

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