search

ExpandedVenture / ConnectionSphere

Simple Service to Start Prospecting Online
0 stars 0 forks source link

Mirror & truncate transactional tables periodically #273

Open leandrosardi opened 2 years ago

leandrosardi commented 2 years ago

lnuseractivity

  1. Mirror lnuseractivity into the mirror01 database using trigger.
  2. Delete 2-day aged records from lnuseractivity all the time.

boterrorlog

  1. Mirror boterrorlog into the mirror01 database using trigger.
  2. Delete 2-day aged records from boterrorlog all the time.

movement

  1. Mirror movement into the mirror01 database using trigger.
  2. Delete records beloning deleted clients.