An example of database replication is transactional replication, where changes made to a primary database are immediately replicated to a secondary database in real-time, ensuring consistency and availability.