- Database schema updates
- Administrative tasks
When you run SQL data definition statements from within a grid context on one server in the grid, they are propagated to all other servers in the grid. You can run SQL data manipulation statements and routines through grid routines. You can choose to set up replication automatically when you create a new table through a grid.
You can route client connections to servers in the grid based on the quality of replicated data and transaction latency by configuring service-level agreements for a Connection Manager.
Read about what a grid is and how to use it: Grid setup and management.
Here's a tutorial that runs through creating a grid: Example of setting up a grid.