Figure E-1 illustrates a query server configuration scenario depicting how the LSMS might be directly connected to a query server, or indirectly connected to daisy-chained query servers. Refer to this figure when performing the maintenance procedures described in this section.
This scenario includes the following:
- One master (LSMS)
- One remote system
- Five query servers:
- One directly connected slave (Query Server A)
- One directly connected master/slave (Query Server B)
- Two daisy-chained slaves (Daisy-chained Query Servers C and E)
- One daisy-chained master/slave (Daisy-chained Query Server D)
Client applications on each query server represent a Service Provider application that queries the replicated LSMS LNP databases using supported MySQL database APIs.
Note: Process all updates to the query server database through the master.
Query Server Configuration Scenario