Ask the Community
Groups
How to separate DGE component from the All in one installation (BVE+DGE+WebAPP) - Connect IT Community | Kaseya
<main> <article class="userContent"> <div><strong>QUESTION:</strong></div> <div>How can I separate/distribute the Data Gathering Engine database from the BVE/DGE/Web all-in-one installation?</div> <div> </div> <div> </div> <div><strong>RESOLUTION:</strong></div> <p>1 . Install the identical Traverse revision on the (new) destination server but ONLY install the DGE component. Please keep the same name and same OS (Windows > Windows or GNU/Linux > GNU/Linux)<br>2 . Stop Traverse software components on the destination server <br>3 . Stop Traverse software on the (original) source server <br>4 . Copy the following files and folders from source to destination:</p> <p> </p> <pre class="code codeBlock" spellcheck="false" tabindex="0"><br>TRAVERSE_HOME\database\mysql\aggregateddatadb\ <br>TRAVERSE_HOME\database\mysql\processdb\ <br><br></pre> <p>* On the new DGE:</p> <p>Restore the MySQL databases:</p> <pre class="code codeBlock" spellcheck="false" tabindex="0">cd TRAVERSE_HOME\ <br>net start nvdgedb </pre> <p> </p> <pre class="code codeBlock" spellcheck="false" tabindex="0"><br>apps\mysql\bin\mysql --defaults-file=etc\mysql.conf --execute="SHOW TABLES" --database="aggregateddatadb" > tables.txt <br>for /F "skip=1" %G IN (tables.txt) DO <a href="https://kaseya.vanillacommunities.com/profile/apps%5Cmysql%5Cbin%5Cmysql" rel="nofollow">@apps\mysql\bin\mysql</a> --defaults-file=etc\mysql.conf --execute="REPAIR TABLE %G USE_FRM" aggregateddatadb >> logs\database_restore.log <br>apps\mysql\bin\mysql --defaults-file=etc\mysql.conf --execute="SHOW TABLES" --database="processdb" > tables.txt <br>for /F "skip=1" %G IN (tables.txt) DO <a href="https://kaseya.vanillacommunities.com/profile/apps%5Cmysql%5Cbin%5Cmysql" rel="nofollow">@apps\mysql\bin\mysql</a> --defaults-file=etc\mysql.conf --execute="REPAIR TABLE %G USE_FRM" processdb >> logs\database_restore.log </pre> <p> </p> <pre class="code codeBlock" spellcheck="false" tabindex="0">cd TRAVERSE_HOME\ <br>utils\db_optimize.cmd</pre> <p>* On the BVE:</p> <p>5 . Disable DGE service <br>6 . Start all other services <br>7 . Log in to the Web Application <br>8 . Change the IP address of the old DGE to the IP address of the new DGE. <br>9 . If applicable point the DGExs to the new upstream DGE IP/FQDN</p> <p>* On the DGE:</p> <p>10 . Start all the services.</p> <p> </p> <p><strong>APPLIES TO:</strong></p> <p>All versions of Traverse </p> <p> </p> <p><strong>REFERENCE:</strong></p> <p>None</p> </article> </main>