Once we have multiple nodes in RDBMS (leader-follower based), it would be similar to MongoDB. It can provide consistency, as read and write are done from leader and followers are on stand-by. So, this would be a CP system.

But, if reads are enabled from followers, you might lose consistency, and end up making your system read-available.

Imagine a case when followers are not able to update from the leader. Followers will still serve traffic and will start giving stale data.