Percona

JULY 17, 2023

In this blog, we’ll examine the reasons why people would seek an alternative to MongoDB Enterprise, and we’ll identify some of the most popular NoSQL alternatives. First, some stage-setting for this blog article. 1 among non-relational/document-based systems ( DB-Engines, July 2023 ). It ranks No.

Open Source 77

Open Source Database Scalability Software 77

Percona

JANUARY 2, 2024

The auditing plugin overview has been explained in the blog post Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price. Installing the plugin is a straightforward operation that is explained in the blog post mentioned above. It has many additional features that we will review in future blogs.

Servers 86

Servers Database Open Source Scalability 86

Percona

DECEMBER 20, 2023

In this blog post, we will go through the process of InnoDB buffer pool resizing online, covering why it is important to monitor its progress and how to monitor it. 2023-12-05T16:51:29.610886Z 65 [Note] [MY-012398] [InnoDB] Requested to resize buffer pool. Importance of monitoring the InnoDB buffer pool resize Since MySQL 5.7.5,

Monitoring 90

Monitoring Code Open Source Cache 90

Dynatrace

MARCH 3, 2020

By 2023, over 500 million digital apps and services will be developed and deployed using cloud-native approaches. For software engineering teams, this demand means not only delivering new features faster but ensuring quality, performance, and scalability too. Industry apps explosion. 2 New roles and responsibilities at Panera Bread .

Performance 239

Performance Education Innovation Software Architecture 239

Percona

DECEMBER 12, 2023

This blog gives you some ideas on using pt-table-sync for replica tables with triggers. sec) mysql> select * from test_tab; select * from test_tab_log; + -+ --+ + | id | test_data | op_time | + -+ --+ + | 1 | lt1 | 2023-11-26 09:59:19 | + -+ --+ + 1 row in set (0.00 The print result is good.

Servers 93

Servers Database Testing Open Source 93

Official Blog - World Web Technology

APRIL 12, 2023

Earlier, it was used to simply create online blogs, but WordPress has evolved since then. Also, WordPress development is simple like the blogs you used to create on it. When you click on Publish, you will see a webpage and not a blog. The post What Skills Are Required For WordPress Developer In 2023?

Development 52

Development Website Ecommerce Programming 52

Percona

APRIL 17, 2023

reaches end of life in October 2023. Reserved keyword – Groups Most notably, and the issue my customers are facing (and the primary reason for this blog post), is the addition of GROUPS as a reserved keyword. You can read more about reserved keywords in a previous blog, MySQL 5.7 Upgrading to MySQL 8 from 5.7

Open Source 75

Open Source Servers Scalability Database 75

Percona

AUGUST 18, 2023

This blog will explore the hurdles encountered during the upgrade process and the innovative solution that saved the day. 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 67

Open Source Database Storage Engineering 67

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. Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Database 98

Database Performance C++ Engineering 98

Percona

SEPTEMBER 14, 2023

MySQL is an outstanding open source transactional database used by most web-based applications and is very good at handling OLTP workloads. I recommend you read our previous blog, Using ClickHouse as an Analytic Extension for MySQL , from Vadim to know more about this. The blog post contains the following topics.

Engineering 90

Engineering Database Servers Analytics 90

Percona

MARCH 3, 2023

And this is how this blog originates so that if you find yourself in the same situation, proceed similarly or at least consider some of the practices used to meet the objective. “Don’t worry, we’ll take a look at the issue, and accordingly, we’ll proceed to suggest an execution plan,” we replied.

Database 102

Database Testing Servers Open Source 102

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. According to the 2023 Kubernetes in the Wild report , 65% of organizations use Prometheus. What is Prometheus?

Metrics 175

Metrics Engineering Energy Tuning 175

Percona

NOVEMBER 2, 2023

This blog was originally published in Sept 2021 and was updated in November 2023. Following the series of blogs started by Peter Zaitsev in Installing MySQL with Docker , on deploying Docker containers running open source databases, in this article, I’ll demonstrate how to install and run PostgreSQL using Docker.

Database 71

Database Open Source Scalability Virtualization 71

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 ). In addition, MariaDB provides optimal scalability options, making it ideal for growing workloads. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Official Blog - World Web Technology

NOVEMBER 24, 2023

In this blog, we shall discuss the three popular JavaScript frameworks (ReactJS vs NodeJS vs AngularJS). It is a JavaScript library that is open-source and popularly used to construct user interfaces (UIs) for the development of web applications. is an open-source, cross-platform with runtime environment of JavaScript.

Development 52

Development Virtualization Open Source Architecture 52

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Therefore, DBAs must take a piecemeal approach to achieve HA with PostgreSQL, bringing together open source extensions and tools from multiple sources.

Availability 85

Availability Open Source Architecture Database 85

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

Percona

AUGUST 1, 2023

This blog was originally published on August 10, 2020, and was updated on August 1, 2023. Because of its NoSQL origin and document architecture design, MongoDB is much more flexible and scalable than SQL databases such as MySQL. As a result, typically, much more data is stored in MongoDB than in traditional SQL databases.

Best Practices 41

Best Practices Transportation Open Source Traffic 41

Percona

MARCH 8, 2023

The main objective of this blog post is to point out the new administrative connections allowed on MySQL 8, as these connections can save us from restarting the instance in case this happens. At some point, we all face this issue in our careers, not only once but many times. Try Percona Distribution for MySQL today!

C++ 96

C++ Database Servers Open Source 96

Percona

DECEMBER 21, 2023

In this blog post, I’ll dig into MySQL query optimization and show how MySQL uses indexes in cases of queries using sorting and limiting. The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. Try Percona Distribution for MySQL today!

Efficiency 106

Efficiency Database Open Source Performance 106

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. In this blog, we will review all of the potential MySQL backup and restore strategies, the cornerstones of any application. Discover more about MySQL encryption: Learn how master key rotation works in this blog!

Best Practices 80

Best Practices Storage Strategy Database 80

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. In this blog, we will answer all of these important questions and provide a general overview comparing the two database services, Aurora vs RDS. What are the differences between Aurora and RDS? How do I choose which one to use?

AWS 52

AWS Database Serverless Storage 52

Percona

AUGUST 17, 2023

This blog post will cover the basic setup of the InnoDB ClusterSet environment, which provides disaster tolerance for InnoDB Cluster deployments by associating a primary InnoDB Cluster with one or more replicas in alternate locations/different data centers. Try Percona Distribution for MySQL today!

C++ 78

C++ Availability Processing Database 78

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. In this blog, we will be discussing different MongoDB database backup strategies and their use cases, along with pros and cons and a few other useful tips. We will be discussing more about Percona Backup for MongoDB in an upcoming blog post.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. In this blog post, we will delve into the world of PostgreSQL performance tuning and establish some basic guidelines for setting database parameters to enhance the performance of your PostgreSQL database, based on the workload.

Tuning 52

Tuning Efficiency Database Performance 52

Testsigma

JUNE 5, 2021

billion people are projected (by 2023) to keep this small device in their pockets and use it daily. It can be done via open source or via commercial tools. Testsigma cloud lab comes with real devices and is highly scalable. appeared first on Testsigma Blog. In a world with a 7.5 billion population, 4.3

Mobile 52

Mobile Testing Website Testing Tools 52

Percona

AUGUST 25, 2023

This blog post will focus on failover and recovery scenarios inside the InnoDB Cluster and ClusterSet environment. To know more about the deployments of these topologies, you can refer to the manuals – InnoDB Cluster and Innodb ClusterSet setup. Try Percona Distribution for MySQL today!

Traffic 78

Traffic Database C++ Servers 78

Enprowess

JANUARY 12, 2022

To make it easier for you, in this blog, we will discuss the latest web development trends that will evolve in 2022. Technologies like Microsoft Bot framework, Facebook Bot Engine, and DailougeFlow open-source builds these bots. Image Source. List of Top Web Development Trends to Track in 2022. Delegated maintenance.

Blockchain 59

Blockchain IoT Development Serverless 59