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

Problems include provisioning and deployment; load balancing; securing interactions between containers; configuration and allocation of resources such as networking and storage; and deprovisioning containers that are no longer needed. Originally created by Google, Kubernetes was donated to the CNCF as an open source project.

Infrastructure 186

Infrastructure Open Source Operating System Cloud 186

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. How can we optimize for performance and scalability? Extend your topology mapping to include open-source observability data.

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 81

Open Source Azure Servers Programming 81

Scalegrid

FEBRUARY 1, 2024

MySQL is a popular open-source relational database management system for online applications and data warehousing. The biggest drawbacks are that a full backup can be time-consuming, and they require a significant amount of storage space. Therefore, it’s not the ideal choice if there are time or storage limitations.

Best Practices 130

Best Practices Storage Strategy Database 130

Dynatrace

DECEMBER 15, 2022

While engaging the automatic instrumentation of the Dynatrace OneAgent makes log ingestion automatic and scalable , our customers have set up multiple other log ingestion methods. Typically, these are streamed to a central syslog server. Set up the configuration on the same port as specified for source data, in this example 5140.

Strategy 180

Strategy AWS Open Source Transportation 180

Percona

DECEMBER 28, 2023

Starting with Percona Server for MySQL 8.0.34-26 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. 26 , the Audit Log Filter is available in a technical preview mode. Dynamically enable or disable the auditing.

Open Source 106

Open Source Database Servers Storage 106

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

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 84

Open Source Servers Database Scalability 84

Percona

JUNE 22, 2023

Load balancing : Requests are evenly distributed across multiple database servers, ensuring the system remains operational even if one server fails. Automated failover : To keep the database operational and minimize downtime, it automatically switches to a backup server if the primary server fails.

Availability 109

Availability Database Open Source Hardware 109

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 Download Percona Server for MongoDB 5.0.17-14

Monitoring 78

Monitoring Open Source Database Servers 78

Percona

JULY 17, 2023

DBAs and developers appreciate its combination of flexibility, scalability, and performance. 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 76

Open Source Database Scalability Software 76

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. Benchmark before you decide. I hope this helps!

Performance 126

Performance Hardware Tuning Storage 126

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Therefore, DBAs must take a piecemeal approach to achieve HA with PostgreSQL, bringing together open source extensions and tools from multiple sources. there cannot be high availability.

Availability 84

Availability Open Source Architecture Database 84

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. Failover testing: If you have a high availability setup or a secondary data center, test to ensure the failover process switches over to the backup database server. The software is truly open source.

Database 89

Database Hardware Open Source Strategy 89

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 112

Servers Storage Database Open Source 112

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 95

Storage Database Engineering Open Source 95

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. The newly formed Open Source AI Alliance , led by META and IBM, promises to support open-source AI. You mentioned ‘More Simple Kubernetes’?

Cloud 81

Cloud Open Source Strategy Best Practices 81

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 79

Open Source Servers AWS Database 79

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 79

Open Source Healthcare Social Media Database 79

KeyCDN

FEBRUARY 22, 2023

Cloud-based development and deployment One of the main advantages of cloud-based development and deployment is scalability. Another benefit is cost savings associated with server and data center setup and maintenance. The main benefits of serverless architecture are cost savings and scalability.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111

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. Marked in red in Figure 1 is a server with less than 30% of CPU usage. Amazon Elastic Block Store (EBS) is your good-to-go option for disk space.

Cloud 120

Cloud Serverless AWS Storage 120

Percona

NOVEMBER 1, 2023

on, you can use mysqlbinlog to stream binary logs from a remote server. Offsite Storage It’s highly recommended to copy all the backup methods to another place, like the cloud or an external file server, so in case of host failure or data center failure, you have another copy. From MySQL 5.6

Best Practices 80

Best Practices Storage Strategy Database 80

Percona

AUGUST 22, 2023

We’ll wrap it up by suggesting high availability open source solutions, and we’ll introduce you to support options for ensuring continuous high performance from your systems. Load balancing: Traffic is distributed across multiple servers to prevent any one component from becoming overloaded.

Availability 79

Availability Hardware Open Source Database 79

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. After applying the first manifests (which are likely copied and pasted from a how-to tutorial ), a web server is up and running within minutes.

Virtualization 161

Virtualization Infrastructure Monitoring Cloud 161

Percona

MARCH 21, 2023

If REQUIRE ROW FORMAT is enabled, row-based binary logging (binlog format=ROW) is required on the source server. Configure REQUIRE_ROW_FORMAT mysql> STOP REPLICA; mysql> CHANGE REPLICATION SOURCE TO REQUIRE_ROW_FORMAT = 1; mysql> START REPLICA; 1 row in set (0.00 Try Percona Distribution for MySQL today!

Storage 88

Storage Open Source Database Engineering 88

Dynatrace

DECEMBER 22, 2021

Metrics are measures of critical system values, such as CPU utilization or average write latency to persistent storage. A database could start executing a storage management process that consumes database server resources. Observability is made up of three key pillars: metrics, logs, and traces.

Artificial Intelligence 178

Artificial Intelligence Metrics Architecture DevOps 178

Percona

DECEMBER 12, 2022

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. This release is focused on the Percona Server for MySQL-based deployment variant. It is based on Percona Server for MySQL 8.0.30-22.

Open Source 63

Open Source Azure Servers Database 63

Percona

AUGUST 18, 2023

2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. /ib_logfile0 which has format (v104) and is stored outside #innodb_redo. 2023-05-12T08:10:38.946683Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. to MySQL 8.x

Open Source 66

Open Source Database Storage Engineering 66

Percona

SEPTEMBER 6, 2023

Well, there is always a drawback to having the server do something complicated for you. That is a light overhead that could grow into something that overwhelms the server with an extremely heavy write load. The index itself takes up storage space as any other index. What was that about insert and update speed?

Speed 83

Speed Virtualization Storage Open Source 83

HammerDB

JUNE 27, 2022

As the TPC makes its specifications available for free, the need was seen for an open source benchmarking application that could leverage the standards written by the TPC yet implemented quickly, easily and at low cost by anyone. HammerDB is open source software licensed under the. How to build HammerDB from source.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

MAY 15, 2023

This operation is quite expensive but our database can run it in a few milliseconds or less, thanks to several optimizations that allow the node to execute most of them in memory with no or little access to mass storage. In the MySQL open source ecosystem, we have only two consolidated ways to perform sharding — Vitess and ProxySQL.

Traffic 124

Traffic Scalability Database Servers 124

Percona

JULY 1, 2023

These may be performance, high availability, operational cost, management, capacity planning, scalability, security, monitoring, etc. Aurora Features High Performance and Scalability Amazon Aurora has gained widespread recognition for its exceptional performance and scalability, making it an ideal solution for handling demanding workloads.

AWS 52

AWS Database Serverless Storage 52

HammerDB

APRIL 19, 2023

As database performance is heavily influenced by the performance of storage, network, memory, and processors, we must understand the upper limit of these key components. For storage, FIO is generally used. For storage, FIO is generally used. TB)) for storage of database tablespaces and logging. Database: MySQL 8.0.31

Performance 54

Performance Benchmarking Cache Storage 54

Percona

MAY 2, 2023

Also, we will take a look at our open-source backup utility custom-built to help avoid costs and proprietary software – Percona Backup for MongoDB or PBM. The speed of backup also depends on allocated IOPS and type of storage since lots of read/writes would be happening during this process.

Best Practices 52

Best Practices Database Storage Servers 52

High Scalability

APRIL 3, 2019

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 177

Database Cloud Open Source Systems 177

IO River

NOVEMBER 2, 2023

Started years ago with a focus on cloud management, Terraform built a massive community around its open-source license–up until two weeks ago, but more on that later. A significant factor that contributed to Terraform's rise to prominence is its open-source nature. ‍Why Manage Infrastructure by Code?

Open Source 52

Open Source DevOps AWS Azure 52