Availability, Database, Download and Servers - Technology Performance Pulse

What is Greenplum Database? Intro to the Big Data Database

Scalegrid

MAY 13, 2020

Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL. It can scale towards a multi-petabyte level data workload without a single issue, and it allows access to a cluster of powerful servers that will work together within a single SQL interface where you can view all of the data.

Big Data

Big Data Database Artificial Intelligence Open Source

Extend business observability: Extract business events from online databases (Part 2)

Dynatrace

SEPTEMBER 8, 2023

In part 2, we’ll show you how to retrieve business data from a database, analyze that data using dashboards and ad hoc queries, and then use a Davis analyzer to predict metric behavior and detect behavioral anomalies. Similar to the tutorial extension, we created an extension that performs queries against databases.

Database

Database Artificial Intelligence Metrics Monitoring

PostgreSQL Database Security: External Server-Based Authentication

Percona

FEBRUARY 2, 2023

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database

Database Servers Testing Programming

Exploring MySQL Binlog Server – Ripple

Scalegrid

MAY 22, 2020

MySQL does not limit the number of slaves that you can connect to the master server in a replication topology. A classic solution for this problem is to deploy a binlog server – an intermediate proxy server that sits between the master and its slaves. Ripple is an open source binlog server developed by Pavel Ivanov.

Servers

Servers Transportation Database Availability

Percona Monitoring and Management High Availability – A Proof of Concept

Percona

DECEMBER 21, 2023

The integration of those projects, plus the years of Percona expertise in the database space, makes PMM one of the best database monitoring solutions on the market. Being software composed of different, multiple technologies can add complexity to a well-known concept: High Availability (HA). With this, the easy part is done.

Availability

Availability Monitoring Open Source Traffic

Can You Trust AI Chatbots When Seeking Help With Databases?

Percona

DECEMBER 14, 2023

I played a bit with ChatGPT in February to see how it would respond to random database-related inquiries, and I found it pretty impressive and annoying at the same time. significantly enhanced downgrade compatibility by introducing changes that make it easier for downgraded databases to interoperate with older MongoDB versions.

Database

Database Artificial Intelligence Servers Operating System

Setting Up and Deploying PostgreSQL for High Availability

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

Availability Open Source Architecture Database

How to Setup a WordPress MySQL Database in the Cloud

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. Managing a database is hard, as it needs continuous updating, tuning, and monitoring to ensure the performance of your website.

Database

Database Cloud Website Azure

Percona Monitoring and Management 2.40.0, Percona Server for MongoDB 7.0.2-1 (RC): Release Roundup October 16, 2023

Percona

OCTOBER 16, 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. you can now use an external VictoriaMetrics database for monitoring in PMM. Take a look.

Servers

Servers Monitoring Open Source Scalability

Why PostgreSQL Is a Top Choice for Enterprise-level Databases

Percona

MARCH 23, 2023

When it comes to enterprise-level databases, there are several options available in the market, but PostgreSQL stands out as one of the most popular and reliable choices. PostgreSQL is a free and open source object-relational database management system (ORDBMS) that has existed since the mid-1990s.

Database

Database Open Source Traffic Small Business

Percona Distribution for MySQL 8.0.33, Percona Server for MySQL: Release Roundup June 26, 2023

Percona

JUNE 26, 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. Download Percona Distribution for MySQL (PS-based variation) 8.0.33 Take a look!

Servers

Servers Open Source Scalability Database

Open Source vs. Proprietary Database Software: What To Choose?

Percona

APRIL 28, 2023

Let’s start with a simple introductory comparison: With proprietary (closed source) database software, the public does not have access to the source code; only the company that owns it and those given access can modify it. Myth #2: Proprietary databases are better and therefore more suitable for large enterprises.

Open Source

Open Source Database Software Software

Oracle database insights Early Adopter Release

Dynatrace

AUGUST 12, 2019

With OneAgent installed on an application server, Davis, the Dynatrace AI causation engine, continuously analyzes all database statements within the context of your applications. Now, with Oracle database insights, we’re going even deeper, giving you visibility into what’s going on in the database layer.

Database

Database Metrics Cache Servers

Percona Server for MySQL 5.7.41-44, Percona Distribution for MongoDB 4.2.24: Release Roundup March 13, 2023

Percona

MARCH 13, 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. It offers highlights, critical information, links to the full release notes, and direct links to the software or service itself to download.

Servers

Servers Open Source Database Software

How To Scale a Single-Host PostgreSQL Database With Citus

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. I won’t cover all the features but show just enough that you’ll want to see more of what you can learn to accomplish for yourself.

Database

Database Benchmarking Latency C++

MongoDB SSL with self-signed certificates in C#

Scalegrid

SEPTEMBER 18, 2020

When deploying MongoDB in production, it is strongly recommended that you use an SSL-enabled geo-distributed replica-set configuration for maximum security and availability. One option is purchasing your own CA-signed SSL certificates and configuring them on the MongoDB server. ScaleGrid provides you two options for setting up SSL.

C++

C++ Programming Servers Database

Identify Active Databases and Users in MySQL

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database

Database C++ Servers Open Source

Percona Monitoring and Management 2.41.0, Percona Distribution for PostgreSQL 14.10, and More: Release Roundup December 18, 2023

Percona

DECEMBER 18, 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. Initially a standalone client for PMM Server, PMM Dump is now accessible in the PMM user interface.

Monitoring

Monitoring Open Source Servers Scalability

From Proprietary to Open Source: The Complete Guide to Database Migration

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

Open Source Database Hardware Strategy

Scalable Solutions With Percona Distribution for PostgreSQL (Part 1): Set Up Three PostgreSQL Database Instances

Percona

OCTOBER 19, 2023

In this guide, we will demonstrate how to establish a Citus database spanning multiple nodes by using Percona Distribution for PostgreSQL. This setup empowers your database to efficiently manage increased data volumes, enhance performance, and maintain availability. Use the following procedure for all the three nodes.

Scalability

Scalability Database Open Source Traffic

Innovation Release of Percona XtraDB Cluster, Updated Percona Distribution for PostgreSQL: Release Roundup November 13, 2023

Percona

NOVEMBER 13, 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. Download the Updated Release of Percona Distribution for PostgreSQL 16.0 Take a look.

Innovation

Innovation Open Source Scalability Database

How to Install or Upgrade Percona Server for MySQL/MySQL 8 to a Specific Version on Debian/Ubuntu

Percona

JUNE 15, 2023

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. 2) … 1.3

Servers

Servers C++ Database Systems

Percona Monitoring and Management 2.40.1, Percona Distribution for MongoDB 6.0.11: Release Roundup October 31, 2023

Percona

OCTOBER 31, 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. This can result in either a successful upgrade or a 500 internal server error. Take a look.

Monitoring

Monitoring Open Source Scalability Database

PostgreSQL: Pgpool-II Use Cases and Benefits

Percona

APRIL 6, 2023

PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. However, as the size of your database grows, it can become challenging to manage and optimize its performance. This can significantly improve query response times and reduce the load on your database servers.

Cache

Cache Open Source Benchmarking Database

Additional T-SQL Improvements in SQL Server 2022

SQL Performance

AUGUST 1, 2022

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here.

Servers

Servers Testing C++ Code

Updated Percona Distributions for MongoDB, Metadata Table for QAN in PMM: Release Roundup August 21, 2023

Percona

AUGUST 21, 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. Download Percona Monitoring and Management 2.39.0 Percona Server for MySQL 5.7.43-47

Open Source

Open Source AWS Servers Database

Percona Distribution for PostgreSQL 16.1, Percona Distribution for MySQL 8.1.0: Release Roundup December 4, 2023

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. Take a look.

Open Source

Open Source Azure Servers Programming

Percona Distribution for PostgreSQL 16.0, Percona Backup for MongoDB 2.3.0: Release Roundup October 2, 2023

Percona

OCTOBER 2, 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. Download Percona Distribution for MySQL (PS-based variation) 8.0.34 Take a look.

Open Source

Open Source Scalability Database Servers

Percona Backup for MongoDB 2.2.1, Updates to Percona Distribution for MySQL, : Release Roundup August 7, 2023

Percona

AUGUST 7, 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. Download Percona Distribution for MySQL (PXC-based variant) 8.0.33 Take a look.

Open Source

Open Source Scalability Servers Database

T-SQL Windowing Improvements in SQL Server 2022

SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher.

Servers

Servers C++ Code Database

Setting Up MongoDB SSL Encryption

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections.

Servers

Servers Best Practices Government Network

Benchmark (YCSB) numbers for Redis, MongoDB, Couchbase2, Yugabyte and BangDB

High Scalability

FEBRUARY 17, 2021

This article is to simply report the YCSB bench test results in detail for five NoSQL databases namely Redis, MongoDB, Couchbase, Yugabyte and BangDB and compare the result side by side. I have used latest versions for each NoSQL DB and have followed the recommendations to run all the databases in optimized conditions. About YCSB.

Benchmarking

Benchmarking Latency C++ Database

LDAP Improvements in Percona Server for MySQL 8.0.30-22

Percona

DECEMBER 6, 2022

Percona Server for MySQL 8.0.30-22 22 introduces several improvements for the LDAP plugin: SASL support, support for fallback servers, and support for LDAP-based authorization. Because of this, using the simple plugin with an SSL connection between the MySQL server and client should be preferred over the SASL plugin where possible.

Servers

Servers Open Source Scalability Availability

New Versions of Percona Distribution for MongoDB, Percona Operator for MySQL: Release Roundup September 18, 2023

Percona

SEPTEMBER 18, 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. Download Percona Distribution for MongoDB 6.0.9 Percona Server for MongoDB 6.0.9-7

Open Source

Open Source Servers Database Scalability

Critical CVE Fix in PMM, Updates to Percona Distribution for MySQL: Release Roundup June 12, 2023

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

Open Source

Open Source Servers Database Scalability

PMM Dump GUI in Percona Monitoring and Management 2.41.0

Percona

JANUARY 3, 2024

If you are a database administrator or developer, you may encounter some issues that require external assistance. Whether you seek help from Percona Support or the Community, you must provide sufficient information about your database performance and configuration. A week later, PMM 2.0.41.0 was released with GUI for the PMM Dump.

Monitoring

Monitoring Open Source Database Servers

Tech Preview of Percona Operator for MySQL 0.4.0, Percona Distribution for MongoDB 6.0.4: Release Roundup February 13, 2023

Percona

FEBRUARY 13, 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. PMM installs and manages operators using Operator Lifecycle Manager (OLM) and database clusters using dbaas-operator. Take a look!

Open Source

Open Source Database Servers Scalability

Which Is the Best PostgreSQL GUI? 2019 Comparison

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? pgAdmin uses too many resources.

Open Source

Open Source Database Azure Cloud

Updated Percona Distributions for MySQL, Percona Distributions for MongoDB: Release Roundup March 27, 2023

Percona

MARCH 27, 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. It offers highlights, critical information, links to the full release notes, and direct links to the software or service itself to download.

Open Source

Open Source Servers Scalability Cache

Updates to Percona Distributions for PostgreSQL, Percona XtraDB Cluster, Percona XtraBackup: Release Roundup May 29, 2023

Percona

MAY 29, 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. This release of Percona Distribution for MongoDB is based on Percona Server for MongoDB 4.4.21-20

Open Source

Open Source Servers Scalability Database

MongoDB Database Backup: Best Practices & Expert Tips

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices

Best Practices Database Storage Servers

Percona Monitoring and Management 2.37, Percona Distribution for MongoDB 5.0.17: Release Roundup May 8, 2023

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. Download Percona Monitoring and Management 2.37 Percona Server for MongoDB 5.0.17-14

Monitoring

Monitoring Open Source Database Servers

MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance

Percona

SEPTEMBER 1, 2023

MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. Experiencing database performance issues?

Tuning

Tuning Database Performance Hardware

Deploying MySQL Group Replication With Terraform

Percona

FEBRUARY 15, 2023

Previously, I wrote about our Terraform provider to deploy Percona Server for MySQL ( Percona Server for MySQL: Automatic Cloud Deployment With Terraform ) and Percona Monitoring and Management ( Deploying Percona Monitoring and Management (PMM) With Terraform ). Download Percona Distribution for MySQL Today

Open Source

Open Source AWS Scalability Servers

What is Greenplum Database? Intro to the Big Data Database

Extend business observability: Extract business events from online databases (Part 2)

Trending Sources

PostgreSQL Database Security: External Server-Based Authentication

Exploring MySQL Binlog Server – Ripple

Percona Monitoring and Management High Availability – A Proof of Concept

Can You Trust AI Chatbots When Seeking Help With Databases?

Setting Up and Deploying PostgreSQL for High Availability

How to Setup a WordPress MySQL Database in the Cloud

Percona Monitoring and Management 2.40.0, Percona Server for MongoDB 7.0.2-1 (RC): Release Roundup October 16, 2023

Why PostgreSQL Is a Top Choice for Enterprise-level Databases

Percona Distribution for MySQL 8.0.33, Percona Server for MySQL: Release Roundup June 26, 2023

Open Source vs. Proprietary Database Software: What To Choose?

Oracle database insights Early Adopter Release

Percona Server for MySQL 5.7.41-44, Percona Distribution for MongoDB 4.2.24: Release Roundup March 13, 2023

How To Scale a Single-Host PostgreSQL Database With Citus

MongoDB SSL with self-signed certificates in C#

Identify Active Databases and Users in MySQL

Percona Monitoring and Management 2.41.0, Percona Distribution for PostgreSQL 14.10, and More: Release Roundup December 18, 2023

From Proprietary to Open Source: The Complete Guide to Database Migration

Scalable Solutions With Percona Distribution for PostgreSQL (Part 1): Set Up Three PostgreSQL Database Instances

Innovation Release of Percona XtraDB Cluster, Updated Percona Distribution for PostgreSQL: Release Roundup November 13, 2023

How to Install or Upgrade Percona Server for MySQL/MySQL 8 to a Specific Version on Debian/Ubuntu

Percona Monitoring and Management 2.40.1, Percona Distribution for MongoDB 6.0.11: Release Roundup October 31, 2023

PostgreSQL: Pgpool-II Use Cases and Benefits

Additional T-SQL Improvements in SQL Server 2022

Updated Percona Distributions for MongoDB, Metadata Table for QAN in PMM: Release Roundup August 21, 2023

Percona Distribution for PostgreSQL 16.1, Percona Distribution for MySQL 8.1.0: Release Roundup December 4, 2023

Percona Distribution for PostgreSQL 16.0, Percona Backup for MongoDB 2.3.0: Release Roundup October 2, 2023

Percona Backup for MongoDB 2.2.1, Updates to Percona Distribution for MySQL, : Release Roundup August 7, 2023

T-SQL Windowing Improvements in SQL Server 2022

Setting Up MongoDB SSL Encryption

Benchmark (YCSB) numbers for Redis, MongoDB, Couchbase2, Yugabyte and BangDB

LDAP Improvements in Percona Server for MySQL 8.0.30-22

New Versions of Percona Distribution for MongoDB, Percona Operator for MySQL: Release Roundup September 18, 2023

Critical CVE Fix in PMM, Updates to Percona Distribution for MySQL: Release Roundup June 12, 2023

PMM Dump GUI in Percona Monitoring and Management 2.41.0

Tech Preview of Percona Operator for MySQL 0.4.0, Percona Distribution for MongoDB 6.0.4: Release Roundup February 13, 2023

Which Is the Best PostgreSQL GUI? 2019 Comparison

Updated Percona Distributions for MySQL, Percona Distributions for MongoDB: Release Roundup March 27, 2023

Updates to Percona Distributions for PostgreSQL, Percona XtraDB Cluster, Percona XtraBackup: Release Roundup May 29, 2023

MongoDB Database Backup: Best Practices & Expert Tips

Percona Monitoring and Management 2.37, Percona Distribution for MongoDB 5.0.17: Release Roundup May 8, 2023

MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance

Deploying MySQL Group Replication With Terraform

Stay Connected