[MCOL-3554] mcsapi - port specification through Columnstore.xml Created: 2019-10-11  Updated: 2023-10-26  Resolved: 2019-12-03

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.4.0
Fix Version/s: 1.4.1

Type: New Feature Priority: Major
Reporter: Jens Röwekamp (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: SkySQLMVP

Attachments: XML File ColumnStore-singlenode-client-minimal.xml    
Sprint: 2019-06

 Description   

Currently mcsapi uses the ColumnStore default ports to connect to.
This patch should allow mcsapi to use non-default ports as specified in Columnstore.xml

It should further add an optional Columnstore.xml entry to skip the Columnstore version check against the ProcMon port. This is useful as we need to expose as less ports as possible for SkySQL.
As SkySQL will use stable ColumnStore versions only, the version check could be skipped and the ProcMon port not exposed to our customers.

 Comments   
Comment by Jens Röwekamp (Inactive) [ 2019-10-15 ]
  • mcsapi uses the ports as defined in Columnstore.xml
  • added an optional client side Columnstore.xml flag 

     <SkySQL>SkipVersionCheck>Y</SkipVersionCheck></SkySQL>

    to skip the ProcMon version check

  • (py|java)mcsapi test suite successfully executed against ColumnStore 1.2.2 on Debian 9
  • manual pymcsapi connection test with minimal Columnstore.xml (SkipVersionCheck flag and no ProcMon entry) successful on Debian 9
Comment by Jens Röwekamp (Inactive) [ 2019-10-15 ] 

jens@debian9:~$ python3
 
Python 3.5.3 (default, Sep 27 2018, 17:25:39)
 
[GCC 6.3.0 20170516] on linux
 
Type "help", "copyright", "credits" or "license" for more information.
 
>>> import pymcsapi
 
>>> d = pymcsapi.ColumnStoreDriver("/home/jens/ColumnStore-singlenode-client-minimal.xml")
 
>>> b = d.createBulkInsert("test", "ti", 0, 0)
 
>>> d.listTableLocks()
 
(<pymcsapi.TableLockInfo; proxy of <Swig Object of type 'mcsapi::TableLockInfo *' at 0x7fd3a90a3b40> >,)
 
>>> b.rollback()
 
>>> exit()

Comment by Daniel Lee (Inactive) [ 2019-12-03 ]

Patch has been verified and used by the SkySQL team

Generated at Thu Feb 08 02:43:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.