Idea Details

PAM to use external DB

Last activity 04-25-2020 01:50 AM
Sung Hoon Kim's profile image
04-07-2020 07:28 PM

Traditional PAM design is to have local DB to store everything.
But as the DB grows, replication takes more time and can cause frequent outages as the node can go out of sync.
Syncing the nodes also takes more time.

The idea is to allow configuration of external DB.
If all the PAM nodes are pointing to the same external DB, there would be no need to replicate. There is no need to synchronize.

In case if customer has sites globally and requires another instance of external DB, this DB would have its own replication(depending on what types of DB we support) but it would be significantly less bytes to transfer over WAN.

Other advantages:
1. Customer can do a DB Backup directly from the DB side and not rely on PAM
2. PAM does not need to run DB locally, reducing CPU/RAM requirement.


04-25-2020 01:50 AM

stall MySQL in a server. Connect to MySQL in the external server and create the database. Grant privileges to the db user that is going to connect to the database from PAM Login to PAM and go to Click on Update. Connect to your database and verify that tables get created My Lowes Life.