# How to configure Endpoint Central MSP server and MySQL database to run in different computers?

## Description

In case you are looking to maintain your **Endpoint Central MSP** Server and MYSQL database in two different machines, for reasons related to performance, data backup etc, you can achieve it with a simple configuration.

The following steps will help you configure the **Endpoint Central MSP** Server and the MySQL database in two different machines. For ease of operation, we have differentiated the steps that need to be carried out on the respective machines.

## Steps to be performed in the computer where Endpoint Central MSP server is installed

1. Open the file `DesktopCentral_Server\conf\Persistence\persistence-configurations.xml` and change the below value as specified.  
   `StartDBServer=false` (default is true applicable for local DB)

2. Open the file `DesktopCentral_Server\conf\database_params.conf` and replace the `localhost` in the below specified with the machine name or IP address of the remote computer where the DB is running (or going to run).  
   `url=jdbc:mysql://localhost:8056/desktopcentral`  

   **Note:**  
   - In case of changing the port, change `8056` to the desired free port.  
   - Also change `DB_PORT` value in `DesktopCentral_Server\mysql\setDBEnv.bat`.

3. Copy the below files (with same directory structure) to the remote computer where the DB needs to be installed. Ensure that MySQL Service is not running when you copy these files. (`DesktopCentral_Server\bin\stopDB.bat` will shut it down if it is running.)  

   - `DesktopCentral_Server\mysql\**` (complete folder)

## Steps to be followed in the Remote Computer where the Database has to be installed

1. Open a command prompt, and go to `DesktopCentral_Server\mysql` folder.

2. Execute the below commands in the same order:

   **`mysql-service.bat install`**  
   (This command will register MySQL as a service with the name `DesktopCentral-MySQL`.)

   **`mysql-service.bat start`**  
   (This command will start the MySQL service. Alternatively, you can use the Services snap-in from Control Panel to start/stop the service.)

3. Execute the following command:

   **`mysql-privilege.bat SERVER_HOST_NAME`**  

   Provide the computer name or IP address of the machine where the **Endpoint Central MSP** server is running in place of `SERVER_HOST_NAME`.  

   Execute this command only after the MySQL service has successfully started.