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

Percona

JULY 17, 2023

MongoDB Community Edition software might set the stage for achieving your high-volume database goals, but you quickly learn that its features fall short of your enterprise needs. First, some stage-setting for this blog article. The popularity of MongoDB MongoDB has emerged as a popular database platform. It ranks No.

Open Source 76

Open Source Database Scalability Software 76

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 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 87

Monitoring Code Open Source Cache 87

Percona

MARCH 21, 2023

Announcement I will be speaking at Percona Live 2023 about serverless PostgreSQL. In the context of databases, a tenant’s data can be logically separated from other tenants’ data in the same database so that each tenant can only access and manage their own data. Join us at this event if you are interested!

Serverless 124

Serverless Software Architecture Virtualization Database 124

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. MySQL MySQL is a database that every WordPress developer should know of.

Development 52

Development Website Ecommerce Programming 52

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. ClickHouse is a columnar database that handles analytical workloads quickly. In this blog post, I will show you how to replicate MySQL data in real-time to ClickHouse. No manual work!

Engineering 88

Engineering Database Servers Analytics 88

Official Blog - World Web Technology

JUNE 13, 2023

It is the most popular CMS that was earlier used to create personal blogs. However, dedicated WordPress theme developers have made the platform so advanced that businesses look up to WordPress when they want to develop a wide range of web applications such as ecommerce websites, business websites, personal blogs, web applications, etc.

Development 52

Development Website Ecommerce Code 52

Percona

JUNE 2, 2023

WordPress, the ubiquitous publishing platform that launched millions of blogs and websites, turned 20 on May 27th. WordPress also benefited from and popularized MySQL, introducing the LAMP stack – and open source – to an audience that might never have touched a database before or had any intro to open source.

Open Source 95

Open Source Traffic Tuning Database 95

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups.

Best Practices 52

Best Practices Database Storage Servers 52

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. Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc. Check the size of the table.

Database 99

Database Testing Servers Open Source 99

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 66

Open Source Database Storage Engineering 66

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 74

Open Source Servers Scalability Database 74

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 70

Database Open Source Scalability Virtualization 70

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 186

Metrics Engineering Energy Tuning 186

Percona

MARCH 8, 2023

Over the years of being a DBA, I had to deal with all kinds of problems in the database. Still, the users keep falling into this trap, maybe because of a poorly configured database, a change in the application components, or just because of a sudden increase of connections in the application. A lot has been written about this error.

C++ 94

C++ Database Servers Open Source 94

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 59

Scalability Best Practices Servers Database 59

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. What is the Recovery Time Objective?

Best Practices 79

Best Practices Storage Strategy Database 79

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. In this blog post, we will talk about MongoDB sharding and walk through the main reasons why you should start a cluster (independent of the approach you have chosen). mongos --configdb <configReplSetName>/<cfg1.example.net:27019>,<cfg2.example.net:27019>,<cfg3.example.net:27019>

Best Practices 72

Best Practices Traffic Database Servers 72

Percona

APRIL 12, 2023

We’re equally convinced on both counts, but in this blog article, we’re focusing on why MongoDB is not open source. This blog article traces key developments that coincided with MongoDB’s move away from open source software, and it examines how SSPL influence might have lured others in the same direction.

Open Source 82

Open Source Programming Database Servers 82

Official Blog - World Web Technology

NOVEMBER 27, 2023

To create a personal blog, you’ll need a drag-and-drop editor. It should have built-in auto-save and premade blogging themes. Top 5 Website Builders to Choose in 2023! Other features include templates, drag-and-drop service, e-commerce and blogging, mobile responsiveness, and integrated hosting.

Website 59

Website Development Mobile Storage 59

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 ). What is MariaDB? Elevate your MariaDB environment with Percona Support for MariaDB. Contact us to learn more!

Open Source 52

Open Source Servers Storage Scalability 52

Percona

DECEMBER 21, 2023

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. 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. Try Percona Distribution for MySQL today!

Efficiency 103

Efficiency Database Open Source Performance 103

Percona

AUGUST 1, 2023

This blog was originally published on August 10, 2020, and was updated on August 1, 2023. With an increasing number of databases in the cloud, the question is now not a matter of IF it will happen again, but when. 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

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. MySQL replication is a process in which data from a primary MySQL database is copied and sent to one or more secondary databases, known as replicas. It also enables geographically distributed databases for disaster recovery.

Servers 52

Servers Database Availability Traffic 52

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 84

Availability Open Source Architecture Database 84

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. Check out this blog to learn how to avoid disaster!

Strategy 40

Strategy Storage Database Best Practices 40

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. vagrant@localhost ~]$ sudo mysqlrouter --bootstrap iroot@127.0.0.1:3308

C++ 76

C++ Availability Processing Database 76

Percona

AUGUST 25, 2023

This blog post will focus on failover and recovery scenarios inside the InnoDB Cluster and ClusterSet environment. 3309" } MySQL localhost:3309 ssl SQL > create database sbtest2; Query OK, 1 row affected (0.0055 sec) Later on, we can fix the failed instances, and they will join cluster1 again. 3308": { "address": "127.0.0.1:3308",

Traffic 77

Traffic Database C++ Servers 77

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. According to a Statista report, it is forecasted that worldwide spending on IoT by 2023 will reach 1.1 The main advantages are as follows: Benefits of Serverless Architecture: Enhanced scalability and app flexibility.

Blockchain 59

Blockchain IoT Development Serverless 59

The Netflix TechBlog

JANUARY 10, 2024

This introductory blog focuses on an overview of our journey. Future blogs will provide deeper dives into each service, sharing insights and lessons learned from this process. Reloaded was well-architected, providing good stability, scalability, and a reasonable level of flexibility. 264, AV1, etc.).

Processing 229

Processing Media Latency Innovation 229