Percona

AUGUST 4, 2023

In this blog post, we will look at the lifecycle and release management for MySQL and MariaDB servers — where we are now and relevant historical background. The MariaDB 11 series did not yet have any long-term supported (LTS) releases, which are the releases most would consider for running mission-critical databases in production.

Database 81

Database Servers Innovation Open Source 81

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 99

Database C++ Servers Open Source 99

Dynatrace

FEBRUARY 10, 2021

Dynatrace is redefining Application Security, applying the automation, AI, scalability, and enterprise-grade robustness of its platform to change the way security gets done. The latest enhancement enables our customers to automatically detect and assess open-source and third-party vulnerabilities in Node.js Next steps.

Java 240

Java Open Source Engineering Database 240

Percona

OCTOBER 17, 2023

This blog post discusses using the CLONE INSTANCE command with the safety option DATA DIRECTORY when you do not have enough disk space to store two datasets. This way, you will have a new instance with a small data directory, so you can use option DATA DIRECTORY without fear of exceeding available disk space.

Open Source 101

Open Source Servers Database Strategy 101

Percona

OCTOBER 10, 2023

In this blog post, I’ll provide some thoughts on how schema changes can be performed when running MySQL on Kubernetes I won’t focus on DIRECT ALTERs as it is pretty straightforward to apply them. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Type 'help;' or 'h' for help.

Database 98

Database Performance C++ Engineering 98

The Netflix TechBlog

MARCH 5, 2019

Challenges & Opportunities in the Infra Data Space Security Events Platform for Anomaly Detection How can we develop a complex event processing system to ingest semi-structured data predicated on schema contracts from hundreds of sources and transform it into event streams of structured data for downstream analysis?

Infrastructure 182

Infrastructure Cloud Scalability AWS 182

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 has default settings for all of the database parameters. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload.

Tuning 52

Tuning Efficiency Database Performance 52

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. and Percona XtraBackup 2.4

C++ 95

C++ Open Source Servers Database 95

Percona

NOVEMBER 6, 2023

This blog post is a quick look at the release notes to see what these new versions bring to the community. 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. and MySQL 8.2.

Open Source 113

Open Source Database Servers Scalability 113

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. In this blog post, we’ll explore what it takes to run Django on Kubernetes with Percona Operator. Django uses it to connect to the database.

Database 117

Database Open Source Engineering Efficiency 117

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. The auditing plugin overview has been explained in the blog post Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price. How does it work? The drop events are listed below. The drop events are listed below.

Servers 86

Servers Database Open Source Scalability 86

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). It continues to be developed and maintained by the open source community and remains free to use under the GNU General Public License.

Open Source 52

Open Source Servers Storage Scalability 52

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

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 93

Open Source Best Practices Servers Database 93

Percona

OCTOBER 13, 2023

This blog will discuss how to debug the core file in VS code. Percona Distribution for MySQL is the most complete, stable, scalable, and secure open source MySQL solution available, delivering enterprise-grade database environments for your most critical business applications… and it’s free to use!

Code 104

Code C++ Storage Programming 104

Percona

DECEMBER 13, 2023

Error logging is a critical aspect of database administration, providing insights into issues, warnings, and errors that may affect the system’s stability and performance. In this blog post, we will explore one of the two error filtering methods, specifically focusing on priority-based error log filtering.

Database 96

Database Open Source Tuning Traffic 96

Official Blog - World Web Technology

NOVEMBER 9, 2023

Developers can stay up to date and improve their skills with the help of many community-made tools, like lessons, groups, and open-source projects, thus building a successful PHP Development Company in India. It works with many databases, including well-known ones like Oracle, MySQL, and PostgreSQL.

Website 59

Website Development Open Source Database 59

KeyCDN

OCTOBER 2, 2018

Reading and following the right web development blogs makes it much easier to get a solid education. That’s why in this post, we’ve compiled a list of the top web development blogs that will help you find your footing and acquire essential skills in modern web dev. Visit website 3. Visit website 5. Visit website 9.

Development 75

Development Website Design Code 75

Percona

MARCH 6, 2023

We will walk through how to figure that out in this blog. The first one has the formula I’ll mention in this blog, and the second has more details regarding Redo Logs. If you want an answer based on detailed information about your database usage and patterns, it’s recommended to use Percona Management and Monitoring.

Tuning 92

Tuning Open Source Database Engineering 92

The Netflix TechBlog

OCTOBER 19, 2020

In our previous blog post we introduced Edgar, our troubleshooting tool for streaming sessions. Troubleshooting a session in Edgar When we started building Edgar four years ago, there were very few open-source distributed tracing systems that satisfied our needs. —?which is difficult when troubleshooting distributed systems.

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

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. mysql> create database test_rocksdb; Query OK, 1 row affected (0.01 mysql> create database test_rocksdb; Query OK, 1 row affected (0.01

Storage 96

Storage Database Engineering Open Source 96

Dynatrace

DECEMBER 18, 2023

For busy site reliability engineers, ensuring system reliability, scalability, and overall health is an imperative that’s getting harder to achieve in ever-expanding, cloud-native, container-based environments. Another source reported a 43% overall increase in Prometheus adoption for the last six months of 2021. What is Prometheus?

Metrics 175

Metrics Engineering Energy Tuning 175

Dynatrace

AUGUST 5, 2022

As a result of persistent queues, a system benefits from improved performance, reliability, and scalability. There are several message queuing software options available for use today, including the following: Apache Kafka is an open source, distributed platform optimized for streaming information. Watch webinar now!

Monitoring 196

Monitoring Serverless Programming Speed 196

Dynatrace

AUGUST 5, 2022

As a result of persistent queues, a system benefits from improved performance, reliability, and scalability. There are several message queuing software options available for use today, including the following: Apache Kafka is an open source, distributed platform optimized for streaming information.

Monitoring 195

Monitoring Serverless Programming Speed 195

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. Connection id: 2 Current database: db1 + -+ -+ | id | username | + -+ -+ | 1 | user1 | | 2 | user2 | + -+ -+ 2 rows in set (0.01 Compared to MySQL 5.7, sec) Query OK, 1 row affected (0.00

Servers 113

Servers Storage Database Open Source 113

Percona

APRIL 19, 2023

This blog post is a quick review of the release notes looking for the exciting items, and comments in italics are solely my own. MySQL released version 8.0.33 on April 18th, featuring some attention-catching features. User-defined collations are now deprecated and will be removed in a future version.

Open Source 95

Open Source Servers Scalability Database 95

Percona

APRIL 11, 2023

Indexes are crucial for optimizing query execution times in databases, but having an excessive number of indexes, or redundant ones, can negatively impact performance. In this blog post, we’ll put ourselves to the test and see if we can identify duplicate and redundant indexes in MySQL. Could you identify all nine of them?

Database 93

Database Open Source Testing Design 93

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. In this blog, we aim to call out some key considerations when trying to assess MySQL performance for your application. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench.

Performance 54

Performance Benchmarking Cache Storage 54

Percona

AUGUST 18, 2023

This blog will explore the hurdles encountered during the upgrade process and the innovative solution that saved the day. It also shows the importance of thorough testing in complex database upgrades. Recently, we had a client wanting to move from MariaDB 10.4 to MySQL 8.0, and this transition presented several challenges.

Open Source 67

Open Source Database Storage Engineering 67

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. Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. Results for Percona Server for MySQL 8.0

Cache 104

Cache Hardware Servers Benchmarking 104

Percona

APRIL 4, 2023

In this blog post, we’ll look at MySQL 8 user attributes and how we can use them. allows database administrators to assign custom key-value pairs to MySQL user accounts. Overall, the user attribute feature in MySQL provides a powerful new feature for database administrators to manage and secure their MySQL installations.

Open Source 81

Open Source Database Mobile Scalability 81

Percona

MARCH 21, 2023

In this blog, I’ll discuss the use case for replication. We want to improve our ability to replicate your data and limit replication to row-based events securely, wherein we do not have control over the source(s). The replica doesn’t have checking capabilities when processing replicated transactions as of MySQL 8.0.18.

Storage 89

Storage Open Source Database Engineering 89

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

In this blog post, I’m going to present a new functionality that is available in MyDumper and will be available in the next release: we added the possibility to build random data based on a format that the user defines. During export, mydumper sends SELECT statements to the database. How does it work?

Testing 108

Testing C++ Open Source Database 108

Percona

AUGUST 7, 2023

Both logs are crucial in the ACID (Atomicity, Consistency, Isolation, Durability) properties of database systems. In this blog post, we will delve into the differences between the InnoDB undo log and redo log, exploring their significance and providing code examples to illustrate their usage.

Database 96

Database Tuning Storage Open Source 96

Percona

NOVEMBER 1, 2023

This blog was originally published in August of 2021 and updated in November of 2023. Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker.

Scalability 60

Scalability Best Practices Servers Database 60

Dynatrace

APRIL 5, 2021

These include website hosting, database management, backup and restore, IoT capabilities, e-commerce solutions, app development tools and more, with new services released regularly. A new record entering a database table. Tasks like API requests, database calls, and file system management are perfect candidates for this service.

Lambda 178

Lambda AWS Serverless Hardware 178