Product Documentation

Back up the encryption_requests table and strongkeylite database from each cluster node before updates to ensure easy recovery if performance issues arise.

NOTE: This step requires stopping application server (Payara) on the appliance, so make sure the appliance is not receiving web-service requests while taking a backup.

  1. Login into the appliance as strongauth user.
  2. Stop Payara
    shell> sudo systemctl stop payara
    Ensure that Payara has been stopped using the following command:
    shell> nfn 8181
    
    If Payara still running, list the process ID and force kill the process:
    shell> pf payara
    
    shell> kill -9 (pid from the above command)
    
  3. Take a backup of encryption_requests table.
    shell> mysqldump -u skles -p strongkeylite encryption_requests > /usr/local/strongauth/dbdumps/encreq-$(hostname)-$(date +%Y-%m-%d).db
  4. Take a backup of whole strongkeylite DB.
    shell>mysqldump -u skles -p`dbpass 2> /dev/null` --no-create-info --ignore-table strongkeylite.decryption_requests --ignore-table strongkeylite.deletion_requests --ignore-table strongkeylite.search_requests --ignore-table strongkeylite.replication strongkeylite > /usr/local/strongauth/dbdumps/strongkeylite-$(hostname)-$(date +%Y-%m-%d).db