How to replicate OTRS on another machine when attachments are getting stored in FS
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? 2. How to I ensure sync of var/article on realtime basis. 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) regards, Amit Sharma Thanks and Regards, Amit Sharma
Hello,
1. Is the above issue related to DB being changed to FS for attachments?
I've seen that crashed table message when moving a database without stopping
the mysql deamon. To repair it just run repair table_name on the mysql
prompt and check your replication process, it might have something wrong
2. How to I ensure sync of var/article on realtime basis.
You can do a bash script using ssh and rsync called by cron to move
attachments from one server to another
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)
Cron scripts are fine as long as they're well written. Maybe sharing your
script here will motivate people to propose improvements
Leonardo Certuche
www.itconsultores.com.co
Medellín, Colombia
On 3 June 2011 23:42, Amit Sharma
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? 2. How to I ensure sync of var/article on realtime basis. 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)
regards, Amit Sharma Thanks and Regards, *Amit Sharma*
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
participants (2)
-
Amit Sharma -
Leonardo Certuche