Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

Scalegrid

APRIL 28, 2020

Since database hosting is more dependent on memory (RAM) than storage, we are going to compare various instance sizes ranging from just 1GB of RAM up to 64GB of RAM so you can see how costs vary across different application workloads. Is my database cluster still highly available? DigitalOcean using the below instance types: AWS.

Azure 344

Azure AWS Database Latency 344

Scalegrid

NOVEMBER 12, 2019

There are many things I love about it – PL/ PG SQL, smart defaults, replication (that actually works out of the box), and an active and vibrant open source community. In this blog post, we will detail some of these operational challenges with PostgreSQL. Feature-wise, it is up there with the best, if not the best.

Database 184

Database Open Source Servers Storage 184

Dynatrace

DECEMBER 18, 2023

Another source reported a 43% overall increase in Prometheus adoption for the last six months of 2021. As the two first graduates of the open source project incubator, the Cloud Native Computing Foundation (CNCF), Kubernetes and Prometheus are usually deployed together. What is Prometheus?

Metrics 172

Metrics Engineering Energy Tuning 172

Dynatrace

AUGUST 5, 2022

However, that assumes he or she is available and has time to talk. Consumers store messages in a queue — usually in a buffer or on a storage medium — until they can process and delete them. How an observability platform eases message queue monitoring appeared first on Dynatrace blog. Two styles of message queuing.

Monitoring 193

Monitoring Serverless Programming Speed 193

Dynatrace

AUGUST 5, 2022

However, that assumes he or she is available and has time to talk. Consumers store messages in a queue — usually in a buffer or on a storage medium — until they can process and delete them. How an observability platform eases message queue monitoring appeared first on Dynatrace blog. Two styles of message queuing.

Monitoring 192

Monitoring Serverless Programming Speed 192

Dynatrace

NOVEMBER 17, 2020

With these release candidate APIs available, instrumentation for web frameworks, storage clients, and much more can be built. We at Dynatrace understand the importance of contributing our expertise in enterprise-grade intelligent observability to the open source community. Dynatrace fully embraces OpenTelemetry.

Open Source 151

Open Source Software Engineering Government Java 151

Percona

JUNE 22, 2023

A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance. In this blog, we will explore various MySQL KPIs that are basic and essential to track using monitoring tools like PMM.

Performance 103

Performance Monitoring Traffic Database 103

Dynatrace

DECEMBER 16, 2021

The vulnerability was first reported to the Apache Foundation (an open-source project) on November 24 by security researcher Chen Zhaojun of Alibaba, China’s largest e-commerce company, after an attack was documented on December 9 and affected servers of the game Minecraft. Also, check back on this FAQ blog for frequent updates.

Internet 258

Internet Internet Games Java 258

Percona

OCTOBER 13, 2023

MySQL writes a.sdi file to accommodate the serialized dictionary information for storage engines that lack support for this functionality. Storage engine compatibility Different MySQL storage engines handle.sdi files in various ways. Storage engine compatibility Different MySQL storage engines handle.sdi files in various ways.

Storage 92

Storage Database Engineering Open Source 92

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). It continues to be developed and maintained by the open source community and remains free to use under the GNU General Public License.

Open Source 52

Open Source Servers Storage Scalability 52

Dynatrace

NOVEMBER 23, 2020

Nevertheless, there are related components and processes, for example, virtualization infrastructure and storage systems (see image below), that can lead to problems in your Kubernetes infrastructure. Configuring storage in Kubernetes is more complex than using a file system on your host. The Kubernetes experience.

Virtualization 159

Virtualization Infrastructure Monitoring Cloud 159

Percona

MARCH 21, 2023

In this blog, I’ll discuss the use case for replication. We want to improve our ability to replicate your data and limit replication to row-based events securely, wherein we do not have control over the source(s). The replica doesn’t have checking capabilities when processing replicated transactions as of MySQL 8.0.18.

Storage 85

Storage Open Source Database Engineering 85

Percona

JANUARY 20, 2023

When using cloud storage like EBS or similar, it is normally easy(er) to extend volumes, which gives us the luxury to plan the space to allocate for data with a good grade of relaxation. This blog is the story of what happened, what was supposed to happen, and why. The story The case was on AWS using EKS.

AWS 90

AWS Storage Monitoring Cloud 90

Percona

SEPTEMBER 12, 2023

MySQL 8’s solution MySQL 8 addresses the auto-increment counter loss issue in the InnoDB storage engine upon server restart. sec) Conclusion The auto-increment counter issue reported in MySQL versions prior to MySQL 8’s InnoDB storage engine could cause confusion and possibly data inconsistency, especially during server restarts.

Servers 109

Servers Storage Database Open Source 109

Percona

JANUARY 19, 2023

16 years ago, our founder Peter Zaitsev covered this topic and some of the points described there are still valid, and we will cover more on this blog. In this blog post, we will review key topics to consider for managing large datasets more efficiently in MySQL. It can help us to save costs on storage and backup times.

Open Source 86

Open Source Storage Database Big Data 86

Percona

FEBRUARY 10, 2023

Percona XtraBackup is an open source hot backup utility for MySQL-based servers. To take consistent and hot backup, it uses various locking methods, especially for non-transactional storage engine tables. This feature is available in Percona Server for MySQL 5.6+.

Storage 99

Storage Engineering Servers Open Source 99

Percona

AUGUST 1, 2023

In this blog, we’ll explore the process of altering VARCHAR columns online, delving into insights gained while expanding the size of such columns. After changing the VARCHAR column size to 200, the following is the storage requirement. Understanding the underlying storage mechanics is vital for successful alterations.

Storage 79

Storage Database Open Source Engineering 79

The Netflix TechBlog

JULY 30, 2019

and beyond By Anoop Panicker and Kishore Banala Conductor is a workflow orchestration engine developed and open-sourced by Netflix. In this blog, we would like to present the latest updates to Conductor, address some of the frequently asked questions and thank the community for their contributions.

Lambda 189

Lambda Media Open Source Metrics 189

Percona

JUNE 29, 2023

There are other options available too when using commitQuorum: “Voting Members” – This is the default behavior when an index will be created on all data-bearing voting replica set members (Default). . Below is the command used to create an index using commitQuorum as the majority : db.getSiblingDB("acme").products.createIndex({

Servers 79

Servers C++ Storage Best Practices 79

Percona

AUGUST 18, 2023

This blog will explore the hurdles encountered during the upgrade process and the innovative solution that saved the day. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. Recently, we had a client wanting to move from MariaDB 10.4 to MySQL 8.0, The incompatibility roadblock MariaDB 10.4

Open Source 66

Open Source Database Storage Engineering 66

Dynatrace

SEPTEMBER 17, 2019

Kubernetes (k8s) provides basic monitoring through the Kubernetes API and you can find instructions like Top 9 Open Source Tools for Monitoring Kubernetes as a “do it yourself guide”. PostgreSQL & Elastic for data storage. Dynatrace news. Full-stack observability. End-to-end code-level tracing. Service mash insights.

AWS 127

AWS Monitoring Ecommerce Lambda 127

Percona

AUGUST 7, 2023

In this blog post, we will delve into the differences between the InnoDB undo log and redo log, exploring their significance and providing code examples to illustrate their usage. InnoDB Undo Log The undo log, also known as the rollback segment, is a crucial part of the InnoDB storage engine.

Database 95

Database Tuning Storage Open Source 95

Percona

JULY 25, 2023

In this blog post, we will describe the improvements to Percona XtraBackup 8.0.33-28 After the “data dictionary” (DD) engine and DD cache are initialized on a server, the Storage Engines can ask for a table definition. 28 (PXB), which significantly reduces the time to prepare the backups before the restore operation.

Cache 85

Cache Benchmarking Servers Design 85

High Scalability

FEBRUARY 19, 2019

Redis Cluster is the native sharding implementation available within Redis that allows you to automatically distribute your data across multiple nodes without having to rely on external tools and utilities. At ScaleGrid, we recently added support for Redis Clusters on our platform through our fully managed Redis hosting plans.

Availability 204

Availability Open Source Cache Storage 204

Percona

JULY 13, 2023

In this blog post, we will explore utf8mb4 and its advantages in MySQL 8.0, Table: To ensure proper storage of emojis, let’s create the table columns using the utf8mb4 character set. With the rise of globalization, the need to store and process multilingual data has become essential. version as a game-changer.

Database 91

Database Games Open Source Engineering 91

Percona

JANUARY 4, 2024

Managing storage and performance efficiently in your MySQL database is crucial, and general tablespaces offer flexibility in achieving this. This blog discusses general tablespaces and explores their functionalities, benefits, and practical usage, along with illustrative examples. What are MySQL general tablespaces?

Storage 86

Storage Engineering Database Hardware 86

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 83

Availability Open Source Architecture Database 83

Scalegrid

MAY 13, 2020

In this blog post, we explain what Greenplum is, and break down the Greenplum architecture, advantages, major use cases, and how to get started. Greenplum Database is an open-source , hardware-agnostic MPP database for analytics, based on PostgreSQL and developed by Pivotal who was later acquired by VMware. Open Source.

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. This guide provides an overview of what high availability means, the components involved, how to measure high availability, and how to achieve it. How does high availability work?

Availability 106

Availability Database Open Source Hardware 106

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. In this blog post, we will delve into the world of PostgreSQL performance tuning and establish some basic guidelines for setting database parameters to enhance the performance of your PostgreSQL database, based on the workload.

Tuning 52

Tuning Efficiency Database Performance 52

Dynatrace

OCTOBER 4, 2022

This architecture offers rich data management and analytics features (taken from the data warehouse model) on top of low-cost cloud storage systems (which are used by data lakes). This decoupling ensures the openness of data and storage formats, while also preserving data in context. This scenario is a thing of the past.

Artificial Intelligence 261

Artificial Intelligence Analytics Storage Architecture 261

Percona

AUGUST 30, 2023

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. An incremental backup, which is faster and requires less storage than a full backup, captures changes made since the previous backup.

Database 86

Database Hardware Open Source Strategy 86

Percona

AUGUST 22, 2023

With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have. This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). What does high availability mean?

Availability 78

Availability Hardware Open Source Database 78

Scalegrid

JULY 17, 2020

For the purposes of this blog, when we refer to JSON support in PostgreSQL, we will refer to JSONB going forward. JSONB storage has some drawbacks vs. traditional columns: PostreSQL does not store column statistics for JSONB columns. JSONB storage results in a larger storage footprint.

Storage 321

Storage Database Efficiency Processing 321

Percona

FEBRUARY 24, 2023

Today, we are excited to announce the release of Percona Monitoring and Management (PMM) V2.35 , including a tech preview of label-based access control, the general availability of Helm Chart, and a range of enhancements to our Database as a Service (DBaaS) offerings, among other improvements and features. Stay tuned!

Availability 93

Availability Metrics Monitoring Open Source 93

The Symphonia

JUNE 19, 2018

Some in-depth and unusual client work (want to encrypt a petabyte of S3 storage? When building an application targeted to a FaaS platform it’s key to understand all the state-management options available to you in order to build a clean, high-performance, design. Unlike the temperature outside.

Serverless 40

Serverless AWS DevOps Open Source 40