### Is there an existing issue for this?

- [X] I have searched the existing issues

### Current Behavior

1. Create kinesis stream with `awslocal kinesis create-stream`
2. Create two firehose delivery stream with `awslocal firehose create-delivery-stream`, both of which have `--kinesis-stream-source-configuration` to the stream created above
3. Put record to the stream
4. Only one of the delivery stream receives the message

### Expected Behavior

At the 4th step, both of the delivery stream should receive the message.
(which was true in real AWS environment.)

### How are you starting LocalStack?

With a `docker run` command

### Steps To Reproduce

#### How are you starting localstack (e.g., `bin/localstack` command, arguments, or `docker-compose.yml`)

    docker run localstack/localstack:2.3.2

#### Client commands (e.g., AWS SDK code snippet, or sequence of "awslocal" commands)

    docker exec -it admiring_chatelet bash
    (in the localstack container)
    awslocal opensearch create-domain --domain-name my-domain
    awslocal kinesis create-stream --stream-name samplestream --shard-count 2 --region dummy
    awslocal firehose create-delivery-stream --delivery-stream-name s1 --delivery-stream-type KinesisStreamAsSource --kinesis-stream-source-configuration "KinesisStreamARN=arn:aws:kinesis:us-east-1:000000000000:stream/samplestream,RoleARN=arn:aws:kinesis:us-east-1:000000000000:role/stream-role" --amazonopensearchservice-destination-configuration "ClusterEndpoint=http://my-domain.us-east-1.opensearch.localhost.localstack.cloud:4566,IndexName=index1,TypeName=_doc,RoleARN=arn:aws:kinesis:us-east-1:000000000000:role/es-role,S3Configuration={RoleARN=arn:aws:iam::000000000000:role/Firehose-Reader-Role,BucketARN=arn:aws:s3:::kinesis-activity-backup-local}"
    awslocal firehose create-delivery-stream --delivery-stream-name s2 --delivery-stream-type KinesisStreamAsSource --kinesis-stream-source-configuration "KinesisStreamARN=arn:aws:kinesis:us-east-1:000000000000:stream/samplestream,RoleARN=arn:aws:kinesis:us-east-1:000000000000:role/stream-role" --amazonopensearchservice-destination-configuration "ClusterEndpoint=http://my-domain.us-east-1.opensearch.localhost.localstack.cloud:4566,IndexName=index2,TypeName=_doc,RoleARN=arn:aws:kinesis:us-east-1:000000000000:role/es-role,S3Configuration={RoleARN=arn:aws:iam::000000000000:role/Firehose-Reader-Role,BucketARN=arn:aws:s3:::kinesis-activity-backup-local}"
    awslocal kinesis put-record --stream-name samplestream --data '{"test":"value"}' --partition-key 1
    curl http://my-domain.us-east-1.opensearch.localhost.localstack.cloud:4566/index1/_search
    curl http://my-domain.us-east-1.opensearch.localhost.localstack.cloud:4566/index2/_search

by the last two `curl`s, only one of the results shows the given data.

### Environment

```markdown
- OS: MacOS 13.2.1
- LocalStack: 2.3.2
```


### Anything else?

_No response_
context, delivery_stream_name: str
) -> DeliveryStreamDescription:
    store = FirehoseProvider.get_store(context.account_id, context.region)
    delivery_stream_description = store.delivery_streams.get(delivery_stream_name)
    if not delivery_stream_description:
        raise ResourceNotFoundException(
            f"Firehose {delivery_stream_name} under account {context.account_id} " f"not found."
        )
    return delivery_stream_description
def get_opensearch_endpoint(domain_arn: str) -> str:
    """
    Get an OpenSearch cluster endpoint by describing the cluster associated with the domain_arn
    :param domain_arn: ARN of the cluster.
    :returns: cluster endpoint
    :raises: ValueError if the domain_arn is malformed
    """
    account_id = extract_account_id_from_arn(domain_arn)
    region_name = extract_region_from_arn(domain_arn)
    if region_name is None:
        raise ValueError("unable to parse region from opensearch domain ARN")
    opensearch_client = connect_to(aws_access_key_id=account_id, region_name=region_name).opensearch
    domain_name = opensearch_domain_name(domain_arn)
    info = opensearch_client.describe_domain(DomainName=domain_name)
    base_domain = info["DomainStatus"]["Endpoint"]
    
    
    endpoint = base_domain if base_domain.startswith("http") else f"http://{base_domain}"
    return endpoint
def get_search_db_connection(endpoint: str, region_name: str):