You will have noticed outages over the past few weeks. What’s happening is that our MySQL server is getting hammered at peak hours by too many connections at once. The cause is almost always our RSS feeds, so, most often, our mail server is going down also. HTTP and FTP are working fine during these outages, but you would never know that, since BloodhoundBlog itself, and our other weblogs, can’t work without MySQL.<\/p>\n
In any case, after doing everything we could think of to try to alleviate the problem, we have elected to move up to a more-robust file server. We will be moving into a fully-dedicated dual-core Xeon machine. We’ll pick up five times the storage space, five times the bandwidth and, we hope, ten times the MySQL power. This is something we would have done in due course, anyway, if only because we’ll be serving more and more video.<\/p>\n
Right now, I don’t know when for sure the move will happen. When it does, we may lose some data. I’ll tell the contributors to stand down, but some comments may not make the shift. The transfer is in-house at HostGator.com, but there will be a delay between the time that our files are copied to the new server and the IP address for BloodhoundRealty.com is propagated through the DNS system.<\/p>\n
I’ll post a note before and after the transition. Thanks for hanging with us through the recent outages. Cross your paws, shortly they’ll be a part of our history.
\n<\/p>\n
Technorati Tags: blogging<\/a>, real estate<\/a>, real estate marketing<\/a><\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" You will have noticed outages over the past few weeks. What’s happening is that our MySQL server is getting hammered at peak hours by too many connections at once. The cause is almost always our RSS feeds, so, most often, our mail server is going down also. HTTP and FTP are working fine during these […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3,6,5,19],"tags":[],"class_list":{"0":"post-1815","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-blogging","7":"category-marketing","8":"category-real-estate","9":"category-technology","11":"no-featured-image"},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":8698,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/8698\/happiness-is-a-green-status-board\/","url_meta":{"origin":1815,"position":0},"title":"Happiness is a green status board…","author":"Greg Swann","date":"May 31, 2009","format":false,"excerpt":"That's the SplendorQuest server a moment ago. The numbers come and go, but it's a rare thing for the server load to go over 5% right now. During the worst of our recent attacks, we were redlined at well over 90%, an enormous amount of computing power. We still have\u2026","rel":"","context":"In "Flourishing"","block_context":{"text":"Flourishing","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/flourishing\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1206,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/1206\/were-on-the-move-if-you-add-a-comment-tonight-it-will-probably-be-lost\/","url_meta":{"origin":1815,"position":1},"title":"We’re on the move: If you add a comment tonight, it will probably be lost","author":"Greg Swann","date":"March 24, 2007","format":false,"excerpt":"I have what I need to start moving BloodhoundBlog. Once I've posted this message, I will be backing up our MySQL database to get it ready to move. The weblog may continue to seem to work for the next few hours, but any changes made to the database -- any\u2026","rel":"","context":"In "Blogging"","block_context":{"text":"Blogging","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/blogging\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2475,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/2475\/cat-will-mew-and-dog-will-have-his-day\/","url_meta":{"origin":1815,"position":2},"title":"“Cat will mew and dog will have his day…”","author":"Greg Swann","date":"January 7, 2008","format":false,"excerpt":"But not today. We have a flaky drive on our file server in Texas. At some point tonight, we will be going down to install the replacement. The affected drive hosts 14GB of content, so the restoration process will probably take a little while. My bet is that we'll lose\u2026","rel":"","context":"In "Blogging"","block_context":{"text":"Blogging","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/blogging\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":7454,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/7454\/ave-atque-vale-bidding-farewell-to-conversations-past\/","url_meta":{"origin":1815,"position":3},"title":"Ave atque vale: Bidding farewell to conversations past","author":"Greg Swann","date":"March 11, 2009","format":false,"excerpt":"Notice a drag in the action lately? Have you been getting the database error a little too often? Time-outs? Memory overloads? Everything associated with Bloodhound Realty runs on a dual-core Xeon box. All by itself, no shared users. We have the whole server to ourselves. Two processors, two big disk\u2026","rel":"","context":"In "Dirty Laundry"","block_context":{"text":"Dirty Laundry","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/dirty-laundry\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8622,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/8622\/when-a-bloodhound-loses-the-scent-uptime-can-be-a-dawgs-life\/","url_meta":{"origin":1815,"position":4},"title":"When a Bloodhound loses the scent, uptime can be a dawg’s life","author":"Greg Swann","date":"May 27, 2009","format":false,"excerpt":"I don't think it would be an exaggeration to say that we've had availability problems lately. In fact, we've had four problems, and three of them may be fully addressed. First we had memory issues, which I didn't understand at first. Y'all would have seen them as memory errors or\u2026","rel":"","context":"In "Flourishing"","block_context":{"text":"Flourishing","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/flourishing\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":929,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/929\/wordpress-21-has-been-released-and-it-may-be-the-perfect-platform-for-real-estate-web-sites-as-well-as-weblogs\/","url_meta":{"origin":1815,"position":5},"title":"WordPress 2.1 has been released, and it may be the perfect platform for real estate web sites as well as weblogs . . .","author":"Greg Swann","date":"January 22, 2007","format":false,"excerpt":"WordPress 2.1 is out. More news from BloggingPro. Standout among the new features:You can set any \"page\" to be the front page of your site, and put the latest posts somewhere else, making it much easier to use WordPress as a content management system.What this means is that there is\u2026","rel":"","context":"In "Blogging"","block_context":{"text":"Blogging","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/blogging\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/posts\/1815","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/comments?post=1815"}],"version-history":[{"count":0,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/posts\/1815\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/media?parent=1815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/categories?post=1815"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/tags?post=1815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}