Archive for the ‘DATABASE’ Category.
建 mysql partition table 遇到的問題
1. Out of resources when opening file
在 my.cnf 加 open-files-limit = 6000
2. Too many partitions were defined
Ref. URL : http://www.monster.com.tw/archives/2504
很好的一篇文章 Apache Cassandra
URL = http://www.rackspace.com/cloud/blog/2010/05/12/cassandra-by-example/
先用 SQL 式的來說明 twitter 的結構 / 流程 , 再用 no-SQL 的 Cassandra 再解釋一次 , 說明得很清楚 , 可以當做入門 Cassandra 的好範例.
oracle export / import command
exp userid=user/password file=/path/database_$(date +%Y%m%d).dmp log=/path/database_$(date +%Y%m%d).log ROWS=Y
imp user/password file=database_20100914.dmp fromuser=user1 touser=user2 grants=n ignore=y feedback=1000000
Maximum Availability Architecture – Oracle Streams Configuration Best Practices
Oracle doc PDF URL : http://dn.monster.tw/my/docs/oracle/MAA_10gR2_Streams_Configuration.pdf
Oracle® Streams Advanced Queuing User’s Guide and Reference
10g Release 2 (10.2) – http://download.oracle.com/docs/cd/B19306_01/server.102/b14257/toc.htm
sample memo: http://www.monster.com.tw/archives/2565
Oracle Maximum Availability Architecture – Overview – http://www.oracle.com/technology/deploy/availability/htdocs/maaoverview.html
