Exporting Percona Database Rumi, March 11, 2020March 11, 2020 Exporting percona database is however a bit tricky way to make funcitonal. The usual- mysqldump -u root -p [database] > database.sql will stuck and shoot you many error. All you need is the add an extended parameters to execute the dump, and here it is: mysqldump -u root -p [database] lock-for-backup > database.sql And that should do the trick! Src: https://www.percona.com/doc/percona-server/5.7/flexibility/extended_mysqldump.html Related MySQL MySQLDumpPerconaPercona XtraDB
Delete/Purging mysql-bin (binlog) files safely January 7, 2021 The file mysql-bin.index keeps a list of all binary logs mysqld has generated and auto-rotated. The mechanisms for cleaning out the binlogs in conjunction with mysql-bin.index are: PURGE BINARY LOGS TO ‘binlogname’; PURGE BINARY LOGS BEFORE ‘datetimestamp’; These will clear all binary logs before the binlog or timestamp you just… Read More
MariaDB Galera Cluster on Ubuntu 20 December 28, 2022December 28, 2022 MariaDB Galera Cluster is a synchronous multi-master cluster for MariaDB with support for XtraDB/InnoDB storage engines. It has the following top features. It provides active-active multi-master topology You can read and write to any cluster node It has an automatic node joining Automatic membership control, failed nodes drop from the… Read More
MySQL my.cnf tweak for faster importing large database March 3, 2018 Few small hack will ease you importing large sized mysql dump in a bit faster process. The trick worked for me for a 70 GB dumped sql, can’t guarantee it’d work for you! Step-1 need to change the following: innodb_buffer_pool_size = 4G innodb_log_buffer_size = 256M innodb_log_file_size = 1G innodb_write_io_threads =… Read More