Official Blog - World Web Technology

APRIL 12, 2023

Unlike other web development platforms where you have to call a designer before updating a simple text, WordPress allows businesses to update content, pages, and other features effortlessly. MySQL MySQL is a database that every WordPress developer should know of. The post What Skills Are Required For WordPress Developer In 2023?

Development 52

Development Website Ecommerce Programming 52

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? Is PostgreSQL enterprise-ready?

Open Source 84

Open Source Healthcare Social Media Database 84

Dynatrace

JUNE 7, 2023

According to the Kubernetes in the Wild 2023 report, “Kubernetes is emerging as the operating system of the cloud.” Like Kubernetes, it allocates resources efficiently and ensures high availability and fault tolerance. Likewise, Red Hat OpenShift helps organizations administer Kubernetes more efficiently.

Open Source 196

Open Source Social Media Infrastructure Operating System 196

Percona

FEBRUARY 24, 2023

As a result, it becomes increasingly important to protect the confidentiality of information to prevent data leaks and facilitate easy access to relevant data sources and tools for the related teams without having to sift through unrelated databases or environmental data. to monitor and diagnose. +50

Metrics 112

Metrics Monitoring Database Engineering 112

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Percona

DECEMBER 18, 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. Today’s post includes those releases and updates that have come out since December 4, 2023.

Monitoring 93

Monitoring Open Source Servers Database 93

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 63

Scalability Best Practices Servers Database 63

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 98

Open Source Database Strategy Hardware 98

KeyCDN

FEBRUARY 22, 2023

Here is a roundup of frontend web development trends to keep an eye on in 2023. PWAs are designed to work offline, be fast, and provide a seamless user experience across different devices. Motion UI Motion UI is a design trend involving animation and other interactive elements to create a more dynamic and engaging user experience.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111

Percona

MAY 29, 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. Today’s post includes those releases and updates that have come out since May 8, 2023.

Open Source 83

Open Source Servers Scalability Database 83

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 90

Open Source Database Servers Scalability 90

Percona

SEPTEMBER 25, 2023

PostgreSQL is a powerful and popular open source relational database management system. Ensuring the safety of your PostgreSQL data through regular backups is an important concern for database administrators. pgBackRest is a highly efficient and versatile tool for managing PostgreSQL backups.

Database 100

Database Open Source Storage Servers 100

Percona

OCTOBER 16, 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. Today’s post includes those releases and updates that have come out since October 2, 2023.

Servers 79

Servers Monitoring Open Source Scalability 79

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 80

Open Source Database Storage Scalability 80

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 83

Open Source Servers AWS Database 83

Percona

OCTOBER 19, 2023

In this guide, we will demonstrate how to establish a Citus database spanning multiple nodes by using Percona Distribution for PostgreSQL. This setup empowers your database to efficiently manage increased data volumes, enhance performance, and maintain availability. 1ubuntu1~20.04.1) 1ubuntu1~20.04.1)

Scalability 91

Scalability Database Open Source Traffic 91

Percona

DECEMBER 29, 2023

Not everything can be addressed on the database side. Human factor: In an ideal case, there must be stringent restrictions and enforcement on what load and number of connections can be onboarded to the Database. App-Dev often demands unrestricted, uncontrolled access to the database. However, gatekeeping is not an easy job.

Servers 86

Servers Database C++ Airlines 86

Percona

OCTOBER 20, 2023

You can read part one here: Scalable Solutions With Percona Distribution for PostgreSQL: Set Up Three PostgreSQL Database Instances. 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.

Scalability 97

Scalability Database Open Source Systems 97

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 84

Open Source Servers Scalability Cache 84

Percona

APRIL 28, 2023

Let’s start with a simple introductory comparison: With proprietary (closed source) database software, the public does not have access to the source code; only the company that owns it and those given access can modify it. Myth #2: Proprietary databases are better and therefore more suitable for large enterprises.

Open Source 119

Open Source Database Software Software 119

Percona

AUGUST 16, 2023

In database management, well-formatted SQL code is easier to read and a vital aspect of maintaining clean, efficient, and error-free databases. PostgreSQL developers and database administrators often deal with complex SQL queries, making code readability a critical factor for productivity.

Code 83

Code Best Practices Open Source C++ 83

Percona

FEBRUARY 23, 2023

If you ever had to make a quick ad-hoc backup of your MongoDB databases, but there was not enough disk space on the local disk to do so, this blog post may provide some handy tips to save you from headaches. while not overloading the CPU capacity on the production database. zst 2023-02-07T19:33:58.138+0100 writing db2.products

AWS 126

AWS Storage Database Open Source 126

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. This level of distribution will seriously affect the efficiency of the operation, which will increase the response time significantly. This is it.

Traffic 130

Traffic Scalability Database Servers 130

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What are the differences between Aurora and RDS?

AWS 52

AWS Database Serverless Storage 52

Dynatrace

OCTOBER 17, 2023

As they try to become more efficient, organizations are turning to technologies such as AIOps and IT automation. AIOps —or the automation of IT operations—and other forms of IT automation have received increasing focus because these technology approaches are critical to improving organizational efficiency.

Innovation 173

Innovation Monitoring Network Strategy 173

Percona

JUNE 7, 2023

Triggers on Data Definition Language (DDL) events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database schema. DDL events include operations such as CREATE, ALTER, and DROP statements on tables, indexes, and other database objects.

Database 79

Database Best Practices Open Source C++ 79

Percona

SEPTEMBER 27, 2023

First, we will need to install the OS with the necessary control files for the appropriate PostgreSQL version for installing pg_partman on the database. Installation of pg_partman on the database I recommend creating the schema before creating the extension to install the extension’s objects.

Storage 105

Storage Open Source Database Efficiency 105

VoltDB

AUGUST 27, 2024

Volt Active Data (Volt) is a sophisticated real-time data platform intricately designed with multiple critical components, including high-speed data processing, in-memory storage, and ACID-compliant transactions. These exported records will be written to an external system (such as another database, CSV files, or another streaming platform).

Testing 52

Testing Database Network Systems 52

Percona

JULY 15, 2023

This blog was originally published in January 2022 and was updated in July 2023. One very common problem when trying to optimize a database environment is index usage. Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. What is an Index?

Virtualization 77

Virtualization Speed Database Efficiency 77

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. If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” of users and 3.9%

Open Source 111

Open Source Google Artificial Intelligence Infrastructure 111

Percona

SEPTEMBER 1, 2023

This blog was originally published in February 2019 and was updated in September 2023. Web applications rely on databases to run the internet, powering everything from e-commerce platforms to social media networks to streaming services. It specifies how characters are converted into binary code and vice-versa.

Performance 52

Performance Storage Social Media Database 52

Percona

JULY 6, 2023

Performance is one of the essential aspects of a database management system. In PostgreSQL, there are different ways it can leverage the indexes to produce the most efficient plan. One way to verify a column’s number of distinct values is by querying the pg_stats view in our database.

Best Practices 96

Best Practices Tuning Testing Database 96

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 76

Database Open Source Scalability Virtualization 76

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. You can find all examples from this blog post in this GitHub repository. Everything is created with postgres admin user.

Storage 100

Storage Database Media Open Source 100

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 2023. MySQL triggers are a powerful tool for database administrators and developers, enabling them to automate tasks, enforce data consistency, and respond to events within the database seamlessly. What is a Trigger in MySQL?

Cache 65

Cache Database Games Healthcare 65

The Netflix TechBlog

JANUARY 10, 2024

Moving away from the use of dedicated instances that were constrained in quantity, we tapped into Netflix’s internal trough created due to autoscaling microservices, leading to significant improvements in computation elasticity as well as resource utilization efficiency. The results are saved to a database so they can be reused.

Processing 232

Processing Media Latency Innovation 232

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. So, What is MySQL Partitioning? Want to ensure a successful MySQL 5.7

Strategy 40

Strategy Storage Database Best Practices 40