Problem: A leading organization in the tech sector sought to optimize their database infrastructure by deploying MongoDB with a focus on scalability, security, and reliability. They required comprehensive guidance on deployment, load balancing, TLS implementation, role-based access control (RBAC), backup strategies, monitoring, and auditing to ensure a seamless transition to a production-ready environment. The client […]
Database 6 May 2024 Enhancing MongoDB User Management: Active Directory/LDAP Integration via Percona MongoDB and Proxy SolutionsProblem: The client requires Active Directory/LDAP integration for MongoDB user management similar to the Enterprise edition of MongoDB. This includes managing user permissions, creation, and deletion. Solution: To address the reported requirements, several potential solutions were put forth. Resolution 1. Utilize Percona MongoDB with LDAP Support: Implement LDAP support through Percona MongoDB. Conducted a Proof […]
Database 25 Apr 2024 Clarification Needed: Understanding Cassandra Replication Factor (RF) in Multi-Data Center ConfigurationsProblem: The issue stems from confusion surrounding the Replication Factor (RF) in Apache Cassandra, where the documentation implies RF determines the quantity of data copies, but clarity on this matter is lacking. Process: To address this issue, in-depth investigation took place. The team explored the information provided by the client: Cassandra Configurations: Cassandra Version: 4.0.1 […]
Database 24 Apr 2024 Resolving PostgreSQL Replication Alert DiscrepanciesProblem: The system is generating alerts indicating replication lag on the “productCatalog” PostgreSQL instance, specifically targeting the machine “pa3fnd02.” However, upon DBA investigation, there is no observable lag in the cluster, with both the leader (pa3fnd02) and the sync standby (pa3fnd01) reporting no lag. The discrepancy raises concerns about the persistence of alerts despite the […]
Database 23 Apr 2024 Capturing Logout Events in Cassandra 4.0.x Audit LogsProblem: The organization is using Cassandra 4.0.x in its Production environment and requires tracking login and logout details from the Cassandra Audit logs. However, the Audit logs only record LOGIN_SUCCESS, LOGIN_ERROR, and UNAUTHORIZED_ATTEMPT events, with no mention of LOGOUT events. The organization seeks clarification on mechanisms for capturing logout-related entries. Solution: Cassandra does not inherently […]
Database 20 Apr 2024 Handling DDL Changes and Replication Issues in Multi-DC Cassandra SetupProblem: The client operates a 6-node multi-DC replication setup for Cassandra, consisting of 3 nodes in the PROD datacenter (East US2) and 3 nodes in the DR datacenter (West US2). They are planning to perform DDL changes, including altering tables to adjust the default_time_to_live parameter and dropping and recreating a table with a new definition. […]
Database 18 Apr 2024 Resolving Data Discrepancies in Cassandra Cluster EnvironmentsProblem: The Production (Prod) and Disaster Recovery (DR) environments for Cassandra databases exhibit different sizes, as observed from the nodetool status output. The client needs to identify the reason behind this discrepancy and ensure the readiness and reliability of the Disaster Recovery environment for use in the event of a failure. Process: The client provided […]
Database 17 Apr 2024 Updating TTL on Сassandra tablesProblem: The issue revolves around an unexpected change in the TTL for our Cassandra cluster. There are approximately 28 tables, six of which contain around 2 million records each. The requirement is to update the TTL for these tables to three years. However, TTL is configured at the row level. The client seeks alternative methods […]
Database 16 Apr 2024 Designing a Scalable Cassandra Topology for Production: Architectural Considerations and Best PracticesProblem: The client sought consultation on the best way establishing the standard Cassandra topology for a production-ready environment. Process: Cassandra Configurations: 2 Data Centers (PROD and DR). Each DC has 3 nodes of Cassandra. 2 DC are part of one cluster, thereby forming a ring architecture of 6 nodes (3 PROD + 3 DR). RF […]
Database