Design and architecture of dell acceleration appliances for database (DAAD): A practical approach with high availability guaranteed. Yu, K., Gao, Y., Zhang, P., & Qiu, M. In Proceedings - 2015 IEEE 17th International Conference on High Performance Computing and Communications, 2015 IEEE 7th International Symposium on Cyberspace Safety and Security and 2015 IEEE 12th International Conference on Embedded Software and Systems, H, 2015.
abstract   bibtex   
© 2015 IEEE.As IT organizations are pursuing database High Availability (HA) solutions to ensure and protest critical commercial data, the challenge is to leverage the three-fold key dimensions: cost, performance and availability. A successful solution needs to integrate Database Management System (DBMS) seamlessly with back-end storage and offer good performance and customer data protection. Through extensively investigating plenty of productions in the market, Oracle database is a leading solution for business critical application. As a cost effective solution, it could reduce business risk and achieve data availability, performance, and Return on Investment (ROI). On the other aspect, high-end storage solution, Storage Area Network (SAN) based on Fibre Channel protocol can be easy to deploy with Oracle database and match end-user's requirements. In this paper, we will present a design of high available database on a new reference architecture. The implementation of design is based on Oracle database with Dell Acceleration Appliances for Databases (DAAD), which introduces flash technology by Fusion-IO. To demonstrate practical performances, we built a proof-ofconcept platform and compared the platform with a traditional 96-SAS-drive platform. The results show that our approach can deliver more than 1-million random Input/output Operations per Second (IOPS) that is 27 times faster than the traditional platform and it can also achieve a 96% reduction in the latencies, thus showing the scalability of the approach with massive database nodes. Therefore, our approach provides not only an ultra-fast storage solution to boost database performances but it also offers a flexible and high available design to achieve zero-downtime database.
@inProceedings{
 title = {Design and architecture of dell acceleration appliances for database (DAAD): A practical approach with high availability guaranteed},
 type = {inProceedings},
 year = {2015},
 identifiers = {[object Object]},
 keywords = {[Cloud computing, Database, Flash technology, High},
 id = {5a20cf67-2289-3904-b1fc-84890789f43f},
 created = {2017-01-23T22:49:55.000Z},
 file_attached = {false},
 profile_id = {a7bfbf93-4046-3937-9e2e-cb1dc086b744},
 last_modified = {2017-01-23T22:49:55.000Z},
 read = {false},
 starred = {false},
 authored = {true},
 confirmed = {false},
 hidden = {false},
 abstract = {© 2015 IEEE.As IT organizations are pursuing database High Availability (HA) solutions to ensure and protest critical commercial data, the challenge is to leverage the three-fold key dimensions: cost, performance and availability. A successful solution needs to integrate Database Management System (DBMS) seamlessly with back-end storage and offer good performance and customer data protection. Through extensively investigating plenty of productions in the market, Oracle database is a leading solution for business critical application. As a cost effective solution, it could reduce business risk and achieve data availability, performance, and Return on Investment (ROI). On the other aspect, high-end storage solution, Storage Area Network (SAN) based on Fibre Channel protocol can be easy to deploy with Oracle database and match end-user's requirements. In this paper, we will present a design of high available database on a new reference architecture. The implementation of design is based on Oracle database with Dell Acceleration Appliances for Databases (DAAD), which introduces flash technology by Fusion-IO. To demonstrate practical performances, we built a proof-ofconcept platform and compared the platform with a traditional 96-SAS-drive platform. The results show that our approach can deliver more than 1-million random Input/output Operations per Second (IOPS) that is 27 times faster than the traditional platform and it can also achieve a 96% reduction in the latencies, thus showing the scalability of the approach with massive database nodes. Therefore, our approach provides not only an ultra-fast storage solution to boost database performances but it also offers a flexible and high available design to achieve zero-downtime database.},
 bibtype = {inProceedings},
 author = {Yu, K. and Gao, Y. and Zhang, P. and Qiu, M.},
 booktitle = {Proceedings - 2015 IEEE 17th International Conference on High Performance Computing and Communications, 2015 IEEE 7th International Symposium on Cyberspace Safety and Security and 2015 IEEE 12th International Conference on Embedded Software and Systems, H}
}

Downloads: 0