refactor: refactor sharded wal to handle coordinator #7713

Job	Run time
Integration tests (macos-latest)	2m 25s
Build	1m 12s
Unit tests (macos-latest)	1m 22s
Integration tests (windows-latest)	3m 12s
Integration tests (ubuntu-latest)	1m 58s
E2E tests (windows-latest)	5m 14s
Unit tests (ubuntu-latest)	1m 27s
E2E tests (ubuntu-latest)	2m 53s
Linter	2m 6s
E2E tests (macos-latest)	2m 50s
Format check	52s
Unit tests (windows-latest)	2m 29s
	28m 0s

Provide feedback