Top Nav

Percona XtraDB Upgrade With Yum Shell

Ran into dependency problems today trying to upgrade a Percona XtraDB server cluster. Yum shell to the rescue:

This way I can run the remove and installs as part of a single transaction.

0

Redirect HTTP to HTTPS on IIS

If you need to force HTTPS on the entire site then add the following to the web.config file:

If you want to force HTTPS on a specific URL, then use this instead:

 

 

 

0

Redirect HTTPS to HTTP

If you want to redirect all HTTPS traffic to HTTP then add the following to your .htaccess file:

 

0

Block Access To .git And .svn Folders

On Nginx add the following to each “server” block:

And the for Apache add the following to the VirtualHost block:

0

Scripting CHECK / REPAIR TABLES

Here’s a one-liner that will check all tables in a database:

http://codeinthehole.com/writing/checking-all-mysql-tables/

And here’s an article that shows the use of mysqlcheck:

http://www.thegeekstuff.com/2011/12/mysqlcheck/

mysqlcheck, unlike myisamchk, can be run when the mysql daemon is running

This command will check, repair and optimize all tables in all databases:

 

0