Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. In this blog post, we will review key topics to consider for managing large datasets more efficiently in MySQL.

Open Source 88

Open Source Storage Database Big Data 88

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52

Smashing Magazine

SEPTEMBER 28, 2022

Jamstack is popular with documentation sites that usually compile code to HTML files and host them on the CDN. Caching partially stores your data and is not used as permanent storage. Using the cache as permanent storage is an anti-pattern. Both can be used simultaneously but will ultimately serve a different purpose.

Cache 125

Cache Performance Servers Social Media 125

Adrian Cockcroft

NOVEMBER 26, 2023

SUS101: Sustainability innovation in AWS Global Infrastructure AWS is determined to make the cloud the cleanest and most energy-efficient way to run customers’ infrastructure and business. This includes providing the efficient, resilient services AWS customers expect, while minimizing their environmental footprint. AWS speaker: T.

AWS 52

AWS Energy IoT Best Practices 52

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

The Netflix TechBlog

JULY 30, 2019

If you’re new to Conductor, this earlier blogpost and the documentation should help you get started and acclimatized to Conductor. Many of the Netflix Content and Studio Engineering services rely on Conductor for efficient processing of their business flows. The Netflix Media Database (NMDB) is one such example.

Lambda 189

Lambda Media Open Source Metrics 189

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

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. How to Implement Pagination in MongoDB® Big datasets require efficient data retrieval and processing for effective management. limit(number).

Best Practices 130

Best Practices Efficiency Strategy Speed 130

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 87

Database Hardware Open Source Strategy 87

Scalegrid

JULY 17, 2020

JSON is the most common format used by web services to exchange data, store documents, unstructured data, etc. Why should a relational database even care about unstructured data? Note: If a particular key is always present in your document, it might make sense to store it as a first class column. JSON database in 9.2

Storage 321

Storage Database Efficiency Processing 321

SQL Performance

APRIL 17, 2020

Depending on the type of change and the configuration of the database, an ALTER COLUMN command will need to perform one of the following actions: Change metadata in system tables only. With careful planning, the other steps required can be made as efficient as possible, for example using minimally-logged or ONLINE operations.

Servers 63

Servers Database Testing Efficiency 63

Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Speed is next; serverless solutions are quick to spin up or down as needed, and there are no delays due to limited storage or resource access. AWS offers four serverless offerings for storage.

Serverless 280

Serverless AWS Lambda Storage 280

Dynatrace

APRIL 20, 2023

With more automated approaches to log monitoring and log analysis, however, organizations can gain visibility into their applications and infrastructure efficiently and with greater precision—even as cloud environments grow. Logs are automatically produced and time-stamped documentation of events relevant to cloud architectures.

Analytics 187

Analytics Infrastructure Storage Efficiency 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 97

AWS Benchmarking Performance Traffic 97

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 75

Open Source Database Storage Scalability 75

The Agile Manager

NOVEMBER 30, 2015

They create documentation templates, project control forms, release and implementation workflows, and program checklists to create contracts among other managers to secure the time and attention of the people who do contribute to solution development. Clearly this cannot be so[.] -- Morgan, pages 237-8.

Systems 45

Systems Storage Programming Infrastructure 45

Percona

MARCH 29, 2023

Compression in any database is necessary as it has many advantages, like storage reduction, data transmission time, etc. Storage reduction alone results in significant cost savings, and we can save more data in the same space. By default, MongoDB provides a snappy block compression method for storage and network communication.

Storage 108

Storage Network Open Source Latency 108

Percona

FEBRUARY 24, 2023

In the Home Dashboard of PMM, a low CPU utilization on any of the database services that are being monitored could mean that the server is inactive or over-provisioned. From AWS documentation , Amazon EBS is an easy-to-use, scalable, high-performance block-storage service designed for Amazon EC2.

Cloud 119

Cloud Serverless AWS Storage 119

Smashing Magazine

NOVEMBER 2, 2021

Cost-Efficient And Effort-Saving Development. On the contrary, a native application of an e-commerce store can come at 30, 50, or even 100 MB and up, consuming internal device storage. These multiple “heads” are attached to the backend and database. Below are some main things to consider. Image credit: Apivita. Large preview ).

Code 74

Code Cache Retail Mobile 74

The Netflix TechBlog

JUNE 13, 2023

Our system doesn’t require strict consistency guarantees and does not use database transactions. Evaluation of migration completeness: To verify the completeness of the records, cold storage services are used to take periodic data dumps from the two data stores and compared for completeness.

Traffic 279

Traffic Metrics Systems Strategy 279

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 80

Database Servers Storage Strategy 80

Percona

JULY 5, 2023

Fragmentation is a common concern in some database systems. In databases, we can experiment with different types of fragmentation: Segment Fragmentation : segments are fragmented; they are stored not following the order of data, or there are empty pages gaps between the data pages. What is fragmentation?

Open Source 125

Open Source Database Efficiency Testing 125

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 107

Availability Database Open Source Hardware 107

Percona

FEBRUARY 23, 2023

If you ever had to make a quick ad-hoc backup of your MongoDB databases, but there was not enough disk space on the local disk to do so, this blog post may provide some handy tips to save you from headaches. Fortunately, there are ways to skip the local storage entirely and stream MongoDB backups directly to the destination.

AWS 120

AWS Storage Database Open Source 120

All Things Distributed

JUNE 21, 2018

A common question that I get is why do we offer so many database products? To do this, they need to be able to use multiple databases and data models within the same application. Seldom can one database fit the needs of multiple distinct use cases. Seldom can one database fit the needs of multiple distinct use cases.

Database 167

Database AWS Games Latency 167

Percona

JUNE 6, 2023

A full backup is a comprehensive data backup strategy that involves creating a complete, exact copy of all data and files in a database. In order to implement effective full backups of your database, you must follow some best practices. Get started today with Percona Backup for MongoDB. What is a full backup?

Storage 68

Storage Strategy Network Efficiency 68

Percona

AUGUST 29, 2023

A single command to deploy the operator would be: kubectl apply -f [link] --server-side Init SQL script Init SQL allows the creation of the database cluster with some initial data in it. You can change this; please see users documentation. In this case, the backups should be stored on some object storage.

Storage 94

Storage Database Media Open Source 94

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

Highly Scalable

MARCH 1, 2012

NoSQL databases are often compared by various non-functional criteria, such as scalability, performance, and consistency. At the same time, NoSQL data modeling is not so well studied and lacks the systematic theory found in relational databases. Document databases advance the BigTable model offering two significant improvements.

Database 279

Database Ecommerce Efficiency Engineering 279

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. Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. So, What is MySQL Partitioning?

Strategy 40

Strategy Storage Database Best Practices 40

All Things Distributed

JANUARY 18, 2012

a Fast and Scalable NoSQL Database Service Designed for Internet Scale Applications. Today is a very exciting day as we release Amazon DynamoDB , a fast, highly reliable and cost-effective NoSQL database service designed for internet scale applications. Werner Vogels weblog on building scalable and robust distributed systems.

Scalability 167

Scalability Database Ecommerce Latency 167

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. This level of distribution will seriously affect the efficiency of the operation, which will increase the response time significantly. This is it. The POC Why this POC?

Traffic 123

Traffic Scalability Database Servers 123

Percona

NOVEMBER 6, 2023

Percona Operators allow users to easily manage complex database systems in a Kubernetes environment. With Percona Operators , users can easily deploy, monitor, and manage databases orchestrated by Kubernetes, making it easier and more efficient to run databases at scale. component=pxc,app.kubernetes.io/instance=cluster1,app.kubernetes.io/managed-by=percona-xtradb-cluster-operator,app.kubernetes.io/name=percona-xtradb-cluster,app.kubernetes.io/part-of=percona-xtradb-cl

Metrics 70

Metrics Monitoring Database Cache 70

Percona

APRIL 17, 2023

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. The Linux default is usually 60 , which is not ideal for database usage. Spoiler alert: This post focuses on MongoDB 3.6.X

Best Practices 52

Best Practices Design Tuning Database 52

Percona

JULY 15, 2023

One very common problem when trying to optimize a database environment is index usage. Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. As such, index design must strike a balance between improved query speed and efficient data modification.

Virtualization 77

Virtualization Speed Database Efficiency 77

The Netflix TechBlog

MARCH 10, 2020

by Damir Svrtan and Sergii Makagon As the production of Netflix Originals grows each year, so does our need to build apps that enable efficiency throughout the entire creative process. At one point, more than 30 developers were working on it, and it had well over 300 database tables. whether it be Relational or Documents.

Architecture 345

Architecture Transportation Java Strategy 345

Tech News Gather

NOVEMBER 20, 2022

Blockchain is a payment system supported by a distributed database or ledger that records all transactions across a peer-to-peer network. Blockchain is an innovative technology because it is a distributed ledger that becomes the data storage medium for all business-related activities. Automated payments. Reduced risks.

Blockchain 52

Blockchain Innovation Efficiency Technology 52