Simpana 10 – MySQL on Windows Server 2008 R2 – Video example

Just a quick demo of installing MySQL on Windows Server 2008 R2, followed by the installation of Simpana 10 MySQL iDA.

We also enable Binary Logging on MySQL so we can perform Log backups, configure the MySQL instance in Simpana and run some backup tests.

You can watch the following video for the demo/example.

If you find this video of benefit, please leave feedback. Thanks.

ERROR 2013 (HY000): Lost connection to MySQL server during query

Recently had a problem with a MySQL iDA backup on a Linux platform. I was seeing a failure where we would get the error below (and per subject) included in the CommVault backup error.

ERROR 2013 (HY000): Lost connection to MySQL server during query

Upon further investigation it was determined that the error was being triggered during a MySQL query as performed by the MySQL iDA during backup attempt. When we attempted to do the same query manually against a MySQL connection we’d also get the same error. It was determined from the MySQL iDA logs that the database causing us the problem was called “prod”.

See the example below;

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 4
Server version: 5.1.32-community-log MySQL Community Server (GPL)

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> use prod
Database changed
mysql> show table status;

ERROR 2013 (HY000): Lost connection to MySQL server during query

As you can see the error was reproducible. Further investigation determined that the database was corrupt in some way, as we could see a large number of errors in the MySQL logs. Fix the corruption on the database and/or exclude it from the backups until resolved by the MySQL DBA.

MySQL backup via Simpana fails with Error Code 87:15

So you’ve just deployed the Simpana MySQL iDA and attempt your first backup, however get an error per below;

Error Code: [87:15]

Description: MySQL Database: [~client~] Data Backup Failed with MySQL Error: [~mysqldump: Got error: 1227: Access denied; you need the RELOAD privilege for this operation when doing refresh ~].

This failure is talking about the MySQL user that you configured in the GUI for the MySQL iDA. Basically the account lacks “RELOAD” privilege, so you should go fix it up before trying again.

Recover MySQL root password

Last week I found myself in one of those situations where a machine I setup nearly 2 years ago required some additional MySQL databases created and for the life of me I couldn’t find where I had recorded the MySQL root password.

I figured setting a new one should be possible, however I’ve never had to do it. After about literally one search on Google and a few short clicks later I had found what I needed. I ended up at the following site here.

Process looked easy enough so I scheduled an outage window, since the MySQL server in question was being used for a Confluence Wiki.

Sure enough the process worked fine, I now had set a new MySQL root password and brought the services back online.

I of course immediately added the password into my password safe, so I don’t have to do it ever again.

pastebin assistance

Anyone out in the world wide web able to give me a hand with installing pastebin into a directory onto an existing domain. It would appear the documentation associated with the pastebin talk about when you want to serve it from a virtual domain.

And the documentation makes no mention of alternate configurations. I spent a little time last week attempting to get it to work from a directory on an existing domain and failed. So I gave up and hoped someone out in the world wide web can assist.

Anyone able to offer a hand.