Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
This means that you should not chain two servers together in a two-way replication relationship unless you are sure that your updates can safely happen in any order, or unless you take care of mis-ordered updates somehow in the client code. For ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
Partial Updates of JSON Values In MySQL 8.4, the optimizer can perform a partial, in-place update of a JSON column instead of removing the old document and writing the new document in its entirety to the column. This optimization can be performed ...
https://dev.mysql.com/doc/refman/8.4/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP column. To be ...For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric context and vice ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-issues.html
Examples of incidents are server failures, database resynchronization, some software updates, and some hardware changes.) When the replica encounters a gap in the replication log, it stops with an error message. All SQL nodes acting as sources and ... This section discusses known problems or issues when using replication with NDB ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-unattended-installation-cmdline-options-agent.html
--mysqlport TCP/IP port for the monitored MySQL server --mysqlsocket Unix socket/Named pipe for the monitored MySQL server --mysqluser MySQL Administrative username for the monitored MySQL server --optionfile Installation option file ... To view all ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filtering.html
If the plugin is installed without the accompanying audit tables and functions needed for rule-based filtering, the plugin operates in legacy filtering mode, described in Section 8.4.5.10, “Legacy Mode Audit Log Filtering”. Legacy mode ... Note ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
Deleting it puts all SQL nodes in read-only mode; NDB detects that this table has been dropped, and re-creates it, after which it is possible once again to perform updates. This keeps the source mysqld process updated to changes performed by the NDB ... ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated and in the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/glossary.html
M master In a replication configuration, a database server that sends updates to a set of slave servers. master/slave In replication, a server that acts as a slave to receive updates from another server, and also acts as a master to propagate ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-connection-security.html
The group_replication_ssl_mode system variable must be set to the required setting for group communications. If group_replication_ssl_mode is set to REQUIRED, VERIFY_CA, or VERIFY_IDENTITY, use require_secure_transport=ON. This privilege is required ... MySQL 8.4 Group Replication can secure group communication connections between members by one of the following methods: Using its own implementation of the security protocols, including TLS/SSL and the use of an allowlist for incoming Group Communication System (GCS) ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-tagging.html
This functionality enables you to safely take a server instance offline so that applications and MySQL Router ignore it. A configurable tag framework is available to allow the metadata of InnoDB Cluster, InnoDB ClusterSet, or InnoDB ReplicaSet to ...