Linux准备好用于大容量数据库？ [英] Linux ready for high-volume databases?
问题描述
On Mon，2003-08-25 16:28，Gregory S. Williamson写道：
On Mon, 2003-08-25 at 16:28, Gregory S. Williamson wrote:
我们的一个系统管理员发送了这个链接...想知道是否有任何评论来自linux和数据库的实际用户世界。
< http://story.news.yahoo.com/news?tmpl = story& cid = 1738& ncid = 738& e = 9& u = / zd / 20030825 / tc_zd / 55311>
One of our sysads sent this link ... wondering if there is any comment on it from the world of actual users of linux and a database.
<http://story.news.yahoo.com/news?tmpl=story&cid=1738&ncid=738&e=9&u=/zd/20030825/tc_zd/55311>
弱点包括缺乏可用工具，易用性和易用性
安装
听起来他需要点滴和流口水工具......
另一方面，甚至可能是一个强大的Linux 2.4 *今天*系统处理
a 24x7 500GB数据库，每天必须处理6-8M OLTP风格的交易，同时还会受到报告查询的影响？
不要以为这是一个巨魔，因为我真的不知道，即使我知道MVS，OpenVMS& Solaris可以。 （我甚至不想询问有关Windows和FreeBSD等玩具的问题。）
-
---- -------------------------------------------------- -----------
Ron Johnson，Jr。 ro ***********@cox.net
美国路易斯安那州杰斐逊
知识应该是免费的所有。
Harcourt Fenton Mudd，星际迷航：TOS，我，Mudd
--------------- ------------（广播结束）---------------------------
提示2：您可以使用取消注册命令一次性取消所有列表
（发送取消注册YourEmailAddressHere到 ma ******* @ postgresql.org ）
"Weak points include lack of available tools, ease of use and ease
of installation"
Sounds like he needs point-and-drool tools...
On the other hand, could even a beefy Linux 2.4 *today* system handle
a 24x7 500GB db that must process 6-8M OLTP-style transactions per
day, while also getting hit by report queries?
Don''t think of this as a troll, because I really don''t know, even
though I do know that MVS, OpenVMS & Solaris can. (I won''t even
ask about toys like Windows and FreeBSD.)
--
-----------------------------------------------------------------
Ron Johnson, Jr. ro***********@cox.net
Jefferson, LA USA
"Knowledge should be free for all."
Harcourt Fenton Mudd, Star Trek:TOS, "I, Mudd"
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)
推荐答案
>> >>> " RJ" == Ron Johnson< ro *********** @ cox.net>写道：
RJ>不要以为这是一个巨魔，因为我真的不知道，甚至还不知道。虽然我知道MVS，OpenVMS& Solaris可以。 （我甚至不会对你来说是一个问题，而是询问有关像Windows和FreeBSD这样的玩具。）
好吧，如果你认为FreeBSD，你必须吸一些有趣的东西是一个
''玩具'与窗户混在一起....
我在FreeBSD上运行24x7x365分贝，*从不*崩溃在它已经投入生产的3年内。只有停机时间从
PG 7.1升级到7.2，一次从RAID5切换到RAID10。因为我正在使磁盘I / O饱和，所以* * * * * $
在从新的盒子上从PG 7.2更新到
7.4后很快就会有几分钟的停机时间
旧盒子上的带宽。 eRServer软件将在现场数据库上进行数据迁移，因此我没有明显的停机时间。
数据库目前在磁盘上约为27Mb（包括索引）和
每天处理数百万次插入和更新，每两周删除几百万美元的b $ b。
-
= - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - = - =
Vivek Khera，Ph.D。 Khera Communications，Inc。
互联网： kh***@kciLink.com Rockville，MD + 1- 240-453-8497
AIM：vivekkhera Y！：vivek_khera http://www.khera.org/~vivek/
--------------------- ------（广播结束）---------------------------
提示9：如果您的
加入列的数据类型不匹配，计划者将忽略您选择索引扫描的愿望
>>>>> "RJ" == Ron Johnson <ro***********@cox.net> writes:
RJ> Don''t think of this as a troll, because I really don''t know, even
RJ> though I do know that MVS, OpenVMS & Solaris can. (I won''t even
RJ> ask about toys like Windows and FreeBSD.)
Well, you must be smoking something funny if you think FreeBSD is a
''toy'' to be lumped in with windows....
I run a 24x7x365 db on FreeBSD which has *never* crashed in the 3
years it has been in production. Only downtime was the upgrade from
PG 7.1 to 7.2 and once for a switchover from RAID5 to RAID10. I *may*
have a few minutes of down time shortly when updating from PG 7.2 to
7.4 on a new box since I''m saturating the disk I/O bandwidth on the
old box. The eRServer software will be doing the data migration on
the live db so I don''t have significant down time.
The DB is currently about 27Mb on disk (including indexes) and
processes several million inserts and updates daily, and a few million
deletes once every two weeks.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: kh***@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column''s datatypes do not match
On Tue ，2003-08-26 10：00，Dennis Gearon写道：
On Tue, 2003-08-26 at 10:00, Dennis Gearon wrote:
免费的BSD可能是玩具，也许不是，但它运行的网站主机比其他任何操作系统都多。
那应该是个玩笑。将FreeBSD放在同一个班级中使用Winblows的
是一个初步的荒谬，无论你怎么削减它...
Ron Johnson写道：
Free BSD may be a toy, maybe not, but it runs more of the webhosting
domains than any other OS.
That was supposed to be a joke. Putting FreeBSD in the same class
with Winblows is a prima facia absurdity, no matter how you cut it...
Ron Johnson wrote:
在星期一，2003-08-25 16:28，Gregory S. Williamson写道：
[snip]虽然我知道MVS，OpenVMS& Solaris可以。 （我甚至不会询问像Windows和FreeBSD这样的玩具。）
On Mon, 2003-08-25 at 16:28, Gregory S. Williamson wrote:
[snip]though I do know that MVS, OpenVMS & Solaris can. (I won''t even
ask about toys like Windows and FreeBSD.)
-
-------------------------------------------------- ---------------
Ron Johnson，Jr。 ro *********** @ cox.net
美国路易斯安那州杰斐逊
百万美元中文说中文，它不是遗传的......
Dean Edell博士
------------- --------------（广播结束）---------------------------
提示1：订阅和取消订阅命令转到 ma*******@postgresql.org
--
-----------------------------------------------------------------
Ron Johnson, Jr. ro***********@cox.net
Jefferson, LA USA
"Millions of Chinese speak Chinese, and it''s not hereditary..."
Dr. Dean Edell
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org
昨天看完这篇文章后，我做了一些研究。一个_big_原因
为什么Sourceforge / VA / OSDN从PostgreSQL转移到IBM / Webshere / DB2是
由此产生的产品将由Sourceforge和IBM共同销售s $ z $ b亿的销售人员。因此，他们不仅会获得一个闪亮的新数据库，而且还会获得后期收入。
这些公司将联合营销和销售该软件作为其中一部分
商业协议。 - 第4段，最后一句。
http://www.eweek.com/print_article/0...a=30025,00.asp
今日另行公告，VA Software宣布与IBM签署一项重要的商业协议，重点关注下一代SourceForgea？企业版的联合营销和销售。&bbsp; - 来自
的第7段报告
http://www.vasoftware.com/news/press.php/2002/1070.html
也许PostgreSQL团队对这项工作的投标，如果有人甚至咨询过，
并没有像IBM那样构建项目 - 产品合资企业。这是一个很好的
战术，我不会因为这个机会而责怪Sourceforge。
这个决定并不完全是技术性的，所以我不要把这看作是一个损失，因为它是b $ b $ PostgreSQL。无论如何DB2都不是一个懒散的数据库，但并不是很多公司能够像Sourceforge那样与IBM讨价还价。如果您是Topeka的零售商
有3个地点，我怀疑IBM会给予您同样的关注或联合
他们给Sourceforge的营销协议。 DB2不便宜。
-
Best，
Al Hulaton |高级客户工程师| Command Prompt，Inc。
503.222.2783 | ah******@commandprompt.com
Mammoth PostgreSQL的主页和''实用的PostgreSQL''
托管PostgreSQL，Linux服务和咨询
阅读和搜索O''Reilly的''实用PostgreSQL''
http://www.commandprompt.com
----- ----------------------（播出结束）----------------------- ----
提示2：您可以使用取消注册命令一次性取消所有列表
（发送取消注册YourEmailAddressHere到 ma ******* @ postgresql.org ）
After seeing this article yesterday, I did a bit of research. One _big_ reason
why Sourceforge/VA/OSDN is moving over to IBM/Webshere/DB2 from PostgreSQL is
the resulting product will be jointly marketed by Sourceforge and IBM''s
zillions of sales people. So not only will they get a shiny, new db, but
backend revenue.
"The companies will jointly market and sell the software as part of the
commercial agreement. "-- 4th paragraph, last sentence.
http://www.eweek.com/print_article/0...a=30025,00.asp
"In a separate announcement today, VA Software announced a significant
commercial agreement with IBM focused on the joint marketing and sales of the
next generation of SourceForgea?￠ Enterprise Edition." -- 7th paragram from
their press release at
http://www.vasoftware.com/news/press.php/2002/1070.html
Perhaps the PostgreSQL team bidding for the job, if any were even consulted,
didn''t frame the project as IBM did -- a product joint venture. It''s a good
tactic and I don''t blame Sourceforge one bit for the opportunity.
The decision wasn''t entirely technical so I don''t see this as a loss for
PostgreSQL. DB2 isn''t a slouch db by any means but not many companies will be
able to bargain with IBM as Sourceforge did. If you''re a retailer in Topeka
with 3 locations, I doubt IBM would give you the same attention or joint
marketing deal they gave Sourceforge. DB2 ain''t cheap.
--
Best,
Al Hulaton | Sr. Account Engineer | Command Prompt, Inc.
503.222.2783 | ah******@commandprompt.com
Home of Mammoth PostgreSQL and ''Practical PostgreSQL''
Managed PostgreSQL, Linux services and consulting
Read and Search O''Reilly''s ''Practical PostgreSQL'' at
http://www.commandprompt.com
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)
这篇关于Linux准备好用于大容量数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
