🚀 go-pugleaf

Hi,

I want to make a DB backup while both the service
application and server socket are active. Server
socket adds data to the DB, so I must somehow
allow pending connections to finish and stop new
connections to affect the DB. But I still want to
inform the clients what's going on (backup).

This is how I imagined the scenario. Can you please
tell me if the presented concept is acceptable?


// PSEUDO

void __fastcall TTicketService::IdTCPServerExecute(TIdPeerThread *AThread)
{
   // SERVER RECEIVES REQUEST FROM CLIENT ...
   AThread->Connection->Read...( READ REQUEST FROM CLIENT );
   
   // IF IT'S TIME FOR DB BACKUP ...
   if ( TimeForBackup )
   {
      // SERVER SENDS RESPONSE TO CLIENT ...
      AThread->Connection->Write...( NOT DONE, BECAUSE OF ... PLEASE TRY AGAIN LATER );
   }
   else
   {
      // counter of connections which *accesses* DB
      RAII_CritSec_Increment_Decrement(); // in constructor ++counter, in destructor --counter
      
      // BLOCK OF CODE IN WHICH DB IS ACCESSED...
      DB->Table->CritSec_Add...( DATA RECEIVED FROM CLIENT );

      // SERVER SENDS RESPONSE TO CLIENT ...
      AThread->Connection->Write...( DATA WAS SUCCESFULY STORED! );
   }
}


// PSEUDO

void __fastcall TTicketService::ServiceExecute(TService *Sender)
{
   while ( !Terminated )
   {
      if ( ( TimeForBackup ) && ( counter == 0 ) )
      {
         BACKUP_DB();
         TimeForBackup = false;
      }

      Sleep ( 500 );

      ServiceThread->ProcessRequests( false );
   }
}



Best Regards,
Vladimir Stefanovic