Knowledgebase

Database Administration in the Nigerian Context Print

  • 0

Local realities.

WHAT CONSTRAINS WORK HERE

Bandwidth cost for large transfers Latency to distant servers Power affecting on-premises systems Foreign-currency pricing for managed services

WHAT BANDWIDTH AFFECTS

Downloading backups Restoring from off-site copies

WHAT TO DO ABOUT IT

Compress before transferring Transfer server to server directly Keep a local copy for speed and a remote one for safety

WHY THE LOCAL COPY MATTERS

Restoring from a distant backup over a slow link can take longer than the outage you are fixing.

WHAT LATENCY AFFECTS

Applications separated from their database by distance.

WHY THAT MATTERS ENORMOUSLY

Each query pays the round trip, and applications issuing many queries become unusable.

WHAT TO DO

Keep application and database close, ideally on the same network.

WHAT POWER AFFECTS

On-premises servers, where unclean shutdown causes corruption.

WHAT PREVENTS IT

Backup power sufficient for a clean shutdown Durability settings that do not trade safety for speed

WHAT TO VERIFY ABOUT MANAGED SERVICES

Where data resides What it costs at your size, in local terms Whether you can export it

WHAT TO PLAN FOR

Costs rising with the exchange rate.

WHAT TO KEEP LOCALLY

Documentation and restore procedures.


Was this answer helpful?
Back

Are you happy with your experience? Leave us a review on Trustpilot.


Trustpilot