+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 29
General EduGeek News/Announcements Thread, Moving the EduGeek Database in EduGeek Stuff; As most people will be aware, EduGeek is SLOW. We believe that the primary reason for this is the fact ...
  1. #1

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,603
    Thank Post
    96
    Thanked 678 Times in 523 Posts
    Rep Power
    156

    Moving the EduGeek Database

    As most people will be aware, EduGeek is SLOW. We believe that the primary reason for this is the fact that the database is sat on a shared database server.

    We now have a dedicated server that will be used for the new version of EduGeek.net (code-named Secundus). This server isn't doing too much at the moment so we are going to move the current EduGeek database to it in an attempt to speed up our site.

    The new version of EduGeek.net will also use a different CMS (that doesn't use as many database calls to render the pages). A new interim wiki will appear soon too.

    Unfortunately, the database move does mean that there will be some downtime. I expect this to either be as soon as I get the chance... we cannot afford to waste much more time I'm afraid.

  2. #2
    beeswax's Avatar
    Join Date
    Jul 2005
    Location
    England
    Posts
    2,252
    Thank Post
    258
    Thanked 212 Times in 144 Posts
    Rep Power
    74

    Re: Moving the EduGeek Database

    You've got to bite the bullet and do it.

  3. #3

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,603
    Thank Post
    96
    Thanked 678 Times in 523 Posts
    Rep Power
    156

    Re: Moving the EduGeek Database

    Quote Originally Posted by beeswax
    You've got to bite the bullet and do it.
    I've got to try to remember all the different passwords first!!!!!

  4. #4

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,272
    Blog Entries
    2
    Thank Post
    595
    Thanked 877 Times in 615 Posts
    Rep Power
    277

    Re: Moving the EduGeek Database

    Tut. I don't know. Most people do migrations in the wee small hours of the morning

  5. #5

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,603
    Thank Post
    96
    Thanked 678 Times in 523 Posts
    Rep Power
    156

    Re: Moving the EduGeek Database

    Quote Originally Posted by webman
    Tut. I don't know. Most people do migrations in the wee small hours of the morning
    The thing is that our site is very active late at night/early in the morning for some reason... the best time seems to be 6pm-8pm. I also like to sleep occasionally and given the amount of time that the backup will take.

    Russ also needs the site active after 10pm to show some Ausie guy.

  6. #6
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    1,670
    Thank Post
    71
    Thanked 82 Times in 69 Posts
    Rep Power
    39

    Re: Moving the EduGeek Database

    Ahh do it ric, edugeek.net needs a faster site, sometimes the slowness is just mental... like beeswax says, just bite the bullet and go for it... once you have rememeber the passwords lol.

  7. #7

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,603
    Thank Post
    96
    Thanked 678 Times in 523 Posts
    Rep Power
    156

    Re: Moving the EduGeek Database

    OK... had a bit of 'fun' moving the database - problems backing up and then the forum block off the front page killed the site (hence why it is currently missing).

    During all the fun, Fasthosts FTP disappeared too!!!

    Anyway... everything else seems OK now and hopefully the speed issues will be gone

  8. #8
    contink's Avatar
    Join Date
    Jul 2006
    Location
    South Yorkshire
    Posts
    3,806
    Thank Post
    296
    Thanked 318 Times in 224 Posts
    Rep Power
    112

    Re: Moving the EduGeek Database

    Some stuff for you to play with to help you tweak and peak the new server.

    VPS info (assuming you're on a VPS server now )
    http://www.labradordata.ca/home/13

    MySQLReport (a useful tool for figuring out your threads, etc..)
    http://hackmysql.com/mysqlreport

    MySQLTop (like top in *nix but for mysql)
    http://jeremy.zawodny.com/mysql/mytop/

  9. #9

    russdev's Avatar
    Join Date
    Jun 2005
    Location
    Leicestershire
    Posts
    7,092
    Blog Entries
    3
    Thank Post
    317
    Thanked 477 Times in 305 Posts
    Rep Power
    133

    Re: Moving the EduGeek Database

    VPS hah we have shiny dedicated server....

    Have you guys been sitting there waiting or something for the site to open backup...


    Russ

  10. #10
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,756
    Thank Post
    85
    Thanked 203 Times in 186 Posts
    Rep Power
    81

    Re: Moving the EduGeek Database

    We were all tuning in for the amusing messages on the maintenance page

  11. #11

    Dos_Box's Avatar
    Join Date
    Jun 2005
    Location
    Preston, Lancashire
    Posts
    7,696
    Blog Entries
    21
    Thank Post
    197
    Thanked 1,414 Times in 581 Posts
    Rep Power
    357

    Re: Moving the EduGeek Database

    BTW, I've initiated the old forums centre block as the new one is broken.

  12. #12
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,756
    Thank Post
    85
    Thanked 203 Times in 186 Posts
    Rep Power
    81

    Re: Moving the EduGeek Database

    Lets hope the site gets a good test tommorow to hopefully see how much faster it should now be .

  13. #13
    Midget's Avatar
    Join Date
    Oct 2006
    Location
    In a Server Room cutting through a forest of Cat5e
    Posts
    1,293
    Thank Post
    5
    Thanked 51 Times in 45 Posts
    Rep Power
    31

    Re: Moving the EduGeek Database

    I was expecting there to be a php script showing a new message from the BOFH message of the day on every refresh.

  14. #14

    Dos_Box's Avatar
    Join Date
    Jun 2005
    Location
    Preston, Lancashire
    Posts
    7,696
    Blog Entries
    21
    Thank Post
    197
    Thanked 1,414 Times in 581 Posts
    Rep Power
    357

    Re: Moving the EduGeek Database

    I'm not sure about faster, just more constant.

  15. #15

    russdev's Avatar
    Join Date
    Jun 2005
    Location
    Leicestershire
    Posts
    7,092
    Blog Entries
    3
    Thank Post
    317
    Thanked 477 Times in 305 Posts
    Rep Power
    133

    Re: Moving the EduGeek Database

    oh that gives me an idea

    Russ

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

Similar Threads

  1. Moving Sleuth database to another server.
    By Kyle in forum Educational Software
    Replies: 0
    Last Post: 10th December 2007, 11:05 AM
  2. Is EduGeek faster since we moved the database? (Poll)
    By Dos_Box in forum Comments and Suggestions
    Replies: 25
    Last Post: 20th July 2007, 06:32 PM
  3. HELP!!!! - Database
    By lalalalalalalalalalala in forum How do you do....it?
    Replies: 1
    Last Post: 21st March 2007, 10:03 PM
  4. Replies: 4
    Last Post: 28th February 2007, 10:37 AM
  5. Moving IIS
    By Simcfc73 in forum Windows
    Replies: 1
    Last Post: 14th July 2006, 03:21 PM

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
  •