Unable to disable MySQL binlog_transaction_compression in VMware Data Services Manager for VCF

Products

• VMware Data Services Manager for VCF

Issue/Introduction

This article addresses a limitation in VMware Data Services Manager for VCF where users are unable to disable binary log transaction compression.

• Symptoms: 

  • After setting binlog_transaction_compression=OFF in the MySQL configuration and successfully restarting the service. 
    
    
  • The change is not reflected. Running the following command shows the parameter remains enabled:
    
    

Environment

• VMware Data Services Manager for VCF 9.0.1.x

Cause

This behavior is a product limitation. The DSM platform enforces specific configuration standards to ensure high availability and performance. The management plane automatically reconciles the database instance configuration against restricted parameter sets, overwriting any manual modifications to managed variables.

Resolution

The binlog_transaction_compression parameter is mandatory and enforced by the DSM platform. There is no supported method to disable this feature in the current release.

For requirements involving changes to restricted parameters:

1. Review the Managed MySQL Parameters documentation.
2. Contact Broadcom Support to submit a Feature Request.
3. Subscribe to this article (Reference: KB 275360) to receive updates regarding potential changes in future releases.

Additional Information

• Review the product documentation for the full list of managed/restricted MySQL parameters.