PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-preparation.html
If the source cluster is already in use, you can create a backup of the source and load this onto the replica to cut down on the amount of time required for the replica to synchronize itself with the source. ndb-connectstring=management_host[:port] ... Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 21.7.2, “General Requirements for NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
Notes The mysql user is created using the -r and -s /bin/false options of the useradd command, so that it does not have login permissions to your server host (see Creating the mysql User and Group for details). To switch to the mysql user on your ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
--user=user_name, -u user_name Command-Line Format --user=user_name, Type String The user name of the MySQL account to use for connecting to the server. --defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-conflict-resolution.html
Conflict resolution in NDB Cluster Replication provides a means of resolving such conflicts by permitting a user-defined resolution column to be used to determine whether or not an update on a given source should be applied on the replica. Some ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
However, if no columns are listed in the PARTITION BY KEY or PARTITION BY LINEAR KEY clause of the CREATE TABLE or ALTER TABLE statement used to create or modify a user-partitioned NDB table, then the table is not required to have an explicit ...The ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlshow.html
--user=user_name, -u user_name Command-Line Format --user=user_name, Type String The user name of the MySQL account to use for connecting to the server. --defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
This program reads the files created as a result of the backup and inserts the stored information into the database. ndb_restore must be executed once for each of the backup files that were created by the START BACKUP command used to create the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 25.1 Performance Schema Tables Table Name Description Deprecated accounts Connection statistics per client ...
https://dev.mysql.com/doc/refman/5.7/en/show-grants.html
Note To display nonprivilege information for MySQL accounts, use the SHOW CREATE USER statement. SHOW GRANTS [FOR user] This statement displays the privileges that are assigned to a MySQL user account, in the form of GRANT statements that must be ...SHOW GRANTS requires the SELECT privilege for the mysql system database, except to display privileges for the current ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-howto.html
If you are starting with new servers, see Section 16.1.2.2, “Creating a User for Replication” for information about adding a specific user for replication connections and Section 16.1.2.1, “Setting the Replication Source Configuration” for ...Stop each server using mysqladmin as shown here, where username is the user name for a MySQL user having sufficient privileges to shut down the server: $> mysqladmin -uusername -p shutdown Then supply this user's password at the ...