Outils pratiques pour administrateurs systèmes, réseaux, sécurité et exploitation.

OPS

Bureau exploitation

Le bureau partagé : incidents, configuration, et le liant entre équipes. Pour celles et ceux qui siègent entre les titres.

1561–1584 / 1864

Database Naming Convention Checker

Actif

Check tables/columns against naming standards. The result stays on this page.

Ouvrir l'outil

Data Type Selector

Actif

Recommend column types by data and engine. The result stays on this page.

Ouvrir l'outil

Schema Documentation Generator

Actif

Schema Documentation Generator. Generate data dictionary from DDL. The result stays on this page.

Ouvrir l'outil

Foreign Key Relationship Explorer

Actif

Foreign Key Relationship Explorer. Visualize foreign key dependencies. The result stays on this page.

Ouvrir l'outil

Column Size Estimator

Actif

Bytes per row by column types and engine. The result stays on this page.

Ouvrir l'outil

Audit Table Generator

Actif

Audit Table Generator. Generate history tables and triggers. The result stays on this page.

Ouvrir l'outil

Star Schema Designer

Actif

Star Schema Designer. Design fact and dimension tables. The result stays on this page.

Ouvrir l'outil

Slowly Changing Dimension Generator

Actif

Slowly Changing Dimension Generator. Generate SCD Type 1/2 logic. The result stays on this page.

Ouvrir l'outil

Oracle Execution Plan Analyzer

Actif

Oracle Execution Plan Analyzer. Interpret DBMS_XPLAN output. The result stays on this page.

Ouvrir l'outil

Composite Index Column Order Helper

Actif

Choose column order for multi-column indexes. The result stays on this page.

Ouvrir l'outil

Covering Index Builder

Actif

Covering Index Builder. Build covering/INCLUDE indexes. The result stays on this page.

Ouvrir l'outil

Index Size Estimator

Actif

Estimate index size from rows and key columns. The result stays on this page.

Ouvrir l'outil

Sargability Checker

Actif

Detect non-sargable predicates in queries. The result stays on this page.

Ouvrir l'outil

pg_stat_statements Analyzer

Actif

Rank queries from pg_stat_statements output. The result stays on this page.

Ouvrir l'outil

Oracle AWR Report Analyzer

Actif

Oracle AWR Report Analyzer. Summarize AWR reports into top issues. The result stays on this page.

Ouvrir l'outil

Lock Compatibility Matrix

Actif

Interactive lock compatibility by engine. The result stays on this page.

Ouvrir l'outil

Isolation Level Simulator

Actif

Simulate dirty/non-repeatable/phantom reads. The result stays on this page.

Ouvrir l'outil

PostgreSQL Checkpoint & WAL Tuner

Actif

Tune max_wal_size and checkpoint settings. The result stays on this page.

Ouvrir l'outil

ProxySQL Config Generator

Actif

Generate ProxySQL hostgroups and query rules. The result stays on this page.

Ouvrir l'outil

Barman Config Generator

Actif

Barman Config Generator. Generate Barman server config. The result stays on this page.

Ouvrir l'outil

Backup Encryption Planner

Actif

Plan backup encryption and key storage. The result stays on this page.

Ouvrir l'outil

Replication Topology Planner

Actif

Design primary/replica/multi-site layouts. The result stays on this page.

Ouvrir l'outil

Galera Cluster Config Generator

Actif

Generate MariaDB/Percona Galera configs. The result stays on this page.

Ouvrir l'outil

MySQL InnoDB Cluster Planner

Actif

MySQL InnoDB Cluster Planner. Plan Group Replication and Router. The result stays on this page.

Ouvrir l'outil