Mgbe Ọdachi Mere!

n’ire ọkụ

The last 48 hours haven't been fun. Technology is a fantastic thing, but it's never perfect. When if fails, I'm not sure there's really that much preparation you can have… but you do have to react.

May nwere ike chọpụtala na saịtị anyị na-eji nwayọ nwayọ ewe izu ole na ole gara aga. Ọ bụ iju nyere eziokwu na anyị nwere ya na a nnukwu ngwugwu ngwugwu jikọtara na ihe nkesa data na netwọk nnyefe ọdịnaya. Ebe ọ bụ na anyị nwere ọtụtụ ohere, anyị kwadoro saịtị ndị ọzọ ebe ahụ, kwa too na nke ahụ bụ mmejọ anyị!

Otu oru ngo anyi bu elekọta mmadụ media nlekota ngwá ọrụ that connects to Twitter and Facebook, collecting data on thousands of teams in the sports market. Once a day it gathers fan and follower information, collecting it in the database. We've been doing a lot of development on the project and recently noticed that some of the stats were wrong. Our client, Okenye Pat, has been patient with us as we've been troubleshooting the issue.

Mgbe niile h ** l mebiri! Ọ na-egosi usoro maka ikpokọta ozi ahụ malitere na-agba ọsọ n'ime nkeji karịa otu ugboro n'ụbọchị. Ebe nchekwa data anyị toro karịa 1G n'ime ụbọchị, na-ebelata sava anyị ma na-ewere ọtụtụ ohere na ya. N'abalị ọzọ m na-ele anya ka saịtị ọ bụla anyị nwere na akaụntụ ahụ malitere ịgbadata otu n'otu. Ug.

Anyị na-eme atụmatụ ịbuga Martech na WPEngine to put it in a dedicated environment with backups, integrated content delivery, and a blazing fast set of servers. We have a couple other clients on it and have been extremely happy with both the service and their incredible support. It's not that Mediatemple was bad, it's simply that this environment was built for publication blogs like ours that get a ton of traffic. In the middle of the night, I wrote the guys at WPEngine and they had me up by the morning! Thanks guys!

Next, we started looking at how to fix the database. It actually halted the database server and corrupted the largest table (the one with ALL the central data!). Since the server was full, we couldn't do repair… we couldn't access the files, couldn't back it up… we were stuck. The folks at MediaTemple jumped in and repaired the table. We were then able to make a full backup and begin bringing the other sites back up.

The move to WPEngine wasn't without pain. Since we couldn't access our database, we had to take a recent snapshot of the database… which for some reason lost all of our category alignment in the process. We have Wepụ saịtị WordPress backups, kwa, mana nchekwa data anyị buru ibu nke na ijikọ ngalaba nchekwa niile ga-ewe ogologo oge.

So, we restored the data and been rooting through the 2,500+ posts and carefully recategorizing them. I'm sure we're going to take a bit of a hit on SEO because that changed URL paths… so we took an even bigger hit and changed our permalink structure (without the category). It's something I've needed to do for a while, so now was a better time than later.

We scrapped our old theme. It was graphics heavy (without CSS sprites) and wasn't too friendly to resizing. We've decided just to highly modify the Iri abụọ na iri na otu isiokwu that's standard with WordPress for now. It's HTML5 ready and has a ton of responsive design features that were good to take advantage of.

Ka ọ dị ugbu a, Jenn jigidere ebe ewusiri ike na DK New Media - juggling ole na ole oru na-akụ ha si nnukwu oge. Stephen wetara ụbọchị niile (ọ na-arụ ọrụ abalị!), Ezi enyi Adam Obere kicked in and helped, MediaTemple knocked it out of the park, and WPEngine helped, too. Thanks to everyone… we're back to blogging again!

Now it's time for me to get some sleep :). Then we'll fix our iPad and mobile themes!

4 Comments

  1. 1

    Doug,

    Ọ dị m nwute ịnụ na ị nwere nsogbu ndị a. Nke a bụ ebe ọkachamara IT, dị ka mụ onwe m, nwere ike ịnwe ma na-enyocha usoro gị iji gbochie ọnọdụ dị otú ahụ. Ekwenyesiri m ike na ị na-enweta ọtụtụ okwu na post dị otú a, mana ọnọdụ ahụ dị mfe. Nlekọta kwesịrị ekwesị, ịkọ uto na ịkọ amụma kwesịrị ịkwadebe saịtị gị na nchekwa data gị maka ọkwa a. M ga-enwe mmasị iso gị kwurịta okwu, banyere ọnọdụ a, yana usoro enwere ike ịme iji gbochie n'ọdịnihu. Anyi ekwuola n’oge gara aga, ị ma m n’igwe twitter gị dịka @indyscompugeek.

    Daniel, HeadGeek nke Indy's Computer Geek

  2. 3

    Doug - UGH! ziri ezi. Anọ m na saịtị a ihe dị ka otu izu ma ọ bụ karịa gara aga na-agụ blog ma achọpụta m na ọ dị nwayọ. Echere m nke ọma iziga gị ozi ma na-ekwu otu a, mana echere m onye m ga-agwa 'Nwoke ahụ' na saịtị ya “dị umengwụ.” Ugbu a ka m matara ihe kpatara ya! Yabụ, na-enwe obi ụtọ na gị (na posse gị) nwere ike iweghachi ya ma rụọ ọrụ. Youtụleela itinye Studio Studio nke StudioPress - http://www.studiopress.com - M na-eji ma ọ bụrụ na saịtị m na saịtị ndị ahịa m niile. Ngwunye ngwanrọ siri ike - Hụ ya n'anya!

    • 4

      Ndewo Greg! Anụla m nnukwu ihe banyere usoro Jenesis. Anyị ejibeghị ya mana echere m na m nwere ike ịpụ WordPress guru, Stephen, iji wuo isiokwu. Isiokwu a malitere site na iri abụọ na iri na otu mana ọ bụ nke ahaziri ma kachasị. Ruo ugbu a, ọ dị ka ọ na-ejide nke ọma!

Kedu ihe ị chere?

Ebe a na-eji Akismet iji belata spam. Mụta otu esi etinye usoro data gị.