Percona

NOVEMBER 2, 2023

On October 24th, the Percona Kubernetes Squad held the first Ask-me-Anything (AMA) session to address inquiries regarding the utilization of Kubernetes for database deployment. Q1: When is it appropriate to use Kubernetes for databases, and when is it not recommended? ” This talk covers this topic exactly.

Open Source 85

Open Source Hardware Storage Database 85

Percona

DECEMBER 27, 2023

In our conversations with developers and engineers during the conference, we confirmed the CNCF GItOps Microsurvey data – 91% are already using GitOps. of respondents are currently utilizing databases in Kubernetes (k8s). They also remove toil and allow engineers to focus on application development vs platform engineering work.

Cloud 79

Cloud Open Source Strategy Best Practices 79

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 91

Open Source Database Hardware Strategy 91

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. It’s used for data management (shocker), application development, and data analytics. StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. What is PostgreSQL used for?

Open Source 77

Open Source Healthcare Social Media Database 77

Percona

DECEMBER 4, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Community Edition in addition to enterprise-grade features developed by Percona.

Open Source 79

Open Source Azure Servers Programming 79

DZone

DECEMBER 17, 2021

The load testing for the database needs to be conducted usually so that the impact on the system can be monitored in different scenarios, such as query language rule optimization, storage engine parameter adjustment, etc. Why Load Testing Matters in Nebula Graph? The operating system in this article is the x86 CentOS 7.8.

Testing 240

Testing Operating System Storage Performance 240

The Netflix TechBlog

OCTOBER 19, 2020

Troubleshooting a session in Edgar When we started building Edgar four years ago, there were very few open-source distributed tracing systems that satisfied our needs. Our tactical approach was to use Netflix-specific libraries for collecting traces from Java-based streaming services until open source tracer libraries matured.

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

Percona

OCTOBER 13, 2023

A common practice among DBAs and developers is to copy table data and.frm files from the data dictionary. MySQL writes a.sdi file to accommodate the serialized dictionary information for storage engines that lack support for this functionality. The exact handling can vary depending on the storage engine. In MySQL 8.0,

Storage 93

Storage Database Engineering Open Source 93

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

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 180

Metrics Engineering Energy Tuning 180

Percona

JUNE 30, 2023

Percona, a leading provider of open-source database software and services, announced the general availability of Percona Operator for PostgreSQL version 2. The solution is 100% open source and automates the deployment and management of PostgreSQL clusters on Kubernetes. In version 1.x,

Availability 93

Availability Open Source Azure Hardware 93

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

OCTOBER 10, 2023

Databases are different from a lot of software. This is not a general rule, but as databases are responsible for a core layer of any IT system – data storage and processing — they require reliability. For one, they often favor stability over innovation. Even with that, the fact that MongoDB 5.0 on your radar.

Availability 98

Availability Servers Database Open Source 98

The Polyglot Developer

APRIL 6, 2017

When building a mobile application, there are often scenarios where you need to storage files remotely and when I say files, I don’t mean database data. For example, maybe you want to develop an image manager or photo storage solution like what Facebook and Instagram offer?

Storage 59

Storage Cloud Open Source Mobile 59

Dynatrace

AUGUST 5, 2022

A message queue is a form of middleware used in software development to enable communications between services, programs, and dissimilar components, such as operating systems and communication protocols. Consumers store messages in a queue — usually in a buffer or on a storage medium — until they can process and delete them.

Monitoring 202

Monitoring Serverless Programming Speed 202

Dynatrace

AUGUST 5, 2022

A message queue is a form of middleware used in software development to enable communications between services, programs, and dissimilar components, such as operating systems and communication protocols. Consumers store messages in a queue — usually in a buffer or on a storage medium — until they can process and delete them.

Monitoring 201

Monitoring Serverless Programming Speed 201

Percona

SEPTEMBER 12, 2023

The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. Connection id: 2 Current database: db1 + -+ -+ | id | username | + -+ -+ | 1 | user1 | | 2 | user2 | + -+ -+ 2 rows in set (0.01 Compared to MySQL 5.7, sec) Query OK, 1 row affected (0.00

Servers 110

Servers Storage Database Open Source 110

Dynatrace

NOVEMBER 23, 2020

While speeding up development processes and reducing complexity does make the lives of Kubernetes operators easier, the inherent abstraction and automation can lead to new types of errors that are difficult to find, troubleshoot, and prevent. Configuring storage in Kubernetes is more complex than using a file system on your host.

Virtualization 161

Virtualization Infrastructure Monitoring Cloud 161

Percona

MARCH 21, 2023

In that situation, implementing the upstream changes in a more constrained security context is beneficial to organizations needing privilege-controlled aggregate data from multiple separate databases. When require_row_format is set to ON, MySQL will require that all tables that use the InnoDB storage engine use the ROW format.

Storage 86

Storage Open Source Database Engineering 86

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. It can help us to save costs on storage and backup times. It is available under a paid subscription.

Open Source 87

Open Source Storage Database Big Data 87

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 74

Open Source Database Storage Scalability 74

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

MAY 13, 2020

Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL. 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. What is an MPP Database?

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

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

Adrian Cockcroft

NOVEMBER 26, 2023

AWS speaker: Aditi Suresh, Customer speaker: Brian Rowe SUS205: Slowing down deforestation by using AI, ML, and open source data Organizations worldwide are developing solutions to evaluate, monitor, or predict land use and cover change in order to identify potential carbon credit projects, deforestation trends, and future wildfire risk areas.

AWS 52

AWS Energy IoT Best Practices 52

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. The Netflix Media Database (NMDB) is one such example. If you’re new to Conductor, this earlier blogpost and the documentation should help you get started and acclimatized to Conductor.

Lambda 189

Lambda Media Open Source Metrics 189

Percona

JULY 25, 2023

Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again. The redo apply phase wouldn’t make the database consistent with respect to a transaction. The data is internally inconsistent because the server concurrently modifies the data files while they are being copied.

Cache 85

Cache Benchmarking Servers Design 85

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. MaaS for Developers: Understand and optimize your code. Dynatrace news. Service mash insights.

AWS 128

AWS Monitoring Ecommerce Lambda 128

Scalegrid

MARCH 28, 2024

Introduction Caching serves a dual purpose in web development – speeding up client requests and reducing server load. This article will explore how they handle data storage and scalability, perform in different scenarios, and, most importantly, how these factors influence your choice. Data transfer technology.

Cache 130

Cache Storage Scalability Architecture 130

The Morning Paper

MARCH 10, 2020

Therefore, using the benchmarking results of YCSB as guidance for production might cause some misleading results… To address this issue, we propose a key-range based modelling and develop a benchmark that can better emulate the workloads of real-world key-value stores. It matters because RocksDB reads from storage in data blocks (e.g.

Benchmarking 59

Benchmarking Storage Cache Open Source 59

Scalegrid

FEBRUARY 1, 2024

MySQL is a popular open-source relational database management system for online applications and data warehousing. Because of this, preserving the availability and integrity of the data stored in MySQL databases requires regular backups. It’s renowned for its dependability, effectiveness, and simplicity.

Best Practices 130

Best Practices Storage Strategy Database 130

Percona

JANUARY 30, 2023

As Ibrar Ahmed noted in his blog post on Transparent Database Encryption (TDE). PostgreSQL is a surprising outlier when it comes to offering Transparent Database Encryption. If database files are copied or otherwise exposed in their raw form, exposure does not happen. Does PostgreSQL Need TDE (Transparent Data Encryption)?

Database 124

Database Storage Government Open Source 124

Scalegrid

SEPTEMBER 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. Why Use a GUI Tool?

Open Source 262

Open Source Database Azure Cloud 262

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. So to test I took a system with Skylake CPUs and all storage on a P4800X SSD. linux-glibc2.12-x86_64.

Testing 48

Testing Tuning Latency Storage 48

The Netflix TechBlog

MAY 21, 2019

Lerner, as a web-service, relies on Amazon Web Services (AWS) and Netflix’s Open Source Software (OSS) tools. The data can be truncated after each execution and offloaded to a long-term storage for further analysis. We developed client libraries that allow seamless, but opinionated, integration with Lerner.

Testing 163

Testing AWS Lambda Network 163

Scalegrid

JULY 29, 2019

MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. We help you configure your MySQL deployment to optimize your performance based on the size of your databases.

Database 166

Database Cloud Website Azure 166

Scalegrid

JULY 17, 2020

Why should a relational database even care about unstructured data? JSON database in 9.2 It is useful to validate incoming JSON and store in the database. JSONB storage has some drawbacks vs. traditional columns: PostreSQL does not store column statistics for JSONB columns. JSONB Patterns & Antipatterns.

Storage 321

Storage Database Efficiency Processing 321