Thinking of quitting my old host ... migrating here

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • blakekr
    Member
    • Dec 2004
    • 30
    #1

    Thinking of quitting my old host ... migrating here

    I have another host on which I have most of my "main" sites. The problem is, their mysql is slow and getting slower, and my main site is now pretty database driven. It isn't "very" db-intensive, but it's too intensive for the host.

    Moving it would be a huge chore ... so I wanted to ask around here about mysql performance. Are you using fairly intensive apps like php forums, and how is the performance? Would you migrate a DB-driven site here if it took you about forty hours to do so?
    Tags: None
    • Jonathan
      Senior Member
      • Mar 2004
      • 1229
      #2
      Originally posted by blakekr
      I have another host on which I have most of my "main" sites. The problem is, their mysql is slow and getting slower, and my main site is now pretty database driven. It isn't "very" db-intensive, but it's too intensive for the host.

      Moving it would be a huge chore ... so I wanted to ask around here about mysql performance. Are you using fairly intensive apps like php forums, and how is the performance? Would you migrate a DB-driven site here if it took you about forty hours to do so?
      Well Dathron can transfer all the stuff for bout 50¢/domain, I think
      the cost is; but the old host must have cPanel for this to work.

      I've run PHPNuke & PostNuke CMSs and so many different
      types of forums that I can't name 'em all (phpBB, IPB, SMF to name a few).

      Personally, DIS is the best host I've come across so far.
      "How can someone be so distracted yet so focused?"
      - C

        Comment

        • sdjl
          Senior Member
          • Mar 2004
          • 502
          #3
          Lets hope your sites aren't too busy for a shared server environment..

          Dumping MySQL databases is quite easy. You can then transfer between the two servers using SSH and command line FTP.

          To dump a DB:
          mysql -u USERNAME -p -D DATABASE_NAME > db_dump.sql

          To import a DB:
          mysql -u USERNAME -p -D DATABASE_NAME < db_dump.sql

          The transferring between servers will have a different command dependant on what command line FTP agent is availble.

          David
          -----
          Do you fear the obsolescence of the metanarrative apparatus of legitimation?

            Comment

            • blakekr
              Member
              • Dec 2004
              • 30
              #4
              All right, I'm 99% sure I'm moving. They are just TOOOOOOOO slow. Thanks so much for responding; it makes me feel a lot better about the work involved to know things will probably go better here.

                Comment

                • waltonics
                  Junior Member
                  • Nov 2004
                  • 28
                  #5
                  I repeat the comment about being really sure you arent too big for a shared hosting environment.

                  How many people online in yr forums simultaneously etc etc? Perhaps you could email Andrew with a few stats.

                  Sorry to butt in, but I think if you have some sort of db driven site and your host is way too slow on mysql, you really need to make sure you have located the problem, and it isnt you or your scripts, before you jump ship!

                    Comment

                    • sdjl
                      Senior Member
                      • Mar 2004
                      • 502
                      #6
                      I'd agree with the above comment. You don't want to get here, transfer your sites over and then get told that you're site is using too much processing time and that you need to move to a dedicated server.

                      David
                      -----
                      Do you fear the obsolescence of the metanarrative apparatus of legitimation?

                        Comment

                        • blakekr
                          Member
                          • Dec 2004
                          • 30
                          #7
                          It's actually a shopping cart of sorts, not a forum. And I'm not very popular right now. I get about 400-500 unique visitors a day and about 2500 page loads. No matter what mysql app I run on this other host, it runs pretty slow. I don't think I'm at the dedicated server level, yet! Plus, all my sites hosted there get tagged as "slow" by Alexa, ya know? Most of them don't run DB apps at all.

                          Is anyone willing to publish their Dathorn-hosted URL that runs a forum or anything database-driven so I can eyeball it for speed?

                            Comment

                            • Jonathan
                              Senior Member
                              • Mar 2004
                              • 1229
                              #8
                              Originally posted by blakekr
                              It's actually a shopping cart of sorts, not a forum. And I'm not very popular right now. I get about 400-500 unique visitors a day and about 2500 page loads. No matter what mysql app I run on this other host, it runs pretty slow. I don't think I'm at the dedicated server level, yet! Plus, all my sites hosted there get tagged as "slow" by Alexa, ya know? Most of them don't run DB apps at all.

                              Is anyone willing to publish their Dathorn-hosted URL that runs a forum or anything database-driven so I can eyeball it for speed?
                              Check my signature, the silly FAQ section is DB driven
                              "How can someone be so distracted yet so focused?"
                              - C

                                Comment

                                • Frank Hagan
                                  Senior Member
                                  • Mar 2004
                                  • 724
                                  #9
                                  Originally posted by blakekr
                                  It's actually a shopping cart of sorts, not a forum. And I'm not very popular right now. I get about 400-500 unique visitors a day and about 2500 page loads. No matter what mysql app I run on this other host, it runs pretty slow. I don't think I'm at the dedicated server level, yet! Plus, all my sites hosted there get tagged as "slow" by Alexa, ya know? Most of them don't run DB apps at all.

                                  Is anyone willing to publish their Dathorn-hosted URL that runs a forum or anything database-driven so I can eyeball it for speed?
                                  Not a very busy site this time of year, but my boat building forums at http://www.messing-about.com/forum/ get about double the page loads that you are getting. They are phpBB forums, database driven. They get about twice as busy in the spring and summer months.

                                  Code:
                                  Date       Visits  Pages   Hits      Bandwidth
21 Jan 2005 575   3780   18629   78.66 MB 
22 Jan 2005 473   3236   17783   66.19 MB 
23 Jan 2005 491   3491   18464   72.92 MB 
24 Jan 2005 592   4508   22641   80.89 MB 
25 Jan 2005 563   4302   18554   90.10 MB 
26 Jan 2005 612   5524   21937  122.03 MB 
27 Jan 2005 502   3444   18265    77.24 MB
                                  I periodically check using a SSH connection and using the "top" command to see what's happening to the server, and my forum processes, even when 4 - 5 people are on at the same time, are never up in the top 10.

                                    Comment

                                    Previous template Next
                                    Working...