Question to the admins, hope you don't mind me asking this -
Does Edugeek work with a single large MySQL database, multiple MySQL databases (so as one gets full, it uses the next available database) or is it split evenly over multiple MySQL databases?
And depending on the answer, how big a database does this site use?
Not to worry, I've found a host that supports what I am looking for. No split databases needed
Last I heard Edugeek was run using Hamsters? You can find these at any pet store, and IIRC they're quick breeders!
They must have a huge food bill then
LMAOOriginally Posted by ahuxham
We currently have a dedicated server running mysql which is allocated plenty of ram for speed. The site is split across multiple databases for the different roles, e.g. vbulletin is a db, jabber has its on db and wiki etc but they all run on a single instance of mysql. I wrote various pieces of code to allow jabber to use the vbulletin db etc for auth but each role gets very limited permissions to each other in case a hole in one was to be discovered it does not allow a full system breach (as it could with a single db)
Currently we will have about 2-3gb of mysql data across the various db's in total.
Hope that helps clarify how its done here at least.
What were you looking for in a host out of interest?
Well I couldn't think of any other website where I could get that information
My existing website will be getting a complete overhaul and I will be starting up other ideas with a need to grow, hence my question with regards to Edugeek and database sizes/configuration. All I will say is it'll be running on a Linux, Apache, PHP and MySQL configuration
Legend tells that the mythical virtual hampsters powering the inner workings of the EduGeek system are feed on the carcases of trolls and spammers found lurking on the forum. This is why so few make it onto the boards and if they do are quickly consumed by the ravonous hamsters. These voracious little critters are herded by the dedicated mods and admins while the mighty datacentre Geoff looks on from his newly refurbished Google moonbase. Edugeek users are left to roam the desolate* surface of the planet below in AT-AKs for a mere 50p an hour or purchase their own customized water cooled monster at a compeditive price from CPLD.They must have a huge food bill then
Though extremely powerful and useful the hampsters are also dangerous so must be carefully contained least 'The Incident' occour again. Where corrupted data rains from the skys, Mattx is sponsered by Apple and Wikipedia becomes accurate.
* From an inteligent life standpoint
There we go 6.4 EduGeek memes ought to be enough for anyone
Last edited by SYNACK; 13th August 2009 at 06:40 PM.
matt40k (20th August 2009)
This is starting to become like You Got Questions, Ninja Got Answers. | Ask A Ninja hahaha lolLegend tells that the mythical virtual hampsters powering the inner workings of the EduGeek system are feed on the carcases of trolls and spammers found lurking on the forum. This is why so few make it onto the boards and if they do are quickly consumed by the ravonous hamsters. These voracious little critters are herded by the dedicated mods and admins while the mighty datacentre Geoff looks on from his newly refurbished Google moonbase. Edugeek users are left to roam the desolate* surface of the planet below in AT-AKs for a mere 50p an hour or purchase their own customized water cooled monster at a compeditive price from CPLD.
Though extremely powerful and useful the hampsters are also dangerous so must be carefully contained least 'The Incident' occour again. Where corrupted data rains from the skys, Mattx is sponsered by Apple and Wikipedia becomes accurate.
* From an inteligent life standpoint
There we go 6.4 EduGeek memes ought to be enough for anyone
whats the maximum size mysql can grow too? I have now setup both student and staff intranets
found the answer to my question
Maximum size limit for mysql table
Code:Operating System File Size Limt Windows (FAT32) 4GB Windows (NTFS) 2TB MacOS 2TB Linux 4TB Solaris 9/10 16TB
Last edited by SYNACK; 13th August 2009 at 06:59 PM.
is it possible to allocate memory to mysql? would it benefit if 500+ users were connecting at any one time?
If OS X 10.6 or above incorporates ZFS at some point would that change for Apple macs max capacity
More memory means more cache which means much more speed (huge benifit). Not sure if you can allocate direcly but you should be able to set minimum and maximum memory usage on the db engine like MS SQL.
Yes, the limits are based on the file system so it would increase with ZFS depending on OSXs implementation if they put it in the next version.
Last edited by SYNACK; 13th August 2009 at 07:05 PM.
mac_shinobi (13th August 2009), PEO (13th August 2009)
Think I might start on the mac bashing cos bit narked off they didnt include it and knowing my luck they won't do it properly first time around or it wont be good enough to match solaris
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Reply With Quote