Stop RT for Backupprocess

Hello all,

I would like to Stop and Start RT in order to make an Backup Process.

Should i Kill or Stop the RT Process ? Whats the difference and what does
it make more sense?

And which processes are belongs to RT?

greetings john
View this message in context: http://old.nabble.com/Stop-RT-for-Backupprocess-tp30984358p30984358.html

You’d want to stop apache and probably the locally running MTA. For me
that would be:

/etc/init.d/httpd stop
/etc/init.d/postfix stop

However we backup rt including the SQL databases every night with no
problems. RT is a tad unresponsive at times, maybe some table locks
thrown in which trouble the night time NOC team, but generally it backs
up fine.

Talking from the view point of having had to have done 3 restores this
year alone due to a mountain of fault Maxtor HDDs.

Cheers

Mat

Kind Regards,
Find Vaioni’s latest Terms and Conditions & SLA docs http://www.vaioni.com/tcaupsla.html.
http://www.vaioni.com/ http://www.convergencesummit.co.uk/Exhibitor_List_North.cfm#Exhibitor_285 http://www.cbawards.co.uk/Reader_Vote_3.cfm
Matthew Hattersley

Email: mailto:matthew.hattersley@vaioni.com
Mobile:

Address: 14 Leslie Hough Way
Manchester
Lancashire
M6 6AJ

Tel: 0870-160-0650 Ext 201
Fax: 0870-160-0651
Web: http://www.vaioni.com

http://www.convergencesummit.co.uk/Exhibitor_List_North.cfm#Exhibitor_285
The information transmitted in and with this email is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the Company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer.
Please also note, Vaioni filter incoming email for spam and inappropriate words. Unfortunately this does mean that sometimes genuine messages can be filtered out. Although we take measures to recover such messages, it must not be assumed that an email has been received by us and important communications should always be followed up by a phone call, fax or printed copy.-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of john s.
Sent: 22 February 2011 10:05
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Stop RT for Backupprocess

Hello all,

I would like to Stop and Start RT in order to make an Backup Process.

Should i Kill or Stop the RT Process ? Whats the difference and what
does
it make more sense?

And which processes are belongs to RT?

greetings john
View this message in context:
http://old.nabble.com/Stop-RT-for-Backupprocess-tp30984358p30984358.html

@Matthew
Thnx for help

best regards john

Matthew Hattersley wrote:

You’d want to stop apache and probably the locally running MTA. For me
that would be:

/etc/init.d/httpd stop
/etc/init.d/postfix stop

However we backup rt including the SQL databases every night with no
problems. RT is a tad unresponsive at times, maybe some table locks
thrown in which trouble the night time NOC team, but generally it backs
up fine.

Talking from the view point of having had to have done 3 restores this
year alone due to a mountain of fault Maxtor HDDs.

Cheers

Mat

Kind Regards,
Find Vaioni’s latest Terms and Conditions & SLA docs
http://www.vaioni.com/tcaupsla.html.
http://www.vaioni.com/
http://www.convergencesummit.co.uk/Exhibitor_List_North.cfm#Exhibitor_285
http://www.cbawards.co.uk/Reader_Vote_3.cfm
Matthew Hattersley

Email: mailto:matthew.hattersley@vaioni.com
Mobile:

Address: 14 Leslie Hough Way
Manchester
Lancashire
M6 6AJ

Tel: 0870-160-0650 Ext 201
Fax: 0870-160-0651
Web: http://www.vaioni.com

http://www.convergencesummit.co.uk/Exhibitor_List_North.cfm#Exhibitor_285
The information transmitted in and with this email is intended only for
the person or entity to which it is addressed and may contain confidential
and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those
of the Company. Any review, retransmission, dissemination or other use of,
or taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the
material from any computer.
Please also note, Vaioni filter incoming email for spam and inappropriate
words. Unfortunately this does mean that sometimes genuine messages can be
filtered out. Although we take measures to recover such messages, it must
not be assumed that an email has been received by us and important
communications should always be followed up by a phone call, fax or
printed copy.

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of john s.
Sent: 22 February 2011 10:05
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Stop RT for Backupprocess

Hello all,

I would like to Stop and Start RT in order to make an Backup Process.

Should i Kill or Stop the RT Process ? Whats the difference and what
does
it make more sense?

And which processes are belongs to RT?

greetings john

View this message in context:
http://old.nabble.com/Stop-RT-for-Backupprocess-tp30984358p30984358.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.

View this message in context: http://old.nabble.com/Stop-RT-for-Backupprocess-tp30984358p30984747.html

it is importante to stop MTA before httpd. We are planning to configure a
replica of the database that will be used to generate backups, while
main copy continues running.

We use this procedure:

Cron:
36 5,11,16,21 * * * /var/lib/mysql/dumprt3.sh

dumprt3.sh
/sbin/service exim stop
/sbin/service httpd stop
mysqldump -u backup rt3 > /backup/local/rt3-$M.sql
mv -f /backup/amanda/rt3-2.sql.gz /backup/amanda/rt3-3.sql.gz
mv -f /backup/amanda/rt3-1.sql.gz /backup/amanda/rt3-2.sql.gz
mv -f /backup/amanda/rt3-atual.sql.gz /backup/amanda/rt3-1.sql.gz
/sbin/service httpd start
gzip /backup/local/rt3-$M.sql
/sbin/service exim start
cp /backup/local/rt3-$M.sql.gz /backup/amanda/rt3-atual.sql.gz
find /backup/local/rt3*.sql.gz -mtime +10 -delete

 Fernando Frota Machado de Morais
    Divisao de Redes de Comunicacao
    Centro de Computacao
    Universidade Federal de Minas Gerais
    Brasil
    Tel. +55(31)3409.4007  Fax. +55(31)3409.4004Em terça-feira 22 fevereiro 2011, às 07:59:06, john s. escreveu:

@Matthew
Thnx for help

best regards john

Matthew Hattersley wrote:

You’d want to stop apache and probably the locally running MTA. For
me that would be:

/etc/init.d/httpd stop
/etc/init.d/postfix stop

However we backup rt including the SQL databases every night with
no problems. RT is a tad unresponsive at times, maybe some table
locks thrown in which trouble the night time NOC team, but
generally it backs up fine.

Talking from the view point of having had to have done 3 restores
this year alone due to a mountain of fault Maxtor HDDs.

Cheers

Mat

Kind Regards,
Find Vaioni’s latest Terms and Conditions & SLA docs
http://www.vaioni.com/tcaupsla.html.
http://www.vaioni.com/
http://www.convergencesummit.co.uk/Exhibitor_List_North.cfm#Exhibit
or_285 http://www.cbawards.co.uk/Reader_Vote_3.cfm
Matthew Hattersley

Email: mailto:matthew.hattersley@vaioni.com
Mobile:

Address: 14 Leslie Hough Way

           Manchester
           Lancashire
           
            M6 6AJ

Tel: 0870-160-0650 Ext 201
Fax: 0870-160-0651
Web: http://www.vaioni.com

http://www.convergencesummit.co.uk/Exhibitor_List_North.cfm#Exhibit
or_285 The information transmitted in and with this email is
intended only for the person or entity to which it is addressed
and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent
those of the Company. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this
information by persons or entities other than the intended
recipient is prohibited. If you received this in error, please
contact the sender immediately and delete the material from any
computer.
Please also note, Vaioni filter incoming email for spam and
inappropriate words. Unfortunately this does mean that sometimes
genuine messages can be filtered out. Although we take measures to
recover such messages, it must not be assumed that an email has
been received by us and important communications should always be
followed up by a phone call, fax or printed copy.

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of john
s. Sent: 22 February 2011 10:05
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Stop RT for Backupprocess

Hello all,

I would like to Stop and Start RT in order to make an Backup
Process.

Should i Kill or Stop the RT Process ? Whats the difference and
what does
it make more sense?

And which processes are belongs to RT?

greetings john

Hello all,

I would like to Stop and Start RT in order to make an Backup Process.

Should i Kill or Stop the RT Process ? Whats the difference and what does
it make more sense?

And which processes are belongs to RT?

I’m not a MySQL expert by any means, but isn’t it possible to get a
quiescent backup of MySQL without stopping/starting any services?

It’s my understanding that one can issue a “read lock” as part of the
mysqldump command. If this is the case, wouldn’t it be less disruptive to
users since the web and email services would not be shutdown in order to
perform a backup.

I have also read that this “read lock” works particularly well when using it
to backup a replica, since this would require zero down time.

~ Tom

@Thomas

Thnx Thomas for advice , but at the moment we dont need an E-Mail Service so
it doesn’t matter if the service will be shutdown for backup process or not.

furthermore… Better safe than sorry :slight_smile:

best regards john

Thomas Smith-12 wrote:

Hello all,

I would like to Stop and Start RT in order to make an Backup Process.

Should i Kill or Stop the RT Process ? Whats the difference and what
does
it make more sense?

And which processes are belongs to RT?

I’m not a MySQL expert by any means, but isn’t it possible to get a
quiescent backup of MySQL without stopping/starting any services?

It’s my understanding that one can issue a “read lock” as part of the
mysqldump command. If this is the case, wouldn’t it be less disruptive to
users since the web and email services would not be shutdown in order to
perform a backup.

I have also read that this “read lock” works particularly well when using
it
to backup a replica, since this would require zero down time.

~ Tom

View this message in context: http://old.nabble.com/Stop-RT-for-Backupprocess-tp30984358p30992842.html