Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-network-partitioning.html
mysql> SELECT @@group_replication_local_address; Once you know the group communication addresses of s1 (127.0.0.1:10000) and s2 (127.0.0.1:10001), you can use that on one of the two servers to inject a new membership configuration, thus overriding ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-primary-mode.html
Each member makes its own decision locally, following the primary election algorithm in its MySQL Server release. Because all members must reach the same decision, members adapt their primary election algorithm if other group members are running ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-summary.html
MySQL Group Replication builds on top of such properties and abstractions and implements a multi-source update everywhere replication protocol. The following figure depicts the MySQL Group Replication protocol and by comparing it to MySQL ... Group ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see the installation and debugging instructions in Section 2.1, “General Installation Guidance”, and Section 7.9, “Debugging MySQL”. Even if you use lower_case_table_names=2 (which enables MySQL to remember the case used for databases and table names), MySQL does not remember the case used for database names for the function DATABASE() or within the various logs (on case-insensitive ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication.html
We assume some familiarity on the part of the reader with standard MySQL replication as discussed elsewhere in this Manual. This process is accomplished by a special thread known as the NDB binary log injector thread, which runs on each MySQL server ... NDB Cluster supports asynchronous replication, more usually referred to simply as ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-storage-layout.html
Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted space. The reorganized tables require less disk ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-transaction-management.html
The default MySQL setting AUTOCOMMIT=1 can impose performance limitations on a busy database server. To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrumentation-checking.html
This information is always up to date for your version of MySQL, also includes instrumentation for instrumented plugins you might have installed that are not part of the core server, and can be used by automated tools. It is always possible to ...
https://dev.mysql.com/doc/refman/8.4/en/program-options.html
There are several ways to specify options for MySQL programs: List the options on the command line following the program name. In practice, option files are used more commonly for this purpose, but Section 7.8.3, “Running Multiple MySQL Instances ...This is common for options that apply to a specific invocation of the ...