Configuring PCC Properties for MySQL Cluster (4.2)

Owned by Jenni Wallin
Jun 03, 2024
1 min read

F 

To use MySQL Cluster as data repository for PCC, you need to update the pcc. properties file by following the steps below:

  1. Open the pcc.properties file, located in the /etc/pcc/pcc.properties directory, and configure the following properties:

    PropertyDescription
    mz.pcc.storage.lock.timeoutThe default value of this property is 3000 ms. It is recommended to also set the MySQL Cluster parameter TransactionInactiveTimeout to 3000 ms to avoid timeout errors due to locked database records.

    mz.pcc.storage.mysqlc.database

    		This property should contain the name of the database created, e g pcc.

    mz.pcc.storage.mysqlc.host

    		This property should contain the host name of the Management Node. If more than one Management Node is being used, comma separated host names should be specified.

    mz.pcc.storage.mysqlc.port

    		This property should contain the port of the Management Node process, e g 1186.

    mz.pcc.config.storage.class

    		This property should be set to com.digitalroute.pcc.storage.config.mysqlc.MySQLClusterStorage.

    mz.pcc.bucket.storage.class

    		This property should be set to com.digitalroute.pcc.buckets.storage.mysqlc.MySQLClusterBucketStorage.


  2. Add the following system property for each ECD to enable the ECDs to locate the pcc.properties file:

    mz.pcc.properties=/etc/pcc/pcc.properties

    see Configuring ECD(s) with PCC Properties (3.2).