RAID 5 at the Transaction Level?
i was having an interesting discussion with a consultant at a client site today about ASE Cluster Edition. This customer basically wanted to have complete transaction recovery for the clients, even in a server failure situation. With the use of ASE-CE, he was hoping he could get them to this ‘striping’ level of transactions. Is this possible with ASE-Cluster Edition?
Not at this time, but with the release of In-Memory Database options for Sybase ASE 15 this month, there is now a clear path to getting here. The possibility of creating a true in memory grid with relaxed ACID database rules starts coming to mind… especially if you are using Solid State Memory and storing unwritten log records to the SSD while allowing the clients to continue churn through the transactions. To reach a truly high level of transactions per second, this type of solution is becoming a requirement in the near future.
At the same time I say this, the thought of ‘Who would actually need this?’ pops to mind. Who would? Trading systems in financial and commodity markets need this today. What about traffic, weather, or utility systems? Let me know of your use case if you have time to comment.
Have a Happy Holidays!


Rob Verschoor is a Technical Director and Data Management Evangelist at Sybase, located in EMEA. Rob's focus is on Adaptive Server Enterprise, ASE Cluster Edition, Replication Server, and Sybase IQ; he has a true passion for query performance and stressing ASE to its limits.