on 12-29-2013 7:58 AM
Hi to all,
I have read that SAP HANA is ACID compatible. And will not lose data if power goes off.
This is because changed pages and log are written in save point and written to persistent storage.
1. But where this stored in RAM or some kind of DISK ?.
As per understanding that once power off all RAM data will go off.
2. Then how save point/ log gets back the data into RAM ?.
Please can any one explain above 2 point ,if i am wrongly understood.
I shall be thankful to you for this.
Regards
Pavneet Rana
First, HANA stores all information in-memory.
Then, period save points are generated which contain a snapshot of the database, usually on SAS local storage or SAN network storage.
In between snapshots, a log is kept on fast disk. Usually on SSD local storage, or on SAN network storage.
In the event of a shutdown, the database creates a consistent state. On startup, database tables are typically loaded on demand, depending on configuration.
In the event of a power failure, the log is replayed, and this ensures the Integrity property of ACID in HANA.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for reply.
So it mean that save point , which is snap shot of in-memory table is stored in some type of Hard disk.
And also the change log also same in hard disk.
So it mean that we are till storing the data in some type of hard disk, which will be used as back, in case of power failure. and thus will in-memory will get data back from hard-disk.
am i right ?.
please elaborate you point if i still understood wrong.
Regards
Pavneet Rana
Correct. Typically the log file is stored on a faster disk but both save point and log are persisted on disk.
In the future we expect this to change, as static RAM becomes available it will no longer be necessary to persist on disk, but this innovation is still years away.
There is more information available in the HANA Admin guide: http://help.sap.com/hana/SAP_HANA_Administration_Guide_en.pdf
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.