Database Parallel Execution
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 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.
MySQL Direct Connect Parallel Execution : Using MySQL Database Parallel Execution with Direct Connect
MariaDB Direct Connect Parallel Execution : Using MariaDB Database Parallel Execution with Direct Connect