Data-driven organizations—which is to say most organizations—often face challenges in supporting multiple databases. Keeping on top of older versions of databases can further complicate IT management. Red Hat Enterprise Linux (RHEL) offers a solution. As the world’s leading enterprise Linux platform, RHEL enables data managers to support a broad range of databases, including Microsoft SQL Server. In this article, PeerSpot members who use RHEL discuss how it has helped them with database management.
The challenge of running a variety of databases
PeerSpot members, like most IT professionals, find themselves juggling more than one relational database management system (RDBMS). This means having to stay on top of multiple system configurations, updating processes and patch management. Without the right tools, it can be very demanding work.
For instance, Fayaz A., a Linux administrator at a tech services company, has to support RAID servers as well as database clusters. TJ, a Cloud and Infrastructure Architect at a communications service provider, runs a mix of applications and databases to support software for embedded design.
A hospitality company is planning a migration of their SAP HANA in-memory database, which they use for websites, ERP and open sources environments, according to their Principal Analyst for AIX and Linux. For Jonathan S., a System Analyst II at an energy/utilities company, his database workloads span MySQL and Oracle.
RHEL database support
Red Hat Enterprise Linux supports a robust database ecosystem, creating a relational database management system that provides a scalable foundation and a more consistent application experience. Bruce Y., for example, a Senior Systems Engineer at a university, has PostgreSQL running in support of PeopleSoft and websites that are deployed on RHEL.
Fredrik L., a Systems Analyst at a government office, has many different databases running on RHEL, including MySQL and Postgres. He shared, “They all run great on RHEL 7 and RHEL 8. Using this solution, we can offer our customers an easier way to get a WordPress site, and they can have Postgres and Tomcat installations, and these run smoother on Linux than they do on Windows. That means we don't have to worry that much about the patching. If we want to deploy the same config file to 100 systems, we just run the playbook with Ansible and it's done. We don't have to run it on 100 servers.”
“We are able to scale applications and databases. It is easy,” said Dinesh J., a Senior Information Technology System Analyst at a government office. He has Oracle databases with databases as large as 30 to 40 terabytes running on RHEL. He added, “Before deploying an application, we check the scalability of each product, and we plan accordingly. So, there are no issues.”
Don B., a Systems Administrator at a university, agreed that Red Hat should be used to host an Oracle database, saying, “My experience with my developers and my DBA [database administrator] is that they love Linux. It's easy for them to use. It's easy for them to deploy things like Oracle databases and web servers. We found that hosting an Oracle database works really well and is very competitive with Microsoft's SQL Server.”
An educational organization uses RHEL to run multiple versions of the same application and database. As Joerg K., their Systems Administrator explained, “We run several versions of the MediaWiki platform on the same system. We usually have one version of a database management system per host. If we need another version, we deploy it on another host.”
Similarly, Usman M., a Joint Director at a government office, has several deployments of databases. He said, “A few of them are running on older versions of Red Hat and some of them are running on newer versions. We are running different versions on different platforms.”
Finally, Bruce Y. added that, “We try very hard to ensure that everything is working irrespective of what it's running on, in terms of the operating system and middleware, including what database is running. RHEL helps maintain consistency of application and user experience, regardless of the underlying infrastructure, simply by not being part of the problem.”
It can be challenging to support multiple databases in a heterogeneous application environment. As PeerSpot members explained in their reviews of RHEL, the operating system helps with this workload. It allows organizations to run a wide variety of applications and databases without overtaxing DBAs or IT managers.
저자 소개
채널별 검색
오토메이션
기술, 팀, 인프라를 위한 IT 자동화 최신 동향
인공지능
고객이 어디서나 AI 워크로드를 실행할 수 있도록 지원하는 플랫폼 업데이트
오픈 하이브리드 클라우드
하이브리드 클라우드로 더욱 유연한 미래를 구축하는 방법을 알아보세요
보안
환경과 기술 전반에 걸쳐 리스크를 감소하는 방법에 대한 최신 정보
엣지 컴퓨팅
엣지에서의 운영을 단순화하는 플랫폼 업데이트
인프라
세계적으로 인정받은 기업용 Linux 플랫폼에 대한 최신 정보
애플리케이션
복잡한 애플리케이션에 대한 솔루션 더 보기
오리지널 쇼
엔터프라이즈 기술 분야의 제작자와 리더가 전하는 흥미로운 스토리
제품
- Red Hat Enterprise Linux
- Red Hat OpenShift Enterprise
- Red Hat Ansible Automation Platform
- 클라우드 서비스
- 모든 제품 보기
툴
체험, 구매 & 영업
커뮤니케이션
Red Hat 소개
Red Hat은 Linux, 클라우드, 컨테이너, 쿠버네티스 등을 포함한 글로벌 엔터프라이즈 오픈소스 솔루션 공급업체입니다. Red Hat은 코어 데이터센터에서 네트워크 엣지에 이르기까지 다양한 플랫폼과 환경에서 기업의 업무 편의성을 높여 주는 강화된 기능의 솔루션을 제공합니다.