SQL Anywhere I/O Requirements for Linux and Windows
Database servers must guarantee that data gets to stable storage to ensure that committed transactions persist and to properly implement recovery in case of power loss. Operating systems and storage devices cache and reorder write operations to improve performance. Running a database server on an improperly configured system can lead to data loss and file corruption. This whitepaper provides the background necessary to understand the durable storage requirements and I/O semantics of SQL Anywhere.