[Glass] Backup procedure

[Trussardi Dario Romano via Glass]

Thanks for your considerations!!!

From my point of view:
	

> We used to do this but switched over to the logsender / logreceiver
> (hot standby) some time ago. It did make management of copying of
> tranlogs over to the standby system easier. I recommend you use this
> if you can; it is robust.

	OK. This is the top of backup procedure.

	And if i right understand i can switch from master to slave in real time ( some minutes? ).

	But it required some hardware and .... configuration.....

	I think to use it to very 24x7 maximum guarantee system and continuity of service.



	My goal is to have a small system which can break, 

	but with support to restore at the last transaction.

	In case of the system crash, i don't need to restart in few minutes,

	but to restore at the last transaction.


	The customer knows that the system can crash, and in this case the system can stay down for some hours, 

	but when the system restart it's update at the last transaction.



	Restore the system to the last tranlog backup is not sufficient.

	As the customer can realign the system if the last backup tranlog is 30 minutes old?

	Where i found the last 30 minutes transaction if the server is dead?

	I think having an intermediate solution could resolve many situations.

	Having the ability to have a online copy of the active tranlog on the backup system it's a very good solution.

	Is possible use the logsender / logreceiver only to replicate the current logs on the backup system ?

	With this support and the last  production backup  it's possible restore the system without losing any transactions.

	But these are my considerations.....

	Thanks,
	
		Dario


> On Thu, Jul 28, 2016 at 7:55 PM, Bob Tucker via Glass
> <glass at lists.gemtalksystems.com> wrote:
>> We keep a warm recovery DB for our production GS system on a geographically
>> separate system.  Nightly we restore the recovery DB from the latest prod
>> backup, then as we switch tranlogs (script via cron) we have scripts that
>> will package it up, send it over to the restore system, kick off scripts on
>> that side that will prepare the tranlog and apply it to the warm recovery
>> system.  Both sides are on AIX and we use rcp to move the files.  You cannot
>> copy active tranlogs nor extents (we use raw) so requires the backup written
>> to disk and exporting tranlogs to filesystems to be able to move them over.
>> We are on a fairly old version so newer versions may be more robust.
>> 
>> On Thu, Jul 28, 2016 at 1:00 PM, Trussardi Dario Romano via Glass
>> <glass at lists.gemtalksystems.com> wrote:
>>> 
>>> Ciao,
>>> 
>>> some time ago ( 10 marzo 2016  ) Dale wrote :
>>> 
>>> Regarding risk of losing data on system restart ... you should already be
>>> keeping copies of your backup files and tranlogs on a separate system, so
>>> that if you lose a disk, you have fairly recent copies of both ... if you
>>> are concerned about losing as little data as possible, you might think about
>>> copy tranlogs to a separate machine several times a day ...
>>> 
>>> 
>>> OK, i working in this direction.
>>> 
>>> I have some doubts:
>>> 
>>> A)  I need a external script  for create the new tranlog  every hour with
>>> the  System class >> startNewLog.
>>> In general i have some methods to perform at regular time and data but i
>>> don't understand if i can schedule it directly into the gemstone,
>>> 
>>> or if i need external scripts call by Crontab?
>>> 
>>> B) On LAN i have a Windows system for perform ftp copy from the Gemstone
>>> server to the backup system.
>>> ( i use the Cobian program )
>>> 
>>> Now i think to setup the incremental  ftp copy of the  /tranlogs  server
>>> directory.
>>> 
>>> But how does the ftp command by copying the online tranlog ?
>>> 
>>> Can create problematic on the server?
>>> 
>>> C) Link to my last email :   [Glass] Integrity of the system
>>> 
>>> I read about Warm and Hot Standbys
>>> 
>>> Is not possible have the " online copy " of the current  tranlog on the
>>> backup system ?
>>> 
>>> Where for online copy i think the copy at the last transaction ( update at
>>> the last minute?! ) on the server.
>>> 
>>> If this would be possible, when the server crash, on the backup system i
>>> found the tranlog update to the latest transactions.
>>> Is not bad?
>>> 
>>> Am I asking too much?
>>> 
>>> Thanks for any considerations,
>>> 
>>> Dario
>>> 
>>> 
>>> 
>>> _______________________________________________
>>> Glass mailing list
>>> Glass at lists.gemtalksystems.com
>>> http://lists.gemtalksystems.com/mailman/listinfo/glass
>>> 
>> 
>> 
>> 
>> --
>> -B-
>> 
>> "Think of how stupid the average person is, and realize half of 'em are
>> stupider than that"
>> - George Carlin
>> 
>> _______________________________________________
>> Glass mailing list
>> Glass at lists.gemtalksystems.com
>> http://lists.gemtalksystems.com/mailman/listinfo/glass
>> 
> _______________________________________________
> Glass mailing list
> Glass at lists.gemtalksystems.com
> http://lists.gemtalksystems.com/mailman/listinfo/glass