Percona

JANUARY 4, 2024

Managing storage and performance efficiently in your MySQL database is crucial, and general tablespaces offer flexibility in achieving this. In contrast to the single system tablespace that holds system tables by default, general tablespaces are user-defined storage containers for multiple InnoDB tables.

Storage 91

Storage Engineering Database Hardware 91

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

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 82

Availability Hardware Open Source Database 82

Percona

JULY 24, 2023

PBM) introduced a GA version of incremental physical backups , which can greatly impact both the recovery time and the cost of backup (considering storage and data transfer cost). Well, it is because we believe that open source philosophy is not only about the source but also about design and decision-making.

Availability 79

Availability Open Source Strategy Storage 79

Dynatrace

JANUARY 16, 2023

Open-source software drives a vibrant Kubernetes ecosystem. On-premises data centers invest in higher capacity servers since they provide more flexibility in the long run, while the procurement price of hardware is only one of many cost factors. Open source software drives a vibrant Kubernetes ecosystem.

Open Source 343

Open Source Java Operating System Programming 343

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. There are numerous options available, each with its advantages and disadvantages.

Best Practices 130

Best Practices Storage Strategy Database 130

Scalegrid

JULY 13, 2020

The unstoppable rise of open source databases. One database in particular is causing a huge dent in Oracle’s market share – open source PostgreSQL. See how open source PostgreSQL Community version costs compare to Oracle Standard Edition and Oracle Enterprise Edition. What’s causing this massive shift?

Open Source 244

Open Source Tuning C++ Database 244

Dynatrace

MARCH 24, 2023

This orchestration includes provisioning, scheduling, networking, ensuring availability, and monitoring container lifecycles. The configuration file directs the container orchestration tool on how to retrieve container images, how to create a network between containers, and where to store log data or mount storage volumes.

Infrastructure 186

Infrastructure Open Source Operating System Cloud 186

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. Percona Server for MongoDB (PSMDB) supports all types of compression and enterprise-grade features for free.

Storage 112

Storage Network Open Source Latency 112

Percona

JUNE 29, 2023

Before Percona Server for MongoDB 4.4 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). . PSMDB), the best practice to create an index was doing it in a rolling manner.

Servers 83

Servers C++ Storage Best Practices 83

Dynatrace

JULY 29, 2021

The complexity of such deployments has accelerated with the adoption of emerging, open-source technologies that generate telemetry data, which is exploding in terms of volume, speed, and cardinality. Extend your topology mapping to include open-source observability data. Next steps.

Analytics 246

Analytics Open Source Serverless Architecture 246

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. Find more information in the Telemetry on Percona Server for MySQL document.

Open Source 82

Open Source Azure Servers Programming 82

Percona

DECEMBER 28, 2023

Starting with Percona Server for MySQL 8.0.34-26 26 , the Audit Log Filter is available in a technical preview mode. Compress the audit log files to reduce the storage space occupied with log files. A server restart is not required to add or adjust existing filtering rules. Dynamically enable or disable the auditing.

Open Source 107

Open Source Database Servers Storage 107

Scalegrid

SEPTEMBER 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. You can remotely access and navigate another database server. It supports all PostgreSQL operations and features while being free and open-source. pgAdmin Cost: Free (open source).

Open Source 262

Open Source Database Azure Cloud 262

Percona

AUGUST 30, 2023

An incremental backup, which is faster and requires less storage than a full backup, captures changes made since the previous backup. Disaster recovery (DR) strategies are essential to ensuring the integrity, availability, and reliability of data, particularly in the event of unexpected failures or errors.

Database 91

Database Hardware Open Source Strategy 91

Scalegrid

JULY 8, 2019

Are you looking to get started with the world’s most popular open-source database, and wondering how you should setup your MySQL hosting ? The first thing to consider when weighing between self-management and a MySQL Database-as-a-Service (DBaaS) solution is what internal resources you have available.

Azure 219

Azure Cloud Virtualization Database 219

Dynatrace

SEPTEMBER 29, 2021

Prometheus is an open-source monitoring and alerting toolkit for services and applications that run in containers. Prometheus components include client libraries for application code instrumentation, special-purpose exporters for popular services, and the optional Prometheus server for orchestrating service discovery and data storage.

Technology 210

Technology Technology Monitoring AWS 210

Percona

JANUARY 30, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. was made available on January 23, 2023. was made available on January 23, 2023. was made available on January 23, 2023.

Open Source 87

Open Source Storage AWS Cloud 87

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. Hopefully we can generate enough interest in the open source community to prioritize these features. Why not have this built it into the server?

Database 184

Database Open Source Storage Servers 184

Percona

JUNE 12, 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. Percona Server for MySQL 5.7.42-46 Download Percona Monitoring and Management 2.37.1

Open Source 86

Open Source Servers Database Scalability 86

Percona

MAY 8, 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. Percona Server for MongoDB 5.0.17-14 Percona Server for MongoDB 5.0.17-14

Monitoring 80

Monitoring Open Source Database Servers 80

Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 server with Percona XtraBackup. In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 server instances are ready for an upgrade. On primary server mysql5.7,

Servers 107

Servers C++ Storage Systems 107

Percona

APRIL 24, 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. Percona XtraDB Cluster is based on Percona Server for MySQL.

Open Source 81

Open Source Storage Servers Database 81

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Percona

MARCH 28, 2023

To briefly explain pgBackRest, it is an open source backup tool that takes FULL Backup, Incremental Backup, and Differential Backup for PostgreSQL databases. Repository means the location/path on the server or the cloud where the actual copy of the backup will reside. One can configure both repositories in different storage.

Servers 86

Servers Azure AWS Cloud 86

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance. Hint Hint, ProxySQL helps.

Performance 107

Performance Monitoring Traffic Database 107

Percona

JULY 17, 2023

MongoDB replica sets enable data redundancy and automatic failover, setting the stage (there’s that term again) for high availability. Not really open source : Even the MongoDB Community version is not open source; it’s source-available and is under the SSPL license (introduced by MongoDB itself).

Open Source 79

Open Source Database Scalability Software 79

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Some servers may need a few GBs of RAM, while others may need hundreds of GBs or even terabytes of RAM. Typically a good value is 70%-80% of available memory.

Performance 129

Performance Hardware Tuning Storage 129

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

Percona

FEBRUARY 10, 2023

Xbcloud is a tool part of Percona XtraBackup and allows you to upload and download backups to Amazon S3 storage. Percona XtraBackup is a free, open source, complete online backup solution for all versions of Percona Server for MySQL and MySQL. Download Percona XtraBackup

Storage 95

Storage Open Source AWS Servers 95

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. It has evolved steadily, however, during 25 years as an open source project. Another reason for PostgreSQL popularity (perhaps the biggest): It’s open source and free to use, distribute, and modify. What is PostgreSQL used for?

Open Source 82

Open Source Healthcare Social Media Database 82

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. High Availability. Test Connectivity Between Your WordPress Site & MySQL Server. Replication.

Database 166

Database Cloud Website Azure 166

Percona

FEBRUARY 24, 2023

Let’s take a look at how to get the benefits you need while spending less, based on the recommendations presented by Dani Guzmán Burgos, our Percona Monitoring and Management (PMM) Tech Lead, on this webinar (now available on demand) hosted in November last year. Marked in red in Figure 1 is a server with less than 30% of CPU usage.

Cloud 122

Cloud Serverless AWS Storage 122

Percona

APRIL 10, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Percona Distribution for MySQL (Percona Server for MySQL-based variation) 8.0.32 It’s time for the release roundup!

Open Source 80

Open Source Servers AWS Database 80

Dynatrace

DECEMBER 16, 2021

Since December 10, days after a critical vulnerability known as Log4Shell was discovered in servers supporting the game Minecraft, millions of exploit attempts have been made of the Log4j 2 Java library, according to one team tracking the impact, with potential threat to millions more applications and devices across the globe. Dynatrace news.

Internet 261

Internet Internet Games Java 261

Percona

SEPTEMBER 12, 2023

this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and reliability in data management. This counter value is stored in memory and is not persistent across server restarts. Compared to MySQL 5.7, sec) Query OK, 1 row affected (0.00 Trying to reconnect.

Servers 113

Servers Storage Database Open Source 113

Percona

DECEMBER 27, 2023

We want adopters of our technology to be able to deploy their critical open source databases and applications across any public or private cloud environment. All of the database automation for running a highly available, resilient, and secure database is built into the operator to simplify the operation and management of your clusters.

Cloud 82

Cloud Open Source Strategy Best Practices 82