Not the answer you need?
Register and ask your own question!

Percona Toolkit - DSN Configuration

dannaniedannanie EntrantInactive User Role Beginner

I am new to the Percona Toolkit and it appears that there are multiple ways to pass MySQL credenials to each of these tools.

Some use DSNs directly on the command line, some use a toolkit.config file, etc. Is that right?

I would like to configure the MySQL credentials once for all of the tools to use, but not quite sure how to do it. Help?

Do I configure my own $HOME/.percona-toolkit.config with a DSN? Not sure how to code it?

Any help would be appreciated. Sorry for such a rookie question.

Thank you. :cool:


  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner

    Yes, you are right that you can use DSN directly with command-line or configuration file. As some utilities does not use DSNs but still you can connect to mysql with --host, --user and --password options or configuration file (i.e my.cnf/toolkit.confg). These tools uses these options to create a DSN automatically. You can get more DSN related information here. ce_name_specifications.html

    So If you want to configure the MySQL credentials once for all tools, I would suggest, you should add user/pass information in my.cnf under [client] section.
  • martinkamkemartinkamke Entrant Inactive User Role Beginner
    But if i do not want to write the user and password in the my.cnf

    I only want to do a nagios check for replication checksum for my server. Is it possble to send the credentials for the replication on the commandline or on the check command.

    what means i can use a configfile. how should it looks like


    And how can i read it in the commandline or in the nagios check?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.