Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 85

Database Hardware Open Source Strategy 85

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 104

Availability Database Open Source Hardware 104

Percona

DECEMBER 11, 2023

Here, we will discuss a notable new feature in Amazon RDS, the Dedicated Log Volume (DLV), that has been introduced to boost database performance. A Dedicated Log Volume (DLV) is a specialized storage volume designed to house database transaction logs separately from the volume containing the database tables.

AWS 94

AWS Benchmarking Performance Traffic 94

Scalegrid

NOVEMBER 23, 2023

Imagine a world where your PostgreSQL® database connections are seamless and secure. Key Takeaways Understanding PostgreSQL hostname is essential for successful database connections. Understanding the PostgreSQL Hostname Hostname is a key factor for the effective management of PostgreSQL databases and providing secure access.

Database 130

Database Servers Storage Network 130

Percona

SEPTEMBER 28, 2023

Let’s review the best practices we usually follow in Managed Services before using your MySQL server in production and stage env, even for home play purposes. Therefore, disabling Transparent Huge Pages for database servers is advisable to avoid this situation. It’s a nice thing to do, but first things first.

Servers 109

Servers Best Practices Database Open Source 109

Adrian Cockcroft

NOVEMBER 26, 2023

SUS101: Sustainability innovation in AWS Global Infrastructure AWS is determined to make the cloud the cleanest and most energy-efficient way to run customers’ infrastructure and business. This includes providing the efficient, resilient services AWS customers expect, while minimizing their environmental footprint. AWS speaker: T.

AWS 52

AWS Energy IoT Best Practices 52

Percona

SEPTEMBER 26, 2023

As MySQL database administrators, we are well aware of the significance of implementing a primary key within a table. Primary keys play an indispensable role in sound database design by uniquely identifying individual rows and significantly enhancing data retrieval, manipulation, and overall system performance.

Database 97

Database Engineering Best Practices Open Source 97

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. First released in 2009, it is the most used NoSQL database and has been downloaded more than 325 million times. The bigger the database, the bigger the damage from a leak.

Database 79

Database Servers Storage Strategy 79

HammerDB

OCTOBER 8, 2018

This limitation is at the database level rather than the hardware level, nevertheless with up to date hardware (from mid-2018) PostgreSQL on a 2 socket system can be expected to deliver more than 2M PostgreSQL TPM and 1M NOPM with the HammerDB TPC-C test. . Initially it is best leave all of these states enabled. cat /proc/meminfo.

Best Practices 40

Best Practices Scalability Performance Hardware 40

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 73

Database Best Practices Open Source C++ 73

Percona

JUNE 6, 2023

A full backup is a comprehensive data backup strategy that involves creating a complete, exact copy of all data and files in a database. In order to implement effective full backups of your database, you must follow some best practices. Get started today with Percona Backup for MongoDB. What is a full backup?

Storage 66

Storage Strategy Network Efficiency 66

Percona

JULY 2, 2023

The size of the database and your database environment—if it is on colo or cloud—matters. Having a backup strategy in place that takes regular backups and has secure storage is essential to protect the database in an enterprise-grade environment to ensure its availability in the event of failures or disasters.

Strategy 52

Strategy Database Storage Open Source 52

Percona

AUGUST 5, 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. ensures that only relevant partitions are accessed, further enhancing query efficiency. So, What is MySQL Partitioning? Partition pruning, a feature in MySQL 5.7,

Strategy 40

Strategy Storage Database Best Practices 40

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. then true else false end FROM generate_series(1, 10000000); Now we have our test table with some dummy data so we can practice.

Best Practices 87

Best Practices Tuning Database Testing 87

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. The POC Why this POC?

Traffic 122

Traffic Scalability Database Servers 122

Smashing Magazine

MAY 5, 2021

However, in our pages, the case was different as our database stores lots of data, and we need to serve thousands of landing pages at scale. Google’s amount of time and resources to crawling a site is commonly called the site’s crawl budget.” — “ Advanced SEO ,” Google Search Central Documentation. How about errors?”

Google 111

Google Architecture Servers Speed 111

IO River

NOVEMBER 2, 2023

It’s not just limited to cloud resources like AWS and Azure; Terraform is versatile, extending its capabilities to key performance areas like Content Delivery Network (CDN) management, ensuring efficient content delivery and optimal user experience.‍Started This level of granularity is not found in UI-managed systems.Â

Open Source 52

Open Source DevOps AWS Infrastructure 52

IO River

NOVEMBER 2, 2023

When you codify infrastructure, you can integrate it with DevOps pipelines to automate various tasks like server provisioning, database scale, and security audits. The Terraform scripts you write not only serve as documentation but also as a disaster recovery plan. ‍If AutomationCode-based systems also shine in automation.

Open Source 40

Open Source DevOps AWS Infrastructure 40

Smashing Magazine

AUGUST 3, 2023

This is why the async and deferred attributes are crucial, as they ensure an efficient, seamless web browsing experience. Layout Shifts From Dynamic And Static Content We have been using dynamic content serving, where each request reaches our back-end server and triggers processes like database retrievals and page renderings.

Performance 75

Performance Cache Traffic Metrics 75

O'Reilly

NOVEMBER 21, 2019

Yes, automation has usually eliminated a small proportion of human jobs; at the same time, however, it has created new opportunities for those well-versed in software, databases, architecture, and operations. 1] GUI/windowing system, kernel/operating system, and, if documented, application APIs. But RPA is different. RPA Don’ts.

Processing 84

Processing Programming Virtualization Technology 84

Smashing Magazine

JUNE 28, 2021

I’m not sure how I’d missed it because it seems to be maturing and well documented and a real… Just a great project. There’s accessibility, best practices, performance and one fourth one. Drew: The Chakra documentation seems to be really well pitched, I thought, with… It has an overview of each component.

Website 63

Website Design Open Source Software 63

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40

The Netflix TechBlog

DECEMBER 11, 2020

This gives us access to Netflix’s Java ecosystem, while also giving us the robust language features such as coroutines for efficient parallel fetches, and an expressive type system with null safety. For storing schema changes, we use an internal library that implements the event sourcing pattern on top of the Cassandra database.

Architecture 249

Architecture Best Practices Engineering Open Source 249

SQL Performance

NOVEMBER 13, 2019

Indeed, if you check SQL Server's documentation of the ROW_NUMBER function , you will find the following text: "order_by_clause. But we're on a quest to find an efficient solution where the optimizer can realize that there's no ordering relevance. T1 ; This attempt results in the following error: Msg 4112, Level 15, State 1, Line 53.

Servers 104

Servers C++ Storage Performance 104

Smashing Magazine

JANUARY 7, 2019

From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19). So if you want to get started, there are some great resources out there: Webpack documentation — obviously — is a good starting point, and so are Webpack — The Confusing Bits by Raja Rao and An Annotated Webpack Config by Andrew Welch.

Performance 104

Performance Cache Metrics Network 104

Smashing Magazine

SEPTEMBER 27, 2021

In order to achieve this efficiently, you might be wondering what and how much you need to test. You might find one possible answer in a metaphor: The test automation pyramid , first introduced by Mike Cohn and further specified by Martin Fowler, shows how to make testing efficient. Cypress documentation. More after jump!

Testing 136

Testing Website Code Efficiency 136

Smashing Magazine

JANUARY 6, 2020

From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19). So if you want to get started, there are some great resources out there: Webpack documentation — obviously — is a good starting point, and so are Webpack — The Confusing Bits by Raja Rao and An Annotated Webpack Config by Andrew Welch.

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JULY 20, 2021

In this decoupled way, models and controllers are bundled on the WordPress side , handling data manipulation and database interaction. So they won’t have to involve the development team in this process and can do their work more efficiently. WP REST API Documentation Needed. Documentation. Monolithic vs Headless.

Website 142

Website Architecture Technology Technology 142

Smashing Magazine

AUGUST 12, 2021

There is also a searchable database for you to find what you are looking for. Hidden layers, single-layer groups, X and Y positions that aren’t quite pixel-perfect — the Clean Document plugin takes care of little flaws like these so you don’t have to. Notes are automatically saved with your documents and are available to other editors.

Google 145

Google Design Code Mobile 145

O'Reilly

OCTOBER 11, 2022

We’ll see it in the processing of the thousands of documents businesses handle every day. However, one thing should be obvious: to fill a prescription, you need to access many different kinds of data, in many different databases. Never assume that most businesses are well run, and that they represent some sort of “best practice.”

Games 120

Games Healthcare Processing Retail 120

Smashing Magazine

NOVEMBER 30, 2021

We last talked to him in July 2020 , where we asked if modern best practices about for the web. Last time we talked, we posed this question of if modern best practices, the use of reactive frameworks and these sorts of things were actually bad for the progress of the web. Drew: You want it to remain unspoiled.

Technology 96

Technology Technology Servers Code 96

Smashing Magazine

NOVEMBER 12, 2021

Thankfully, hooks solved all the problems simply and efficiently while creating room for more interesting features in React. The plugin provides useful warnings and hints on the best practices. This may be necessary to prevent memory leaks and make the application more efficient. Cleaning Up The Effect.

Code 119

Code Availability Efficiency Performance 119