# MySQL db running outside of gateway

**URL:** <https://forum.inductiveautomation.com/t/mysql-db-running-outside-of-gateway/5356>\
**Category:** Archived Topics\
**Created:** [October 30, 2012, 1:10pm UTC](https://forum.inductiveautomation.com/t/mysql-db-running-outside-of-gateway/5356 "2012-10-30T13:10:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rcorkern](https://avatars.discourse-cdn.com/v4/letter/r/90db22/32.png) [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\
**Post date:** [October 30, 2012, 1:10pm UTC](https://forum.inductiveautomation.com/t/mysql-db-running-outside-of-gateway/5356/1 "2012-10-30T13:10:16Z")

</div>

Has anyone tried running MySQL outside of the Ignition gateway? I’m curious to know what the drawbacks are of running MySQL on another server or in a hosted environment.  
We want to be scalable to run multiple projects and I can see how having several schemas with several projects all on the same Ignition gateway could get to be a difficult task to manage. Thanks in advance for your input.

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [October 30, 2012, 7:07pm UTC](https://forum.inductiveautomation.com/t/mysql-db-running-outside-of-gateway/5356/2 "2012-10-30T19:07:37Z")

</div>

Most of our customers use a database that is on a different machine. We recommend that so the database can use dedicated machine resources. There aren’t any drawbacks.

---

<div class="post-metadata">

**Author:** ![rcorkern](https://avatars.discourse-cdn.com/v4/letter/r/90db22/32.png) [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\
**Post date:** [November 2, 2012, 1:00pm UTC](https://forum.inductiveautomation.com/t/mysql-db-running-outside-of-gateway/5356/3 "2012-11-02T13:00:34Z")

</div>

After speaking more with Rackspace about the “cloud database” option; we won’t have root priviliges to the DB and won’t be able to edit the .cnf file. Would this be a problem?

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [November 5, 2012, 6:23pm UTC](https://forum.inductiveautomation.com/t/mysql-db-running-outside-of-gateway/5356/4 "2012-11-05T18:23:01Z")

</div>

I don’t think so. Ignition needs full privileges on the database to create tables, query, insert, update, and delete. As long as you have that it should be fine.