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

AUGUST 1, 2023

Source: “Meowing” attack completely destroyed more than 1000 databases These are the words of Bob Diachenko, one of the most respected cybersecurity researchers in relation to a “Meowing” attack, which destroyed between 1000-4000 databases around the world. MongoDB databases commonly exceed a terabyte of data.

Best Practices 40

Best Practices Transportation Open Source Traffic 40

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

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. . Start the PostgreSQL Database. cat /proc/meminfo. HugePages_Total: 35000.

Best Practices 40

Best Practices Scalability Performance Hardware 40

Dynatrace

JANUARY 5, 2022

To do so we have successfully established AI-based White box load and resiliency testing with JMeter and Dynatrace, helping identify and resolve major performance and scalability problems in recent projects before deploying to production. Here’s how we have implemented and extended those practices: Test context through web request header.

Testing 206

Testing Open Source Metrics Infrastructure 206

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

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

AUGUST 3, 2023

As an experienced database developer, you should know that these kinds of queries should not exist in any production code. For further details, you can have a look at the documentation: [link] Generated Invisible Primary Keys This feature has been deployed in MySQL 8.0.30; it’s more recent.

Best Practices 77

Best Practices Open Source Code Engineering 77

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 122

Traffic Scalability Database Servers 122

Percona

APRIL 24, 2023

Plain text passwords are extremely vulnerable to unauthorized access, as anyone with access to the database or configuration files can easily read them. Hence, we could say, ProxySQL and MySQL communication better support users that are created with the mysql_native_password plugin inside the database.

Database 78

Database Best Practices Open Source Testing 78

Percona

JULY 19, 2023

You can build within the extracted source tree, but this goes against best practices. If you want a more detailed explanation, please consult the documentation. Now that we have the code tree extracted and our plugin code ready, we need to create a build location. The contents below is my tl;dr. spolier* It’s better!)

C++ 79

C++ Servers Benchmarking Best Practices 79

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. As the data is distributed into smaller partitions, the database engine only needs to scan relevant partitions, leading to faster query responses.

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. Even if the builder is easy, you should always opt-in for tutorials and documents. 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

HammerDB

OCTOBER 17, 2018

This is a very typical FAQ and although detailed in the documentation some extra details may help in sizing and configuration. However most people use HammerDB with keying and thinking time disabled and therefore each virtual user can approximately drive the CPU resources of one CPU core on the database server.

C++ 40

C++ Testing Virtualization Cache 40

All Things Distributed

APRIL 5, 2012

Werner Vogels weblog on building scalable and robust distributed systems. One of the services that is very successful in driving innovation at our customers in this context is Amazon RDS , the Relational Database Service. The best part was that the entire process was what I call Ã?hands All Things Distributed. Comments ().

Innovation 146

Innovation AWS Education Network 146

Smashing Magazine

AUGUST 3, 2023

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

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. ‍This workflow not only streamlines processes but also ensures that any changes are in line with the organization's best practices and compliance standards.‍Advantages

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

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

For storing schema changes, we use an internal library that implements the event sourcing pattern on top of the Cassandra database. We partnered with Netflix’s Developer Experience (DevEx) team to build out documentation, training materials, and tutorials for developers. The schema registry is developed in-house, also in Kotlin.

Architecture 249

Architecture Best Practices Engineering Open Source 249

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

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. But not only on the visual aspect, but they will also be looking to improve the performance of the database, so you get your content instantly and forget about all the work that is involved. Monolithic.

Website 142

Website Architecture Technology Technology 142