LanceT Posted September 16, 2007 Share Posted September 16, 2007 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. Link to comment https://forums.phpfreaks.com/topic/69603-multiple-databases-for-my-tables/ Share on other sites More sharing options...
fenway Posted September 18, 2007 Share Posted September 18, 2007 It's ugly, why do you need to? Link to comment https://forums.phpfreaks.com/topic/69603-multiple-databases-for-my-tables/#findComment-350521 Share on other sites More sharing options...
jaymc Posted September 19, 2007 Share Posted September 19, 2007 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 Link to comment https://forums.phpfreaks.com/topic/69603-multiple-databases-for-my-tables/#findComment-351224 Share on other sites More sharing options...
LanceT Posted September 29, 2007 Author Share Posted September 29, 2007 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. Link to comment https://forums.phpfreaks.com/topic/69603-multiple-databases-for-my-tables/#findComment-358120 Share on other sites More sharing options...
fenway Posted October 1, 2007 Share Posted October 1, 2007 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. Link to comment https://forums.phpfreaks.com/topic/69603-multiple-databases-for-my-tables/#findComment-358983 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.