Database Parallel Execution

From Vendita MAS
Jump to: navigation, search

MAS Parallel Execution

MAS Parallel Execution allows a single SQL script to be run against more than one database server. This capability is supported for Oracle RDBMS, Microsoft SQL Server, MySQL, and MariaDB. This capability with each database allows for a single SQL statement to be executed, with results returned in the jobs output window. There is a special version of MAS Parallel Execution available for Oracle SQLPlus, that allows more complex queries with SQLPlus formatting. See the diagrams below for these two paradigms.

Parallel Execution for
Oracle, MS SQL, MySQL, MariaDB
Parallel Execution
for Oracle SQLPlus
Direct Connect to Database

One MAS account is created for a service account.

The service account must be
available on all database servers.

Connect to SSH then Oracle via SQLPlus

A MAS SSL account and MAS Oracle account

must exist for every database server.


Parallel Execution with Direct Connect requires the use of a common service account that exists on all database servers. This service account must have a common username and password that is available on all database servers. MAS Parallel Execution for Oracle SQLPlus does not require the use of a service account, but instead requires a SSH account and Oracle account be provided for every database. The account information used for parallel execution is provided to MAS by using a MAS form. The MAS form is created from a MAS prototype. The sections which follow document procedures for each of the five features. MAS contains all drivers needed to connect to the databases, only a username or password is required. Prior to establishing a connection to the databases, ensure that network firewall rules allow connectivity between MAS and all databases.



Oracle

Oracle Direct Connect Parallel Execution : Using Oracle Database Parallel Execution with Direct Connect
SQLPlus Parallel Execution : Using Oracle Parallel Execution for SQLPlus

MySQL

MySQL Direct Connect Parallel Execution : Using MySQL Database Parallel Execution with Direct Connect

MariaDB

MariaDB Direct Connect Parallel Execution : Using MariaDB Database Parallel Execution with Direct Connect