The Moz Q&A Forum

    • Forum
    • Questions
    • My Q&A
    • Users
    • Ask the Community

    Welcome to the Q&A Forum

    Browse the forum for helpful insights and fresh discussions about all things SEO.

    1. SEO and Digital Marketing Q&A Forum
    2. Categories
    3. Technical SEO Issues
    4. Database Crash affecting our rankings

    Database Crash affecting our rankings

    Technical SEO Issues
    11 5 390
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as question
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • SteveTheWoodsman
      SteveTheWoodsman last edited by

      I think your assumptions are on par.  However, make sure to review that the 301 has been removed.  Also, if you still want that auto redirect to happen on a crash, make it a 302 and not a 301 as a 301 will suck a lot of life out of your site (since SEs see it as permanent).

      tdawson09 1 Reply Last reply Reply Quote 1
      • tdawson09
        tdawson09 @SteveTheWoodsman last edited by

        Good point on the 301's. I'll look into that.

        Thanks, for your input!

        1 Reply Last reply Reply Quote 0
        • XNUMERIK
          XNUMERIK last edited by

          Your assumptions are globally right. However, I have never seen Google react that quickly to a 301 redirect or even a crash, I always tell my customers "if you have a temporary issue with 404 and 500 erros, don't worry about it too much, Google won't react unless it is a permanent issue that lasts over three or four crawls".

          This is why I would also investigate a penalty that just happened to take effect shortly after the crash. To rule that out, could you please tell us if some of your major keywords are still ranking well?

          I don't think you sould worry too much about that, just wait a few days and see if some pages recover.

          tdawson09 1 Reply Last reply Reply Quote 0
          • tdawson09
            tdawson09 @XNUMERIK last edited by

            Investigating it further, we have some permanent redirects that are still hanging. I've got my IT guys working on it as we speaking.

            I've got to run, but I would like to revisit this soon. Once we have determined the problem, I will post it here.

            Thanks for your opinions. They have helped.

            1 Reply Last reply Reply Quote 0
            • dawnieando
              dawnieando last edited by

              It seems extreme that Google would react within an hour and 15 mins but who knows nowadays.  Keep an eye on your GWT account and hopefully if you have a decent crawl rate things should remedy themselves.  Stephen Salstrand made a good point.  302's rather than 301's should help.  It's great to have something in place like a redirection for user experience in case of database failure, however, as Stephen said, it should be made clear to Google that it's only temporary.

              1 Reply Last reply Reply Quote 0
              • williammarlow
                williammarlow last edited by

                Also, can't we use GWT to find out the exact times or at least approximate times of when Google crawled a site? Or can we not find that information so precisely?  In this case, it does seem that the 301 vs. 302 is the key problem, but also the fact that the system for getting rid of the 301 didn't work out properly.

                1 Reply Last reply Reply Quote 0
                • dawnieando
                  dawnieando last edited by

                  I'm pretty sure that GWT is a little vague in  terms of times that Googlebot visited with just the crawlrate shown on a day by day basis and there's some lag between now and when it happened.  CPanel will show when spiders visited in latest visitors from memory, however I think that rather than looking back it would be better to simply ensure that this doesn't happen again with the 302 rather than the 301.  Maybe refreshing of your sitemap submissions in GWT would help to get some crawling going on with a ping or two to get Googlebot back soon.

                  1 Reply Last reply Reply Quote 0
                  • tdawson09
                    tdawson09 last edited by

                    I wanted to get back to report the cause of our problem with a lot of our rankings dropping. We originally thought it was due to a database crash. And that still could be affecting some things.

                    We moved our servers to a new location. A couple of weeks ago, we switched over to some new IP addresses. When we did so, a program started blocking Google's IP addresses because they were hitting our servers with a lot of hits, and put those IP addresses on a blocked list. So our pages on some of the websites stopped getting crawled, and thus rankings dropped. We discovered the problem when exploring our Webmaster Tools Crawl Stats and noticed that the "kilobytes downloaded per day" had flat-lined. Doing a fetch on selected pages we could see that it was not fetching the page. So after unblocking those IP addresses, the pages got crawled, our crawl stats went back up, and our rankings started going back to where they were. We still have some rankings that have not bounced back, but assume they will as new crawls re-index those pages.

                    A lesson learned for me was to pay attention to the crawl stats. Any drastic variations could be a sign of a problem.

                    Brad
                    iboats.com

                    1 Reply Last reply Reply Quote 1
                    • tdawson09
                      tdawson09 last edited by

                      Update:

                      After unblocking Google, almost all of our rankings are back up, and in some cases a little improved. I was surprised how quickly Google recrawled and ranked the pages that dropped.

                      I did do a Fetch and submit on all my websites and pages. I'm not sure how Fetches are attended to by Google, but it appears they are.

                      I have an IT guy who doesn't feel a Fetch makes any difference. He says Google will crawl when they want to and probably does not pay attention to the Fetch request.

                      dawnieando 1 Reply Last reply Reply Quote 0
                      • dawnieando
                        dawnieando @tdawson09 last edited by

                        Glad to hear you appear to be back on the right track 🙂

                        1 Reply Last reply Reply Quote 0
                        • 1 / 1
                        • First post
                          Last post
                        • # in url affecting rank
                          FonSeo
                          FonSeo
                          0
                          6
                          147

                        • Our sites have a high number of long urls. how does this affected ranking
                          Marcus_Miller
                          Marcus_Miller
                          0
                          3
                          386

                        • Page rank and ranking down
                          AnnSmarty
                          AnnSmarty
                          0
                          6
                          434

                        • Duplicat content affecting SEO Rankings
                          DanHill
                          DanHill
                          0
                          2
                          383

                        • Changing Domain Registrars have an affect on rankings?
                          858-SEO
                          858-SEO
                          0
                          2
                          351

                        • How do 301 redirects affect rankings?
                          akim26
                          akim26
                          0
                          4
                          1.6k

                        • Does a CDN affect search rankings?
                          Igal_Zeifman
                          Igal_Zeifman
                          0
                          7
                          9.5k

                        • How will a domain change affect my rankings?
                          mosaicpro
                          mosaicpro
                          0
                          5
                          860

                        Get started with Moz Pro!

                        Unlock the power of advanced SEO tools and data-driven insights.

                        Start my free trial
                        Products
                        • Moz Pro
                        • Moz Local
                        • Moz API
                        • Moz Data
                        • STAT
                        • Product Updates
                        Moz Solutions
                        • SMB Solutions
                        • Agency Solutions
                        • Enterprise Solutions
                        • Digital Marketers
                        Free SEO Tools
                        • Domain Authority Checker
                        • Link Explorer
                        • Keyword Explorer
                        • Competitive Research
                        • Brand Authority Checker
                        • Local Citation Checker
                        • MozBar Extension
                        • MozCast
                        Resources
                        • Blog
                        • SEO Learning Center
                        • Help Hub
                        • Beginner's Guide to SEO
                        • How-to Guides
                        • Moz Academy
                        • API Docs
                        About Moz
                        • About
                        • Team
                        • Careers
                        • Contact
                        Why Moz
                        • Case Studies
                        • Testimonials
                        Get Involved
                        • Become an Affiliate
                        • MozCon
                        • Webinars
                        • Practical Marketer Series
                        • MozPod
                        Connect with us

                        Contact the Help team

                        Moz logo
                        © 2021 - 2026 SEOMoz, Inc., a Ziff Davis company. All rights reserved. Moz is a registered trademark of SEOMoz, Inc.
                        • Accessibility
                        • Terms of Use
                        • Privacy