I have a mixture of Linux, M$, Android, iOS clients and two Pi-hole DNS servers:
pi@ph5a:~ $ nc localhost 4711 <<< $'>stats >quit'
[..]
dns_queries_today 13641
pi@ph5b:~ $ nc localhost 4711 <<< $'>stats >quit'
[..]
dns_queries_today 3306
Thats roughly 80% resolved through the "primary" and 20% by the "secondary".
I did not configure anything related to DNS forwarding order on the clients.
This is a reoccurring topic:
@Peterkal2112, have you searched Discourse here for what your looking?
Much has been discussed already and some bits are harder to implement as others.
Like syncing the long term dbase pihole-FTL.db
live or scheduled which to my knowledge (???) is still not possible because of dbase tables getting locked all the time by the pihole-FTL
daemon preventing any sync attempts to write.
pi@ph5a:~ $ ls -1 /etc/pihole/*.db
/etc/pihole/gravity.db
/etc/pihole/macvendor.db
/etc/pihole/pihole-FTL.db