Connect to alternate DB when default DB is down?

[eluser]Randy Casburn[/eluser]
I'm thinking as I type, so...

If you're auto loading your DB, you could hook into a pre_controller routine that tests for the DB connection exactly as you've described above...so in code:

Code:

$this->load->database('local_group_name');
if ( ! this->db )
{
     $this->load->database('remote_group_name');
    
}

That is exactly what your code above does. In a pre_controller hook you could ensure your CI_DB object wouldn't have to change. In other words, you would be able to use $this->db to access the CI_DB object rather than separate names for separate connections.

Again, thinking as I'm typing, but this would achieve what you want as a temporary stop-gap.

Randy