I recently did an upgrade of 200+ nodes of Cassandra across multiple environments sitting behind multiple applications using the cstar tool. I chose the cstar tool because, out of all automation options, it has topology awareness specific to Cassandra. I will share my experience with this upgrade, including observations and surprises, as well as a walk-through of the process using a Cassandra cluster provisioned in Docker.
Upgrading large Cassandra clusters is simplified with cstar, which discovers cluster topology and executes commands in a topology-aware manner. This reduces downtime and risk, and practical tips include using verbose output and ensuring all nodes are up before starting. cstar’s automation and resilience make it ideal for complex, large-scale operations.
Security vulnerabilities in PostgreSQL related to the search_path setting can allow malicious users to inject trojan-horse functions or objects. Remediation includes removing the public schema from the default search_path and restricting object creation in public. Practical commands and best practices help secure PostgreSQL installations against these exploits.
Database administrators can proactively manage and predict resource usage in Apache Cassandra clusters using Facebook Prophet, an open-source forecasting tool.
I presented on online schema change methods in MySQL and MariaDB with my colleague at the M|18 conference at the Conrad in NYC.
Enabling InnoDB compression in MySQL improves storage efficiency and can boost performance for certain workloads. Configuration options and best practices help administrators implement compression effectively, balancing space savings with processing overhead.
Data encryption at rest in Oracle MySQL 5.7 protects sensitive information using key management and encryption algorithms. Configuring and managing encryption settings helps secure databases against unauthorized access and meets compliance requirements.
Recent vulnerabilities in MySQL related to file system access pose risks to data security. Understanding affected versions and applying recommended patches or configuration changes helps mitigate these threats and protect sensitive information.
Implementing data encryption at rest in MariaDB involves configuring encryption options and managing keys. Best practices ensure that sensitive data remains protected, supporting security and compliance in database environments.