+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
Coding Thread, Edugeek Database in Coding and Web Development; Question to the admins, hope you don't mind me asking this - Does Edugeek work with a single large MySQL ...
  1. #1

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,228
    Thank Post
    239
    Thanked 1,562 Times in 1,246 Posts
    Rep Power
    339

    Edugeek Database

    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?

  2. #2

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,228
    Thank Post
    239
    Thanked 1,562 Times in 1,246 Posts
    Rep Power
    339
    Not to worry, I've found a host that supports what I am looking for. No split databases needed

  3. #3
    ahuxham's Avatar
    Join Date
    Apr 2008
    Posts
    1,122
    Thank Post
    76
    Thanked 138 Times in 109 Posts
    Rep Power
    30
    Last I heard Edugeek was run using Hamsters? You can find these at any pet store, and IIRC they're quick breeders!

  4. #4

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,228
    Thank Post
    239
    Thanked 1,562 Times in 1,246 Posts
    Rep Power
    339
    They must have a huge food bill then

  5. #5

    ZeroHour's Avatar
    Join Date
    Dec 2005
    Location
    Edinburgh, Scotland
    Posts
    5,630
    Thank Post
    890
    Thanked 1,314 Times in 798 Posts
    Blog Entries
    1
    Rep Power
    441
    Quote Originally Posted by ahuxham View Post
    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?

  6. 3 Thanks to ZeroHour:

    john (13th August 2009), matt40k (20th August 2009), Michael (13th August 2009)

  7. #6

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,228
    Thank Post
    239
    Thanked 1,562 Times in 1,246 Posts
    Rep Power
    339
    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

  8. #7

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,984
    Thank Post
    850
    Thanked 2,650 Times in 2,250 Posts
    Blog Entries
    9
    Rep Power
    763

    Talking

    Quote Originally Posted by ahuxham View Post
    Last I heard Edugeek was run using Hamsters? You can find these at any pet store, and IIRC they're quick breeders!
    Quote Originally Posted by Michael View Post
    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
    Last edited by SYNACK; 13th August 2009 at 06:40 PM.

  9. Thanks to SYNACK from:

    matt40k (20th August 2009)

  10. #8

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,675
    Thank Post
    3,209
    Thanked 1,030 Times in 955 Posts
    Rep Power
    361
    Quote Originally Posted by SYNACK View Post
    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

  11. #9
    PEO
    PEO is offline
    PEO's Avatar
    Join Date
    Oct 2007
    Posts
    2,093
    Thank Post
    457
    Thanked 150 Times in 95 Posts
    Rep Power
    71
    whats the maximum size mysql can grow too? I have now setup both student and staff intranets

  12. #10
    PEO
    PEO is offline
    PEO's Avatar
    Join Date
    Oct 2007
    Posts
    2,093
    Thank Post
    457
    Thanked 150 Times in 95 Posts
    Rep Power
    71

  13. #11

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,984
    Thank Post
    850
    Thanked 2,650 Times in 2,250 Posts
    Blog Entries
    9
    Rep Power
    763
    Quote Originally Posted by PEO View Post
    whats the maximum size mysql can grow too? I have now setup both student and staff intranets
    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.

  14. #12
    PEO
    PEO is offline
    PEO's Avatar
    Join Date
    Oct 2007
    Posts
    2,093
    Thank Post
    457
    Thanked 150 Times in 95 Posts
    Rep Power
    71
    is it possible to allocate memory to mysql? would it benefit if 500+ users were connecting at any one time?

  15. #13

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,675
    Thank Post
    3,209
    Thanked 1,030 Times in 955 Posts
    Rep Power
    361
    Quote Originally Posted by SYNACK View Post
    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
    If OS X 10.6 or above incorporates ZFS at some point would that change for Apple macs max capacity

  16. #14

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,984
    Thank Post
    850
    Thanked 2,650 Times in 2,250 Posts
    Blog Entries
    9
    Rep Power
    763
    Quote Originally Posted by PEO View Post
    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.
    Quote Originally Posted by mac_shinobi View Post
    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.
    Last edited by SYNACK; 13th August 2009 at 07:05 PM.

  17. 2 Thanks to SYNACK:

    mac_shinobi (13th August 2009), PEO (13th August 2009)

  18. #15

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,675
    Thank Post
    3,209
    Thanked 1,030 Times in 955 Posts
    Rep Power
    361
    Quote Originally Posted by SYNACK View Post
    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

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [CLOSED] Misc: EduGeek Database Error
    By EduTech in forum EduGeek.net Site Problems
    Replies: 10
    Last Post: 15th May 2009, 01:57 AM
  2. EduGeek Blogs - Public or Private/EduGeek only?
    By mb2k01 in forum General Chat
    Replies: 4
    Last Post: 13th April 2009, 04:08 PM
  3. Is EduGeek faster since we moved the database? (Poll)
    By Dos_Box in forum Comments and Suggestions
    Replies: 25
    Last Post: 20th July 2007, 05:32 PM
  4. Moving the EduGeek Database
    By Ric_ in forum General EduGeek News/Announcements
    Replies: 28
    Last Post: 20th July 2007, 08:19 AM
  5. Replies: 4
    Last Post: 28th February 2007, 09:37 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •