• Yes exactly:

    AG1

    --Node 01-Primary

    --Node 02-Secondary, Syncronous commit.

    --Node 03-Secondary, Syncronous commit.

    --Node 04-Secondary, Asyncronous commit.

    --Node 05-Secondary, Asyncronous commit.

    --Node 06-Secondary, Asyncronous commit.

    AG2

    --Node 01-Secondary, Syncronous commit.

    --Node 02-Primary.

    --Node 03-Secondary, Syncronous commit.

    --Node 04-Secondary, Asyncronous commit.

    --Node 05-Secondary, Asyncronous commit.

    --Node 06-Secondary, Asyncronous commit.

    AG3

    --Node 01-Secondary, Asyncronous commit.

    --Node 02-Secondary, Asyncronous commit.

    --Node 03-Secondary, Asyncronous commit.

    --Node 04-Primary.

    --Node 05-Secondary, Syncronous commit.

    --Node 06-Secondary, Syncronous commit.

    And so on.

    Developing the read intent routing scripts will be a very interesting project I think; I'm not too worried about that one. It will be allocated a pretty good chunk of time in the project plan.