Documentation Home
X DevAPI User Guide
Download this Manual

Pre-General Availability Draft: 2017-05-19

2.2 Session Models

This section provides an overview of the XSession and NodeSession objects. The difference between XSession and NodeSession is that XSession abstracts the connection, meaning that it can be a connection to one or more MySQL Servers. A NodeSession does not abstract the connection and connects directly to only a single MySQL Server. An XSession is the default when connecting from MySQL Shell. This logical abstraction enables you to address a group of servers without requiring code changes. The following table illustrates the advantages of coding using XSession.

Feature

XSession

NodeSession

Session Type

Logical

Physical

Document support

Relational Table support

Full SQL Language support

-

The following features are available:

Feature

XSession

NodeSession

Session Type

Logical

Physical

Document support

Relational Table support

Transparent HA support

-

-

Vertical scaling support

-

-

Horizontal scaling support

-

-

Full SQL Language support

-

MySQL Shell offers an additional ClassicSession class which can be used to execute SQL on MySQL Servers not running X Plugin, see also Section 13.2, “MySQL Shell X DevAPI extensions”.


User Comments
Sign Up Login You must be logged in to post a comment.