MySQL complete Unicode compliance

/
By default MySQL only supports a subset of UTF-8, meaning that…

MySQL / MariaDB : re-sync a replicated slave to the master

/
Assumptions: 2 or more database servers in a master-slave with…

MySQL / MariaDB : Bug fix : InnoDB: Error: log file ./ib_logfile0 is of different size

/
Error InnoDB: Error: log file ./ib_logfile0 is of different…

MySQL replicated cluster / replication change master node IP on slaves

/
On the master record the master_log_file and the master_log_pos [crayon-5900dba477153662686373/]…

MySQL / MariaDB bugfix : [ERROR] mysqld: Can't create/write to file '/tmp/' (Errcode: 13)

/
Error: [ERROR] mysqld: Can't create/write to file '/tmp/' (Errcode:…

MySQL / MariaDB bugfix : [Warning] Unsafe statement written to the binary log using statement format

/
Error: Error: [Warning] Unsafe statement written to the binary…

Debian 7 PowerDNS Server ( PowerDNS Authoritive Server ) with MariaDB ( MySQL ) with DNSSEC

/
Assumptions Minimal Debian 7 installation Completed Proxmox…

CentOS 6 / RHCE 6 / Redhat : Monit ( Server Monitoring and Automatic Maintenance ) via YUM/RPM installation

/
Assumptions: Minimal CentOS 6 installation Completed CentOS 6…

Debian 7 wheezy : 3 Node Percona XtraDB Cluster + XtraBackup + GLB Load Balancer ( aka MySQL + Galera )

/
Assumptions Minimal Debian 7 installation Completed Proxmox /…