Category: MySQL

  • Ansible, python and mysql… untangling the mess

    Nearly every “how to” article or tutorial on the web describes one way of using Ansible, python, and connecting to MySQL as if that was the only solution.  Many don’t note code versions used, or even the pub date, and the Internet is rife with simply bad advice.  I finally gave up researching all this […]

  • Un-%&$-ing MySQL character sets and collations across an entire server

    Recently, requests to one of our data-backed web services started timing out.  It turned out the problem was that some of our data tables had been (re)created using the wrong character sets and collations.  And as everyone should know, and now I do: Indexes are useless for joins unless the collations match The carefully optimized queries […]