[MCOL-499] support disabling exemgr round robin and use local exemgr Created: 2017-01-10  Updated: 2020-04-02  Resolved: 2020-04-02

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.0.6
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: David Thompson (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 0
Labels: None

Sprint: 2017-14, 2017-15, 2017-16

 Description   

Add a configuration option for a multi um deployment to always use the local exemgr rather than round robinning between the exemgrs. The system default value should remain as round robin as this can still be useful if a customer does not use the multiple mysqld instances.



 Comments   
Comment by David Hall (Inactive) [ 2017-01-12 ]

mcsadmin command
UMRoundRobin off/On enable/disable

Comment by David Hill (Inactive) [ 2017-02-28 ]

This type of query control is requested by a customer. I don't know if it can be done as part of this feature.

https://support.mariadb.com/view.php?id=13592

Ok, so say we set it so UM2 does not route queries.

And all the others queries came in on UM1. Would UM1 route queries to UM3, and if a UM4 existed to UM4, but not to UM2?

Comment by David Hill (Inactive) [ 2017-07-11 ]

Implementing this feature by updating the ExeMgr Ip address accordingly in the Columnstore.xml, so no code changes are required at the connector leave.

Also will look at implementing to allow based on the comment from 2017-02-28.
Disable round-robin on a selected number of um1s

Comment by David Hill (Inactive) [ 2017-08-30 ]

lets push this feature change out, not part of 1.1.0 beta

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