TheFilmGod Posted September 25, 2007 Share Posted September 25, 2007 Okay, so I'm designing this website. I'm designing for a high load of traffic (in the future, hopefully...) My host allows me to have up to ten mysql databases. But each of these databases can have seperate "virtual databases" within myphpadmin. Would there be any increase in performance if there were multiple databases? What about "virtual" databases? Is it even worth it? I mean if a page load requires three database connections - that may be a huge problem... Quote Link to comment https://forums.phpfreaks.com/topic/70557-more-database-equal-more-power/ Share on other sites More sharing options...
trq Posted September 25, 2007 Share Posted September 25, 2007 Would there be any increase in performance if there were multiple databases? It would make queries and database normalization very difficult. Most heavy traffic sites use load balancing, ie sharing the load between two servers. Notice I highlighted the word server? Having seperate databases on the same server will achieve nothing. Quote Link to comment https://forums.phpfreaks.com/topic/70557-more-database-equal-more-power/#findComment-354534 Share on other sites More sharing options...
TheFilmGod Posted September 25, 2007 Author Share Posted September 25, 2007 Good point. Thanks thorpe. I do like to ask a follow up question. How do I do load balancing? Quote Link to comment https://forums.phpfreaks.com/topic/70557-more-database-equal-more-power/#findComment-354565 Share on other sites More sharing options...
jaymc Posted September 25, 2007 Share Posted September 25, 2007 Load balancing.. Maybe have 2 servers 1 server = 5 tables heavily used 2nd server = the other 5 tables that are heavily used Quote Link to comment https://forums.phpfreaks.com/topic/70557-more-database-equal-more-power/#findComment-355054 Share on other sites More sharing options...
TheFilmGod Posted September 25, 2007 Author Share Posted September 25, 2007 well yeah. I'm not stupid. How do I SETUP load balancing? Quote Link to comment https://forums.phpfreaks.com/topic/70557-more-database-equal-more-power/#findComment-355296 Share on other sites More sharing options...
fenway Posted September 25, 2007 Share Posted September 25, 2007 well yeah. I'm not stupid. How do I SETUP load balancing? You don't -- the "future" is very far away. Leave it be, make sure you abstract the connection strings, and you can fiddle with load balancing later. I've built 100s of websites on the same db server with no issues yet. Quote Link to comment https://forums.phpfreaks.com/topic/70557-more-database-equal-more-power/#findComment-355299 Share on other sites More sharing options...
TheFilmGod Posted September 26, 2007 Author Share Posted September 26, 2007 well yeah. I'm not stupid. How do I SETUP load balancing? You don't -- the "future" is very far away. Leave it be, make sure you abstract the connection strings, and you can fiddle with load balancing later. I've built 100s of websites on the same db server with no issues yet. Yes, I agree with you, but its a good thing to plan. Mind you, this isn't going to a be personnal/hobby page, more like a serious website. Is there anything else I would need to worry about? Quote Link to comment https://forums.phpfreaks.com/topic/70557-more-database-equal-more-power/#findComment-355387 Share on other sites More sharing options...
fenway Posted September 26, 2007 Share Posted September 26, 2007 Not to sound brash, but get it up and running first... I've seen way too many projects plan for phase III without ever getting off the ground. Quote Link to comment https://forums.phpfreaks.com/topic/70557-more-database-equal-more-power/#findComment-355639 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.