[Zachariah]

I was working on a rotation script.
- multi usernames 1 database
each user gets 50K in a given time frame. The script rotates what user VB uses.


- this needs some work or a new way of looking @ it.
- I am busy @ the moment

Old post I found
If you have a shared host for your website you may know what I mean. MySQL users get 50,000 Questions per hour. The account is banned then after the hour you get access again.

The hosts will allow you to create unlimited users per DB.

If I reindex the search index of my forums.
"" "" any part of my site that has a lot of data.

- 50,000 limit smashed and I get the no access "finger"

Here is what I get:

Processing: 102279 ... Done
Processing: 102281 ... Querying first post of thread... Done
Processing: 102282 ... Done
Processing: 102283 ...

Invalid SQL:
INSERT IGNORE INTO word (title) VALUES ('annnnnnything');

MySQL Error : User 'root' has exceeded the 'max_questions' resource (current value: 50000)
Error Number : 1226

Idea: "user load balance" (this may be done somewere)
- I could use some ideas
- would make a nice "how-to" also

forums/config.php

EX: w/ vBulletin 3.5.4

//	****** DATABASE NAME ******
	//	This is the name of the database where your vBulletin will be located.
	//	This must be created by your webhost.
$config['Database']['dbname'] = 'forums';

	//	****** TABLE PREFIX ******
	//	Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';

	//	****** MASTER DATABASE USERNAME & PASSWORD ******
	//	This is the username and password you use to access MySQL.
	//	These must be obtained through your webhost.
$config['MasterServer']['username'] = 'root';
$config['MasterServer']['password'] = 'password';

	//	****** MASTER DATABASE SERVER NAME AND PORT ******
	//	This is the hostname or IP address and port of the database server.
	//	If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 3306;


// Database array for Random users
// ##########################################
$dblogins = array();
	//	****** MASTER DATABASE USERNAME & PASSWORD ******
	//	This is the username and password you use to access MySQL.
	//	These must be obtained through your webhost.
$dblogins['1']['user'] = 'root2';
$dblogins['1']['pass'] = 'password';

	//	****** MASTER DATABASE USERNAME & PASSWORD ******
	//	This is the username and password you use to access MySQL.
	//	These must be obtained through your webhost.
$dblogins['2']['user'] = 'root3';
$dblogins['2']['pass'] = 'password';

	//	****** MASTER DATABASE USERNAME & PASSWORD ******
	//	This is the username and password you use to access MySQL.
	//	These must be obtained through your webhost.
$dblogins['3']['user'] = 'root4';
$dblogins['3']['pass'] = 'password';


// Place this below every thing.

// ********* The following does NOT need to be edited and is only used for multiple DB users ************
srand((float) microtime() * 10000000);
$dbloginid = array_rand($dblogins);
while ($dblogins[$dbloginid]['user'] == '')
{
	$dbloginid = array_rand($dblogins);
}	
$config['MasterServer']['username'] = $dblogins[$dbloginid]['user'];
$config['MasterServer']['password'] = $dblogins[$dbloginid]['pass'];

unset($dblogins, $dbloginid);

This will work but It still needs:
- counter in session memory per user and stop using account when close to 50k.

or

- IF mysql connect gives error ER_USER_LIMIT_REACHED (Error Number : 1226) THEN skip that user and use the next one.