memcachedb-开源的内存数据库
memcachedb是一个开源的产品,类似于oracle的timesten。这下oracle在tt上面又多了个竞争产品了,虽然目前memcachedb的性能和功能上都无法与tt相比,但是不得不说,它的潜力很大!详见http://code.google.com/p/memcachedb/[@more@]
timesten常见的一些简单问题
环境为:instance_name为eservice安装目录为/home/timesten/TimesTen下面这些问题是针对新手而言的,通过这些问题可以帮助刚接触timesten的人可以快速配置timesten。[@more@]如何启动/home/timesten/TimesTen/eservice/startup/tt_eservice [start|stop|restart]如何访问[timesten@rh44server ~]$ ttisqlCopyright (c) 1996-2007, Oracle. All rights reserved.Type ? or "help" for help, type "exit" to quit ttIsql.All commands must end with a semicolon character.Command> connect tt_eservice;Connectio
timesten常用命令和内置存储过程
timesten自带大量的命令和内置存储过程,通过它们可以做很多事情。下面是经常会用到的一些命令和存存储过程的解释和用法。[@more@]1.ttAdmin(命令)功能: 指定内存加载策略 指定replication agent策略 启动或停止cache agent如:[timesten@rh44server ~]$ ttadmin -query tt_eservice;RAM Residence Policy : inUseReplication Agent Policy : manualReplication Manually Started : FalseCache Agent Policy : manualCache Agent Manually Started : False[timesten@rh44server ~]$ ttad
Timesten在linux上面的安装步骤
timesten的安装还是非常简单的, 下面是它的一个简单的安装步骤[@more@]一。设置内核参数:kernel.shmmax=2147483648kernel.shmall=4194304kernel.sem = 250 32000 200 200net.ipv4.tcp_rmem="4096 4194304 4194304"net.ipv4.tcp_wmem="98304 4194304 4194304"net.ipv4.tcp_mem="98304 4194304 4194304"net.core.rmem_default=262144net.core.wmem_default=262144net.core.rmem_max=4194304net.core.wmem_max=4194304net.ipv4.tcp_window_scaling=1net.ipv4.ip_local_port_range="1024 65000"二。
Timesten内存数据库的架构
由于项目需要采用timesten,于是来了个突击。幸好timesten比较简单,研究起来也较快。后面将陆续有几篇关于timesten的文章。[@more@](缺图)Checkpoint and log filesCheckpoint files contain an image of the database on disk. TimesTen uses dualcheckpoint files for additional safety, in case the system fails while a checkpointoperation is in progress. Changes to databases are captured in transaction logsthat are written to disk periodically. If a database needs to be recovered,TimesTen merges the database che