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 amit_...@yahoo.com wrote:
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
-
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