+ 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,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    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,285
    Thank Post
    285
    Thanked 225 Times in 153 Posts
    Rep Power
    131

    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,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    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,403
    Thank Post
    637
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319

    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,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    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
    2,992
    Thank Post
    287
    Thanked 283 Times in 197 Posts
    Rep Power
    118

    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,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    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,791
    Thank Post
    303
    Thanked 327 Times in 233 Posts
    Rep Power
    118

    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
    6,920
    Thank Post
    708
    Thanked 550 Times in 365 Posts
    Blog Entries
    3
    Rep Power
    204

    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,999
    Thank Post
    120
    Thanked 280 Times in 258 Posts
    Rep Power
    106

    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
    9,853
    Thank Post
    583
    Thanked 2,162 Times in 987 Posts
    Blog Entries
    23
    Rep Power
    627

    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,999
    Thank Post
    120
    Thanked 280 Times in 258 Posts
    Rep Power
    106

    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,298
    Thank Post
    5
    Thanked 59 Times in 49 Posts
    Rep Power
    39

    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
    9,853
    Thank Post
    583
    Thanked 2,162 Times in 987 Posts
    Blog Entries
    23
    Rep Power
    627

    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
    6,920
    Thank Post
    708
    Thanked 550 Times in 365 Posts
    Blog Entries
    3
    Rep Power
    204

    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, 10: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, 05:32 PM
  3. HELP!!!! - Database
    By lalalalalalalalalalala in forum How do you do....it?
    Replies: 1
    Last Post: 21st March 2007, 09:03 PM
  4. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  5. Moving IIS
    By Simcfc73 in forum Windows
    Replies: 1
    Last Post: 14th July 2006, 02: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
  •