# Is it possible to break mautic database into 2 databases?

**URL:** <https://forum.mautic.org/t/is-it-possible-to-break-mautic-database-into-2-databases/28761>\
**Category:** Product Support\
**Created:** [July 30, 2023, 2:57pm UTC](https://forum.mautic.org/t/is-it-possible-to-break-mautic-database-into-2-databases/28761 "2023-07-30T14:57:53Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![yochay11](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/yochay11/32/7301_2.png) [@yochay11](https://forum.mautic.org/u/yochay11)\
**Post date:** [July 30, 2023, 2:57pm UTC](https://forum.mautic.org/t/is-it-possible-to-break-mautic-database-into-2-databases/28761/1 "2023-07-30T14:57:53Z")

</div>

Hi, I am guising the answer is no but wanted to give it a shoot.

Mautic database is getting big and if wanted to check if there is some kind of way for me to take a table inside the database like “campaign\_lead\_event\_log” and break it into different database so it won’t have one database that really big but if rather break it into 2 as if want to keep the database under a set size.

If someone knows a work around to do it but still having the system works well if will be happy to hear about it.

Thanks

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [July 31, 2023, 7:25am UTC](https://forum.mautic.org/t/is-it-possible-to-break-mautic-database-into-2-databases/28761/2 "2023-07-31T07:25:35Z")

</div>

Hi,  
Why not just clean it?  
I would also check if there are problematic campaigns, that fill up the DB, like loops for example.

---

<div class="post-metadata">

**Author:** ![yochay11](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/yochay11/32/7301_2.png) [@yochay11](https://forum.mautic.org/u/yochay11)\
**Post date:** [July 31, 2023, 7:39am UTC](https://forum.mautic.org/t/is-it-possible-to-break-mautic-database-into-2-databases/28761/3 "2023-07-31T07:39:05Z")

</div>

Yea i do clean it up every week with a cron but it’s still big, just wanted to explore that option.  
But after i went into mautic files it seems like it won’t be possible.

And yes i also had a similar problem with the past with a loop, which was crazy.

Thanks for your help.

---

<div class="post-metadata">

**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\
**Post date:** [July 31, 2023, 12:11pm UTC](https://forum.mautic.org/t/is-it-possible-to-break-mautic-database-into-2-databases/28761/4 "2023-07-31T12:11:47Z")

</div>

how do you deal with this @joeyk - are you talking about campaigns that have the user restart at the end of the campaign?

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [July 31, 2023, 3:14pm UTC](https://forum.mautic.org/t/is-it-possible-to-break-mautic-database-into-2-databases/28761/5 "2023-07-31T15:14:00Z")

</div>

I try to avoid it on large scale. These campaigns generate a huge amount of logs, and the DB can get out of hand. I either use segments to check if someone qualifies or webhooks into forms to start campaign.

---

<div class="post-metadata">

**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\
**Post date:** [July 31, 2023, 3:32pm UTC](https://forum.mautic.org/t/is-it-possible-to-break-mautic-database-into-2-databases/28761/6 "2023-07-31T15:32:34Z")

</div>

Quite interested to hear how you deal with showing pop-ups on specific pages to all visitors using campaigns. This is something we do, however I am not sure I am using the best implementation.

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [August 1, 2023, 6:31am UTC](https://forum.mautic.org/t/is-it-possible-to-break-mautic-database-into-2-databases/28761/7 "2023-08-01T06:31:19Z")

</div>

If it’s about placing a focus item in wordpress dynamically, I use Woody Snipplets. Even the free version allows you to place focus items based on rules.  
Just add your js / html / php content:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/5/5604fe6c6b14bb066bf7047296eed5013076c624.png)

Then define the placement:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/4/4b2bf6e0d4f7b9f07916b8aaa3405290f54e8496.png)

Define rules:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/2/286fecc79912198b0f0d2a309b7a03f8bde4d698.png)

There are bunch of other rules you can choose from.

---

<div class="post-metadata">

**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\
**Post date:** [August 1, 2023, 7:06am UTC](https://forum.mautic.org/t/is-it-possible-to-break-mautic-database-into-2-databases/28761/8 "2023-08-01T07:06:09Z")

</div>

we deal a lot with different web site technologies like react and angular - any other thoughts on this?
