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. Quote 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? Quote 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 Quote 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. Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.