Earthquake disrupts Internet

The Taiwan earthquake that occured late last year showed the world how dependant they were on communications technology. However I was thinking more about the lessons that this event brought about…

The Internet was designed to contain redundant links. It was supposed to withstand breakdowns within the network. And it did have redundant links through other continents and countries. Why did a single point of failure cause a drop in more than 50% of connectivity across Asia? Why was so much traffic preferred over the Taiwan link? Was it because it was cheaper so everyone turned to its link rather than the others? Was the Internet backbone design flawed to allow Taiwan to connect so many links?

I understand certain organisations or telephony networks might be directly connect to those links, but what about the rest of the major ISPs? I would expect slowness but not a breakdown such that it may cripples economies due to lack of financial information getting across. In fact economy crippling might be even on a terrorist agenda. (No I’m nothing near one.)

Perhaps, and hopefully, I’m just missing some information that gives me this mis-interpretation.

Update: According to this report [1], economical factors are preventing the network to be laid the way they should. I should have guessed.

But nature’s precise targeting alone cannot be blamed for Wednesday’s virtual blackout. It costs up to US$500,000 ($767,000) to lay a single kilometre of cables. Thousands of such kilometres were laid in the 1990s, but the returns dried up and no one was keen to pour money into fibre-optic activity for years. The next wave of investments is overdue, and just earlier this month a consortium announced plans to spend US$500 million on a high-speed undersea link directly between the United States and China.

Source: Channel News Asia

[1] The cable disconnect: Channel News Asia

The WordPress database

I’ve gone one round from a simple blog+wiki to trying MediaWiki, then XOOPS, now finally back to WordPress. After listing my requirements of chronological and categorized articles it seems WP has what I need and is easier to setup and customize as compared to the wiki and CMS.

During the process I tried the XOOPS news module and a variation of it know as the Article Management System (AMS). They could have sufficed for categorized articles, but I also need a blog-like interface, which I tried XPress – WordPress for XOOPS. It was simply a wrapper and could switch between the XOOPS and WordPress styles. Pretty impressive to me. Since I’ve migrated my older posts into the wrapped WP it should be easier for me to move posts over to the current WP.

Posts in WP are stored in the “wp_posts” table, or whatever your table prefix is. This includes your Pages, so be careful not to have duplicated IDs over at both sides. For a clean migration you’ll need to delete both the example post AND the example About page. Then, export the wp_posts data from the old blog and import it into the new blog.

Categories are stored in the “wp_categories” table, and linked to posts via the “wp_post2cat” table. This is due to the many-to-many relationship between categories and posts. The table has 3 columns, the first being a running number, the 2nd and third columns are the PKs of the category and posts table. Also, if the categories don’t match the new database, be sure to also update the category_count column in the wp_categories table. Mine was empty so the category didn’t show up on the blog and the category admin page showed 0 posts on the category.

Finally remember to set the correct time difference on the Options page before you begin migration, or you’ll end up with screwed up old posts like me…