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? 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? 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? 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. 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? 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. Link to comment https://forums.phpfreaks.com/topic/196443-max-connections/#findComment-1036774 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.