Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-objects-table.html
The effect of the default object configuration is to instrument all tables except those in the mysql, INFORMATION_SCHEMA, and performance_schema databases. The setup_objects table controls whether the Performance Schema monitors particular objects.
https://dev.mysql.com/doc/refman/8.4/en/perl-support-problems.html
If Perl reports that it cannot find the ../mysql/mysql.so module, the problem is probably that Perl cannot locate the libmysqlclient.so shared library. You should be able to fix this problem by one of the following methods: Copy libmysqlclient.so ...Note that you may also need to modify the -L options if there are other libraries that the linker fails to ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-positions.html
In our example, given that we know the rough time where the table deletion took place (tp), we can find the log position by checking the log contents around that time using the mysqlbinlog utility. Because the output of mysqlbinlog includes SET ...
https://dev.mysql.com/doc/refman/8.4/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/refman/8.4/en/replication-administration.html
Tip To deploy multiple instances of MySQL, you can use InnoDB Cluster which enables you to easily administer a group of MySQL server instances in MySQL Shell. InnoDB Cluster wraps MySQL Group Replication in a programmatic environment that enables ...
https://dev.mysql.com/doc/refman/8.4/en/replication-delayed.html
MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of time. In MySQL 8.4, the method of delaying replication depends on two timestamps, ...This ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-reserved-words.html
You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of identifiers on the source that are reserved words in the newer MySQL version running on the replica. For example, a table column ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-adding-binlog-master.html
These steps assume that binary logging is enabled on the source (which is the default), the replica is using TABLE based replication applier metadata repositories (which is the default in MySQL 8.4), and that you have enabled a replication user and ...Use a CHANGE REPLICATION SOURCE TO statement to configure a replication channel for each source on the replica (see Section 19.2.2, “Replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-provision-replica.html
The best strategy for provisioning such a replica is therefore to use mysqldump to create an appropriate dump file on each source, then use the mysql client to import the dump file on the replica. If you are using GTID-based replication, you need to ... If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine ...