Multiple databases for my tables?

[LanceT]

Is there any way I can have multiple databases, each located on different servers handling one application? For example, maybe each table will have its own database on its own server? How do I do this exactly?

 

I am connecting using

 

$db1= mysql_connect ("$dbhost", "$dbusername", "$dbpassword") 	
or die ('I cannot connect to the database.');
mysql_select_db("$dbname", $db1);

 

which is located in my config.php

 

Thanks for your input.

[fenway]

It's ugly, why do you need to?

[jaymc]

Clustering with an N-Tier setup is what your after

 

Are you running out of system resources?

 

Will each database be a clone of a primary one? or do you want to spread the tables accross multiple servers

 

More info needed

[LanceT]

No each database will not be a clone.

 

Each database will only contain a single table, so I'm guessing that means that the tables are spread out across multiple servers. I'm doing this because I want to plan for the future if I will need more system resources.

[fenway]

Each database will only contain a single table, so I'm guessing that means that the tables are spread out across multiple servers. I'm doing this because I want to plan for the future if I will need more system resources.

 

IMHO, that's not even remotely required.