PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-two-channels.html
First, the mysqld processes for the primary and secondary replication source servers must be started, followed by those for the primary and secondary replicas. The secondary replication channel needs to be started only in the event that the primary ... In a more complete example scenario, we envision two replication channels to provide redundancy and thereby guard against possible failure of a single replication ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-rolling-restart.html
This is often done as part of a rolling upgrade or rolling downgrade, where high availability of the cluster is mandatory and no downtime of the cluster as a whole is permissible. Other parameters require that the data node be stopped completely ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-privileges.html
In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster and the implications of this for keeping an NDB Cluster secure. This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-networking-issues.html
Any ndb_mgm client This means that any cluster management client that is given the management server's host name (or IP address) and port (if not the standard port) can connect to the cluster and execute any management client command. (We show the ... In this section, we discuss basic network security issues as they relate to NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-single-user-mode.html
Example: ndb_mgm> ENTER SINGLE USER MODE 5 After this command has executed and the cluster has entered single user mode, the API node whose node ID is 5 becomes the cluster's only permitted user. Single user mode enables the database administrator ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-audit.html
MySQL Enterprise Audit uses the open MySQL Audit API to enable standard, policy-based monitoring and logging of connection and query activity executed on specific MySQL servers. MySQL Enterprise Edition includes MySQL Enterprise Audit, implemented ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-firewall.html
MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against allowlists of accepted statement patterns. This ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-subqueries.html
Some optimizations that MySQL itself makes are: MySQL executes uncorrelated subqueries only once. Development is ongoing, so no optimization tip is reliable for the long term. The following list provides some interesting tricks that you might want ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-mysql-sock.html
To do this, set the sticky bit on the /tmp directory by logging in as root and using the following command: $> chmod +t /tmp You can check whether the sticky bit is set by executing ls -ld /tmp. The default location for the Unix socket file that ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterstatus.html
row *************************** File: mysql-bin.000003 Position: 73 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5 1 row in set (0.00 sec) The File column shows the name of the log file ... To configure the replica to start the replication process at the correct point, you need to note the source's current coordinates within its binary ...