June 18, 2013

Post: Galera Flow Control in Percona XtraDB Cluster for MySQL

… find in standard async MySQL replication. It is my belief that the lack of understanding of this … transactions, which translates into number of unique key lookups into the certification index, which is a hash table…. Flow Conflct time name P cnf # name cmt sta Up Dn Up Dn Up Dn pau snt dst lcf bfa …

Post: Is DNS the Achilles heel in your MySQL installation?

… have skip_name_resolve set in your /etc/my.cnf? If not, consider it. DNS works fine, until it doesn’t. Don’t…? To disable two DNS lookups per authentication attempt, you just need to set skip_name_resolve in your my.cnf file and restart MySQL… after you disable DNS resolution. For more information on how and why MySQL does both a forward and reverse DNS lookup on authentication…