Page 5 of 9

MySQL – Architecture and Components

This Blog will focus on MySQL logical and physical architecture overview. MySQL operates in networked environment using client/server architecture. A MySQL installation has the following major components.

  • MySQL Server
    • is also referred to as mysqld
    • Manage access to the actual database on disk or memory.
    • Is multithreaded
    • supports many simultaneous client connections
    • Supports multiple storage engines – both transactional or non-transactional
    • A single host can have multiple mysqld instances running.
  • Client programs
    • Utility to connect MySQL server.
    • programs are mysql, mysqladmin, mysqlcheck, mysqldump,mysqlimport, mysqlpump, mysqlsh, mysqlshow,mysqlslap
  • MySQL non-client programs.
    • Programs that act independently of the server.
    • myisamchk (table checks and repair operation) and myisampack (compressed read only version of MyISAM table)

Continue reading → MySQL – Architecture and Components

MySQL – Introduction

MySQL is a relational database management system or an RDBMS. It’s originally  developed by company founded in Sweden, MySQL AB.  It’s world’s most popular open source database.

MySQL Editions

Community Edition: Community Edition is the MySQL database for open source developers and technology enthusiasts who wan to get started with MySQL.  Its free of cost.

Enterprise Edition: Commercial customers have the flexibility of choosing from multiple editions to meet specific business and technical requirements.

  • MySQL Enterprise Edition
  • MySQL Standard Edition
  • MySQL Classic Edition
  • MySQL Cluster Carrier Grade Edition

Continue reading → MySQL – Introduction

Oracle 12.2 RDBMS – TFA is optional

Oracle Trace File Analyzer helps you perform real-time health monitoring, fault detection & diagnosis via a single interface. It will securely consolidate all distributed diagnostic data. TFA can be installed on the database nodes either stand alone or cluster nodes. It’s continuously available and watching your logs for significant problems that may affect your service. If desired it can also automatically collect the relevant diagnostics, when it sees these problems.

From 12.2, TFA is included with RDBMS software and again this is optional when we run the root.sh script. You can skip this if you don’t want. Continue reading → Oracle 12.2 RDBMS – TFA is optional

ORA-20079: full resync from primary database is not done with ORA-17627, RMAN-20051

Whenever a structural change is made on the primary, attempts to resync from the primary using db_unique_name during the standby RMAN backups, it fails with following error.
Db-unique-name for all databases participating in the Data Guard configuration has been configured. Continue reading → ORA-20079: full resync from primary database is not done with ORA-17627, RMAN-20051

Global Data Services (GDS) with Active Data Guard – High Availability

In this blog post, I will talk about how you can perform workload routing across the standby databases based on Database role with GDS. GDS provides this functionality without requiring Oracle Clusterware to be installed. But if clusterware is installed then GDS automatically register the global service to GI home. When role transition happens in Data Guard Broker configuration, GDS relocates the global services automatically as per the role attribute. There is no need to write custom logic or database startup triggers to achieve this behavior. Continue reading → Global Data Services (GDS) with Active Data Guard – High Availability

Global Data Services (GDS) – Set Up

What is Global Data Services??

Oracle 12c Database provides a powerful workload management feature called database services. Database services are named representations of one or more database instances. Database services allow you to group database workloads, ensure that client requests are routed to the optimal instance that offers a service, and provide high availability by transparently failing client connections over to surviving instances when a planned or unplanned instance outage occurs

Oracle Global Data Services (GDS) implements the Oracle Database service model across a set of replicated databases known as a Global Data Services configuration. The GDS is the replacement for the Oracle Grid Infrastructure for 11g database high availability. The GDC works perfectly with Oracle 12c CDB or PDB’s. Continue reading → Global Data Services (GDS) – Set Up