Category: Web application
PgBouncer on Vultr Managed Databases for PostgreSQL
PgBouncer on Vultr Managed Databases for PostgreSQL A connection pooling tool for PostgreSQL that improves performance by managing and reusing database connections. PgBouncer is a high-performance connection pooler for PostgreSQL that helps optimize database connections, especially in high-traffic environments. It sits between client applications and the PostgreSQL database, reducing the…
Read MoreHow to Create a Physical Backup and Restore a MySQL Database
Introduction In MySQL, you can backup your data either by using a logical or a physical backup. The former makes MySQL dump file. On the other hand, a physical MySQL backup is a raw copy of all files and directories containing the database information. You can create MySQL logical backups…
Read MoreHow to Install MySQL on Debian 12
Introduction MySQL is an open-source relational database management system (RDBMS) that enables the storage, management, and retrieval of database records on a server. MySQL works as a database backend and uses the SQL (Structured Query Language) syntax to store relational data in the form of tables to enable efficient records…
Read MoreHow to Automatically Back Up MySQL Databases with Object Storage
Introduction MySQL databases need timely backups to keep recovery data available in case of unplanned database server failures or data corruption events. Available MySQL database backup strategies include SQL statement recreation with tools such as mysqldump and mysqlbackup, replication, and point-in-time recovery methods such as binary logging. Cloud Storage such as object storage…
Read MoreHow to Migrate MySQL from AWS to a Vultr Managed Database
Introduction This guide explains how you can migrate your AWS Cloud Database to Vultr with minimal downtime to the source database applications. Vultr’s Managed Databases for MySQL offer reduced costs, easy management and backups, scheduled updates, quick scaling, straightforward monitoring, and automated failover to replica nodes in case of database…
Read MoreIntegrate PostgreSQL and Apache Kafka with Debezium
Introduction This article demonstrates how to integrate a Vultr Managed Database for PostgreSQL with Apache Kafka using the Debezium source connector for PostgreSQL. Behind the scenes, this is made possible by Change Data Capture (also referred to as CDC), which can track row-level create, update and delete operations in PostgreSQL tables.…
Read More