3.2.4.2. Example Execution

Note

In the example below, keystrokes are represented using square brackets. For example, [TAB] indicates the tab key was pressed. Similarly, portions in the commands specific with angle brackets are values you would replace with actual values. For example, <user> indicates you would place the user's login name here.


shell> mysqluc 
Launching console ...

Welcome to the MySQL Utilities Client (mysqluc) version 1.4.2
Copyright (c) 2010, 2014 Oracle and/or its affiliates. All rights reserved.
This is a release of dual licensed MySQL Utilities. For the avoidance of
doubt, this particular copy of the software is released
under the version 2 of the GNU General Public License.
MySQL Utilities is brought to you by Oracle.

Type 'help' for a list of commands or press TAB twice for list of utilities.

mysqluc> help
Command                 Description                                        
----------------------  ---------------------------------------------------
help utilities          Display list of all utilities supported.           
help <utility>          Display help for a specific utility.               
show errors             Display errors captured during the execution of the
                        utilities.                                         
clear errors            clear captured errors.                             
show last error         Display the last error captured during the         
                        execution of the utilities                         
help | help commands    Show this list.                                    
exit | quit             Exit the console.                                  
set <variable>=<value>  Store a variable for recall in commands.           
show options            Display list of options specified by the user on   
                        launch.                                            
show variables          Display list of variables.                         
<ENTER>                 Press ENTER to execute command.                    
<ESCAPE>                Press ESCAPE to clear the command entry.           
<DOWN>                  Press DOWN to retrieve the previous command.       
<UP>                    Press UP to retrieve the next command in history.  
<TAB>                   Press TAB for type completion of utility, option,  
                        or variable names.                                 
<TAB><TAB>              Press TAB twice for list of matching type          
                        completion (context sensitive). 

mysqluc> help utilities 
Utility           Description                                              
----------------  ---------------------------------------------------------
mysqlauditadmin   audit log maintenance utility                            
mysqlauditgrep    audit log search utility                                 
mysqldbcompare    compare databases for consistency                        
mysqldbcopy       copy databases from one server to another                
mysqldbexport     export metadata and data from databases                  
mysqldbimport     import metadata and data from files                      
mysqldiff         compare object definitions among objects where the       
                  difference is how db1.obj1 differs from db2.obj2         
mysqldiskusage    show disk usage for databases                            
mysqlfailover     automatic replication health monitoring and failover     
mysqlfrm          show CREATE TABLE from .frm files                        
mysqlindexcheck   check for duplicate or redundant indexes                 
mysqlmetagrep     search metadata                                          
mysqlprocgrep     search process information                               
mysqlreplicate    establish replication with a master                      
mysqlrpladmin     administration utility for MySQL replication             
mysqlrplcheck     check replication                                        
mysqlrplms        establish multi-source replication                       
mysqlrplshow      show slaves attached to a master                         
mysqlrplsync      replication synchronization checker utility              
mysqlserverclone  start another instance of a running server               
mysqlserverinfo   show server information                                  
mysqluserclone    clone a MySQL user account to one or more new users  


mysqluc> help mysqldb[TAB][TAB]
Utility         Description                                                
--------------  -----------------------------------------------------------
mysqldbcompare  compare databases for consistency                          
mysqldbcopy     copy databases from one server to another                  
mysqldbexport   export metadata and data from databases                    
mysqldbimport   import metadata and data from files 


mysqluc> mysqlrplshow --m[TAB][TAB] 

Option                 Description                                         
---------------------  ----------------------------------------------------
--master=MASTER        connection information for master server in the     
                       form: <user>[:<password>]@<host>[:<port>][:<socket>]
                       or <login-path>[:<port>][:<socket>].                
--max-depth=MAX_DEPTH  limit the traversal to this depth. Valid only with  
                       the --recurse option. Valid values are non-negative 
                       integers.          

mysqluc> mysqlrplshow --mast[TAB]er=<user>:<password>@localhost:13001

The console has detected that the utility 'mysqlrplshow' ended with an error code.
You can get more information about the error by running the console command 'show last error'.

mysqluc> show last error 
Execution of utility: mysqlrplshow --master=<user>:<password>@localhost:13001 
returned errorcode: 2 with error message: 
Usage: mysqlrplshow.py --master=root@localhost:3306 

mysqlrplshow.py: error: The --discover-slaves-login is required to test slave connectivity.

mysqluc> mysqlrplshow --master=<user>:<password>@localhost:13001 \
            --discover-slaves-login=<user>:<password>
# master on localhost: ... connected.
# Finding slaves for master: localhost:13001

# Replication Topology Graph
localhost:13001 (MASTER)
   |
   +--- localhost:13002 - (SLAVE)
   |
   +--- localhost:13003 - (SLAVE)
   |
   +--- localhost:13004 - (SLAVE)
   |
   +--- localhost:13005 - (SLAVE)


mysqluc>     


User Comments
Sign Up Login You must be logged in to post a comment.