johnsmith153 Posted March 25, 2010 Share Posted March 25, 2010 MySQL version: 5.0.77 I am on the Rackspace Cloud platform and their database allows 2000 connections and 500 per user. Although they say you can scale a web site to allow thousands of visitors, I can't see how when I can only get 500 connections. Is there a way around this (they say not)? At the moment I use two different users to connect to two different databases (on the same database server) - does this mean I get 500 connections for each of these user accounts? What if my PHP code randomly assigned a different user to each visitor (out of four that I would create on the database server in advance) - would that mean I could have 500 connections PER USER - and thus get the full 2000 for my site? Quote Link to comment https://forums.phpfreaks.com/topic/196443-max-connections/ Share on other sites More sharing options...
johnsmith153 Posted March 25, 2010 Author Share Posted March 25, 2010 Any ideas anybody? Quote Link to comment https://forums.phpfreaks.com/topic/196443-max-connections/#findComment-1031943 Share on other sites More sharing options...
johnsmith153 Posted March 30, 2010 Author Share Posted March 30, 2010 Anyone know this? Quote Link to comment https://forums.phpfreaks.com/topic/196443-max-connections/#findComment-1034225 Share on other sites More sharing options...
johnsmith153 Posted April 1, 2010 Author Share Posted April 1, 2010 All I really need to know is this: If max_user_connections is set to 500, does that mean that I can just get PHP to randomly assign a different mysql user to use to connect and in effect my website would have 2000 connections if 4 random users were used. OR, is the max_user_connection 'my site' as the user - and of course no way of ever getting more than 500 connections. I am sure this is a simple question to those in the know and whilst I have no right to any help, I am a little surprised there hasn't been a response to this. Quote Link to comment https://forums.phpfreaks.com/topic/196443-max-connections/#findComment-1035260 Share on other sites More sharing options...
johnsmith153 Posted April 2, 2010 Author Share Posted April 2, 2010 Any ideas? Quote Link to comment https://forums.phpfreaks.com/topic/196443-max-connections/#findComment-1035954 Share on other sites More sharing options...
fenway Posted April 4, 2010 Share Posted April 4, 2010 Yes, you should be able to hit 2K with 4 users. Quote Link to comment https://forums.phpfreaks.com/topic/196443-max-connections/#findComment-1036774 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.