Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-backups.html
This section discusses making backups and restoring from them using NDB Cluster replication. We assume that the replication servers have already been configured as covered previously (see Section 25.7.5, “Preparing the NDB Cluster for ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-multi-source.html
This does not automatically create binary logs on the second NDB Cluster's SQL node acting as the replica; in order to cause the binary logs to be created, you must issue a SHOW TABLES statement on that SQL node; this should be done prior to running ... It is possible to use NDB Cluster for bidirectional replication between two clusters, as well as for circular replication between any number of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-networking-issues.html
Any traffic other than that shown in the table for a given node type should be denied. iptables is a very common and reliable firewall application, which is often used with APF as a front end to make configuration easier. In this section, we ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-shm-definition.html
See Section 25.4.3.14, “Configuring NDB Cluster Send Buffer Parameters”, and Section 25.6.15.66, “The ndbinfo transporters Table”, for more information. Communications between NDB cluster nodes are normally handled using TCP/IP. The shared ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-upgrade-downgrade.html
Some of the reasons for this are listed here: DDL statements on NDB tables are not possible during some phases of data node startup. DDL statements on NDB tables may be rejected if any data nodes are stopped during execution; stopping each data node ... Versions Supported for Upgrade to NDB 8.4 Known Issues When Upgrading or Downgrading NDB Cluster This section provides information about NDB Cluster software and compatibility between different NDB Cluster releases with regard to performing upgrades and ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-sql-format.html
Without this option, mysqldump treats the first name as a database name and those following as table names. This section describes how to use mysqldump to create SQL-format dump files. For information about reloading such dump files, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/not-enough-file-handles.html
To tell mysqld to keep open fewer files at a time, you can make the table cache smaller by reducing the value of the table_open_cache system variable (the default value is 64). This may not entirely prevent running out of file descriptors because in ... If you get ERROR 'file_name' not found (errno: 23), Can't open file: file_name (errno: 24), or any other error with errno 23 or errno 24 from MySQL, it means that you have not allocated enough file descriptors for the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/online-ddl-parallel-thread-configuration.html
Parallel scan is not supported on tables defined with virtual columns. Parallel scan is not supported on tables defined with a full-text index. Parallel scan is not supported on tables defined with a spatial index. The default setting is calculated ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-transaction-management.html
When rows are modified or deleted within a long-running transaction, other transactions using the READ COMMITTED and REPEATABLE READ isolation levels have to do more work to reconstruct the older data if they read those same rows. When a ... To ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-build-configuration.html
If you install MySQL over a previous installation that was configured without the Performance Schema (or with an older version of the Performance Schema that has missing or out-of-date tables). One indication of this issue is the presence of ...It ...