# Two Database Connections in one URL **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [October 25, 2023, 12:03pm UTC](https://forum.inductiveautomation.com/t/two-database-connections-in-one-url/80955 "2023-10-25T12:03:31Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Miguel\_Cimildoro](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@Miguel\_Cimildoro](https://forum.inductiveautomation.com/u/Miguel_Cimildoro)\ **Post date:** [October 25, 2023, 12:03pm UTC](https://forum.inductiveautomation.com/t/two-database-connections-in-one-url/80955/1 "2023-10-25T12:03:31Z")
good morning, is there any way to connect 2 databases in 1? i.e., currently I have a database connection that is working correctly, (following image) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/a/4a6fed00f1e03aa666999e66a41f3c320cc2c6a7.png) now, what I want to do is to have the same name but with another bbdd, so that the tag value is stored in the 2 bbdd's something like that ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/7/173ce17a160d96b3a427099b0f7a225f0951f467.png) if I create it separately it works, but the transaction grop is linked only to 1 bbdd Any suggestions? regards ---
**Author:** ![Hayden\_Watson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/hayden_watson/32/48792_2.png) [@Hayden\_Watson](https://forum.inductiveautomation.com/u/Hayden_Watson)\ **Post date:** [October 25, 2023, 12:05pm UTC](https://forum.inductiveautomation.com/t/two-database-connections-in-one-url/80955/2 "2023-10-25T12:05:24Z")
Could create them as two seperate database connections, and use a tag history data splitter to send data to both. [https://docs.inductiveautomation.com/display/DOC80/Tag+History+Splitter](https://docs.inductiveautomation.com/display/DOC80/Tag+History+Splitter) Edit- Didn't see the part about transaction groups, can't use the splitter then infortunately 😬 ---
**Author:** ![Miguel\_Cimildoro](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@Miguel\_Cimildoro](https://forum.inductiveautomation.com/u/Miguel_Cimildoro)\ **Post date:** [October 25, 2023, 12:08pm UTC](https://forum.inductiveautomation.com/t/two-database-connections-in-one-url/80955/3 "2023-10-25T12:08:24Z")
but in my case it is a transaction group ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/9/b96c4ea2bfcbac9f7e6dba1d84bdc124adcf1218.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [October 25, 2023, 12:12pm UTC](https://forum.inductiveautomation.com/t/two-database-connections-in-one-url/80955/4 "2023-10-25T12:12:39Z")
No, you will need two transaction groups. ---
**Author:** ![Felipe\_CRM](https://avatars.discourse-cdn.com/v4/letter/f/dfb087/32.png) [@Felipe\_CRM](https://forum.inductiveautomation.com/u/Felipe_CRM)\ **Post date:** [October 25, 2023, 1:00pm UTC](https://forum.inductiveautomation.com/t/two-database-connections-in-one-url/80955/5 "2023-10-25T13:00:02Z")
You might be better off setting up some kind of replication outside of Ignition, depending on what you're trying to achieve. See also: > [@Transaction groups, full redundancy, automatic switchover?](https://forum.inductiveautomation.com/t/transaction-groups-full-redundancy-automatic-switchover/23891): > > I have a project with lots of transaction groups for storing history data. It is storing history to a SQL server but the facility wants to install another SQL on another server as a backup. Since they are transaction groups, Tag Splitter cannot be used to save the data to both databases. Therefore, we will have to duplicate the transaction groups to store the same data to the other database. The question I have is whether there is a way on the client to detect which database connection is ac… ---
**Author:** ![Miguel\_Cimildoro](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@Miguel\_Cimildoro](https://forum.inductiveautomation.com/u/Miguel_Cimildoro)\ **Post date:** [October 25, 2023, 1:17pm UTC](https://forum.inductiveautomation.com/t/two-database-connections-in-one-url/80955/6 "2023-10-25T13:17:19Z")
thanks phil, I will try to do it this way. ---
**Author:** ![Miguel\_Cimildoro](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@Miguel\_Cimildoro](https://forum.inductiveautomation.com/u/Miguel_Cimildoro)\ **Post date:** [October 25, 2023, 1:19pm UTC](https://forum.inductiveautomation.com/t/two-database-connections-in-one-url/80955/7 "2023-10-25T13:19:29Z")
Thank you very much, that's exactly what I was asking, but in your case he tries to connect to another one in case one fails, I would need to be connected to both at the same time. mostly the 2nd connection would serve as a backup, since the other connection is on another mysql on another machine totally destined to be used.