Journal of Internet Computing and Services (인터넷정보학회논문지)

Korean Society for Internet Information (한국인터넷정보학회)
권호 표지
DOI QR코드

DOI QR Code

A method of Securing Mass Storage for SQL Server by Sharing Network Disks - on the Amazon EC2 Windows Environments -

네트워크 디스크를 공유하여 SQL 서버의 대용량 스토리지 확보 방법 - Amazon EC2 Windows 환경에서 -

  • Kang, Sungwook (School of Computer Science and Engineering, Soongsil University) ;
  • Choi, Jungsun (School of Computer Science and Engineering, Soongsil University) ;
  • Choi, Jaeyoung (School of Computer Science and Engineering, Soongsil University)
  • Received : 2015.08.12
  • Accepted : 2016.02.12
  • Published : 2016.04.30
Download PDF
⟨ Previous Next ⟩

Abstract

Users are provided infrastructure such as CPU, memory, network, and storage as IaaS (Infrastructure as a Service) service on cloud computing environments. However storage instances cannot support the maximum storage capacity that SQL servers can use, because the capacity of instances provided by service providers is usually limited. In this paper, we propose a method of securing mass storage capacity for SQL servers by sharing network disks with limited storage capacity. We confirmed through experiments that it is possible to secure mass storage capacity, which exceeds the maximum storage capacity provided by an instance with Amazon EBS on Amazon EC2 Windows environments, and it is possible to improve the overall performance of the SQL servers by increasing the disk capacity and performance.

클라우드 컴퓨팅 환경에서 사용자는 중앙처리장치, 메모리, 네트워크, 저장 장치 등과 같은 인프라를 IaaS(Infrastructure as a Service) 서비스로 제공받을 수 있다. 저장 장치의 경우 서비스 제공자가 제공하는 물리적인 자원들의 인스턴스가 제공하는 저장 용량이 제한되어 있으므로, SQL 서버가 사용할 수 있는 최대 저장 용량을 지원할 수 없다. 본 논문에서는 한정된 용량을 가진 인스턴스들의 네트워크 디스크를 공유하여 SQL 서버에서 사용할 수 있는 대용량의 저장소를 확보하기 위한 방법을 제안한다. 실험을 통해 아마존 EC2 윈도우즈 환경에서 아마존 EBS 볼륨을 사용하는 하나의 인스턴스가 사용할 수 있는 최대 저장 용량을 초과하는 대용량 저장 공간을 확보할 수 있으며, SQL Server를 운영하는 아마존 클라우드 환경에서 디스크 용량 및 성능을 증가시켜 전체적인 SQL Server의 성능을 향상시킬 수 있음을 확인하였다.

Keywords

References

  1. "Amazon Elastic Compute Cloud(Amazon EC2)," https://aws.amazon.com/ec2/
  2. "Amazon Elastic Compute Cloud Storage," http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/Storage.html
  3. O.G. Min, H.Y. Kim, and G.H. Nam, "Trends in Technology of Cloud Computing (in Korean)," Electronics and Telecommunications Trends, Vol. 24, No. 4, Aug. 2009.
  4. "Amazon Instance Vloume Limits," http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/volume_limits.html
  5. "Amazon EBS Volume Types," http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/EBSVolumeTypes.html
  6. "SQL Server Database Files and Filegroups," https://msdn.microsoft.com/en-us/library/ms189563.aspx
  7. "Maximum Capacity Specifications for SQL Server," https://technet.microsoft.com/en-us/library/ms143432(v= sql.110).aspx
  8. HDFS, "http://hadoop.apache.org/core/docs."
  9. "Amazon EC2 Instance," http://aws.amazon.com/ec2/instance-types/?nc2=h_ls
  10. "Amazon EC2 Instance Configuration," http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-ec2-config.html
  11. "SQL Server Memory Server Configuration Options," https://msdn.microsoft.com/en-us/library/ms178067(v=sql.120).aspx
  12. "Description of support for network database files in SQL Server," https://support.microsoft.com/en-us/kb/304261.