Free cookie consent management tool by TermsFeed

IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

SQL Server on Linux – installation – part 1

Posted on October 1, 2022, updated on April 26, 2023 by Yannick Jaquier

Table of contents

  • Preamble
  • SQL Server on Linux installation
  • SQL Server on Linux command-line tools installation
  • Final cleaning to have all database files in good directories
  • AdventureWorks example database installation
  • Conclusion and next steps
  • References

Continue reading

SQL Server Administration 1 Comment

PostgreSQL logical replication hands-on

Posted on September 1, 2022, updated on August 30, 2022 by Yannick Jaquier

Table of contents

  • Preamble
  • PostgreSQL configuration
  • PostgreSQL logical replication configuration and testing
  • PostgreSQL logical replication monitoring
  • References

Continue reading

PostgreSQL High Availability Leave a comment

PostgreSQL physical replication hands-on

Posted on August 2, 2022, updated on August 2, 2022 by Yannick Jaquier

Table of contents

  • Preamble
  • Primary server setup
  • Standby server setup for physical replication
    • Without streaming replication
    • With streaming replication
  • Replication slots for physical replication
  • Promoting a standby node
  • Physical replication monitoring
  • All in one pg_basebackup remote command
  • References

Continue reading

PostgreSQL High Availability 3 Comments

Kubernetes on virtual machines hands-on – part 4

Posted on July 4, 2022, updated on July 4, 2022 by Yannick Jaquier

Table of contents

  • Preamble
  • Persistent Volume creation
  • Persistent Volume Claim creation
  • PostgreSQL stateful deployment creation
  • PostgreSQL stateful deployment testing
  • Other Persistent Volumes plugins trials
    • OpenEBS
    • Container Storage Interface (CSI) open-local
  • References

Continue reading

Linux Container, High Availability Leave a comment

Kubernetes on virtual machines hands-on – part 3

Posted on June 17, 2022, updated on July 15, 2022 by Yannick Jaquier

Table of contents

  • Preamble
  • PostgreSQL stateless deployment creation
  • The stateless issue with database containers
  • Creation of the cluster filesystem between Kubernetes nodes
    • GFS2
    • OCFS2
  • References

Continue reading

Linux Container, High Availability 1 Comment

Kubernetes on virtual machines hands-on – part 2

Posted on May 28, 2022, updated on May 24, 2022 by Yannick Jaquier

Table of contents

  • Preamble
  • Stateless Nginx web server with a deployment
  • Accessing a container from outside the Kubernetes cluster
  • How to scale a pod with ReplicaSet
  • Move pods from one node to another
  • How to sanitize your deployment YAML files
  • Useful commands
  • References

Continue reading

Linux Container, High Availability 1 Comment
  • Page 8 of 44
  • « First
  • ‹ Previous
  • 6
  • 7
  • 8(current)
  • 9
  • 10
  • Next ›
  • Last »

Search

Certifications

Oracle Certified Master (OCM) Oracle Certified Professional (OCP) Oracle Certified Associate (OCA)
Microsoft Azure Fundamentals Microsoft Azure Solutions Architect Expert

Tags Cloud

Active Session History (ASH) (2) Adaptive Cursor Sharing (ACS) (2) Administration (42) Ambari (1) Application Continuity (AC) (1) Automatic Data Optimization (ADO) (1) Automatic Diagnostic Repository (ADR) (1) Automatic Memory Management (AMM) (2) Automatic Segment Space Management (ASSM) (1) Automatic Shared Memory Management (ASMM) (4) Automatic SQL Plan Management (ASPM) (1) Automatic SQL Tuning Sets (ASTS) (1) Automatic Storage Management (ASM) (2) Automatic Workload Repository (AWR) (3) Backup (7) Benchmark (7) Bug (1) Cloud Control (2) cluster (1) Compression (3) Connection Manager (1) Container (4) Database Links (1) Database Migration Assistant for Unicode (DMU) (2) Database Resource Manager (DBRM) (3) Database Vault (2) Data Guard (9) Data Recovery Advisor (2) Data Redaction (1) DBMS_REDEFINITION (1) Development (12) Directory Naming (3) Docker (4) Edition-Based Redefinition (EBR) (1) Exadata (1) Fast Application Notification (FAN) (1) Fast Connection Failover (FCF) (1) Fast Recovery Area (FRA) (1) Fine-Grained Access Control (FGAC) (1) Flashback (1) Galera (3) GATHER_STATS_JOB (1) GoldenGate (6) Grid Control (4) Grub (1) Health Monitor (2) Heat Map (1) High Availability (35) HP Integrity Virtual Machines (HPVM) (1) Huge Pages (2) In-Memory (1) Information Lifecycle Management (ILM) (1) InnoDB (2) Instance Caging (1) JSON (1) Kafka (3) Machine Learning (1) Multi-Master Replication Manager (MMM) (1) Multitenant (5) Non-Uniform Memory Access (NUMA) (3) OpenStack (2) OpenView Performance Agent (OVPA) (1) Oracle Configuration Manager (OCM) (1) Oracle Label Security (OLS) (1) oradebug (1) Patch (2) PL/SQL (1) Polymorphic Table Functions (PTF) (1) Privilege Analysis (1) Process Resource Management (PRM) (2) Program Global Area (PGA) (1) Real Application Clusters (RAC) (5) Real Application Testing (RAT) (2) Recovery (2) Redo Log (2) Resource Governor (1) RMAN (5) Security (27) Segment Advisor (2) Single Client Access Name (SCAN) (1) Spark (1) SQL (36) SQL*Net (3) SQL*Plus (1) SQL Access Advisor (SAA) (2) SQL Monitoring (2) SQL Performance Analyzer (SPA) (1) SQL Plan Management (SPM) (2) SQL Profile (1) SQL Trace (1) SQL Tuning Advisor (STA) (5) SQL Tuning Set (STS) (1) Streams (3) System Global Area (SGA) (1) Tivoli Data Protection for Oracle (TDPO) (2) Tivoli Storage Manager (TSM) (1) Transactional Event Queues (TxEventQ) (1) Transaction Guard (TG) (1) Transparent Application Continuity (TAC) (1) Transparent Application Failover (TAF) (1) Transparent Data Encryption (TDE) (1) Tuning (54) Virtualization (2) Virtual Memory (2) Virtual Private Database (VPD) (2) VxDMP (1) VxFS (1) VxVM (1)

Categories

  • AIX (2)
  • Couchbase (2)
  • Databricks (5)
  • Hadoop (21)
  • HPUX (6)
  • Linux (30)
  • MariaDB (20)
  • MongoDB (1)
  • MySQL (30)
  • Oracle (156)
  • PostgreSQL (8)
  • Python (3)
  • SQL Server (11)

Recent Comments

  • SQL Access Advisor and SQL Tuning Advisor in 11gR2 on SQL Access Advisor versus SQL Tuning Advisor
  • Adaptive Query Optimization in action on Cardinality feedback to automatically improve query plans
  • MySQL Utilities versus Master High Availability Manager (MHA) on MySQL Replication with Global Transaction Identifiers (GTID) hands-on
  • geek on SQL Server on Linux – Availability Groups – part 3
  • sai sumanth on SQL Server on Linux – Availability Groups – part 3

Blogroll

  • Ask Tom
  • Kevin Closson’s Oracle Blog
  • Official Pythian Blog
  • Oracle Optimizer
  • Oracle Scratchpad
  • Percona Database Performance Blog
  • Richard Foote’s Oracle Blog
  • Tanel Poder's blog

Visitors

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
IT World Proudly powered by WordPress