Menu

#323 Multiple primary nodes in XC

Development Queue
open
SQL query (126)
5
2013-06-11
2012-07-24
No

Now in XC it is possible to define multiple primary nodes with CREATE NODE, however only one node is really registered in the session parameters.

Multiple nodes are basically necessary because some tables might be distributed on a subset of nodes that do not contain primary.
So what is necessary here is to add support for multiple primary nodes, and enforce the correct selection of a primary node if it is contained.
In case no primary node can be found in the node list of relation, we need to pick up the 1st one.

Discussion

  • Koichi Suzuki

    Koichi Suzuki - 2012-09-11

    Q3.

    Each coordinator should assign the same primary node for a given table. Different table may have different primary node.

    At present, we have only one primary node common to all the replicated table, which is visible to DBA, but this may not be visible. Coordinator handling create table can assign one of the available datanode as the primary node and propagate it to all the other coordinators.

     
  • Koichi Suzuki

    Koichi Suzuki - 2013-03-12

    Nor a beta blocker.

    Table-specific primary node will eliminate this problem.

     
  • Koichi Suzuki

    Koichi Suzuki - 2013-03-12
    • assigned_to: michaelpq --> amitdkhan
     
  • Koichi Suzuki

    Koichi Suzuki - 2013-03-12
    • assigned_to: amitdkhan --> gabbasb
     
  • Koichi Suzuki

    Koichi Suzuki - 2013-06-11
    • milestone: 2663467 --> Development Queue
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.