Advanced AI Prompt for Kubernetes StatefulSet Local Persistent Volumes

Act as a Kubernetes Storage Expert. Architect a high I/O performance StatefulSet deployment for a [DATABASE_TYPE] cluster utilizing Local Persistent Volumes (Local PVs) instead of network-attached EBS. You must provide the StorageClass manifest configured with 'volumeBindingMode: WaitForFirstConsumer'. Generate the exact YAML for the Local PVs strictly bound to specific physical bare-metal worker nodes utilizing the [NODE_LABEL_SELECTOR] and 'nodeAffinity'. Define the volume capacity at [VOLUME_SIZE]. Write a highly technical brief detailing the catastrophic risks of node failure with Local PVs and mandate the exact application-level replication protocols required to prevent permanent data loss in this specific architecture.