Migrate Data From Atlas to Self-Hosted MongoDB
In this blog post, we will discuss how we can migrate data from MongoDB Atlas to self-hosted MongoDB. There are a couple of third-party tools in the market to migrate data from Atlas to Pecona…
Category: mysql-server
Using Jobs to Perform Schema Changes Against MySQL Databases on K8s
Performing an operation is always challenging when dealing with K8s.When on-prem or DBaaS like RDS or Cloud SQL, it is relatively straightforward to apply a change. You can perform a DIRECT ALTER, use a tool…
PostgreSQL Tuple-Level Statistics With pgstattuple
Since Postgres table bloat degrades database performance, we can improve its performance by removing the table bloat. We can use the pgstattuple extension to identify the bloated tables.This extension provides several functions for obtaining tuple-level…
What’s New in Percona Toolkit 3.5.5
Percona Toolkit 3.5.5 was released on October 3, 2023. This blog post covers the main changes in this release.pt-online-schema-change improvementsAfter nibble hookThis was contributed by Marcelo HP Ferreira at https://github.com/percona/percona-toolkit/pull/645. The feature allows you to…
Transparent Huge Pages Refresher
Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. While THP can be beneficial for many applications, enabling it on a database server could have…
Percona Distribution for PostgreSQL 16.0, Percona Backup for MongoDB 2.3.0: Release Roundup 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 software is…
Using MySQL Offline Mode To Disconnect All Client Connections
As a DBA, one of the very frequent tasks is to stop/start MySQL service for batching or some other activities. Before stopping MySQL, we may need to check if there are any active connections; if…
Replace a Live Mongo Node With a New Node
In this blog post, we will discuss replacing a Mongo node. Consider a scenario when a node is going to be decommissioned for some reason or if a node’s data partition is almost full and…
PostgreSQL Partitioning Made Easy Using pg_partman (TimeBased)
PostgreSQL Partition Manager — ‘pg_partman’ — is an open source extension freely available, widely supported, and actively maintained by the PostgreSQL community.pg_partman creates and manages both time-based and serial-based table partition sets. Users use it…
Explore the New Feature of MySQL To Restrict Users From Creating a Table Without a Primary Key
As MySQL database administrators, we are well aware of the significance of implementing a primary key within a table. Throughout our careers, most of us have encountered situations where the absence of a primary key…