Rechercher dans le manuel MySQL

22.3.3.13 SCI Transport Connections in NDB Cluster

Inhoudsopgave

[sci] sections in the config.ini file explicitly define SCI (Scalable Coherent Interface) connections between cluster nodes. Using SCI transporters in NDB Cluster requires specialized hardware as well as specially-built MySQL binaries; compiling such binaries is not supported using an NDB 8.0 distribution.

The following parameters are present in NDB source code as well as the output of ndb_config and other NDB programs, but are currently nonfunctional:

  • NodeId1

    Table 22.320 This table provides type and value information for the NodeId1 SCI configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units numeric
    Default [none]
    Range 1 - 255
    Restart Type N

    To identify a connection between two nodes it is necessary to provide node identifiers for each of them, as NodeId1 and NodeId2.

  • NodeId2

    Table 22.321 This table provides type and value information for the NodeId2 SCI configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units numeric
    Default [none]
    Range 1 - 255
    Restart Type N

    To identify a connection between two nodes it is necessary to provide node identifiers for each of them, as NodeId1 and NodeId2.

  • Host1SciId0

    Table 22.322 This table provides type and value information for the Host1SciId0 SCI configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units unsigned
    Default [none]
    Range 0 - 4294967039 (0xFFFFFEFF)
    Restart Type N

    This identifies the SCI node ID on the first Cluster node (identified by NodeId1).

  • Host1SciId1

    Table 22.323 This table provides type and value information for the Host1SciId1 SCI configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units unsigned
    Default 0
    Range 0 - 4294967039 (0xFFFFFEFF)
    Restart Type N

    It is possible to set up SCI Transporters for failover between two SCI cards which then should use separate networks between the nodes. This identifies the node ID and the second SCI card to be used on the first node.

  • Host2SciId0

    Table 22.324 This table provides type and value information for the Host2SciId0 SCI configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units unsigned
    Default [none]
    Range 0 - 4294967039 (0xFFFFFEFF)
    Restart Type N

    This identifies the SCI node ID on the second Cluster node (identified by NodeId2).

  • Host2SciId1

    Table 22.325 This table provides type and value information for the Host2SciId1 SCI configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units unsigned
    Default 0
    Range 0 - 4294967039 (0xFFFFFEFF)
    Restart Type N

    When using two SCI cards to provide failover, this parameter identifies the second SCI card to be used on the second node.

  • HostName1

    Table 22.326 This table provides type and value information for the HostName1 SCI configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units name or IP address
    Default [none]
    Range ...
    Restart Type N

    The HostName1 and HostName2 parameters can be used to specify specific network interfaces to be used for a given SCI connection between two nodes. The values used for these parameters can be host names or IP addresses.

  • HostName2

    Table 22.327 This table provides type and value information for the HostName1 SCI configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units name or IP address
    Default [none]
    Range ...
    Restart Type N

    The HostName1 and HostName2 parameters can be used to specify specific network interfaces to be used for a given SCI connection between two nodes. The values used for these parameters can be host names or IP addresses.

  • SharedBufferSize

    Table 22.328 This table provides type and value information for the SharedBufferSize SCI configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units unsigned
    Default 10M
    Range 64K - 4294967039 (0xFFFFFEFF)
    Restart Type N

    Each SCI transporter has a shared memory segment used for communication between the two nodes. Setting the size of this segment to the default value of 1MB should be sufficient for most applications. Using a smaller value can lead to problems when performing many parallel inserts; if the shared buffer is too small, this can also result in a crash of the ndbd process.

  • SendLimit

    Table 22.329 This table provides type and value information for the SendLimit SCI configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units unsigned
    Default 8K
    Range 128 - 32K
    Restart Type N

    A small buffer in front of the SCI media stores messages before transmitting them over the SCI network. By default, this is set to 8KB. Our benchmarks show that performance is best at 64KB but 16KB reaches within a few percent of this, and there was little if any advantage to increasing it beyond 8KB.

  • SendSignalId

    Table 22.330 This table provides type and value information for the SendSignalId SCI configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units boolean
    Default true
    Range true, false
    Restart Type N

    To trace a distributed message it is necessary to identify each message uniquely. When this parameter is set to Y, message IDs are transported over the network. This feature is disabled by default in production builds, and enabled in -debug builds.

  • Checksum

    Table 22.331 This table provides type and value information for the Checksum SCI configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units boolean
    Default false
    Range true, false
    Restart Type N

    This parameter is a boolean value, and is disabled by default. When Checksum is enabled, checksums are calculated for all messages before they are placed in the send buffer. This feature prevents messages from being corrupted while waiting in the send buffer. It also serves as a check against data being corrupted during transport.

  • OverloadLimit

    Table 22.332 This table provides type and value information for the OverloadLimit SCI configuration parameter

    Property Value
    Version (or later) NDB 8.0.13
    Type or units bytes
    Default 0
    Range 0 - 4294967039 (0xFFFFFEFF)
    Restart Type N

    When more than this many unsent bytes are in the send buffer, the connection is considered overloaded. See Section 22.3.3.14, “Configuring NDB Cluster Send Buffer Parameters”, for more information.


Zoek in de MySQL-handleiding

Nederlandse vertaling

U hebt gevraagd om deze site in het Nederlands te bezoeken. Voor nu wordt alleen de interface vertaald, maar nog niet alle inhoud.

Als je me wilt helpen met vertalingen, is je bijdrage welkom. Het enige dat u hoeft te doen, is u op de site registreren en mij een bericht sturen waarin u wordt gevraagd om u toe te voegen aan de groep vertalers, zodat u de gewenste pagina's kunt vertalen. Een link onderaan elke vertaalde pagina geeft aan dat u de vertaler bent en heeft een link naar uw profiel.

Bij voorbaat dank.

Document heeft de 26/06/2006 gemaakt, de laatste keer de 26/10/2018 gewijzigd
Bron van het afgedrukte document:https://www.gaudry.be/nl/mysql-rf-mysql-cluster-sci-definition.html

De infobrol is een persoonlijke site waarvan de inhoud uitsluitend mijn verantwoordelijkheid is. De tekst is beschikbaar onder CreativeCommons-licentie (BY-NC-SA). Meer info op de gebruiksvoorwaarden en de auteur.

Referenties

  1. Bekijk - html-document Taal van het document:en Manuel MySQL : https://dev.mysql.com/

Deze verwijzingen en links verwijzen naar documenten die geraadpleegd zijn tijdens het schrijven van deze pagina, of die aanvullende informatie kunnen geven, maar de auteurs van deze bronnen kunnen niet verantwoordelijk worden gehouden voor de inhoud van deze pagina.
De auteur Deze site is als enige verantwoordelijk voor de manier waarop de verschillende concepten, en de vrijheden die met de referentiewerken worden genomen, hier worden gepresenteerd. Vergeet niet dat u meerdere broninformatie moet doorgeven om het risico op fouten te verkleinen.

Inhoudsopgave Haut