Michael Posted August 13, 2009 Posted August 13, 2009 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?
Michael Posted August 13, 2009 Author Posted August 13, 2009 Not to worry, I've found a host that supports what I am looking for. No split databases needed
ahuxham Posted August 13, 2009 Posted August 13, 2009 Last I heard Edugeek was run using Hamsters? You can find these at any pet store, and IIRC they're quick breeders!
ZeroHour Posted August 13, 2009 Posted August 13, 2009 Last I heard Edugeek was run using Hamsters? You can find these at any pet store, and IIRC they're quick breeders! LMAO 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? 3
Michael Posted August 13, 2009 Author Posted August 13, 2009 Well I couldn't think of any other website where I could get that information It's been a good year so I'm looking at new ideas and I found a suitable host, but initially I found most hosts restrict MySQL database sizes to 150MB, which isn't much at all really. I don't have the need to go dedicated, plus that's an additional task I can do without having to deal with everyone else! 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
SYNACK Posted August 13, 2009 Posted August 13, 2009 (edited) 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 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. 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 Edited August 13, 2009 by SYNACK 1
mac_shinobi Posted August 13, 2009 Posted August 13, 2009 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. 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 This is starting to become like You Got Questions, Ninja Got Answers. | Ask A Ninja hahaha lol
PEO Posted August 13, 2009 Posted August 13, 2009 whats the maximum size mysql can grow too? I have now setup both student and staff intranets
PEO Posted August 13, 2009 Posted August 13, 2009 found the answer to my question MySQL :: MySQL 5.0 Reference Manual :: B.1.2.12 The table is full
SYNACK Posted August 13, 2009 Posted August 13, 2009 (edited) whats the maximum size mysql can grow too? I have now setup both student and staff intranets Maximum size limit for mysql table [b]Operating System [/b][b]File Size Limt[/b] Windows (FAT32) 4GB Windows (NTFS) 2TB MacOS 2TB Linux 4TB Solaris 9/10 16TB Edited August 13, 2009 by SYNACK 1
PEO Posted August 13, 2009 Posted August 13, 2009 is it possible to allocate memory to mysql? would it benefit if 500+ users were connecting at any one time?
mac_shinobi Posted August 13, 2009 Posted August 13, 2009 Maximum size limit for mysql table [b]Operating System [/b][b]File Size Limt[/b] Windows (FAT32) 4GB Windows (NTFS) 2TB MacOS 2TB Linux 4TB Solaris 9/10 16TB If OS X 10.6 or above incorporates ZFS at some point would that change for Apple macs max capacity
SYNACK Posted August 13, 2009 Posted August 13, 2009 (edited) is it possible to allocate memory to mysql? would it benefit if 500+ users were connecting at any one time? 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. If OS X 10.6 or above incorporates ZFS at some point would that change for Apple macs max capacity 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. Edited August 13, 2009 by SYNACK 2
mac_shinobi Posted August 13, 2009 Posted August 13, 2009 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. 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
PEO Posted August 13, 2009 Posted August 13, 2009 I have about 8GB installed on the server. I cant see anything in mysql or joomla that would allow me to set min and max cache sizes so I am assuming it is all done auto magically
SYNACK Posted August 13, 2009 Posted August 13, 2009 I have about 8GB installed on the server. I cant see anything in mysql or joomla that would allow me to set min and max cache sizes so I am assuming it is all done auto magically Looks like it is configurable in the mysqld service config, here are some guides: MySQL Server Memory Usage | MySQL Performance Blog MySQL :: MySQL 5.0 Reference Manual :: 7.5.8 How MySQL Uses Memory Troubleshooting Memory Usage - RimuHosting 1
Michael Posted August 13, 2009 Author Posted August 13, 2009 (edited) All those numbers aside, I believe youtube uses MySQL, which goes to show how scaleable it really is. I know with MS SQL you can specify memory limits, but by default it will use as much as possible to speed everything up. I suspect MySQL behaves the same by default. Only on very large configurations you may need to tweak accordingly. A good example with MS SQL is when using Sims. It will quite easily use anywhere between 600MB to 1200MB with a server with 2GB of memory installed. Edited August 13, 2009 by Michael 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now