How to Create a Physical Backup and Restore a MySQL Database
databaseIntroduction 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…
How to Install MySQL on Debian 12
databaseIntroduction 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…
How to Automatically Back Up MySQL Databases with Object Storage
databaseIntroduction 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…
How to Migrate MySQL from AWS to a Vultr Managed Database
databaseIntroduction 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…
Integrate PostgreSQL and Apache Kafka with Debezium
databaseIntroduction 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.…
How to Use Views in MySQL 8
databaseIntroduction In MySQL, views are virtual tables for running pre-defined queries. Thus, they’re suitable in database applications that require tight security. For instance, you can design an application that allows end-users to run complex queries using views without directly interacting with base tables to hide sensitive information. In such a…