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

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 strategies and testing One might think disaster begets loss, but with the right planning, that loss can be so minimal it’s more “blip” than “bad.”

Database 90

Database Hardware Open Source Strategy 90

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

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

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. and xtrabackup 2.4

Servers 106

Servers C++ Storage Systems 106

Percona

JULY 25, 2023

You can choose to save them locally on the same server, stream them to different servers, or store them in object storage. STDOUT Datasink This diagram displays the process of streaming a backup to object storage utilizing the current STDOUT datasink: XtraBackup spawns multiple copy threads.

Storage 79

Storage Speed Open Source Servers 79

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 85

Availability Open Source Architecture Database 85

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. As such, you save on storage space and data transfer in case of cloud setups. It’s time for the release roundup!

Open Source 86

Open Source Storage AWS Cloud 86

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 96

Storage Database Engineering Open Source 96

Percona

FEBRUARY 10, 2023

Xbcloud is a tool part of Percona XtraBackup and allows you to upload and download backups to Amazon S3 storage. 221121 13:04:52 xbcloud: Sleeping for 2384 ms before retrying test/mysql.ibd.00000000000000000002 00000000000000000002 [1] 221121 13:05:09 xbcloud: successfully uploaded chunk: test/mysql.ibd.00000000000000000002,

Storage 95

Storage Open Source AWS Servers 95

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 110

Availability Database Open Source Hardware 110

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 79

Monitoring Open Source Database Servers 79

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 ? Standalone deployments are a single node without any replication, and should really only be used for development or testing environments. MySQL Dev/Test Environments: Standard Disks.

Azure 219

Azure Cloud Virtualization Database 219

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 85

Open Source Servers Database Scalability 85

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 106

Performance Monitoring Traffic Database 106

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. version is affected by this, as per my tests. This feature is available in Percona Server for MySQL 5.6+.

Storage 103

Storage Engineering Open Source Servers 103

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 84

Servers Azure AWS Cloud 84

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 80

Open Source Healthcare Social Media Database 80

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

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.

Performance 127

Performance Hardware Tuning Storage 127

Percona

DECEMBER 19, 2023

Since our previous blog post, Adding Transparent Data Encryption to PostgreSQL with pg_tde: Please Test , it received new features such as TOAST data encryption and HashiCorp Vault support for key storage. deb package, or as source code on github. deb package, or as source code on github.

Open Source 85

Open Source Storage Database C++ 85

Percona

SEPTEMBER 25, 2023

PostgreSQL is a powerful and popular open source relational database management system. This issue tends to occur when your backup storage is located offsite, your database is quite large, and the backup process generates a lot of files. pgBackRest is a highly efficient and versatile tool for managing PostgreSQL backups.

Database 97

Database Open Source Storage Servers 97

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. MongoDB is the #3 open source and #1 NoSQL database in the world. EC2 instances. VM instances.

Azure 344

Azure AWS Database Latency 344

Percona

SEPTEMBER 19, 2023

Now, since backup speed and compactness are important for busy, important databases, Percona’s open source physical backup solution – Percona XtraBackup (PXB) , takes into account all these aspects and benefits MySQL world with its exceptional capabilities! Your MySQL connection id is 10 (X protocol) Server version: 8.0.33-25

C++ 107

C++ Servers Storage Speed 107

Percona

JANUARY 19, 2023

Example: Creating four simple tables to store strings but using different data types: db1 test> CREATE TABLE tb1 (id int auto_increment primary key, test_text char(200)); Query OK, 0 rows affected (0.11 sec) db1 test> CREATE TABLE tb2 (id int auto_increment primary key, test_text varchar(200)); Query OK, 0 rows affected (0.05

Open Source 90

Open Source Storage Database Big Data 90

The Netflix TechBlog

MAY 21, 2019

using RL agents for test case scheduling By: Stanislav Kirdey , Kevin Cureton , Scott Rick , Sankar Ramanathan Introduction Netflix brings delightful customer experiences to homes on a variety of devices that continues to grow each day. Detect a regression in a test case. These problems could be solved in several different ways.

Testing 163

Testing AWS Lambda Network 163

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? Sysbench ran on a third server, which I’ll refer to as the application server (APP).

Tuning 137

Tuning Cache Servers Benchmarking 137

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. id` AS `id` from `test`.`product` id` AS `id`,`test`.`product`.`date_available`

Speed 84

Speed Virtualization Storage Open Source 84

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

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 121

Cloud Serverless AWS Storage 121

Percona

NOVEMBER 1, 2023

Using mydumper you can backup and restore a single database or a single table if it’s needed, and this is useful to copy some data to a different environment to run tests. on, you can use mysqlbinlog to stream binary logs from a remote server. Seven daily and four weekly logical backups locally on the backup server.

Best Practices 80

Best Practices Storage Strategy Database 80

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

Database 166

Database Cloud Website Azure 166

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

Storage 89

Storage Open Source Database Engineering 89

Percona

AUGUST 18, 2023

I tried the in-place upgrade on my test VM for my own curiosity and got some redo log format errors/Data Dictionary errors. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.

Open Source 67

Open Source Database Storage Engineering 67

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 80

Availability Hardware Open Source Database 80

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 Database Servers 63