Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-upgrade-testing.html
Then you can dump the database and database object definitions from the production server and load them into the new server to verify that they are handled properly. (This is also useful for testing downgrades.) On the production server: $> ... When ...
https://dev.mysql.com/doc/refman/8.4/en/option-defaults-equals.html
080112 12:53:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var $> After shutting down the server, restart it as follows: $> mysqld_safe --log-error & [1] 11699 $> 080112 12:53:40 mysqld_safe Logging to ...Due to this ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. Even though it is permitted to use NULL as the value of an expression that must ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-ndb-sync-excluded-objects-table.html
This table provides information about NDB database objects which cannot be automatically synchronized between NDB Cluster's dictionary and the MySQL data dictionary. Example information about NDB database objects which cannot be synchronized with ...row *************************** SCHEMA_NAME: NULL NAME: lg1 TYPE: LOGFILE GROUP REASON: Injected failure *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/perl-support.html
The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. To use DBI, you must install the DBI module, as well as a DataBase Driver (DBD) module ...You can obtain the necessary modules from http://search.cpan.org for Unix, or by using the ActiveState ppm program on ...
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
For some distribution types (such as binary distributions on Windows, or RPM and DEB distributions on Linux), the installation process initializes the MySQL data directory, including the mysql system database containing the grant tables. (The data ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
Access privileges for the connection metadata repository table mysql.slave_master_info should be restricted to the database administrator, because it contains the replication user account name and password for connecting to the source. Use a ... A ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-performance.html
Figure 19.3 Using an Additional Replication Source to Improve Performance For this to work, you must configure the MySQL instances as follows: Source 1 is the primary source where all changes and updates are written to the database. The above ... As ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-scaleout.html
You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across multiple database servers, within some reasonable limitations. Figure 19.1 Using Replication to Improve Performance During ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
The replica does not check whether the databases on the source are compatible with those on the replica; it simply begins reading and executing events from the specified coordinates in the new source's binary log. In a failover situation, all the ...