Homepage on Valerie Parham-Thompson: Database architecture for teams ready to launch and scale

Covering indexes in PostgreSQL allow queries to be satisfied directly from the index, reducing I/O by leveraging the visibility map.

Security vulnerabilities in PostgreSQL related to the search_path setting can allow malicious users to inject trojan-horse functions or objects.

Database administrators can proactively manage and predict resource usage in Apache Cassandra clusters using Facebook Prophet, an open-source forecasting tool.

Managing transactional workloads in Cassandra involves choosing appropriate consistency levels and leveraging lightweight transactions for ACID-like guarantees.

Nodetool is a powerful administrative tool for Cassandra, offering commands for cluster management, monitoring, and maintenance.

Nodetool provides detailed information about Cassandra cluster status, node health, and performance metrics.

The nodetool utility in Cassandra enables snapshot creation and restoration for backups.

I presented on online schema change methods in MySQL and MariaDB with my colleague at the M|18 conference at the Conrad in NYC.

Generating random test data in MySQL is straightforward with SQL techniques and functions.

The MariaDB Connect Engine enables federated queries across diverse data sources, making it possible to integrate and analyze data from multiple systems.

gh-ost is a tool for performing online schema changes in MySQL, offering advantages over traditional ALTER TABLE operations.

Enabling InnoDB compression in MySQL improves storage efficiency and can boost performance for certain workloads.

Data encryption at rest in Oracle MySQL 5.7 protects sensitive information using key management and encryption algorithms.

Recent vulnerabilities in MySQL related to file system access pose risks to data security.

Implementing data encryption at rest in MariaDB involves configuring encryption options and managing keys.

MySQL’s Performance Schema enables detailed query profiling and analysis.

Embedding comments in MySQL queries helps trace their origin and purpose.