Work Cassandra quick ref This is handy cheatsheet for myself. Connection cqlsh # local connect cqlsh <host> <port> # remote cqlsh -u <user> -p <pass> # with auth Keyspace Ops -- create CREATE KEYSPACE ks_name WITH replication = {'class':'SimpleStrategy', 'replication_factor':3}
Work Azure certifications Yayy!! I got my AZ-900 and AI-900 certificates. Now I can say I know Azure and you must beleive me :P Despite my keen interest in VLSI and electronics in general, I ended up doing database engineerign for most part of my life. I've dealt with on-premise installations
From Oracle to Cassandra After eight years of working with Oracle databases, I thought I understood distributed systems pretty well. Oracle RAC, Data Guard, partitioning - I'd done it all. Then I encountered Apache Cassandra, and realized I needed to unlearn almost everything I knew about databases. The First Shock: No Master
Art of SOPs Standard Operating Procedures for technical operations often fall into two traps: either they're so vague they're useless ("restart the service if it fails"), or so rigid they become obsolete the moment your infrastructure changes. The best technical SOPs strike a balance—specific enough to
Oracle Data Guard Imagine you run a popular clothing store in a busy shopping district. Every day, customers come in, buy items, and you carefully record each transaction in your ledger. Business is booming, but you have a nagging worry: What if something happens to my store? A fire, a flood, a power
Why I write here? Last Tuesday, I spent forty minutes trying to remember how I'd solved that gnarly Redis caching issue. You know, the one that had me pulling my hair out for three days straight back in March? The elegant solution I was so proud of? The one I swore I&
DB Backups... Every database administrator has faced that moment of dread—realizing that critical data might be lost, corrupted, or compromised. Whether it's hardware failure, human error, or a ransomware attack, the question isn't if you'll need your backups, but when. Understanding the different backup strategies
Zero Downtime Migrations: Oracle GoldenGate in Practice In today's always-on digital economy, database downtime is no longer acceptable. Whether you're migrating to the cloud, upgrading infrastructure, or consolidating data centers, businesses demand zero interruption to their operations. This is where Oracle GoldenGate shines as a battle-tested solution for real-time data replication and zero-downtime