refactor: refactor sharded wal to handle coordinator #7690

Job	Run time
Linter	3m 18s
Integration tests (macos-latest)	3m 19s
Integration tests (windows-latest)	3m 16s
E2E tests (macos-latest)	12m 44s
Unit tests (windows-latest)	2m 27s
E2E tests (ubuntu-latest)	9m 14s
Unit tests (macos-latest)	1m 26s
Unit tests (ubuntu-latest)	1m 42s
E2E tests (windows-latest)	16m 39s
Build	1m 38s
Integration tests (ubuntu-latest)	1m 40s
Format check	1m 14s
	58m 37s

Provide feedback