June 19, 2013

Post: Using LVM for MySQL Backup and Replication Setup

… you need to do to perform backup of MySQL Database (or create slave) using LVM2 on Linux…. probably record binary log position which is done by running SHOW MASTER STATUS – This is binary log…master_log_file=”host-bin.000335″, master_log_pos=401934686; 12) Run SLAVE START to restart replication. With…

Post: Paul McCullagh answers your questions about PBXT

backup work in PBXT, and is incremental backup possible? A recent version of PBXT (1.0.09) supports the MySQL Backup…from the transaction log to the database table files….record versions are no longer needed and deletes them from the database…based replication which makes it possible to do replication