Cluster Wide Properties value size

Products

• CA API Gateway

Issue/Introduction

We are looking to use cluster wide property value to store the whitelist of specific DATA, currently we need at least 40k characters space.  Need to retrieve this in policy 

I cannot find a document describing the size of this value, please advise.

Environment

Gateway 10.x 11.X

Resolution

From the mysql side 

Cluster_properties table stores the value as mediumtext:


MEDIUMTEXT [CHARACTER SET charset_name] [COLLATE collation_name]

A TEXT column with a maximum length of 16,777,215 (224 − 1) characters. The effective maximum length is less if the value contains multibyte characters. Each MEDIUMTEXT value is stored using a 3-byte length prefix that indicates the number of bytes in the value.

There is caching for cluster properties so we do not read from db each time

Support confirmed CWP already larger than 40K 

otk.authorixation_server.log is about 87K 

Tested custom CWP with 5300 IP address  = 65K, using is on a next variable and returned in a response