Percona

FEBRUARY 13, 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 January 30, 2023. was released on February 9, 2023.

Open Source 81

Open Source Database Servers Scalability 81

Percona

APRIL 10, 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 March 27, 2023. was released on March 27, 2023.

Open Source 75

Open Source Servers AWS Database 75

Percona

MARCH 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 March 13, 2023. was released on March 23, 2023.

Open Source 76

Open Source Servers Scalability Cache 76

Percona

MARCH 1, 2023

has had a good, long run, but the official End of Life is October of 2023. EXPLAIN without the ANALYSE gives you the server’s estimated analysis of the performance of your query. Add in INVISIBLE INDEXes, and you can test the efficiency of an index without risking a disastrous rebuild after a delete. The Era of MySQL 5.x

Servers 115

Servers Open Source Tuning C++ 115

Percona

DECEMBER 27, 2023

As we at Percona wind down 2023 and look into what the next year holds, our attention is drawn to the cloud-native landscape and how it is maturing, growing, and evolving. KubeCon NA 2023 recap The theme for KubeCon NA was very clear — AI and Large Language Models (LLMs). We expect that number to rise higher in 2024.

Cloud 77

Cloud Open Source Strategy Best Practices 77

Percona

SEPTEMBER 25, 2023

PostgreSQL is a powerful and popular open source relational database management system. pgBackRest is a highly efficient and versatile tool for managing PostgreSQL backups. This way, they won’t interfere with each other, enabling efficient parallel execution. This lock-path is utilized during backup operations.

Database 91

Database Open Source Storage Servers 91

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

Percona

OCTOBER 20, 2023

Citus is an open-source extension for PostgreSQL that expands its capacity to manage databases of varying scales, ranging from individual nodes to extensively distributed database clusters. This blog post is part two of a multi-post series about using the Citus extension with Percona Distribution for PostgreSQL. Let's download the deb.sh

Scalability 90

Scalability Database Open Source Systems 90

Percona

FEBRUARY 23, 2023

It is a common practice that before a backup can be stored in the cloud or on a dedicated backup server, it has to be prepared first locally and later copied to the destination. However, I find zstd way more efficient, so I’ll use it in the examples. zst 2023-02-07T19:33:58.138+0100 writing db2.products

AWS 118

AWS Storage Database Open Source 118

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Load balancing and replication: Scaling the database system horizontally by distributing the workload across multiple servers using techniques like connection pooling, read replicas, or implementing a primary-replica replication setup.

Tuning 52

Tuning Efficiency Database Performance 52

Percona

DECEMBER 29, 2023

Inadequate application-side pooling: Suboptimal application-side pooling can lead to opening a large number of connections, and they may remain open and unused, consuming valuable resources. These connections can accumulate, eventually exhausting server resources and causing the system to become unresponsive.

Servers 78

Servers Database C++ Airlines 78

Percona

DECEMBER 14, 2023

Will 2023 be called the year of Generative Artificial Intelligence (AI)? refined the rollback mechanism, making it more efficient and reliable in handling downgrade procedures. Me : OK, so if I want to downgrade my MongoDB standalone server from version 7.0 Bard : Downgrading MongoDB Standalone Server from 7.0

Database 84

Database Artificial Intelligence Servers Operating System 84

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 76

Open Source Healthcare Social Media Database 76

Official Blog - World Web Technology

APRIL 12, 2023

Here are the benefits of WordPress: It is a free, open-source CMS and can be used by anyone who wants to develop a website. A WordPress developer must have the technical expertise and should be familiar with WordPress, its themes, plugins, difficulties that arise during the development, and how to address them quickly and efficiently.

Development 52

Development Website Ecommerce Programming 52

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 69

Database Open Source Scalability Virtualization 69

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory. The call for participation ends on March 2nd 23:59 SGT!

Performance 110

Performance Latency Cache Virtualization 110

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 ). MariaDB Server, on the other hand, is a fork of MySQL 5.5. What is MariaDB? Contact us to learn more!

Open Source 52

Open Source Servers Storage Scalability 52

Official Blog - World Web Technology

NOVEMBER 24, 2023

It is a JavaScript library that is open-source and popularly used to construct user interfaces (UIs) for the development of web applications. ReactJS utilizes virtual DOM to improve the updating efficiency of actual DOM. This is due to its flexibility, efficiency, simplified tools and huge libraries built around it.

Development 52

Development Virtualization Open Source Architecture 52

Percona

OCTOBER 19, 2023

This setup empowers your database to efficiently manage increased data volumes, enhance performance, and maintain availability. sudo percona-release setup ppg-15 # Install "percona-ppg-server-15" package sudo apt install percona-ppg-server-15 Now, let’s verify if the service is operating correctly.

Scalability 82

Scalability Database Open Source Traffic 82

O'Reilly

NOVEMBER 28, 2023

Generative AI has been the biggest technology story of 2023. As of November 2023: Two-thirds (67%) of our survey respondents report that their companies are using generative AI. 16% of respondents working with AI are using open source models. Late in 2023, we suspect that relatively few companies have a policy.

Open Source 106

Open Source Artificial Intelligence Google Infrastructure 106

Percona

MAY 15, 2023

This level of distribution will seriously affect the efficiency of the operation, which will increase the response time significantly. In the MySQL open source ecosystem, we have only two consolidated ways to perform sharding — Vitess and ProxySQL. This is it. The POC Why this POC?

Traffic 121

Traffic Scalability Database Servers 121

Percona

AUGUST 29, 2023

A single command to deploy the operator would be: kubectl apply -f [link] --server-side Init SQL script Init SQL allows the creation of the database cluster with some initial data in it. Please follow our installation instructions and use your favorite way. You can find all examples from this blog post in this GitHub repository. Interested?

Storage 91

Storage Database Media Open Source 91

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory. It was a great privilege.

Performance 52

Performance Latency Cache Virtualization 52

Percona

DECEMBER 21, 2023

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. While sorting may seem simple, it’s important to understand how to do it efficiently and effectively to ensure your queries are optimized and use better indexing.

Efficiency 100

Efficiency Database Open Source Performance 100

Testsigma

APRIL 28, 2021

Below are few statistics that will give you an idea: Mobile applications are expected to generate over $935 billion in revenue by 2023 The Apple App Store has 1.96 million apps available for download on the Google Play Store 21% of Millennials open an app 50+ times per day. It is open-source, hence free to use.

Mobile 69

Mobile Testing Open Source Java 69

Percona

JULY 2, 2023

This blog was originally written in September 2018 and was updated in June 2023. Backup Testing and Validation: To ensure backups are reliable and can be efficiently used for recovery, DBAs regularly perform backup testing and validation. In setting up our demonstration system, we use pg_basebackup and continuous archiving.

Strategy 52

Strategy Database Storage Open Source 52

Percona

JUNE 6, 2023

This blog was originally published in January 2012 and was updated in June 2023. For issues that may arise during peak network usage, this can prove to be valuable in keeping applications performing efficiently. In today’s data-driven world, the protection and reliability of our valuable information is vital.

Storage 67

Storage Strategy Network Efficiency 67

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. docker-entrypoint."

Scalability 57

Scalability Best Practices Servers Database 57

Smashing Magazine

AUGUST 3, 2023

How We Optimized Performance To Serve A Global Audience How We Optimized Performance To Serve A Global Audience Liran Cohen 2023-08-03T10:00:00+00:00 2023-08-03T13:06:00+00:00 I work for Bookaway , a digital travel brand. Download Time of HTML This is the time it takes to download the page’s HTML file. Here’s how we do it at Bookaway.

Performance 74

Performance Cache Traffic Metrics 74

Percona

JULY 3, 2023

However, a rule of thumb is that the size of the table should exceed the physical memory of the database server. Hash keys are used effectively and efficiently in cases where ranges are not applicable, like employee number, product ID, etc. The exact point at which a table will benefit from partitioning depends on the application.

Storage 80

Storage Database Performance Open Source 80

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. It efficiently manages read and write operations, optimizes data access, and minimizes contention, resulting in high throughput and low latency to ensure that applications perform at their best. What are the differences between Aurora and RDS?

AWS 52

AWS Database Serverless Storage 52

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 2023. MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. What is a Trigger in MySQL?

Cache 59

Cache Database Games Healthcare 59

Enprowess

JANUARY 12, 2022

Technologies like Microsoft Bot framework, Facebook Bot Engine, and DailougeFlow open-source builds these bots. Image Source. According to a Statista report, it is forecasted that worldwide spending on IoT by 2023 will reach 1.1 Image Source. Benefits of using AI-powered Chatbots. billion connected devices by 2025.

Blockchain 59

Blockchain IoT Development Serverless 59