Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

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 114

Servers Best Practices Database Open Source 114

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 102

Database Engineering Best Practices Open Source 102

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 79

Best Practices Open Source Code Engineering 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

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 81

Database Best Practices Open Source Testing 81

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.

C++ 82

C++ Servers Benchmarking Best Practices 82

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 94

Open Source Database Hardware Strategy 94

Scalegrid

MARCH 8, 2024

With MySQL point-in-time recovery , you can restore your database to the moment before the problem occurs. Preparation for PITR is crucial and involves enabling binary logging and creating a full database backup. STATEMENT level – at which only SQL statements causing changes in data are documented succinctly.

Database 162

Database Strategy Servers Best Practices 162

Percona

APRIL 17, 2023

In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. The Linux default is usually 60 , which is not ideal for database usage.

Best Practices 52

Best Practices Design Tuning Database 52

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

NOVEMBER 1, 2023

As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. Learn more: Discover six of the most common causes of poor database performance in our free eBook. What is the Recovery Time Objective?

Best Practices 79

Best Practices Storage Strategy Database 79

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 89

Database Hardware Open Source Strategy 89

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. In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here.

Best Practices 117

Best Practices C++ Database Code 117

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

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 41

Best Practices Transportation Open Source Traffic 41

Smashing Magazine

NOVEMBER 19, 2021

With 100s of real-life examples , guidelines and best practices that you can apply right away. An example would be a branded footer, on a technical documentation page. Following this, we can then take certain actions such as fetching different data from your database depending on the wildcard and return that from the API.

Servers 84

Servers Website Code Best Practices 84

The Netflix TechBlog

DECEMBER 3, 2022

For more information on this and other examples please visit the Dataflow documentation page." See example below: - template: id: wap type: wap tables: - ${CATALOG}/${DATABASE}/${TABLE} write_jobs: - job: id: write type: Spark spark: script: $S3{./src/sparksql_write.sql} test_sparksql_write.py Let’s review them below.

Best Practices 358

Best Practices Code Testing Data Engineering 358

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

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 199

Java Analytics Best Practices Monitoring 199

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 109

Availability Database Open Source Hardware 109

Percona

OCTOBER 18, 2023

See more details in the documentation. Backups server-side encryption (SSE) JIRA Github Whether it is compliance or security requirements, there is often a need to encrypt database backups. But what about logical backups, where data from your databases is copied as is to the object storage? my-cluster-name-rs0.test.svc.cluster.local

Best Practices 93

Best Practices Storage AWS Big Data 93

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). Once the replication of changes has resumed, pause the database at the backup site.

Hardware 40

Hardware Database Servers Tuning 40

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

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 98

AWS Benchmarking Performance Traffic 98

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 62

Website Design Open Source Software 62

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

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 198

Engineering Performance Metrics Best Practices 198

The Netflix TechBlog

FEBRUARY 25, 2021

Our experience using GQLMS for rapid proof-of-concept applications confirmed two theories regarding the advertised benefits of GraphQL: The GraphiQL IDE displays any available GraphQL documentation right alongside the schema, dramatically improving developer ergonomics for API consumers (in contrast to the best-in-class Swagger UI ).

Database 201

Database Entertainment Infrastructure Architecture 201

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 81

Database Servers Storage Strategy 81

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

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 76

Database Best Practices Open Source C++ 76

Percona

JULY 19, 2023

Start it up Deploy and prepare ArgoCD ArgoCD has quite detailed documentation explaining the installation process. Install it by following the CLI installation documentation. You can find my manifests here. I did the following: kubectl create namespace argocd kubectl apply -n argocd -f [link] Expose the ArgoCD server.

Servers 80

Servers Best Practices DevOps Open Source 80

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

SQL Server According to Bob

JULY 13, 2016

This is effectively the same as if you had used the full install and picked the features of Database Engine Services and Client Connectivity SDK as the two components to install. In addition, we enable the best practice setting for instant file initialization (equivalent to the setup command line parameter SQLSVCINSTANTFILEINIT).

Servers 40

Servers Media Engineering Virtualization 40

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