23:30 整合Apache和Tomcat (3387 Bytes) » AnySQL.net

作者:AnySQL, 订阅AnySQL, Oracle数据库恢复及服务, Sybase恢复, 磁盘及RAID恢复

先下载mod_jk模块, 放到apache的modules目录下. 然后创建一个mod_jk.conf文件.

LoadModule jk_module modules/mod_jk.so
JkWorkersFile $TOMCAT_HOME/conf/workers.properties
JkLogFile $TOMCAT_HOME/logs/mod_jk.log
JkLogLevel info
JkLogStampFormat "[%a %b %d %H:%M:%S %Y] "

JkMount /webchart/* worker1

创建上面提到的workers.properties文件, 内容如下所示.

workers.tomcat_home=$TOMCAT_HOME
workers.java_home=$JAVA_HOME
ps=/
# Define 1 real worker using ajp13
worker.list=worker1
# Set properties for worker1 (ajp13)
worker.worker1.type=ajp13
worker.worker1.host=localhost
worker.worker1.port=8009
worker.worker1.lbfactor=50
worker.worker1.socket_keepalive=1
worker.worker1.socket_timeout=300

再启动Tomcat.

export JAVA_OPTS=-Djava.awt.headless=true
./startup.sh

在Apache的配置文件中, 加入mod_jk.conf文件.

include "/path/mod_jk.conf"

再重启一下Apache就好了.

相关文章 | Related Artiles

Vista不能安装Oracle 11g (2)

使用Oracle Chart Builder在页面上画图 (1)

FastCGI下TagSupplementals插件的一点问题 (0)

再见了, Java语言! (5)

优秀的DataDirect JDBC驱动 (0)

我要留言(当前0)

21:35 用HSCALE实现MySQL的数据分布式存储 (4228 Bytes) » NinGoo@Net

Author:NinGoo posted on NinGoo.net

针对单个表过大造成的性能问题，MySQL在5.1开始引入了分区表(partition)，可以将数据在内部拆分存储，对应用透明，但是分区表只能将表在同一个数据库内部分解，而且对于表的维护(比如执行alter table)还是比较麻烦。手工分表也是一个解决方法，手工分表还有一个好处是可以将表分布到不同的服务器中，实现分布式存储。但是手工分表要求应用程序做相应的改写，以支持从不同的表中来存取数据。

HSCALE简单来说就是一个支持手工分表的中间层，对于应用来说看起来还是一个表，而由HSCALE来负责底层子表的数据存取。HSCALE是基于MySQL Proxy的一个插件应用，通过MySQL Proxy的lua脚本拦截分拆对应的SQL语句来实现数据的分布存储，而且使用lua脚本可以自由定制分表策略，比起MySQL自己的partition更加灵活些。现在版本还是0.2，功能有限，只能实现同库分表，但是基于MySQL Proxy的架构，未来要实现示分库分表也不是什么难事。

作者利用mysqlslap对HSCALE和MySQL Proxy做了几组性能测试，结果参考这里，还有这里。

当然，现在MySQL Proxy和HSCALE都是刚刚起步，要在产品库中应用还有很长的一段路要走，从上面的性能测试中可以看到基于最新的MySQL Proxy 0.7版的HSCALE性能有了较大的提升，期待后续版本有更好的表现。

Related Articles

PermLink: http://www.ningoo.net/html/2008/using_hscale_for_mysql_partition_.html

Add Comments(0) | Follow NinGoo@Twitter | Google Reader

19:31 物化视图日志对UPDATE的影响 (663 Bytes) » yangtingkun

物化视图日志的功能是记录基表的DML修改，使得物化视图可以通过物化视图日志上的记录进行快速刷新。那么物化视图日志记录基本修改的同时，是否会对基表的DML产生一定的影响。由于物化视图日志会将UPDATE主键的操作变成DELETE和INSERT，那么实际上基表执行的是什么操作呢，下面做一个简单的测试验证一下，首先是不包含物化视图日志的情况：SQL> CREATE TABLE T (ID NUMBER PRIMARY KEY, NAME VARCHAR2(30));表已创建。SQL> INSERT INTO T VALUES (1, 'A');已创建 1 行。SQL> INSERT INTO T VALUES (2, 'A');已创建 1 行。SQL> UPDATE T SET...

19:30 Oracle IOPS and HBA Queue Depth : Ardent Performance Computing (0 Bytes) » del.icio.us/fenng/oracle

13:32 Summit link round-up: Day 1 (4004 Bytes) » Red Hat Magazine

We’ve scoured the web for all the latest dish on the Red Hat Summit. Here’s a few tidbits from the first day (and before):

In the news:

Red Hat chief calls for open source missionary work. (Austin Modine for Channel Register)
Red Hat meanders into hypervisor market. (Austin Modine for Channel Register)
Red Hat in Boston, parts 0, 1.0, and 1.1. (Serdar Yegulalp, for InformationWeek)
Red Hat Network to be open sourced. (from PC World)
Red Hat unveils new virtualization initiatives. (from Network World)
Red Hat Summit 2008 opens in Boston (from heise online)
Red Hat offers JBoss on the Amazon Elastic Compute Cloud. (Pam Derringer, for SearchEnterpriseLinux.com)

From our own press corps:

Other voices:

Jeremy Katz (Red Hat engineer): Day 0 wrap-up and a note about campground sessions
Max Spevack (former Fedora Project Leader): Starts a helpful discussion on how to best get from boston airport to fudcon/sheraton for $5
Paul Frields (current Fedora Project Leader): More on FUDcon Thursday
Barton George (from Sun): In Boston for Red Hat

10:31 Issues about oracle bin file s bit not set (2089 Bytes) » Chanel [K]

很早之前记录过一个问题 - oracle可执行文件s位导致的Cluster资源组无法正常启动的问题解决。

今天在另外一个客户处又出现了同样的问题，解决方法一样，但是问题现象却不一样，着实折腾了很久。问题现象是，启动数据库没有任何报错，启动监听也没有任何问题，lsnrctl services命令显示一切正常，但是在远程客户端通过监听登陆数据库，第一次会报Oracle not available的错误，之后再次尝试会报TNS-12516错误, “TNS:listener could not find instance with matching protocol stack”，此时再次检查lsnrctl services，会发现监听的状态变为blocked。

同样是使用tar包安装的Oracle9i软件，同样是在Solaris 9中，似乎这是Solaris系统中tar命令的一个毛病。

最后执行chmod解决问题。

chmod u+s,g+s $ORACLE_HOME/bin/oracle

07:15 Two new open source projects at Velocity - 创建新帖 (3839 Bytes) » Fenng's shared items in Google Reader

Shared by hutuworm
搜了一圈，似乎没地方下载 Jiffy.

Two new open source projects at Velocity

Jesse Robbins 2008/06/17

At Velocity next week there will be two significant open source projects debuting. The first is the Jiffy: Open Source Performance Measurement and Instrumentation tool created by Scott Ruthfield and his team at Whitepages.com.

Most tools for measuring web performance come in two flavors:

Developer-installed tools ( Firebug, Fiddler, etc.) that allow individuals to closely trace single sessions

Third-party performance monitoring systems (Gomez, Keynote, etc.) that will hit your site occasionally and report back component-level metrics (for a fee)

Neither of these tools give you real-world information on what’s actually happening with your clients—how long are pages really taking to load, what’s the real cost of client-side execution, and what’s the impact of your loading or dependency chain. This is even more important when you don’t host all of your own assets, such as when you load ads or JavaScript from third parties, for example, and you need to monitor their performance.

Thus we built Jiffy—an end-to-end system for instrumenting your web pages, capturing client-side timings for any event that you determine, and storing and reporting on those timings. You run Jiffy yourself, so you aren’t dependent on the performance characteristics, inflexibility, or costs of third-party hosted services.

The second is project is EUCALYPTUS, the Elastic Utility Computing Architecture for Linking Your Programs To Useful Systems, presented by Rich Wolski from UCSB. This project has already started getting attention. (Many thanks to Surj Patel of Structure08/GigaOM for connecting us!)

Eucalyptus is an open-source software infrastructure for implementing "cloud computing" on clusters. The current interface to EUCALYPTUS is compatible with Amazon's EC2 interface, but the infrastructure is designed to support multiple client-side interfaces. EUCALYPTUS is implemented using commonly-available Linux tools and basic Web-service technologies making it easy to install and maintain.

The talk will focus on the design, the implementation tradeoffs we have identified in implementing Eucalyptus as an exploratory tool, and the ways in which we have chosen to address these tradeoffs in the first version of the software.

06:56 Robert Scoble Visits Salesforce.com (897 Bytes) » Fenng's shared items in Google Reader

Armed with his Nokia N95 and Qik, uber-web 2.0 technology blogger and video-blogger Robert Scoble visited Salesforce.com headquarters yesterday and interviewed Marc Benioff and others.

I'm guessing his interview with Benioff (which sounds like it was done with a "real" video camera) will be up shortly on his FastCompany.TV site.

In the meantime, however, you can watch his cell phone video interview with Kraig Swensrud, VP of Applications, where they talk about Salesforce and Google:

Or, this one with Ariel Kelman from the Product Platform Marketing group where they discuss the Force.com platform:

06:55 下载日──取得巨大成功 (655 Bytes) » Fenng's shared items in Google Reader

Update：最后全球下载日当天下载量超过830万，中国大陆加台湾香港超过20万。社区的力量真伟大，呵呵

忙忙碌碌的一天阿！昨天忙了一凌晨，结果没做出啥东西来，sigh～～

第二张照片拍摄：SUN

06:51 久违的命题 - 为何而读书? (1738 Bytes) » Oracle Life

©作者：eygle 发布在 eygle.com

好不容易冲上网来，发一张照片。

久违的一句话：为中华崛起而读书！
这几天看到这句话，颇觉得亲切，仿佛埋藏心中已久的记忆被重新唤起。

然而今天，我们为什么而读书呢？

相关文章|Related Articles

评论数量(3)|Add Comments

本文网址：http://www.eygle.com/archives/2008/06/read_for_what.html

06:33 America holidays (402 Bytes) » 玉面飞龙的BLOG

Learn english,learn culture. I’m also looking forward to America holidasy beside China holidays.Both holidays I would be relaxing. Our database will be quite quiet during America holidays. No change happens inside database. More flexiable work time I could have. America holidays New Year’s Day : Jan 1st. martin Luther King’s Day : thrid Monday of Jan Valentine’s Day : [...]

03:57 Welcome to the Summit (1556 Bytes) » Red Hat Magazine

Whether or not you’re here in Boston with us at the Summit, you can follow along with Red Hat Magazine.

Twitter updates

Flickr pool

Mugshot group

We’ll be posting updates here about what’s going on, and links to other Summit bloggers. If you’re blogging from the Summit, send us an email at rhm-summit@redhat.com with a link to your posts.

03:22 SQL Server 2008 VS. Oracle Database 11g (1428 Bytes) » Chanel [K]

英文版地址：SQL Server 2008 Compared to Oracle Database 11g

中文版地址：SQL Server 2008与Oracle Database 11g相比较

计划找个时间批驳一下。:D

02:09 How to resolve “Access is denied” when install Windows XP Service Pack 3 (4167 Bytes) » Chanel [K]

多次尝试，总算把自己的Windows XP SP2升级到了SP3，在升级过程中碰到了“Access is denied”报错，每次尝试都是升级到一半报错，之后Windows又会回滚所有的改动，然后再重启机器，简直是噩梦一般的体验。

如果在升级Windows XP Service Pack 3的过程中你也碰到了同样的报错，首先要确认是不是错在注册表更新这一步上，检查SP3的升级log，在Windows的安装目录下可以找到svcpack.log这个文件，查看最后的报错信息，如果找到诸如“DoRegistryUpdates failed”这样的报错，那么恭喜你，你通过下面的方法可以解决问题了。

1723.172: DoRegistryUpdates:UpdSpInstallFromInfSection Failed for ProductInstall.GlobalRegistryChanges.Install error: 0×5
1723.172: INF_REGISTRY Failed
1723.172: DoInstallation:DoRegistryUpdates failed
1728.625: Unregistration of sprecovr successful
1729.047: Access is denied.
1884.422: Message displayed to the user: Access is denied.

在微软官方站点上的技术文章949377中提到了这个问题，但是提供了三种解决方法。

方法一：下载完全版的Windows XP Service Pack 3安装程序，一个有316 MB的庞然大物，然而该方法无效。
方法二：重启机器，禁用所有的杀毒软件和防间谍软件，再次重新安装SP3，此方法也同样无效。
方法三：重设注册表和文件权限，重新安装SP3，有效！

方法三比较复杂，简单描述一下。

1. 首先要下载Subinacl.exe程序，该程序用来修改注册表权限设置。

2. 打开记事本，将以下代码copy进去，然后将新文件保存为Reset.cmd。

cd /d “%ProgramFiles%\Windows Resource Kits\Tools”
subinacl /subkeyreg HKEY_LOCAL_MACHINE /grant=administrators=f /grant=system=f
subinacl /subkeyreg HKEY_CURRENT_USER /grant=administrators=f /grant=system=f
subinacl /subkeyreg HKEY_CLASSES_ROOT /grant=administrators=f /grant=system=f
subinacl /subdirectories %SystemDrive% /grant=administrators=f /grant=system=f
subinacl /subdirectories %windir%\*.* /grant=administrators=f /grant=system=f
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb /verbose

3. 备份注册表，可以参看技术文章322756.

4. 双击之前保存的Reset.cmd，将会运行大概10-20分钟的时间，如果没有任何报粗，command窗口将在运行结束完之后自动关闭。

5. 重新安装Windows XP Service Pack 3