web stats
Best Practices for Pruning Messages - Page 3 - Mirth Community

Go Back   Mirth Community > Mirth Connect > General Discussion

Reply
 
Thread Tools Display Modes
  #21  
Old 08-11-2013, 10:08 AM
santosam santosam is offline
OBX.2 Kenobi
 
Join Date: May 2012
Location: Portugal
Posts: 62
santosam is on a distinguished road
Default

Regarding the answer from cory_cole, I have a question: is it better to write a shell script that runs on the Linux cron service that deletes messages from the Postgres database than to have Mirth prunning messages?

TYA

Alex
Reply With Quote
  #22  
Old 08-12-2013, 12:30 PM
cory_cole cory_cole is offline
Mirth Guru
 
Join Date: Mar 2012
Posts: 1,227
cory_cole is on a distinguished road
Default

Depends...

Is the DB on the same server as Mirth?

If not then you would want to go with the Cron job (shorter distance travelled and less chance of communication errors).

If they are on the same server, it depends on your (your IT group) level of comfort with either one. There are pros and cons to either way.
Reply With Quote
  #23  
Old 09-26-2013, 04:49 AM
santosam santosam is offline
OBX.2 Kenobi
 
Join Date: May 2012
Location: Portugal
Posts: 62
santosam is on a distinguished road
Default Load Balancing

Just a note to this topic: to prevent downtime during the pruning I have two mirth connect instances running and use crossroads as a load balancer.

Alexandre
Reply With Quote
  #24  
Old 09-26-2013, 04:57 AM
wit-man wit-man is offline
OBX.2 Kenobi
 
Join Date: Apr 2012
Posts: 80
wit-man is on a distinguished road
Default

What is crossroads?
Reply With Quote
  #25  
Old 09-26-2013, 05:02 AM
santosam santosam is offline
OBX.2 Kenobi
 
Join Date: May 2012
Location: Portugal
Posts: 62
santosam is on a distinguished road
Default

Quote:
Originally Posted by wit-man View Post
What is crossroads?
Sorry :-)

I've been using this software and it's very light, easy to configure and comes with a lot of nice options.

http://crossroads.e-tunity.com/index.xr
Reply With Quote
  #26  
Old 09-26-2013, 05:19 AM
wit-man wit-man is offline
OBX.2 Kenobi
 
Join Date: Apr 2012
Posts: 80
wit-man is on a distinguished road
Default

Interesting. Would you happen to have a document of how you configured it that you would be willing to share?
Reply With Quote
  #27  
Old 09-26-2013, 05:46 AM
santosam santosam is offline
OBX.2 Kenobi
 
Join Date: May 2012
Location: Portugal
Posts: 62
santosam is on a distinguished road
Default

Well, it's rather simple for LLP. After installing crossroads you just need to configure a xml file and save it in /etc. If you use HTTP, crossroads can handle it too but needs more configuration.

You just need to choose the <dispatchmode> and the <backend><address>.
I use round-robin in some scenarios and the default (least-connections) on others. It depends of how you want to balance your mirth.
In the backend, you just put the IP:Port of your mirth instances.

The rest is pretty simple and you can keep the default. Attention to the port of the <webinterface>, must be unique for each service.

I attach an example. For LLP, simply delete the <service> entries for HTTP.

Alexandre
Attached Files
File Type: xml xrctrl.xml (9.0 KB, 36 views)
Reply With Quote
  #28  
Old 09-26-2013, 05:51 AM
wit-man wit-man is offline
OBX.2 Kenobi
 
Join Date: Apr 2012
Posts: 80
wit-man is on a distinguished road
Default

Thanks! I'll give it a try.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 09:40 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation