Database, Open Source, Performance and Scalability

Database Migration Plan: Avoiding Common Pitfalls in Open Source Migration

Percona

OCTOBER 20, 2023

Many organizations are turning to open source solutions to streamline their operations and reduce costs. Open source migration can be a game-changer, offering flexibility, scalability, and cost-effectiveness. Common pitfalls when migrating to open source Lack of proper planning Proper is the operative word here.

Open Source

Open Source Database Best Practices Strategy

Powering the Web: Two Decades of Open Source Publishing With WordPress and MySQL

Percona

JUNE 2, 2023

While not the first open source content management system (CMS), WordPress caught on like nothing before and helped spread open source to millions. It was simple, easy to deploy, and easy to use, and WordPress had the added benefit of being open source. MySQL was founded in 1995 and went open source in 2000.

Open Source

Open Source Traffic Tuning Database

Is MongoDB Open Source? Is Planet Earth Flat?

Percona

APRIL 12, 2023

We’re equally convinced on both counts, but in this blog article, we’re focusing on why MongoDB is not open source. Let’s start with this: MongoDB is accurately referred to as source-available software. To be clear, we are rock-solid in our stance that MongoDB is not open source.

Open Source

Open Source Programming Database Servers

MySQL on Azure Performance Benchmark – ScaleGrid vs. Azure Database

High Scalability

SEPTEMBER 1, 2020

Microsoft Azure is one of the most popular cloud providers in the world, and a natural fit for database hosting on applications leveraging Microsoft across their infrastructure. MySQL is the number one open source database that’s commonly hosted through Azure instances.

Azure

Azure Database Benchmarking Performance

Why Choose a Third-Party Database Migration Service

Percona

NOVEMBER 3, 2023

Sure, database migration is complex, particularly when you’re looking to migrate from a proprietary database to an open source one. Database migration is almost always time-consuming, tedious, and full of potential pitfalls. Database migration is complex Let’s start here.

Database

Database Open Source Benchmarking Strategy

Kubernetes in the wild report 2023

Dynatrace

JANUARY 16, 2023

The study analyzes factual Kubernetes production data from thousands of organizations worldwide that are using the Dynatrace Software Intelligence Platform to keep their Kubernetes clusters secure, healthy, and high performing. The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Java, Go, and Node.js

Open Source

Open Source Java Operating System Programming

Rocket Performance on Your Java Application with Memcached

DZone

JULY 1, 2019

Memcached is an easy-to-use, high-performance, in-memory data store. It offers a mature, scalable, open-source solution for delivering sub-millisecond response times, unlike databases that store data on disk or SSDs, Memcached keeps its data in memory. Installing Memcached Using Docker.

Java

Java Performance Open Source Scalability

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

Percona

OCTOBER 10, 2023

Performing an operation is always challenging when dealing with K8s. You can perform a DIRECT ALTER, use a tool such as pt-osc, or even, for certain cases where async replication is in use, perform changes on replicas and failover. You can just connect to the MySQL service POD and perform the ALTER. drop_triggers:10000:0.25,copy_rows:10000:0.25,swap_tables:10000:0.25,update_foreign_keys:10000:0.25,analyze_table:10000:0.25

Database

Database Performance C++ Engineering

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

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. We found the answers at the Postgres Conference in March where we surveyed PostgreSQL users, contributors, and SQL and NoSQL database administrators alike.

Database

Database Cloud Open Source Systems

Release Roundup May 15, 2024

Percona Community

MAY 14, 2024

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.

Open Source

Open Source Scalability Database Software

Should You Keep Your Business Logic In Your Database?

Percona

JULY 31, 2023

Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the database has little or no effect on the data quality.

Database

Database Open Source Servers Code

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

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. What is PostgreSQL performance tuning? Why is PostgreSQL performance tuning important?

Tuning

Tuning Efficiency Database Performance

Percona Monitoring and Management 2.41.1, Percona Distribution for MongoDB 7.0.5: Release Roundup February 5, 2024

Percona

FEBRUARY 5, 2024

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.

Open Source

Open Source Monitoring Scalability Database

Plan Your Multi Cloud Strategy

Scalegrid

MARCH 22, 2024

It focuses on aligning organizational needs with cloud services, balancing performance and cost, and ensuring compliance, security, and effective cost management. Pick combinations that are not just affordable but also high-performing. Find that sweet spot where the costs and performance balance out just right.

Strategy

Strategy Cloud Government Innovation

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. Percona Distribution for MySQL (PS-based variation) 8.0.34

Open Source

Open Source Scalability Database Servers

Release Roundup April 30, 2024

Percona Community

APRIL 29, 2024

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.

Open Source

Open Source Scalability Database Software

16 Updates and Releases to Start the New Year! Roundup January 8, 2024

Percona

JANUARY 8, 2024

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.

Open Source

Open Source Scalability Database Software

Best Practices for PostgreSQL Migration

Percona

APRIL 5, 2024

PostgreSQL’s reputation as a powerful, open source database management system has been steadily rising, making it a top choice for businesses looking to upgrade or switch their database infrastructure. It is so […]

Best Practices

Best Practices Open Source Scalability Database

Release Roundup April 2, 2024

Percona Community

APRIL 1, 2024

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.

Open Source

Open Source Scalability Database Software

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

Release Roundup April 17, 2024

Percona Community

APRIL 16, 2024

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.

Open Source

Open Source Scalability Database Software

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

Updated Versions of Percona Distribution for PostgreSQL, Percona XtraDB Cluster: Release Roundup September 4, 2023

Percona

SEPTEMBER 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. 24-2 by performing the steps in the release notes.

Open Source

Open Source Scalability Database Software

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. Percona Distribution for MySQL (PXC-based variant) 8.0.33 25 was released.

Open Source

Open Source Scalability Servers Database

Percona Distribution for MongoDB 4.4.27, Updates to Percona Distribution for PostgreSQL, : Release Roundup January 22, 2024

Percona

JANUARY 22, 2024

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.

Open Source

Open Source Scalability Database Software

How to Improve MySQL AWS Performance 2X Over Amazon RDS at The Same Cost

High Scalability

OCTOBER 29, 2019

AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. ScaleGrid offers a compelling alternative to hosting MySQL on AWS that offers better performance, more control, and no cloud vendor lock-in and the same price as Amazon RDS.

AWS

AWS Latency Performance Open Source

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. Percona Distribution for MySQL (PS- based variant) 8.1.0 was released.

Open Source

Open Source Azure Servers Programming

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. Percona Distribution for MySQL (PS-based variation) 8.0.33 was released.

Servers

Servers Open Source Scalability Database

Release Roundup February 21, 2024

Percona Community

FEBRUARY 20, 2024

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.

Open Source

Open Source Scalability Database Software

Release Roundup March 18, 2024

Percona Community

MARCH 17, 2024

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.

Open Source

Open Source Scalability Database Software

Release Roundup March 4, 2024

Percona Community

MARCH 3, 2024

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.

Open Source

Open Source Scalability Database Software

Upgrade to Grafana 9.2.20 in PMM 2.38, New Data Sink in Percona XtraBackup 8.0.33-28: Release Roundup July 24, 2023

Percona

JULY 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. Take a look. Percona Monitoring and Management 2.38.1 was released.

Open Source

Open Source Scalability Database Monitoring

Percona Monitoring and Management 2.38, Updates to Percona Distribution for PostgreSQL: Release Roundup July 10, 2023

Percona

JULY 10, 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. Take a look! Percona Monitoring and Management 2.38 was released.

Monitoring

Monitoring Open Source Scalability Database

How to Assess MySQL Performance

HammerDB

APRIL 19, 2023

Predicting application performance is a difficult art, but an important one when choosing the target deployment environment. Among the different components of modern software solutions, the database is one of the most critical. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench.

Performance

Performance Benchmarking Cache Storage

What Is PostgreSQL Used For?

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. Most recently, in StackOverflow’s 2022 Stack Developer Survey , PostgreSQL took a slight lead over MySQL (46.48% to 45.68%) as the most popular database platform among professional developers. What is PostgreSQL used for?

Open Source

Open Source Healthcare Social Media Database

Deploying Percona Monitoring and Management With Terraform

Percona

FEBRUARY 14, 2023

Recently, we released Percona Monitoring and Management 2.34 (PMM) which includes upgrades for backup and Database as a Service (DBaaS) features, and we are seeking ways to simplify PMM deployment. Scalability : Terraform makes it easy to scale infrastructure up or down, so you can quickly adapt to changing needs.

Monitoring

Monitoring Infrastructure Open Source AWS

Dynatrace Application Security boosts BizDevSecOps for Kubernetes

Dynatrace

FEBRUARY 10, 2021

Dynatrace is redefining Application Security, applying the automation, AI, scalability, and enterprise-grade robustness of its platform to change the way security gets done. The latest enhancement enables our customers to automatically detect and assess open-source and third-party vulnerabilities in Node.js

Java

Java Open Source Engineering Database

How Data Inspires Building a Scalable, Resilient and Secure Cloud Infrastructure At Netflix

The Netflix TechBlog

MARCH 5, 2019

As a micro-service owner, a Netflix engineer is responsible for its innovation as well as its operation, which includes making sure the service is reliable, secure, efficient and performant. In the Performance space, our data teams currently focus on the quality of experience on Netflix-enabled devices.

Infrastructure

Infrastructure Cloud Scalability AWS

Announcing the General Availability of Percona Operator for PostgreSQL Version 2

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.

Availability

Availability Open Source Azure Hardware

How PHP Web Development Beneficial For Online Business?

Official Blog - World Web Technology

AUGUST 27, 2023

It is a server-side scripting language that is highly secure, open-source, and versatile. PHP is Open Source Language The most important thing for a business is to optimize costs to make operations more cost-effective and improve profit margins. You can use PHP limitlessly.

Development

Development Ecommerce Open Source Website

Percona Server for MongoDB 7 Is Now Available

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. Think of us as the extra set of eyes, the extra layer of QA to ensure your safety passage to the next database version.

Availability

Availability Servers Database Open Source

Using CLONE INSTANCE With DATA DIRECTORY on Replicas With Data

Percona

OCTOBER 17, 2023

You may use one of the following strategies to perform the clone operation safely. List all non-system databases with query SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME NOT IN ('mysql', 'sys', 'information_schema', 'performance_schema'); Remove them one by one. To avoid it, use the option DATA DIRECTORY.

Open Source

Open Source Servers Database Strategy

Backup Mastery: Running Percona XtraBackup in Docker Containers

Percona

DECEMBER 7, 2023

Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our open source backup solution for all versions of MySQL, is designed to make backups a seamless procedure without disrupting the performance of your server in a production environment. respectively.

C++

C++ Open Source Servers Database

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 is an enhanced, source-available, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 4.2.24

Servers

Servers Open Source Database Software

Database Migration Plan: Avoiding Common Pitfalls in Open Source Migration

Powering the Web: Two Decades of Open Source Publishing With WordPress and MySQL

Trending Sources

Is MongoDB Open Source? Is Planet Earth Flat?

MySQL on Azure Performance Benchmark – ScaleGrid vs. Azure Database

Why Choose a Third-Party Database Migration Service

Kubernetes in the wild report 2023

Rocket Performance on Your Java Application with Memcached

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

Release Roundup May 15, 2024

Should You Keep Your Business Logic In Your Database?

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Percona Monitoring and Management 2.41.1, Percona Distribution for MongoDB 7.0.5: Release Roundup February 5, 2024

Plan Your Multi Cloud Strategy

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

Release Roundup April 30, 2024

16 Updates and Releases to Start the New Year! Roundup January 8, 2024

Best Practices for PostgreSQL Migration

Release Roundup April 2, 2024

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

Release Roundup April 17, 2024

Identify Active Databases and Users in MySQL

Updated Versions of Percona Distribution for PostgreSQL, Percona XtraDB Cluster: Release Roundup September 4, 2023

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

Percona Distribution for MongoDB 4.4.27, Updates to Percona Distribution for PostgreSQL, : Release Roundup January 22, 2024

How to Improve MySQL AWS Performance 2X Over Amazon RDS at The Same Cost

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

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

Release Roundup February 21, 2024

Release Roundup March 18, 2024

Release Roundup March 4, 2024

Upgrade to Grafana 9.2.20 in PMM 2.38, New Data Sink in Percona XtraBackup 8.0.33-28: Release Roundup July 24, 2023

Percona Monitoring and Management 2.38, Updates to Percona Distribution for PostgreSQL: Release Roundup July 10, 2023

How to Assess MySQL Performance

What Is PostgreSQL Used For?

Deploying Percona Monitoring and Management With Terraform

Dynatrace Application Security boosts BizDevSecOps for Kubernetes

How Data Inspires Building a Scalable, Resilient and Secure Cloud Infrastructure At Netflix

Announcing the General Availability of Percona Operator for PostgreSQL Version 2

How PHP Web Development Beneficial For Online Business?

Percona Server for MongoDB 7 Is Now Available

Using CLONE INSTANCE With DATA DIRECTORY on Replicas With Data

Backup Mastery: Running Percona XtraBackup in Docker Containers

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

Stay Connected