Hi -
The Debezium's team overall messaging is to always prefer a single
connector because reading from transaction logs is a serial process
and there's not always much to gain by splitting that action across
multiple connectors since all transaction log events must be read by
each connector, so multiple connectors do increase IO.
But there are most certainly business goals, reliability concerns,
and potential variances in configuration where using a connector per
tenant distribution strategy makes more sense. In practice, this
isn't all that uncommon and it provides you with potentially more
long-term flexibility as you scale and helps to avoid situations
where one tenant issue taints the availability or stream of changes
for other tenants.
So it's really more of a question of what matters the most to you,
long-term goals, and business need.
-cc