Documentation Home
MySQL Utilities 1.5 Manual
Related Documentation Download this Manual
PDF (US Ltr) - 1.5Mb
PDF (A4) - 1.5Mb
HTML Download (TGZ) - 289.5Kb
HTML Download (Zip) - 301.7Kb


MySQL Utilities 1.5 Manual  /  ...  /  Dump Commands

8.4.2 Dump Commands

The dump commands are designed to be used by the connectors to retrieve information on shards, high-availability groups and their servers.

  • Command: dump shard_maps: Return information about all shard mappings matching any of the provided patterns. If no patterns are provided, dump information about all shard mappings.

    Usage:
      mysqlfabric  dump shard_maps [--connector_version=CONNECTOR_VERSION]      
                   [--patterns=]                                                
    
    Options:
      --connector_version=CONNECTOR_VERSION                                     
                           The connectors version of the data. By default None. 
      --patterns=PATTERNS  shard mapping pattern. By default "".
  • Command: dump servers: Return information about the index for all mappings matching any of the patterns provided. If no pattern is provided, dump the entire index. The lower_bound that is returned is a string that is a md-5 hash of the group-id in which the data is stored.

    Usage:
      mysqlfabric  dump servers [--connector_version=CONNECTOR_VERSION]         
                   [--patterns=]                                                
    
    Options:
      --connector_version=CONNECTOR_VERSION                                     
                           The connectors version of the data. By default None. 
      --patterns=PATTERNS  group pattern. By default "".
  • Command: dump shard_index: Return information about servers. The servers might belong to any group that matches any of the provided patterns, or all servers if no patterns are provided.

    Usage:
      mysqlfabric  dump shard_index [--connector_version=CONNECTOR_VERSION]     
                   [--patterns=]                                                
    
    Options:
      --connector_version=CONNECTOR_VERSION                                     
                           The connectors version of the data. By default None. 
      --patterns=PATTERNS  group pattern. By default "".
  • Command: dump sharding_information: Return information about all shard mappings matching any of the provided patterns. If no patterns are provided, dump information about all shard mappings.

    Usage:
      mysqlfabric  dump shard_maps [--connector_version=CONNECTOR_VERSION]      
                   [--patterns=]                                                
    
    Options:
      --connector_version=CONNECTOR_VERSION                                     
                           The connectors version of the data. By default None. 
      --patterns=PATTERNS  shard mapping pattern. By default "".
  • Command: dump shard_tables: Return information about all tables belonging to mappings matching any of the provided patterns. If no patterns are provided, dump information about all tables.

    Usage:
      mysqlfabric  dump shard_tables [--connector_version=CONNECTOR_VERSION]    
                   [--patterns=]                                                
    
    Description:
    
    
    Options:
      --connector_version=CONNECTOR_VERSION                                     
                           The connectors version of the data. By default None. 
      --patterns=PATTERNS  shard mapping pattern. By default "".
  • Command: dump fabric_nodes: Return a list of Fabric Nodes (i.e. addresses). Specifically, the host and port are returned. If the protocol is not specified, it assumes the 'protocol.xmlrpc'. Currently, the 'protocol.xmlrpc' and 'protocol.mysql' are valid options.

    Usage:
      mysqlfabric  dump fabric_nodes [--protocol=PROTOCOL]                      
    
    Options:
      --protocol=PROTOCOL  MySQL Fabric might support different protocols which 
                           have different addresses. By default None.           
    
    Return:
      List with existing Fabric Servers. ["host:port", ...]

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