Redirect Incase of mySQL problem

If someone has posted something like this before, I couldn't find it.

What this does:
It will redirect visitors to a static webpage of your choosing incase a connection to the mySQL server could not be established.

Every so often, The SQL server of our host becomes unresponsive, usually only for a few minutes, but, it's still annoying to try and load the site and have it take forver then be finally be greeted with a lovely SQL error. So, now people can get a nice friendly error page instead.

Feel free to modify and mess with it however you choose.


UPDATED

Trigunflame has provided a more elegant, sitewide solution that effectivly does the same exact thing.


Installation:

1. open includes/db_mysql.php
2. find the code below in the connect() function

if (!$this->link_id)
		{
			$this->halt('Link-ID == false, connect failed');
			return false;
		}

3. Replace that with

// Redirect For SQL Server Down
		if (!$this->link_id)
		{
			$url = 'http://narutotalk.org/';
			header ("Location: $url");
		}

Just replace the url with where ever you want it to goto.

I'm leaving the original file availible to download as it might be useful for other administrative purposes.

[Polo]

I was looking for something like this... thanks for sharing

[Deaths]

Very nice, this is very usefull.

[Tekton]

It doesn't take a good coder to make a great mod

[Harley77]

Thank you very much.

One other note, if someone want's it, its not hard to modify the testcon.php file to take the database login settings from your vb config file. I just did it this way for flexibility and make it easier to test without causing site wide dissruption.

[Deaths]

Originally Posted by Harley77

Thank you very much.

One other note, if someone want's it, its not hard to modify the testcon.php file to take the database login settings from your vb config file. I just did it this way for flexibility and make it easier to test without causing site wide dissruption.

I'm 99% sure this should so it, haven't tested though.

[Trigunflame]

A better solution that will work on any page.

1. open includes/db_mysql.php
2. find the code below in the connect() function

		if (!$this->link_id)
		{
			$this->halt('Link-ID == false, connect failed');
			return false;
		}

3. Replace that with

		// Redirect For SQL Server Down
		if (!$this->link_id)
		{
			$url = 'http://narutotalk.org/';
			header ("Location: $url");
		}

This will redirect users on any page, if the the DB connection could not be established.

All of the methods in the above posts's are redundant as they are trying to establish a "second" db connection. All that is going to do is slow down your pages on every load, and increase your mysql load by increasing its connections.

[Harley77]

Ah ha! new there was a better way. Curious though, would this method redirect on any kind of SQL issue such as conneciton limit reached (server side, not though VB), or any other failure to connect to the server and not just on an outright connection failure?

[Deaths]

My method, or his?

[Harley77]

His, Just wasn't sure what all errors it covered. I know that the method I put up pretty much covered all the bases incase of any kind of issue, just wasn't sure if the same was true with Trigunflames.