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. It is important to begin with a thorough database backup to prepare for such situations.

Database 162

Database Strategy Servers Best Practices 162

Percona

OCTOBER 20, 2023

Heck, typing “database migration plan” into Google and reading this blog could constitute planning. In brief, a proper database migration plan includes: Establishing clear objectives: Define what you want to achieve and how open source will get there. Some level of planning is expected when migrating to open source.

Open Source 88

Open Source Database Best Practices Strategy 88

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

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 92

Open Source Database Hardware Strategy 92

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 88

Database Hardware Open Source Strategy 88

Percona

SEPTEMBER 1, 2023

Database architects working with MongoDB encounter specific challenges related to database systems and system growth. Scalability is a significant concern, as databases must handle growing data volumes and user demands while maintaining peak performance. Learn more: View our webinar on How to Scale with MongoDB.

Best Practices 72

Best Practices Traffic Database Servers 72

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. More in the following sub-section.)

Availability 108

Availability Database Open Source Hardware 108

Percona

JULY 2, 2023

In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster. In setting up our demonstration system, we use pg_basebackup and continuous archiving. The size of the database and your database environment—if it is on colo or cloud—matters.

Strategy 52

Strategy Database Storage Open Source 52

Scalegrid

JANUARY 12, 2024

Simply put, it’s the set of computational tasks that cloud systems perform, such as hosting databases, enabling collaboration tools, or running compute-intensive algorithms. Such demanding use cases place a great value on systems capable of fast and reliable execution, a need that spans across various industry segments.

Cloud 130

Cloud Virtualization Storage Efficiency 130

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. Implementing pagination can be done using two primary strategies: offset-based and cursor-based methods. So in effect, our page size is 10. The result?

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Percona

SEPTEMBER 1, 2023

MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

Dynatrace

OCTOBER 10, 2023

This intricate allocation strategy can be categorized into two main domains. Process Improvements (50%) The allocation for process improvements is devoted to automation and continuous improvement SREs help to ensure that systems are scalable, reliable, and efficient. These tasks collectively ensure uninterrupted production service.

Engineering 235

Engineering DevOps Innovation Strategy 235

Dynatrace

SEPTEMBER 30, 2021

We’ll answer that question and explore cloud migration benefits and best practices for how to go through your migration smoothly. A cloud migration strategy, however, provides technical optimization that’s also firmly rooted in the business value chain. What is cloud migration? Read eBook now! Multicloud complexity.

Cloud 172

Cloud Traffic Best Practices Strategy 172

Percona

DECEMBER 27, 2023

of respondents are currently utilizing databases in Kubernetes (k8s). These indicators suggest that the adoption of databases on k8s is in its early stages and is likely to continue growing in the future. Nearly every vendor at Kubecon and every person we spoke to had some form of a multi-cloud requirement or strategy.

Cloud 80

Cloud Open Source Strategy Best Practices 80

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

DECEMBER 6, 2023

This blog is regarding some of the usual MySQL database conversations and responses, which can appear “wrong” or “funny,” but there’s actually more to them. Additional read Mike’s blog on How to Find and Tune a Slow SQL Query Q: What is your disaster recovery (DR) strategy? ” you may ask.

Strategy 78

Strategy Database Best Practices Tuning 78

Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Efficiency Database Performance 52

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 97

AWS Benchmarking Performance Traffic 97

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics 130

Metrics Monitoring Latency Cache 130

The Netflix TechBlog

DECEMBER 11, 2020

The biggest challenge was aligning on this strategy across the organization. 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. This journey hasn’t been without its challenges.

Architecture 249

Architecture Best Practices Engineering Open Source 249

Percona

JUNE 6, 2023

Therefore, establishing a strong backup strategy is essential to ensure data security and minimize potential disruptions. A full backup is a comprehensive data backup strategy that involves creating a complete, exact copy of all data and files in a database.

Storage 68

Storage Strategy Network Efficiency 68

The Netflix TechBlog

JUNE 25, 2021

Netflix’s internal teams strive to provide leverage by investing in easy-to-use tooling that streamlines the user experience and incorporates best practices. Dynomite is a high-speed in-memory database, providing highly available cross datacenter replication while preserving Redis-like semantics.

Metrics 152

Metrics Best Practices Strategy Design 152

Dynatrace

JANUARY 13, 2021

Dynatrace’s OneAgent automatically captures PurePaths and analyzes transactions end-to-end across every tier of your application technology stack with no code changes, from the browser all the way down to the code and database level. They allow us to easily create a primary key of a configuration that is unique in the system.

Open Source 141

Open Source Code Monitoring Azure 141

Dotcom-Montior

NOVEMBER 27, 2018

Additionally, end users can access your site or applications from anywhere in the world using different browsers, operating systems, and mobile devices, all with varying connection speeds. LoadView – Best Practices and Process. Finding upper limits of your current systems for capacity planning.

Performance Testing 40

Performance Testing Strategy Testing Performance 40

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. This can leave your database instances exposed and vulnerable.

Database 80

Database Servers Storage Strategy 80

Percona

SEPTEMBER 1, 2023

Web applications rely on databases to run the internet, powering everything from e-commerce platforms to social media networks to streaming services. MySQL is one of the most popular database management systems, playing a pivotal role in the functionality and performance of web applications.

Performance 52

Performance Storage Social Media Database 52

Percona

JULY 6, 2023

Performance is one of the essential aspects of a database management system. I included a sequence creation statement for the id column since one best practice is always to have a primary key column, but for the specific examples we will go through, we don’t need it. Next is the table definition.

Best Practices 90

Best Practices Tuning Database Testing 90

Smashing Magazine

DECEMBER 22, 2021

You’ll find psychology heuristics just like tips for building a winning UX strategy , dive deep into user research and UX writing , and explore real-world examples — good and bad — from which you can learn to create experiences that truly matter. The Ultimate Guide to UX Research shares tips and best practices from leading industry experts.

Airlines 129

Airlines Mobile Design Strategy 129

The Morning Paper

FEBRUARY 18, 2020

Enterprises in every industry are developing strategies for digitally transforming their businesses at every level. ML learning systems combine the characteristics of software, e.g. the need for CI/CD pipelines, and of data, e.g. the need to track lineage. And there’s going to be a lot of them!

Government 95

Government Software Engineering Storage Database 95

Percona

SEPTEMBER 1, 2023

MySQL triggers are a powerful tool for database administrators and developers, enabling them to automate tasks, enforce data consistency, and respond to events within the database seamlessly. A Trigger in MySQL is a database object that plays a pivotal role in database management.

Cache 61

Cache Database Games Healthcare 61

O'Reilly Software

SEPTEMBER 7, 2018

Introduction to Chaos Architecture: Gaining from Learning Loops and System Weaknesses , by Russ Miles, ChaosIQ.io. In the talk linked here, Russ Miles asks the pointed question: "What happens when (not if ) something in your system breaks? Technology Strategy Patterns for Architects , by Eben Hewitt, Sabre.

Software Architecture 64

Software Architecture Architecture Software Software 64

Smashing Magazine

AUGUST 3, 2023

These pages serve as a pivotal tool in our digital marketing strategy, not only providing valuable information about our services but also designed to be easily discoverable through search engines. Although landing pages are a common practice in online marketing, we were trying to make the most of it. SEO is key to our success.

Performance 74

Performance Cache Traffic Metrics 74

IO River

NOVEMBER 2, 2023

‍AutomationCode-based systems also shine in automation. When you codify infrastructure, you can integrate it with DevOps pipelines to automate various tasks like server provisioning, database scale, and security audits. They check it thoroughly, ensuring it's in line with all other systems in place and won't cause any hiccups.

Open Source 52

Open Source DevOps AWS Azure 52

Smashing Magazine

NOVEMBER 19, 2021

Unfortunately, there aren’t any special systems to provide custom statically generated pages for different wildcard subdomains like you may with dynamic routing for example (where you have [slug].js With 100s of real-life examples , guidelines and best practices that you can apply right away. Difficulties with Development.

Servers 84

Servers Website Code Best Practices 84

IO River

NOVEMBER 2, 2023

This level of granularity is not found in UI-managed systems. AutomationCode-based systems also shine in automation. When you codify infrastructure, you can integrate it with DevOps pipelines to automate various tasks like server provisioning, database scale, and security audits.

Open Source 40

Open Source DevOps AWS Azure 40

O'Reilly

NOVEMBER 21, 2019

In a classic 1983 paper , cognitive psychologist Lisanne Bainbridge drew attention to a curious irony: so-called “automated” systems were, in practice, usually attended by one or more human operators. The more advanced the system, she observed, “the more crucial…the contribution of the human operator.” But RPA is different.

Processing 83

Processing Programming Virtualization Technology 83

Smashing Magazine

SEPTEMBER 27, 2021

However, end-to-end testing does have some pitfalls that are cause for concern: End-to-end tests are slow and, thus, pose a significant hurdle in every continuous integration and continuous deployment (CI/CD) strategy. Cypress’ test runner is open-source, so it fits our product strategy. Large preview ). I’d like to focus on one level.

Testing 135

Testing Website Code Efficiency 135