Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database.

Tuning 52

Tuning Database Performance Hardware 52

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).

Cloud 77

Cloud Open Source Strategy Best Practices 77

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 is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning?

Tuning 52

Tuning Efficiency Database Performance 52

Percona

AUGUST 3, 2023

As an experienced database developer, you should know that these kinds of queries should not exist in any production code. This is not a best practice at all, and we strongly encourage you to always create an explicit PK in your tables. Suppose you have SELECT * queries in your application code.

Best Practices 76

Best Practices Open Source Code Engineering 76

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. As said, the last one is probably the most powerful, scalable, and difficult to design, and unfortunately, it represents probably less than 5% of the solution currently deployed.

Traffic 121

Traffic Scalability Database Servers 121

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

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. These benefits collectively contribute to a more efficient database environment.

Strategy 40

Strategy Storage Database Best Practices 40

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 82

Availability Open Source Architecture Database 82

Official Blog - World Web Technology

NOVEMBER 27, 2023

It depends on the best practices of web design. Top 5 Website Builders to Choose in 2023! The website builder offers top-notch customer support, scalability, security and compliance, and multi-channel selling options. It is written in PHP and uses a MySQL database for operations.

Website 59

Website Development Mobile Storage 59

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. We realized that we needed to consider a more global and scalable solution to better serve our global audience.

Performance 74

Performance Cache Traffic Metrics 74