Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Key areas include: Configuration parameter tuning : This tuning involves altering variables such as memory allocation, disk I/O settings, and concurrent connections based on specific hardware and requirements.

Tuning 52

Tuning Efficiency Database Performance 52

O'Reilly

JANUARY 16, 2024

I’m personally interested in this topic since I am a professor who researches human-computer interaction, user experience design, and cognitive science , so AI voice interfaces are fascinating to me. software” rather than “hardware” in our brains).

Entertainment 73

Entertainment Internet Internet Design 73

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

JUNE 26, 2023

We need to identify whether it was deleted manually by mistake or was due to hardware failure. In case of hardware failure, first, we need to fix the hardware issue or migrate our database to new hardware and then perform a restore, as mentioned below. Perform PITR if we have backup configured with proper archive backup.

Hardware 74

Hardware C++ Database Open Source 74

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 108

Open Source Artificial Intelligence Google Infrastructure 108

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. You can run multiple instances on a server to test your backups with the correct version and configs.

Programming 83

Programming Servers Database Hardware 83

Brendan Gregg

MARCH 16, 2024

2005-2023: The winter of broken profilers However, the change was then applied to x86-64 (64-bit) as well, which had sixteen registers and didn't benefit so much from a seventeenth. Back-end servers. 2023, 2024: Frame Pointers in Fedora and Ubuntu! The actual overhead depends on your workload.

Java 145

Java Cache Google Hardware 145

Percona

OCTOBER 18, 2023

The findings from our 2023 Open Source Database Report highlight that a substantial 42% of all database instances are now licensed through community-supported open source models, and GitHub reports that over 30% of Fortune 100 companies have established open source program offices (OSPO) to coordinate and manage their open source initiatives.

Open Source 89

Open Source Database Hardware Strategy 89

Percona

JULY 7, 2023

Where a high availability design once worked well, it can no longer keep up with more complex requirements. In general terms, to achieve HA in PostgreSQL, there must be: Redundancy: To ensure data redundancy and provide continuous performance when a primary server fails, multiple copies of the database reside in replica servers.

Availability 82

Availability Open Source Architecture Database 82

ACM Sigarch

JULY 17, 2023

We then discuss defects observed, the role of test and design to address this problem, and identify research opportunities. An example of a specification is the correct operation of the hardware of a microprocessor. While testing is important, exhaustive testing is challenging given the sheer size of modern processor designs.

Energy 52

Energy Hardware Best Practices Architecture 52

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. The idea is to use secondary servers on your infrastructure for either reads or other administrative solutions. Network Connectivity: Establish a reliable network connection between the primary and replica servers. Restart the MySQL service.

Servers 52

Servers Database Availability Traffic 52

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. To address these challenges, architects must design robust and scalable MongoDB databases and adopt appropriate sharding strategies that can efficiently handle increasing workloads while ensuring continuous availability. What is sharding in MongoDB?

Best Practices 70

Best Practices Traffic Database Servers 70

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. If you don’t have well-designed and small columns for this composite primary key, it could enlarge all of your secondary indexes. Inappropriately designed queries may not fully utilize partitioning benefits, leading to poor performance.

Strategy 40

Strategy Storage Database Best Practices 40

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. Understanding DBaaS DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure or installing software. This eliminates the need for complex or scripted backup procedures and designated backup windows.

AWS 52

AWS Database Serverless Storage 52