Direct NFS Client Bypassing OS Kernel for Database Performance
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional Network File System (NFS) protocols within Operating System (OS) kernels are inefficient for database systems, leading to performance issues, data consistency problems, and cache coherency challenges, especially in I/O-intensive environments and when using Network Attached Storage (NAS) for database storage.
Innovation Solution
Implementing a direct NFS client within the database server process to bypass the OS kernel, allowing database processes to directly access NFS servers, share file handles across processes, and manage caching, while utilizing multiple Network Interface Cards (NICs) for scalability and high availability.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If a conventional OS kernel NFS client is used, then ease of operation is improved, but database performance and data consistency deteriorate
Solution Approach 1:
The patent extracts the NFS client functionality from the OS kernel and relocates it to the database server process level. This allows the database to directly manage NFS operations without relying on the OS kernel's NFS client, thereby improving performance and data consistency while maintaining operational simplicity through automated handle sharing mechanisms.
2Productivity
If a direct NFS client in database server process is implemented, then database performance is improved, but device complexity increases
Solution Approach 1:
The patent implements self-service by having the database server process automatically manage NFS file handles and share them across multiple database processes without external intervention. The system autonomously handles handle allocation, distribution, and cleanup, reducing the need for complex external configuration while maintaining high performance.
3Ease of operation
If OS kernel NFS client is used, then ease of operation is improved, but data consistency and cache coherency deteriorate
Solution Approach 1:
The patent extracts NFS client functionality from the OS kernel to the database server process, enabling direct control over NFS operations. This extraction allows the database to maintain its own cache coherency protocols and data consistency mechanisms independent of the OS kernel's caching behavior, thereby improving reliability while preserving ease of operation through automated handle sharing.
4Adaptability or versatility
If multiple NIC devices are coupled to NFS server, then scalability and availability are improved, but device complexity increases
Solution Approach 1:
The patent segments network connectivity by coupling multiple NIC devices to the NFS server, allowing the database server process to distribute NFS operations across different network paths. This segmentation improves scalability and availability by enabling failover and load balancing, while the complexity is managed through automated process assignment to network paths.
Data Source
AI summary
A computer-implemented method of implementing a network file system may include steps of providing a host, the host including an Operating System (OS) that includes a kernel and a first client implementing the Network File System (NFS) protocol in the kernel, and a database server process. A second NFS client may be provided in the database server process. A NFS server may be provided, coupled to the host. A device implementing the Network Attached Storage (NAS) protocol may also be provided, coupled to the NFS server. NFS requests to access data stored in the NAS server may then be generated and sent from the second NFS client in the database server process directly to the NFS server, bypassing the first NFS client in the OS kernel of the host. NFS File handles obtained by one database process may be shared with other database processes through a shared memory area.