Scalegrid

DECEMBER 28, 2023

Managing vast datasets effectively is an essential requirement for modern applications, and MongoDB , a leading NoSQL database, offers robust solutions for this requirement. Offset-based involves utilizing functions such as skip , limit and a query which indicates how many documents should be skipped or returned at maximum.

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 90

Open Source Database Hardware Strategy 90

Scalegrid

APRIL 5, 2024

Grasping the concept of Redis sharding is essential for expanding your Redis database. This method involves splitting data over various nodes to improve the database’s efficiency. Redis isn’t alone in utilizing sharding strategies — it’s a common concept found throughout database technologies to distribute workload efficiently.

Scalability 130

Scalability Efficiency Java Database 130

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

Dynatrace

JANUARY 31, 2024

SAP Basis teams have established best practices for managing their SAP systems. Teams benefit from a boost in aligning SAP operations practices with the operation of all surrounding systems that SAP depends on and those that depend on SAP. Any insights can be annotated and documented with the help of markdown.

Java 178

Java Analytics Best Practices Monitoring 178

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

JULY 7, 2023

With the average cost of unplanned downtime running from $300,000 to $500,000 per hour , businesses are increasingly using high availability (HA) technologies to maximize application uptime. Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges.

Availability 82

Availability Open Source Architecture Database 82

Alex Podelko

FEBRUARY 28, 2021

First of all, it is MongoDB and Atlas documentation: Performance , Monitoring , and Query Optimization. Atlas Performance Overview and Monitor Your Cluster documentation. Can’t say that it changed much since then industry-wise – but great free MongoDB courses are available to everybody). What is MongoDB FTDC (aka.

Performance 200

Performance IoT Education Best Practices 200

Dynatrace

JANUARY 19, 2020

Having released this functionality in a Preview Release back in May 2019, we’re now happy to announce the General Availability of our SAP ABAP monitoring extension. SAP database performance: Query response time, percentage of time spent in the database, and the number of database calls executed by the SAP server.

Monitoring 152

Monitoring Best Practices Infrastructure Servers 152

Scalegrid

DECEMBER 16, 2019

MongoDB is the #3 open source database and the #1 NoSQL database in the world. It’s a cross-platform document-oriented database that uses JSON-like documents with schema, and is leveraged broadly across startup apps up to enterprise-level businesses developing modern apps. minutes of downtime in one year.

Azure 187

Azure AWS Latency Database 187

Dynatrace

MAY 31, 2019

Collected metrics are analyzed in Dynatrace, using the SAP expert community’s established best-practice advice on ABAP platform health indicators, including response time breakdowns of the response times between ABAP-specific application server activities, tasks, and database interaction. Deployment and support.

Monitoring 160

Monitoring Best Practices Infrastructure Programming 160

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. The kernel’s memory allocation function allocates the requested page size, and sometimes more, rounded up to fit within the available memory.

Servers 109

Servers Best Practices Database Open Source 109

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections. This file is located at /etc/ssl on your MongoDB server.

Servers 130

Servers Best Practices Government Network 130

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

Dynatrace

MAY 28, 2020

If you have a distributed environment with multiple servers hosting your webservers, app servers, and database, I suggest you install the OneAgent on all these servers to get full end-to-end visibility. Please note – there is no need to restart your database servers. If your apps are deployed in a PaaS Platform, e.g:

Engineering 185

Engineering Performance Metrics Best Practices 185

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. or a later release.

Database 97

Database Engineering Best Practices Open Source 97

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. . available cpufreq governors: performance powersave. cpupower idle-info.

Best Practices 40

Best Practices Scalability Performance Hardware 40

Percona

AUGUST 3, 2023

As an experienced database developer, you should know that these kinds of queries should not exist in any production code. Metadata regarding invisibility is available on the information_schema, and the INVISIBLE/VISIBLE keyword is preserved in the binlog, so all changes are correctly replicated.

Best Practices 77

Best Practices Open Source Code Engineering 77

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

APRIL 24, 2023

Here we are just highlighting one of the scenarios during work on the client environment where we noticed that the ProxySQL mysql_users table had more than 100 user entries, but some of them were available/inserted into the clear text password, whereas some were inserted properly into hashed entries.

Database 78

Database Best Practices Open Source Testing 78

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

Adrian Cockcroft

NOVEMBER 26, 2023

In this session, learn how to build automated, serverless AWS architectures to upload, extract, process, verify, and validate supply chain documents, accelerating end-to-end supply chain transparency. This session revisits the pillar and its best practices. AWS speaker: T.

AWS 52

AWS Energy IoT Best Practices 52

Percona

JUNE 6, 2023

When it comes to backups, there are multiple types available, each with its own advantages and limitations. A full backup is a comprehensive data backup strategy that involves creating a complete, exact copy of all data and files in a database. Get started today with Percona Backup for MongoDB. What is a full backup?

Storage 66

Storage Strategy Network Efficiency 66

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

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.

Google 111

Google Architecture Servers Speed 111

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. In shard-nothing, each shard can live in a totally separate logical schema instance / physical database server/data center/continent. The POC Why this POC?

Traffic 122

Traffic Scalability Database Servers 122

Smashing Magazine

OCTOBER 2, 2023

for the web app, Sanity CMS, Firebase Auth, and Firestore database. Now, let’s dive into the technical features and best practices that my team adopted in the process of building the WaterBear web app. It’s available on the web , Android, and iOS. Here is how we tackled the challenge. image preload options. <head>

Cache 73

Cache Strategy Best Practices Design 73

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. Make sure these are available before you commit to a website builder. Shopify dominates WooCommerce and other rivals because it has more than 5,000 applications available in its app store.

Website 59

Website Development Mobile Storage 59

SQL Performance

DECEMBER 11, 2019

Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. Finally, I cover missing standard features related to NULL handling in T-SQL and suggest alternatives that are available in T-SQL. NULL as a marker for a missing value.

Best Practices 117

Best Practices C++ Database Code 117

Smashing Magazine

NOVEMBER 19, 2021

With 100s of real-life examples , guidelines and best practices that you can apply right away. This approach, however, is far from perfect as there is a delay between the page’s first render and the wildcard being available. An example would be a branded footer, on a technical documentation page. More after jump!

Servers 86

Servers Website Code Best Practices 86

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

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

VoltDB

MAY 2, 2017

This has always been a supported configuration of VoltDB database replication. Here’s how we explain it in our Documentation: Support for different cluster sizes in passive Database Replication (DR). One consideration is availability vs. completeness. The simplest configuration might be called a “balanced” approach.

Hardware 40

Hardware Database Servers Tuning 40

All Things Distributed

APRIL 5, 2012

One of the services that is very successful in driving innovation at our customers in this context is Amazon RDS , the Relational Database Service. Amazon RDS removes the headaches of running a relational database service reliably at scale, allowing Amazon RDS customers to focus on innovation for their customers. hands freeÃ?

Innovation 146

Innovation AWS Education Network 146

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

The Netflix TechBlog

DECEMBER 3, 2022

For more information on this and other examples please visit the Dataflow documentation page." Optionally, this step can use the Write-Audit-Publish pattern to ensure that data is correct before it is made available to the rest of the company. Centralized Best Practices Data infrastructure evolves continually.

Best Practices 358

Best Practices Code Testing Data Engineering 358