车东 posted a photo:

DNS被劫持后，有很大的安全风险，比如Google域下的COOKIE有可能被劫持域的网站读取到。

想使用OpenDNS的服务非常简单，只需要将你现在的DNS换为如下两个地址就行了：
* 208.67.222.222
* 208.67.220.220

如果无法查看此图： 请试用Firefox的Access Flickr 插件
www.chedong.com/blog/archives/001355.html

    某国外公司的一个2TB的数据仓库坏了, 由于磁盘的问题, 系统表空间上出现了一些块坏. 他们也不是没有备份, 只是最后一次备份是在一个月以前做的, 而最近一段时间装载和处理了很多数据(大约100G左右), 如果直接恢复到一个月以前的备份, 则需要将这些数据重新装载和处理, 将消耗很长的时间. 在数据仓库中, 一般会将数据按时间分表或分区来存放, 因此还是比较容易将最近处理的数据恢复出来的.

    他们的领导给他们下了最后命令, 必须在5个工作日之内将这些数据恢复出来, 以供业务部门进行经营分析. 因此他们在对AUL作了一些测试后, 选用它作为这次恢复的解决方案. 这可是AUL有史以来面最大的数据库了, 要恢复其中100g的数据, 数据量也不算少了. 上次遇到一个1TB的, 不过我建议了他们重新生成数据.

    第一天我给他们许可证, 第二天我去问他们恢复进行得如何时, 已经只有一张大一点的表还没有恢复出来, 其他大部份数据都已经恢复好了, 速度还是比较快的. 在整个过程中, 我基本上没有作什么技术支持, 只是将英文站点上的几个页面链接发过去, 告诉他们如何申请许可证, 如何一步一步进行恢复.

    中国的数据仓库就没有这样的事了, 一个500G的坏掉了, 在OEM中将用户删除了, 三年的数据, 领导说重新从业务系统来生成数据, 只能说明这个数据仓库并不重要. 另外一个200G的数据仓库坏掉了, 磁盘陈列坏了, 拷出来的系统表空间文件中有很多的坏块, 好象也没有选择去恢复.

    还有一个数据库, 一个15G的表空间不知如何被删除了, 只留下了数据文件, 表空间文件用自动增长方式, 在这15G充满了数据. 据说是10月1号左发生的, 到现在还没有恢复, 因为领导还在费用和数据之间做平衡工作.

相关文章 | Related Artiles

评论这篇文章(0)

东北一哥们前两天中了6500万元的彩票（理论值，实际小于这个数），是开国以来第一人。领奖的时候由运钞车和武装护卫护送，阵势和一小型元首出巡没有什么两样。首先我很羡慕，因为这就意味着他不用继续光荣的劳动了。我以及我周围的一小撮人有一个共同的梦想：35岁以前退休。中了6500万大奖，可以左手对奖，右手写辞职书。高兴的话，可以在原公司对面再开一家一样的公司，然后挤跨它，请原来的老总过来擦皮鞋。不高兴的话，可以就那么呆着，一年出去旅行两次。下半年一次，北半球。上半年一次，南半球。一边玩，一边等着排队的消息，随时准备随神舟十号上天一次。

其次我觉得这位哥们勇气可嘉，没有戴墨镜蒙丝袜什么的，而是勇敢地走到了镜头前面。媒体在他还没有领奖前就已经曝料，很多人都表示，在他们美国领大奖要公布真实身份，这是公众的权利。也有人反对，说必须保护当事人。已经发生过类似的事情，人才从彩票中心出来，刀就已经架在了脖子上。我认识的时评家盛大林先生根据这事已经写好了评论，《彩票中奖者身份不应该保密》。吵来吵去，哥们自己出来了，虽然身边有几个拿霰弹枪（Google拼音中文不及格，xian！霰雪纷其无垠兮的霰，不是San！）的大汉。

我个人是反对曝光真实身份的，因为我们现在是个丛林社会。被亲戚朋友要点，被慈善机构勒索点，这都是小事。关键是一旦曝光之后，连我这样的良民都会立即动了邪念：干掉他。这是种非常自然的心态流露，中国人的行为方式是财不露白。一旦露出来而不抢，那是一种对财神的不尊重，我们要尊重赵公元帅。身边有宝马疾驰而过，路人都要投以仇恨的目光，何况6500万就在面前？

从另外一个方面来说，如果我是媒体记者，报道的风险也很大。法律上保证了中奖人有权保护自己的真实信息，透露就是违法。而他本人有好几千万，如果打官司的话，我的赢面很低。法律是对每个人都是公平的，但是对富人要更公平一些。即使官司赢了，他还有好几千万，买房买车买人都很容易的事情。守法是每个公民的责任，但是权力和财富可以获得豁免。

所以，还是什么都不知道最好，相信有圣诞老人，相信有天堂地狱，相信彩票真的能中大奖。

In this week’s Creative Commons Artist Spotlight, we interview French artist Philippe Mangold about his CC-licensed work available at Jamendo.com.

Why did you decide to release your music under a Creative Commons license?

I always considered art and music in particular as a way to share and build relationships with others. When I heard about the CC licences, I was immediately attracted because it fit my personal ethic. On the one hand, my works are protected under a copyright, but on the other hand I have the opportunity to do anything I want with it — and why not offer them by free downloads? It allows me to have good visibility on the web, a visibility which leads me into relationships with people like Red Hat Magazine readers!

How much of your work is CC-licensed?

All of my work is available under CC license on jamendo.com.

Who are your musical influences?

Actually I’m interested in all music; I’m like a kind of sponge. It influences me if i feel emotionally touched. Of course African music and ethnic music are my strongest influences. I fell for the Swiss harpist/guitar player Andreas Wollenweider. His music turned out to be a revelation for me — a kind of world fusion with a lot of instruments.

My carrier as a musician is pretty weird. Basically I’m a guitarist and I come from rock music. I had the chance to get in touch with many musicians with very different influences and they handed a little of their knowlege down to me, and they all contribute to build my tastes and my styles. I’m a completely open musician and I look forward to new discoveries.

What tools do you use to produce your music?

I work with Cubase but I play all the VSTs. I dont program any samples or loops. This is perhaps why my creations sound alive, with a kind of warmth. Of course I play all guitar, electric or not; it is my favorite instrument.

In composing my music I am very instinctive; despite my high musical level, I completely lean on a kind of intuition that allows me to build a sonic landscape to make the listener feel great emotion.

Are you touring, and if so, how can readers find you?

Currently touring is a project that I’m not able to realize, since I can’t afford it right now. But to play the Voyage Dans L’ether live — it would be an amazing experience.

Anything you’d like our readers to know about you?

I wish a brilliant future to Red Hat Magazine readers, and I advise all readers to keep an ear on the Jamendo platform. There are many talents and so many styles there!

I already wrote once about hosting troubles which we had with this site a while back. Today we had another trouble to one of the European hit servers for ClickAider project.

We had purchased this 1and1 server few months ago, before we were running into troubles and as it was running well and because we have rather quick and automated fail over if it ever crashes we do not get into too much trouble.
There is however yet another traffic trick surprise which we got into.

When we purchased the server we specially looked for traffic limits and 1and1 looked very good from the glance view. Promising Unlimited Traffic with 100Mbit transfer speed and when we got the server it indeed had 100Mbps connection.

Yesterday we’ve noticed server responding slow, showing packet loss as well as very large ping times compared to other servers in the same network. Checking with 1and1 support of course was useless - “if you shut down the web server you do not have any packet loss means it is your application problem”. I specially asked them if they could have enabled any traffic shaping or have any concurrent connection limit on their firewall or something similar - they told me they do not.

Looking closer at the problem I discovered my NIC is now switched to 10Mbit/Half duplex mode which was not enough at the times.
Checking with 1and1 support again I was told I’m switched to 10Mbps because I used over 1TB of traffic over month.
Now I’m given the option to unblock it in the control panel manually but I have to do this each 250GB of traffic manually after it blocks, which is of course unusable for any real use.

Indeed you can find about this limit in fine print but not from the outlined offer.

This is not the first time I run into the problem. The last one was with other provider and was even funnier. I got the server with
3000GB per month of traffic, however as I started to put any traffic on it I found my server is down and I was told their system simply shuts down the server if it uses more than 3Mbit/sec for more than 24 hours. And that was not even in the fine print.
The funnies thing is if you do the math here - if you use 5Mbit/Sec for 30 days 24 hours with 100% efficiency you can use only 970GB worth of traffic, which means their advertised offer is simply unreachable with such restrictions.

Generally in my experience (which is at large extent focused on inexpensive hosting) I found it much better to work with Co-Location than dedicated server hosting. If you get a rack or two, especially from the smaller company (which will make you significant client) you can get fair treatment. On other hand if you’re unlucky if will be harder to move servers to another location than simply stop renting one dedicated server and get another one. Typically used 95% Commit + Overcharge payment is also fair pricing which means hosting provider is interested for me to use more traffic, not less.

There are some surprised in Co-Location market as well but as setting up your own location is more involved you tend to check things more carefully. For example 24/7 support may not be such or it could be a guy living 30 miles from data center which can come where within an hour during the night if you need him. The “remote hands” may also wary a lot in price and quality.

The other interesting surprises I had were about power consumption. First you really need to make sure what power consumption is stated. Many data centers even though they give you 20A of power will only allow 80% peak use, which makes it 16A. In other cases you could get the amperage you can use fully. Of course I do not speak about 110V vs 208V difference which is pretty obvious one. Another gotcha with power is power availability and density - quite often there would not be extra power available or power density allowed per rack will be very low. Hurricane Electric in one of their data centers for example allows 15A of power per rack and this is it - want more power buy another rack.

Going forward we plan to host our consulting business web sites MySQLPerformanceBlog, Percona high quality dedicated server, mainly to keep it isolated from everything else and be secure, while for our other projects such as ClickAider as development and test servers and some other projects we have in works we will need to organize our little data center in the next few months.

For ClickAider this however would not be good enough - to minimize latency we need several GEOIP based locations which gather the data and that would be way to expensive to organize multiple data centers. So for the coming months I will be on lookout for dedicated physical or virtual servers in different parts of the world.

Entry posted by peter | No comment

Add to: | | | |