This ProxySQL post is sourced from an error I faced recently handler___status_CONNECTING_CLIENT___STATE_SERVER_HANDSHAKE(): [ERROR] ProxySQL Error: Access denied for user ProxySQL has become one of the popular choice as the “proxy” for MySQL databases. This post is tipping you off for debugging connectivity issue and fixtures around it for a specific use-case. ProxySQL Connectivity Ofcourse while to connect ProxySQL we have two choices for what we want to do: Admin Interface and MySQL. Admin interface allows us to configure and manage the ProxySQL. MySQL interface is basically the “proxy” connectivity to MySQL databases configured in ProxySQL.
In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a “Friday”, so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to prove it. Prove it technically that it actually is a Friday. This blog post is my attempt to share the proofs of existence of a “Friday”. Using MySQL datetime function: dayname Running system command from MySQL prompt
MySQL is one of the top used database system and with highly active community. Though without proper configuration you may not squeeze the most out of it.This will be a talk about the low hanging fruits to get the best outcome preferably in a short time or with small efforts. This will include configuration, performance and the most common problem scenarios that you can relate, examine and implement. I got opportunity to talk at Percona Live Community 2022. Please find the recording and slides below.
Two or more dots in your relay log or binary log names can break replication; but worry not, it will only do it once. If you request to start again, it will work. That’s it, that’s the blog. Should you choose to spend some more time, go ahead. A new MySQL 5.7 GTID replication chain was being constructed and fail-overs were being tested while an oddity of MySQL replication revealed itself. The Orchestrator graceful fail-over was not able to attach the replica and reporting an error. Every possibility was investigated:
Recently, we were affected by an ignored configuration option introduced in MySQL 5.6. This incident caused us to perform extended planning of downtime and the rebuilding of the slave. In this post, we’ll discuss our encounter with binlog_error_action and likely bad default. The incident started with an alert from our monitoring platform that a check failed to verify a MySQL master’s binary log coordinates. My colleague working from the other side of the globe observed the following: mysql> show master status; Empty set (0.00 sec) mysql> show binary logs; ERROR 1381 (HY000): You are not using binary logging Interestingly, the...