Last modified Jan, 20, 2017
Users & DBs

Click on User & DBs to see a list of users associated with the cluster. 

Make sure you are running ScaleArc, Version 3.x for this configuration.

ScaleArc Authentication Offload

You enable or disable authentication offload. Enabling authentication offload can speed up performance significantly. The bi-product of this feature provides connection pooling and multiplexing. Client sessions terminate on ScaleArc instead of the database. ScaleArc provides session management by reducing the total number of sessions to the DB servers, which in turn increase performance. 

  1. On the ScaleArc dashboard, click Clusters > Settings and locate Users and DBs to open the screen. 


     
  2. Notice that the screen lists the existing users associated with the cluster. 



  3. The fields are as follows:

    Field Description Default/User Input
    ScaleArc Authentication Offload
    ON/OFF button

    Functions like a "master switch" for Offload settings. When ON, ScaleArc authenticates each user internally instead of connecting to the database to speed up performance.

    To toggle the ON/OFF setting you must first stop the cluster.

    Note that to disable this option, first 
    disable the Read/Write Split and Prep-exec handling settings. Only then does the GUI allow you to disable Authentication Offload.

    Default is ON. Note that when OFF, Windows Authentication Offload and Kerberos Authentication Offload are hidden. Set it to ON for Kerberos delegation to work.
    Add User Allows you to create a new user. Click to open and add a user.
    Fetch Users Enables Auto Fetch Database Users, which automatically updates the user password changes and addition/deletion of new users. Click to enable.
    Gear icon

    Helps configure access and control of cache for a particular user. Databases must be specified here to be fully accessible. 

    Click on the Gear icon to select/edit the DBs for the user. Click on the Change password button to assign a new password.
    User

    A list of one or more users who are enabled on ScaleArc to execute various statements against the database server. 

     
    Databases The names of the database server(s) associated with the user.  
    Search Lets you search for a user. Enter a username to search.

Add users

Follow these procedures to add a user to the cluster.

  1. Click Add User in the User & DBs screen.



  2. Enter the user name and password for the new user. Assign the user one or more databases by moving the selected database from the left panel to the right. 

    If you select the checkbox for adding a Kerberos user, make sure you enter the username as username@domain. You do not need to enter a password for a Kerberos cluster.




  3. Click Save. This action creates a new user with access to the control cache for the database(s) you specified.

Fetch User

Alternatively, you can enable Auto fetch. This option works when you are integrated with Active Directory. This action automatically adds the databases to which the users have permissions. Auto fetch also auto updates any modifications to users. 

  1. Click Fetch Users in the User & DBs screen.
  2. Turn ON. 



  3. Click Select All Users listed on the screen.



  4. if you do not see the users in the Auto Fetch Users list, check if they occur in the User Failure List under Live Monitor. If the user exists in the User Failure list, set the appropriate privileges as described in the following KB article

  5. Enter a number to set the interval between each auto fetch.
  6. Click Save.

Modify database assignment and password

You can easily reassign databases or change the database password for a user.

  1. Click on the Gear icon next to the database.

     
     
  2. Reassign one or more databases to the user.
  3. Click the Change password button to assign a new password.

     

 

 


 

 



On this page

 

 

 

Comments

    Add new comment