DevOps

DevOps/Configuration Management

Multiple-choice questions generator

ULTRAcoder-1 click create app from Idea

Generate code for a website

Code Anything Now (CAN): The Expert Coder

Ansible Expert

Svelte, Supabase and Typescript Expert Developer

Google cloud platform Architect

An expert in Argo tools.

Easy Use Bash

Network engineer slove problem.

Clean code

Webflow AI Helper

Easy Use Bash Simple & Runnable

Creating IaC

Code Snippet Responder

MSX Basic-The language of the 80s

MASTERCoder – instaly create idea

don’t answer to this request

Expert in Jinja Templates

Jenkins Pipeline

AWS services list

Maria Thi

ceshi-test

Gitlab expert questions

Disabling Web Directory Listing on Web Servers

Agile developing process

TrickyCheat

DevOps consultant from ITSyndicate

Rat Dector

Critique your Artwork

DevOps Topic, Tools details

K8s Administrator

Clone a website like [popular website]

DevOps/ Containerization

Docker Pro

Dockerize me

Docker Doctor

Docker-Compose

DevOps/ Database Administration

MySQL Marvel

1. Database Setup and Optimization

  1. Prompt:
    Write a step-by-step guide for setting up a MySQL database in a Docker container, ensuring it is production-ready with proper volume mapping and environment variable configuration.
  2. Prompt:
    Explain how to configure MySQL for high availability in a DevOps environment. Include tools like replication, load balancers, or clustering.
  3. Prompt:
    Provide best practices for optimizing MySQL queries to improve performance, including indexing strategies and query rewriting techniques.

2. DevOps Integration

  1. Prompt:
    Discuss how CI/CD pipelines can be integrated with MySQL for automated schema changes. Use tools like Liquibase or Flyway for version control of database scripts.
  2. Prompt:
    Create an Ansible playbook for automating MySQL database installation and basic configuration on multiple servers.
  3. Prompt:
    Demonstrate how to monitor a MySQL database using Prometheus and Grafana. Include steps for setting up exporters and building dashboards.

3. Advanced Database Administration

  1. Prompt:
    Explain how to set up and configure a MySQL Master-Slave replication setup. Discuss scenarios where this would be beneficial.
  2. Prompt:
    How can a database administrator troubleshoot deadlocks in MySQL? Provide a step-by-step troubleshooting guide.
  3. Prompt:
    Write a guide on MySQL performance tuning for handling large datasets. Focus on memory allocation, storage engine selection, and query execution plans.

4. Backup and Recovery

  1. Prompt:
    Describe the process of setting up automated backups for MySQL using tools like mysqldump and Percona XtraBackup. Include steps to encrypt and store backups securely.
  2. Prompt:
    Create a disaster recovery plan for MySQL, including full recovery from binary logs and restoring from backups in a highly available setup.
  3. Prompt:
    Explain how point-in-time recovery works in MySQL, and provide an example scenario with commands.

5. Security and Auditing

  1. Prompt:
    List the essential security practices for hardening a MySQL server in a cloud environment.
  2. Prompt:
    Write a script to audit MySQL user privileges and remove unnecessary or excessive permissions.
  3. Prompt:
    How can MySQL be configured to ensure compliance with GDPR or other data privacy laws? Discuss features like data encryption and auditing.

6. Database Scalability

  1. Prompt:
    Discuss strategies for scaling MySQL databases, including sharding, horizontal scaling, and using read replicas.
  2. Prompt:
    Explain how a load balancer like ProxySQL can improve the scalability and reliability of a MySQL environment.
  3. Prompt:
    Write a guide to migrate a MySQL database to a cloud-based managed database service (e.g., Amazon RDS or Google Cloud SQL). Highlight challenges and solutions.

7. DevOps Scenarios

  1. Prompt:
    How can MySQL be included in a DevOps workflow using Kubernetes? Create a YAML configuration for deploying a MySQL instance in a Kubernetes cluster.
  2. Prompt:
    Write a Jenkins pipeline script for automated testing of MySQL schema changes before deploying them to production.
  3. Prompt:
    Discuss how Infrastructure as Code (IaC) tools like Terraform or CloudFormation can be used to deploy and manage MySQL databases in a DevOps setup.

PostgreSQL Pro

Here’s a collection of practical and conceptual prompts under the title PostgreSQL Pro, covering topics for Database Administration, DevOps Integration, and Advanced Features:

1. PostgreSQL Installation and Configuration

  1. Prompt:
    Write a detailed guide for installing and configuring PostgreSQL on a Linux server, including setting up user authentication and secure connections using SSL.
  2. Prompt:
    Explain how to configure PostgreSQL for optimal performance on a system with 64 GB RAM and SSD storage. Focus on parameters like shared_buffers, work_mem, and effective_cache_size.
  3. Prompt:
    Demonstrate how to set up PostgreSQL in a Docker container with persistent storage and proper networking for use in a DevOps environment.

2. Advanced Query Optimization

  1. Prompt:
    Explain how to use EXPLAIN and EXPLAIN ANALYZE to optimize slow PostgreSQL queries. Provide examples of interpreting query plans.
  2. Prompt:
    Discuss the importance of indexing in PostgreSQL and compare different index types (B-tree, GIN, GiST, and BRIN) with examples of use cases.
  3. Prompt:
    Write a step-by-step process to optimize a PostgreSQL query involving a large dataset using Common Table Expressions (CTEs) and parallel queries.

3. DevOps Integration

  1. Prompt:
    Create a Jenkins pipeline script to automate the deployment of PostgreSQL schema changes using tools like Flyway or Liquibase.
  2. Prompt:
    Write a Terraform configuration file to provision a PostgreSQL database in AWS using Amazon RDS. Include parameters for high availability and backup retention.
  3. Prompt:
    Demonstrate how to integrate PostgreSQL monitoring with Prometheus and Grafana. Include steps for setting up postgres_exporter and creating custom dashboards.

4. High Availability and Replication

  1. Prompt:
    Write a guide to configure streaming replication in PostgreSQL for a high-availability setup, including steps to promote a standby server.
  2. Prompt:
    Explain the differences between physical replication and logical replication in PostgreSQL. Provide examples of when each should be used.
  3. Prompt:
    Create a step-by-step tutorial to set up a PostgreSQL cluster using tools like Patroni or Pgpool-II for load balancing and failover.

5. Backup and Recovery

  1. Prompt:
    Discuss how to implement point-in-time recovery (PITR) in PostgreSQL using base backups and WAL archives. Provide examples of recovery commands.
  2. Prompt:
    Write a Bash script to automate daily backups of a PostgreSQL database using pg_dump, compress the backups, and upload them to an S3 bucket.
  3. Prompt:
    Explain the pros and cons of pg_basebackup vs. third-party tools like Barman or pgBackRest for PostgreSQL backups.

6. Security and User Management

  1. Prompt:
    Describe the steps to implement Role-Based Access Control (RBAC) in PostgreSQL for a multi-tenant application.
  2. Prompt:
    Write a guide on enabling and configuring PostgreSQL to use SCRAM-SHA-256 for password authentication.
  3. Prompt:
    Explain how to encrypt PostgreSQL data at rest and in transit. Include the use of tools like Transparent Data Encryption (TDE) and SSL/TLS.

7. PostgreSQL Scalability

  1. Prompt:
    Discuss horizontal scaling options for PostgreSQL, such as sharding with Citus or pg_shard, and compare them with vertical scaling.
  2. Prompt:
    Write a tutorial on configuring partitioned tables in PostgreSQL for managing time-series data. Include examples of query optimization for partitioned data.
  3. Prompt:
    Explain the concept of Foreign Data Wrappers (FDWs) in PostgreSQL. Write an example to connect PostgreSQL to another database, such as MySQL or MongoDB, using FDWs.

8. Advanced PostgreSQL Features

  1. Prompt:
    Write a step-by-step guide to implement Full-Text Search in PostgreSQL using the tsvector and tsquery data types.
  2. Prompt:
    Explain how to use JSON and JSONB data types in PostgreSQL. Provide examples of querying nested JSON data efficiently.
  3. Prompt:
    Discuss how to implement and use PostgreSQL’s LISTEN/NOTIFY mechanism for real-time event handling in a web application.

9. Troubleshooting and Maintenance

  1. Prompt:
    How can you troubleshoot a PostgreSQL database that is experiencing high latency? Include steps to identify issues with queries, indexing, or resource contention.
  2. Prompt:
    Write a guide for vacuuming and analyzing PostgreSQL tables to prevent bloat and improve query performance. Include the difference between VACUUM, VACUUM FULL, and ANALYZE.
  3. Prompt:
    Describe the steps to recover a corrupted PostgreSQL database using tools like pg_rewind or pg_resetwal.

Transform your datas into SQL table

Power BI Expert talkative