Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
BUG: Pandora Server doesn't like a MySQL bounce
#1
I have MySQL on a master-master setup by which if mysql-1 goes down, the IP address automatically transfers to mysql-2.

If mysql-1 is downed, the Pandora FMS console continues to function--the IP address moves, the Web console shows you what's in the database.

However, Pandora starts collecting a bigger and bigger backlog of XML files as soon as the console is downed.  The server needs a restart once MySQL drops and comes back up or else it just collects logs forever.  This seems to occur even if MySQL is just restarted in earnest, so may affect a single database server that bounces.

Try stopping and then starting MySQL and see if Pandora Server starts backlogging input instead of recovering from the failure.
 Reply
#2
Hello;

Check the next instructions in order to optimize mysql.I also attach a way to balance two nodes which is already tested with pandora also (I don't know if it's the one you are using)


http://openideas.info/wiki/index.php?tit...timization

http://openideas.info/wiki/index.php?tit...QL_Replica

Regards
 Reply
#3
Yes I have master-master with automated script (mysql-mmm) to change over if the db goes down.

The problem is if the db ever goes down, pandora server hangs.  In the event of a db server restart or a fail-over, pandora server stops processing XML files entirely.
 Reply
#4
Could you attach this files?:

/srv/www/htdocs/pandora_console/include/config.php

/etc/pandora/pandora_server.conf

/var/log/pandora/pandora_server.log


Regards
 Reply


Users browsing this thread: 1 Guest(s)


(c) 2006-2018 Artica Soluciones Tecnológicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org

Theme © MyBB Themes