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

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 2, 2023

In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster. The size of the database and your database environment—if it is on colo or cloud—matters. They also ensure that backup strategies adhere to industry and legal compliance requirements.

Strategy 52

Strategy Database Storage Open Source 52

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

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

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. MongoDB Replication Strategies.

Azure 187

Azure AWS Latency Database 187

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

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. Looking for a MongoDB backup solution? What is a full backup?

Storage 66

Storage Strategy Network Efficiency 66

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

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

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

Smashing Magazine

OCTOBER 2, 2023

for the web app, Sanity CMS, Firebase Auth, and Firestore database. Definitely read up on the strategy and reasoning behind this stack in the first article if you missed it. Now, let’s dive into the technical features and best practices that my team adopted in the process of building the WaterBear web app.

Cache 73

Cache Strategy Best Practices Design 73

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 87

Best Practices Tuning Database Testing 87

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 75

Performance Cache Traffic Metrics 75

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 86

Servers Website Code Best Practices 86

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

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. An RPA initiative must be aligned with the organization’s overall digital transformation strategy. But RPA is different.

Processing 84

Processing Programming Virtualization Technology 84

Smashing Magazine

JANUARY 7, 2019

It might be tempting to get into quick "low-hanging-fruits"-optimizations early on — and eventually it might be a good strategy for quick wins — but it will be very hard to keep performance a priority without planning and setting realistic, company-tailored performance goals. when web fonts aren’t loaded yet). Large preview ).

Performance 104

Performance Cache Metrics Network 104

Smashing Magazine

JUNE 28, 2021

The Rise Of Design Thinking As A Problem Solving Strategy. 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. But the documentation is great in that it’s very linear.

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

Smashing Magazine

JANUARY 6, 2020

It might be tempting to get into quick "low-hanging-fruits"-optimizations early on — and it might be a good strategy for quick wins — but it will be very hard to keep performance a priority without planning and setting realistic, company-tailored performance goals. when web fonts aren’t loaded yet). Planning, planning, planning.

Performance 145

Performance Cache Network Metrics 145

The Netflix TechBlog

DECEMBER 11, 2020

The biggest challenge was aligning on this strategy across the organization. For storing schema changes, we use an internal library that implements the event sourcing pattern on top of the Cassandra database. We engaged with them to determine graph schema best practices to best suit the needs of Studio Engineering.

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. When there is a supporting index in place, you're limiting the storage engine to an index order scan strategy (following the index linked list). In short, don't do this.

Servers 104

Servers C++ Storage Performance 104

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. Cypress documentation. Getting Started.

Testing 136

Testing Website Code Efficiency 136

Smashing Magazine

JULY 20, 2021

In this decoupled way, models and controllers are bundled on the WordPress side , handling data manipulation and database interaction. Rethink Your Content Strategy For A Headless CMS ”. “ WP REST API Documentation Needed. Documentation. Meanwhile, the front-end only interacts with the REST API via an HTTP client.

Website 142

Website Architecture Technology Technology 142

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. What will cause those trends to end, and what strategies will the business need to adopt?

Games 120

Games Healthcare Processing Retail 120