Technical

Can not connect to ProxySQL: reasons and fixtures

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.

mysql database backup shell script with status email

This post is for the backup script for MySQL database on Linux with mail. It’s a linux shell script for taking logical backup using mysqldump and sending status email. The backup shell script works as follows: – The script takes backup using mysqldump and compresses it. – Upon success, it will attempt to ship the backup to specified offsite location. – Upon detecting failure in any of the above step, it will send out failure email. – Upon overall success, it will sendout success email with execution time and present backups list. You might be looking for setting up physical...

Export MySQL database table to CSV (delimited / Excel) file

Today lets talk a little about converting a MySQL table to CSV (Excel). My friend was looking to export MySQL to Excel, I saw couple of questions for export MySQL tables to CSV on forums. Since I saw the question often, I thought of writing out all the ways I can think of for exporting Delimited (CSV / TSV / …) data from MySQL table. Pretty chewed & basic but frequent topic. Following are the ways to export CSV data from MySQL database / table(s). 1. Using SELECT INTO … OUTFILE statement to export from MySQL to CSV SELECT …...