Ansible Create new MySQL database with predefined collation and encodingAnsible – install Prometheus mysql-exporter on remote instanceInstall latest MySQL 5.7 on remote instance using ansibleBackup + Restoration Bash script – restore non-replica from data files backuped with Percona XtraBackupBash script: create backup with Percona XtraBackupClone database with Percona xtrabackupData manipulations Load data from text file – using command LOAD DATA INFILEDatabase design How to change data type of column used in foreign keyTiny fun with TINYINT data typePartitioningString typesGlobal Status Global status – table open cacheGlobal status – tmp tablesinformation_schema get comma separated list of columns for tableShow all constraintsLocks Investigation of locks on MySQL tablesLocking strategiesmySQL on Linux Linux bash script for drop of all tablesPerformance MySQL 5.7 parameter range_optimizer_max_mem_sizeMove MySQL data files / log files / temp directory to the different disk on Ubuntu / DebianLinux hugepages and MySQL – Ubuntu / DebianExperiences with high availability in MySQL clusterInnoDB buffer poolQuery cacheConfiguration parameters for OptimizerOptimizer hintsCost based optimizer / server statisticsReplication Settings for parallel replication workersRelay log read failure: Could not parse relay log event entry – binary log is corruptedSetting MySQL chain replicationHow to handle heavy changes in MySQL replication with ansibleError ‘You cannot ‘ALTER’ a log table if logging is enabled’ on query. Default database: ‘mysql’. Query: ‘ALTER TABLE slow_logSwitch the binlog format at runtimeMySQL replication troubleshooting – replication error on replicaExperiences with tuning of MySQL 5.7 replicasCreate new replica by copying data and log files on OS levelMySQL 5.7 investigate replication lagsHow to create new MySQL master databaseClone new MySQL replica on Google Compute EngineHow to manually set MySQL replicationMySQL replication troubleshooting – Lags on replicasMySQL replication small cheat sheetSettings MySQL memory usage / settingsUseful settingsmySQL and more CPUsMemory settingsStorage engines FEDERATED engine – small notesMemoryMyISAMInnoDBTransactions InnoDB REDO logBinary logRollback / Undo segmentIsolation LevelsMultiversion Concurrency ControlTransactionsTroubleshooting How to clean or resize the ibtmp1 file in MySQLCheck MySQL slow log from command lineHow to handle errcode 28 – no space leftWhat can happen when you try to use very big VARCHAR columnsMessage “Could not increase number of max_open_files” in MySQL error logProblems with remote login into MySQL caused by performance_schema tablesGotchas in MySQL replicationTable corruption / table fragmentationFull disk !Useful small hints Export and import existing usersFind size o MySQL databaseAllow remote access to mysql databasekill process / session on databaseUsefull scripts Check size of tables and indexes for all storage enginesDump from one machine using ssh and restore on other machineCheck differences in settings between master and replicas – golang program
