Scatter Gather in Mule 4 | Routing in Mule 4

Scatter Gather in Mule 4

Scatter Gather routes the payload to multiple destinations parallelly. It then collects the responses from all routes and aggregates them back into a single response.

Once a message is received by Scatter-Gather, it sends a message for concurrent processing to all configured routes. The main thread executing the flow that owns the router waits until all routes complete or time out.

If there are no failures, Mule aggregates the results from each of the routes into a message collection (MessageCollection class). Failure in one route does not stop Scatter-Gather from sending messages to its other configured routes, so it is possible that many or all routes may fail concurrently.


Scatter Gather settings:

Scatter Gather is used to insert data parallelly in both tables.

If any route fails, then CompositeRouterException occurs.
The failed route is identified by sequential ID.

Method: POST

Input & output:

XML project code:

<?xml version="1.0" encoding="UTF-8"?>

<mule xmlns:db="" xmlns:http=""
       xmlns:doc="" xmlns:xsi="" xsi:schemaLocation="">
       <http:listener-config name="HTTP_Listener_config" doc:name="HTTP Listener config" doc:id="fd80a52e-5bd2-402a-8479-752022beb6d6" >
              <http:listener-connection host="" port="8085" />
       <db:config name="Database_Config" doc:name="Database Config" doc:id="0f447783-a70d-4a3e-91e9-7e0057d07ff7" >
              <db:my-sql-connection host="localhost" port="3306" user="root" password="" database="mule4" />
       <flow name="test_scatter_gatherFlow" doc:id="129054c3-55bc-42fa-85e9-0d47eddd7917" >
              <http:listener doc:name="Listener" doc:id="bd38bf47-633b-4811-a3d6-b8432cc2970d" config-ref="HTTP_Listener_config" path="/scatter"/>
              <scatter-gather doc:name="Scatter-Gather" doc:id="1e8366b8-36b5-470c-8aca-cd865a2e02a1" >
                     <route >
                           <db:insert doc:name="Insert" doc:id="965d8d96-6e70-488a-8961-71b0bec0a105" config-ref="Database_Config">
                                  <db:sql >insert into info(ID,NAME) values(:ID,:NAME);</db:sql>
                                  <db:input-parameters ><![CDATA[#[{ID:,
                     <route >
                           <db:insert doc:name="Insert" doc:id="c88fde97-7320-47f5-beea-735f4f69073b" config-ref="Database_Config">
                                  <db:sql >insert into info2(ID,NAME) values(:ID,:NAME);</db:sql>
                                  <db:input-parameters ><![CDATA[#[{,
              <set-payload value="Data inserted in Database" doc:name="Set Payload" doc:id="3ee1c60d-c8d5-43b5-8761-aef559c922bb" />

© 2020

Share on :

Mule 4:

XML to JSON in mule 4 Web service consumer VM Validation in Mule 4 Until Successful
Sub flow Set Variable & Remove Variable Set Transaction ID Scatter Gather Round Robin
Consume Restful Service CRUD in Mule 4 Parse Template Object to JSON Load Static Resource
JSON to XML Invoke Idempotent Filter ForEach Flat file to JSON
Fixwidth to JSON First Successful File Execute Error Handling
Email Dynamic Evaluate Custom Business Event CSV to JSON Copybook to JSON
Choice Router Async RabbitMQ

Mule 3:

Database Connector Async CXF Attachement XSLT
Mongo DB Cache scope Custom Business Event Gzip Compress Expression
SMTP For Each Expression Javascript Filter Reference
Salesforce Message Enricher Groovy Parse Template Idempotent
VM Poll Invoke Ruby Message
Webservice consumer Python Transformer reference Message Property Not
Collection Aggregator First Sucessful Catch Exception Strategy Reference Exception Strategy Or
Choice Message Chunk Aggregator Choice Exception Strategy Global Exception Strategy Schema Validation
Custom Aggregator Scatter Gather Custom Exception Strategy Batch Processing MEL
M Unit RAML Map Operator API Mocking Dataweave