Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-installation.html
We use the world database which is available for download from the MySQL website (see https://dev.mysql.com/doc/index-other.html). For general information about installing MySQL, see Chapter 2, Installing MySQL. This section describes the basics ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-processes.html
For example, mysql://198.51.100.3/tmp/mysql.sock indicates that the SQL node was started with the skip_networking system variable enabled, and mysql://198.51.100.3:3306/?server-id=1 shows that replication is enabled for this SQL node. This table ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-server-locks.html
The server_locks table is similar in structure to the cluster_locks table, and provides a subset of the information found in the latter table, but which is specific to the SQL node (MySQL server) where it resides. (The cluster_locks table provides ...Together with the block name, this number can be used to look up a given instance in the threadblocks ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-transporters.html
Notes For each running data node in the cluster, the transporters table displays a row showing the status of each of that node's connections with all nodes in the cluster, including itself. This information is shown in the table's status column, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-api.html
The listing in this section provides information about parameters used in the [mysqld] and [api] sections of a config.ini file for configuring NDB Cluster SQL nodes and API nodes. For a discussion of MySQL server options for NDB Cluster, see ...For ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-pitr.html
Performing point-in-time recovery of NDB Cluster tables with NDB Cluster and NDB Cluster Replication can be accomplished using a native NDB data backup (taken by issuing CREATE BACKUP in the ndb_mgm client) and restoring the ndb_binlog_index table ... Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-starting.html
Start the MySQL replication source server by issuing this command, where id is this server's unique ID (see Section 25.7.2, “General Requirements for NDB Cluster Replication”): shellS> mysqld --ndbcluster --server-id=id \ --log-bin --ndb-log-bin ... This section outlines the procedure for starting NDB Cluster replication using a single replication ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-collections-add.html
mysql-js> db.countryinfo.add( { GNP: .6, IndepYear: 1967, Name: "Sealand", Code: "SEA", demographics: { LifeExpectancy: 79, Population: 27 }, geography: { Continent: "Europe", Region: "British Islands", SurfaceArea: 193 }, government: { ... To work ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-download.html
Start your MySQL server so that you can load the world_x schema, then follow these steps: Download world_x-db.zip. You can either: Start MySQL Shell in SQL mode and import the file by issuing: mysqlsh -u root --sql --file /tmp/world_x-db/world_x.sql ... As part of this quick-start guide, an example schema is provided which is referred to as the world_x ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-relational-tables.html
In MySQL, each relational table is associated with a particular storage engine. mysql-js> db <Schema:world_x> If the returned value is not Schema:world_x, set the db variable as follows: mysql-js> \use world_x Schema `world_x` accessible through db.