-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Hi,
Amit Sharma writes: > Hi, > > I have OTRS 2.4.7 working successfully on Linux box from past 1 > year. MySQL was configured in replication mode and the DB was getting > successfully replicated when the attachments were begin stored in DB. > > Of late I have moved to FS for attachments and from them on replication has > started giving trouble. > > I get the following error at mysql prompt: > > Last_SQL_Error: Error 'Table 'ticket' is marked as crashed and should > be repaired' on query. Default database: 'otrs'. Query: 'UPDATE ticket > SET escalation_response_time = '0' WHERE id = '101233'' > My questions are: > > 1. Is the above issue related to DB being changed to FS for attachments? Assuming FS is filesystem, I don't think so. Try repairing table, check database's error log if it crashed. > 2. How to I ensure sync of var/article on realtime basis. Assuming "var/article" is a filesystem object, maybe try DRBD[1] ? > 3. Is there any other option of having realtime copy of OTRS so that in case > primary servers crashes, the backup server takes over as primary almost > immediately. > (Earlier it was working fine and it used to get switched to backup server > almost immediately. This was done thru cron scripts) Maybe look at Heartbeat[2], or Wackamole[3]. Keep DB and FS replicated and make your webserver listen on virtual IPs (aka service IPs), and use Wackamole or Heartbeat to migrate IP addresses during failover. I've not worked with OTRS since a long time. Don't remember much of its setup now. References: [1] http://en.wikipedia.org/wiki/DRBD [2] http://linux-ha.org/wiki/Heartbeat [3] http://www.backhand.org/wackamole/ HTH - -- Ashish SHUKLA “We could tell you what it's about. But then, of course, we'd have to kill you.” (tagline of movie "Sneakers", 1992) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.17 (FreeBSD) iQIcBAEBCgAGBQJN6cOGAAoJEMdGz6nnT6SwdhkP/ArVZNbBbZwXhl4giWpTOhX9 yB+uRx4SYQEsXVVnipfUeTueCCrHidksM5hOaVc/GHFIUrSZHL5rpB7MPFE3cjuM q079uMZ+s3YjxwJdwnp7QojtzoILXrEjEql0g2ufPEXUcBCNqouc43BcxQ7DVgMU B9j0t7bJWMEpI89YLycVsVCavW7ezASW6iNJerK9AjXgNd3P9PBFL3zJ+tZZ2j3v Ksc3Gw9bcDb0rTc3mu5IubPVBwlQvh7jia3KC7aty56dNXG1B5CGQQwkW0QRXfVo vVJjM23iIgueYVX6iEHxPVDGh/2J0FCTN/GKh5A27qQOlZokC9Qvvv4sd7rulhHo zC+N3TdzNWIBcn64j679oJMw07ydgFg7BBiY3tY94FNaCpCqclCiPX6XKPtIt6dS bqKKhlrje1T2dnI8KQwCCyfBv0F+Hjz3PgMgjfcLr5zxXqQDKvfZKq1WnSEKyfMl XTwgMF58EAIkadpIVvH0REvCEit1ih/awitk+53aVvRldBlmnYHC5ApHMG2dFod0 I/ThrfVTux9I+hYUx9CEjINPSB9HVhD84sos1tns/rbx6eUxpBFWUFeny9MOsUxN Gqb/UtrvgVD7FlHD9H4+2fgwo93niPIiGbkl+AB7l/GNoxNSEdnOgClJz3kS8ZQZ lIl69eNDyZJNtNe5sDYZ =JjvD -----END PGP SIGNATURE----- _______________________________________________ Ilugd mailing list [email protected] http://frodo.hserus.net/mailman/listinfo/ilugd
