Rotating database script

[dupatan]

Hello all,
i need help with the specific db queries problem. My site is hosted on ipage which limits max questions to 70000 queries per hour per user for a database. For some reason my site goes down quite often because it goes over this limit. To put it online i manually change the db user in configuration.php file.
The solution would be the rotating mysql login script where it either chooses one of these usernames randomly to login to the database or a username in a set order to log in with an array. That way is increases my queries to 210,000 per hour.
I found such a script for drupal which switches 3 users randomly. That's what i need but for joomla. Since my knowledge in this field is very basic i'd like to ask for the advice to correct this script to use it in joomla configuration.php file.
Any help is greatly appreciated!

Here is the drupal script:

Code: Select all

$db_user_array[] = 'mysql://username1:[email protected]/database_drupal1'; //enter 1st user name 
$db_user_array[] = 'mysql://username2:[email protected]/database_drupal1'; //enter 2nd user name 
$db_user_array[] = 'mysql://username3:[email protected]/database_drupal1'; //enter 3rd user name
$db_url = $db_user_array[ rand( 0, ( sizeof($db_user_array) -1 ) ) ];

[itoctopus]

You will need to have a core optimization in order to do the above. In any case, the real solution to this problem is to move to a more serious host.

[dupatan]

So it's not possible to modify just a configuration.php file to do that?

[dupatan]

For anyone who's facing same problem: here is the solution for J1.5
Core optimization is not needed! just create few users for the same database and with the same password.
In configuration.php you have to add this script after class JConfig {


function __construct()
{
$this->user = $this->getUser();
}
private function getUser()
{
$users_a = array('main_user_joomla','main_user_joomla2','main_user_joomla3');
$user_a = $users_a[array_rand($users_a)];
return $user_a;
}

[dupatan]

You will need to have a core optimization in order to do the above. In any case, the real solution to this problem is to move to a more serious host.

NOT true! See my solution above. Few lines of code in configuration.php and my problem is fixed. And i don't have to upgrade the host.

[gws]

You may consider upgrading / migrating from J1.5 as it is very old and vulnerable,latest is J3.8.5