cosmicoppai.comTraceroute: Not so hardI’m sure most of you might have already heard about traceroute. If not, it’s a command line tool generally used to trace the path of the packet over the network. I recently came across the implementation detail of it, and it’s surprisingly simple to ...Oct 4, 2025·6 min read
cosmicoppai.comBastion HostBastion host or server is a server mainly for jumping connection, especially ssh connection. It’s also known as jump server The reason is mainly for security and to reduce the attack surface. Only bastion server is exposed to the outer world and all ...Jun 19, 2025·4 min read
cosmicoppai.comRestoring MySQL replica from sourceIn this article, I’m going to dig into, how you can restore your replica from the source. The reason can vary from huge lag to data discrepancy etc… The overview of steps would look like: Note the master LOG_POS and LOG_FILE Take snapshot of data v...Mar 24, 2025·2 min read
cosmicoppai.compt-table-syncI recently had a situation when a lot of rows from one of our replicas was missing.One of the solutions that came in mind is to use the snapshot of the source and reconfigure it as replica. While this would have worked, it seemed like an extreme appr...Mar 17, 2025·2 min read
cosmicoppai.comUnderstanding Python SlotsHow about explicitly declaring class attributes or reducing memory footprint of class variables. Slots seems to be an answer. slots (__slots__) a special class variable that is assigned a sequence of strings that are variable names used by instance...Nov 8, 2024·2 min read