Database triggers.

[muudi10]

We are in the process of migrating our multi-tenant application, where each tenant has access to both private services and shared services exposed via a central marketplace.

As part of this architecture, we require a database-level trigger to be implemented. The trigger should automatically activate whenever a tenant creates or updates a service marked as publicly available (i.e., intended for the marketplace).

Use Case:
• When a tenant publishes a service (marks it as public), this service should be pushed into a shared database or a shared table that serves as the central marketplace.
• The trigger should ensure real-time synchronization, making the service immediately available to all tenants via the marketplace interface.
• This approach should help maintain consistency and reduce the need for redundant service lookups or manual propagation.

Please ensure the trigger is efficient, secure, and does not introduce performance bottlenecks. If possible, include rollback safety in case the sync operation fails.