vitess.io/vitess@v0.16.2/go/flags/endtoend/vtbackup.txt (about)

     1  Usage of vtbackup:
     2        --allow_first_backup                              Allow this job to take the first backup of an existing shard.
     3        --alsologtostderr                                 log to standard error as well as files
     4        --azblob_backup_account_key_file string           Path to a file containing the Azure Storage account key; if this flag is unset, the environment variable VT_AZBLOB_ACCOUNT_KEY will be used as the key itself (NOT a file path).
     5        --azblob_backup_account_name string               Azure Storage Account name for backups; if this flag is unset, the environment variable VT_AZBLOB_ACCOUNT_NAME will be used.
     6        --azblob_backup_container_name string             Azure Blob Container Name.
     7        --azblob_backup_parallelism int                   Azure Blob operation parallelism (requires extra memory when increased). (default 1)
     8        --azblob_backup_storage_root string               Root prefix for all backup-related Azure Blobs; this should exclude both initial and trailing '/' (e.g. just 'a/b' not '/a/b/').
     9        --backup_engine_implementation string             Specifies which implementation to use for creating new backups (builtin or xtrabackup). Restores will always be done with whichever engine created a given backup. (default "builtin")
    10        --backup_storage_block_size int                   if backup_storage_compress is true, backup_storage_block_size sets the byte size for each block while compressing (default is 250000). (default 250000)
    11        --backup_storage_compress                         if set, the backup files will be compressed. (default true)
    12        --backup_storage_implementation string            Which backup storage implementation to use for creating and restoring backups.
    13        --backup_storage_number_blocks int                if backup_storage_compress is true, backup_storage_number_blocks sets the number of blocks that can be processed, at once, before the writer blocks, during compression (default is 2). It should be equal to the number of CPUs available for compression. (default 2)
    14        --ceph_backup_storage_config string               Path to JSON config file for ceph backup storage. (default "ceph_backup_config.json")
    15        --compression-engine-name string                  compressor engine used for compression. (default "pargzip")
    16        --compression-level int                           what level to pass to the compressor. (default 1)
    17        --concurrency int                                 (init restore parameter) how many concurrent files to restore at once (default 4)
    18        --consul_auth_static_file string                  JSON File to read the topos/tokens from.
    19        --db-credentials-file string                      db credentials file; send SIGHUP to reload this file
    20        --db-credentials-server string                    db credentials server type ('file' - file implementation; 'vault' - HashiCorp Vault implementation) (default "file")
    21        --db-credentials-vault-addr string                URL to Vault server
    22        --db-credentials-vault-path string                Vault path to credentials JSON blob, e.g.: secret/data/prod/dbcreds
    23        --db-credentials-vault-role-mountpoint string     Vault AppRole mountpoint; can also be passed using VAULT_MOUNTPOINT environment variable (default "approle")
    24        --db-credentials-vault-role-secretidfile string   Path to file containing Vault AppRole secret_id; can also be passed using VAULT_SECRETID environment variable
    25        --db-credentials-vault-roleid string              Vault AppRole id; can also be passed using VAULT_ROLEID environment variable
    26        --db-credentials-vault-timeout duration           Timeout for vault API operations (default 10s)
    27        --db-credentials-vault-tls-ca string              Path to CA PEM for validating Vault server certificate
    28        --db-credentials-vault-tokenfile string           Path to file containing Vault auth token; token can also be passed using VAULT_TOKEN environment variable
    29        --db-credentials-vault-ttl duration               How long to cache DB credentials from the Vault server (default 30m0s)
    30        --db_allprivs_password string                     db allprivs password
    31        --db_allprivs_use_ssl                             Set this flag to false to make the allprivs connection to not use ssl (default true)
    32        --db_allprivs_user string                         db allprivs user userKey (default "vt_allprivs")
    33        --db_app_password string                          db app password
    34        --db_app_use_ssl                                  Set this flag to false to make the app connection to not use ssl (default true)
    35        --db_app_user string                              db app user userKey (default "vt_app")
    36        --db_appdebug_password string                     db appdebug password
    37        --db_appdebug_use_ssl                             Set this flag to false to make the appdebug connection to not use ssl (default true)
    38        --db_appdebug_user string                         db appdebug user userKey (default "vt_appdebug")
    39        --db_charset string                               Character set used for this tablet. (default "utf8mb4")
    40        --db_conn_query_info                              enable parsing and processing of QUERY_OK info fields
    41        --db_connect_timeout_ms int                       connection timeout to mysqld in milliseconds (0 for no timeout)
    42        --db_dba_password string                          db dba password
    43        --db_dba_use_ssl                                  Set this flag to false to make the dba connection to not use ssl (default true)
    44        --db_dba_user string                              db dba user userKey (default "vt_dba")
    45        --db_erepl_password string                        db erepl password
    46        --db_erepl_use_ssl                                Set this flag to false to make the erepl connection to not use ssl (default true)
    47        --db_erepl_user string                            db erepl user userKey (default "vt_erepl")
    48        --db_filtered_password string                     db filtered password
    49        --db_filtered_use_ssl                             Set this flag to false to make the filtered connection to not use ssl (default true)
    50        --db_filtered_user string                         db filtered user userKey (default "vt_filtered")
    51        --db_flags uint                                   Flag values as defined by MySQL.
    52        --db_flavor string                                Flavor overrid. Valid value is FilePos.
    53        --db_host string                                  The host name for the tcp connection.
    54        --db_port int                                     tcp port
    55        --db_repl_password string                         db repl password
    56        --db_repl_use_ssl                                 Set this flag to false to make the repl connection to not use ssl (default true)
    57        --db_repl_user string                             db repl user userKey (default "vt_repl")
    58        --db_server_name string                           server name of the DB we are connecting to.
    59        --db_socket string                                The unix socket to connect on. If this is specified, host and port will not be used.
    60        --db_ssl_ca string                                connection ssl ca
    61        --db_ssl_ca_path string                           connection ssl ca path
    62        --db_ssl_cert string                              connection ssl certificate
    63        --db_ssl_key string                               connection ssl key
    64        --db_ssl_mode SslMode                             SSL mode to connect with. One of disabled, preferred, required, verify_ca & verify_identity.
    65        --db_tls_min_version string                       Configures the minimal TLS version negotiated when SSL is enabled. Defaults to TLSv1.2. Options: TLSv1.0, TLSv1.1, TLSv1.2, TLSv1.3.
    66        --detach                                          detached mode - run backups detached from the terminal
    67        --disable-redo-log                                Disable InnoDB redo log during replication-from-primary phase of backup.
    68        --emit_stats                                      If set, emit stats to push-based monitoring and stats backends
    69        --external-compressor string                      command with arguments to use when compressing a backup.
    70        --external-compressor-extension string            extension to use when using an external compressor.
    71        --external-decompressor string                    command with arguments to use when decompressing a backup.
    72        --file_backup_storage_root string                 Root directory for the file backup storage.
    73        --gcs_backup_storage_bucket string                Google Cloud Storage bucket to use for backups.
    74        --gcs_backup_storage_root string                  Root prefix for all backup-related object names.
    75        --grpc_auth_static_client_creds string            When using grpc_static_auth in the server, this file provides the credentials to use to authenticate with server.
    76        --grpc_compression string                         Which protocol to use for compressing gRPC. Default: nothing. Supported: snappy
    77        --grpc_enable_tracing                             Enable gRPC tracing.
    78        --grpc_initial_conn_window_size int               gRPC initial connection window size
    79        --grpc_initial_window_size int                    gRPC initial window size
    80        --grpc_keepalive_time duration                    After a duration of this time, if the client doesn't see any activity, it pings the server to see if the transport is still alive. (default 10s)
    81        --grpc_keepalive_timeout duration                 After having pinged for keepalive check, the client waits for a duration of Timeout and if no activity is seen even after that the connection is closed. (default 10s)
    82        --grpc_max_message_size int                       Maximum allowed RPC message size. Larger messages will be rejected by gRPC with the error 'exceeding the max size'. (default 16777216)
    83        --grpc_prometheus                                 Enable gRPC monitoring with Prometheus.
    84    -h, --help                                            display usage and exit
    85        --incremental_from_pos string                     Position of previous backup. Default: empty. If given, then this backup becomes an incremental backup from given position. If value is 'auto', backup taken from last successful backup position
    86        --init_db_name_override string                    (init parameter) override the name of the db used by vttablet
    87        --init_db_sql_file string                         path to .sql file to run after mysql_install_db
    88        --init_keyspace string                            (init parameter) keyspace to use for this tablet
    89        --init_shard string                               (init parameter) shard to use for this tablet
    90        --initial_backup                                  Instead of restoring from backup, initialize an empty database with the provided init_db_sql_file and upload a backup of that for the shard, if the shard has no backups yet. This can be used to seed a brand new shard with an initial, empty backup. If any backups already exist for the shard, this will be considered a successful no-op. This can only be done before the shard exists in topology (i.e. before any tablets are deployed).
    91        --keep-alive-timeout duration                     Wait until timeout elapses after a successful backup before shutting down.
    92        --keep_logs duration                              keep logs for this long (using ctime) (zero to keep forever)
    93        --keep_logs_by_mtime duration                     keep logs for this long (using mtime) (zero to keep forever)
    94        --lock-timeout duration                           Maximum time for which a shard/keyspace lock can be acquired for (default 45s)
    95        --log_backtrace_at traceLocation                  when logging hits line file:N, emit a stack trace (default :0)
    96        --log_dir string                                  If non-empty, write log files in this directory
    97        --log_err_stacks                                  log stack traces for errors
    98        --log_rotate_max_size uint                        size in bytes at which logs are rotated (glog.MaxSize) (default 1887436800)
    99        --logtostderr                                     log to standard error instead of files
   100        --min_backup_interval duration                    Only take a new backup if it's been at least this long since the most recent backup.
   101        --min_retention_count int                         Always keep at least this many of the most recent backups in this backup storage location, even if some are older than the min_retention_time. This must be at least 1 since a backup must always exist to allow new backups to be made (default 1)
   102        --min_retention_time duration                     Keep each old backup for at least this long before removing it. Set to 0 to disable pruning of old backups.
   103        --mycnf-file string                               path to my.cnf, if reading all config params from there
   104        --mycnf_bin_log_path string                       mysql binlog path
   105        --mycnf_data_dir string                           data directory for mysql
   106        --mycnf_error_log_path string                     mysql error log path
   107        --mycnf_general_log_path string                   mysql general log path
   108        --mycnf_innodb_data_home_dir string               Innodb data home directory
   109        --mycnf_innodb_log_group_home_dir string          Innodb log group home directory
   110        --mycnf_master_info_file string                   mysql master.info file
   111        --mycnf_mysql_port int                            port mysql is listening on
   112        --mycnf_pid_file string                           mysql pid file
   113        --mycnf_relay_log_index_path string               mysql relay log index path
   114        --mycnf_relay_log_info_path string                mysql relay log info path
   115        --mycnf_relay_log_path string                     mysql relay log path
   116        --mycnf_secure_file_priv string                   mysql path for loading secure files
   117        --mycnf_server_id int                             mysql server id of the server (if specified, mycnf-file will be ignored)
   118        --mycnf_slow_log_path string                      mysql slow query log path
   119        --mycnf_socket_file string                        mysql socket file
   120        --mycnf_tmp_dir string                            mysql tmp directory
   121        --mysql_port int                                  mysql port (default 3306)
   122        --mysql_server_version string                     MySQL server version to advertise. (default "8.0.30-Vitess")
   123        --mysql_socket string                             path to the mysql socket
   124        --mysql_timeout duration                          how long to wait for mysqld startup (default 5m0s)
   125        --port int                                        port for the server
   126        --pprof strings                                   enable profiling
   127        --purge_logs_interval duration                    how often try to remove old logs (default 1h0m0s)
   128        --remote_operation_timeout duration               time to wait for a remote operation (default 15s)
   129        --restart_before_backup                           Perform a mysqld clean/full restart after applying binlogs, but before taking the backup. Only makes sense to work around xtrabackup bugs.
   130        --s3_backup_aws_endpoint string                   endpoint of the S3 backend (region must be provided).
   131        --s3_backup_aws_region string                     AWS region to use. (default "us-east-1")
   132        --s3_backup_aws_retries int                       AWS request retries. (default -1)
   133        --s3_backup_force_path_style                      force the s3 path style.
   134        --s3_backup_log_level string                      determine the S3 loglevel to use from LogOff, LogDebug, LogDebugWithSigning, LogDebugWithHTTPBody, LogDebugWithRequestRetries, LogDebugWithRequestErrors. (default "LogOff")
   135        --s3_backup_server_side_encryption string         server-side encryption algorithm (e.g., AES256, aws:kms, sse_c:/path/to/key/file).
   136        --s3_backup_storage_bucket string                 S3 bucket to use for backups.
   137        --s3_backup_storage_root string                   root prefix for all backup-related object names.
   138        --s3_backup_tls_skip_verify_cert                  skip the 'certificate is valid' check for SSL connections.
   139        --security_policy string                          the name of a registered security policy to use for controlling access to URLs - empty means allow all for anyone (built-in policies: deny-all, read-only)
   140        --sql-max-length-errors int                       truncate queries in error logs to the given length (default unlimited)
   141        --sql-max-length-ui int                           truncate queries in debug UIs to the given length (default 512) (default 512)
   142        --stats_backend string                            The name of the registered push-based monitoring/stats backend to use
   143        --stats_combine_dimensions string                 List of dimensions to be combined into a single "all" value in exported stats vars
   144        --stats_common_tags strings                       Comma-separated list of common tags for the stats backend. It provides both label and values. Example: label1:value1,label2:value2
   145        --stats_drop_variables string                     Variables to be dropped from the list of exported variables.
   146        --stats_emit_period duration                      Interval between emitting stats to all registered backends (default 1m0s)
   147        --stderrthreshold severity                        logs at or above this threshold go to stderr (default 1)
   148        --tablet_manager_grpc_ca string                   the server ca to use to validate servers when connecting
   149        --tablet_manager_grpc_cert string                 the cert to use to connect
   150        --tablet_manager_grpc_concurrency int             concurrency to use to talk to a vttablet server for performance-sensitive RPCs (like ExecuteFetchAs{Dba,AllPrivs,App}) (default 8)
   151        --tablet_manager_grpc_connpool_size int           number of tablets to keep tmclient connections open to (default 100)
   152        --tablet_manager_grpc_crl string                  the server crl to use to validate server certificates when connecting
   153        --tablet_manager_grpc_key string                  the key to use to connect
   154        --tablet_manager_grpc_server_name string          the server name to use to validate server certificate
   155        --tablet_manager_protocol string                  Protocol to use to make tabletmanager RPCs to vttablets. (default "grpc")
   156        --topo_consul_lock_delay duration                 LockDelay for consul session. (default 15s)
   157        --topo_consul_lock_session_checks string          List of checks for consul session. (default "serfHealth")
   158        --topo_consul_lock_session_ttl string             TTL for consul session.
   159        --topo_consul_watch_poll_duration duration        time of the long poll for watch queries. (default 30s)
   160        --topo_etcd_lease_ttl int                         Lease TTL for locks and leader election. The client will use KeepAlive to keep the lease going. (default 30)
   161        --topo_etcd_tls_ca string                         path to the ca to use to validate the server cert when connecting to the etcd topo server
   162        --topo_etcd_tls_cert string                       path to the client cert to use to connect to the etcd topo server, requires topo_etcd_tls_key, enables TLS
   163        --topo_etcd_tls_key string                        path to the client key to use to connect to the etcd topo server, enables TLS
   164        --topo_global_root string                         the path of the global topology data in the global topology server
   165        --topo_global_server_address string               the address of the global topology server
   166        --topo_implementation string                      the topology implementation to use
   167        --topo_zk_auth_file string                        auth to use when connecting to the zk topo server, file contents should be <scheme>:<auth>, e.g., digest:user:pass
   168        --topo_zk_base_timeout duration                   zk base timeout (see zk.Connect) (default 30s)
   169        --topo_zk_max_concurrency int                     maximum number of pending requests to send to a Zookeeper server. (default 64)
   170        --topo_zk_tls_ca string                           the server ca to use to validate servers when connecting to the zk topo server
   171        --topo_zk_tls_cert string                         the cert to use to connect to the zk topo server, requires topo_zk_tls_key, enables TLS
   172        --topo_zk_tls_key string                          the key to use to connect to the zk topo server, enables TLS
   173        --v Level                                         log level for V logs
   174    -v, --version                                         print binary version
   175        --vmodule moduleSpec                              comma-separated list of pattern=N settings for file-filtered logging
   176        --xbstream_restore_flags string                   Flags to pass to xbstream command during restore. These should be space separated and will be added to the end of the command. These need to match the ones used for backup e.g. --compress / --decompress, --encrypt / --decrypt
   177        --xtrabackup_backup_flags string                  Flags to pass to backup command. These should be space separated and will be added to the end of the command
   178        --xtrabackup_prepare_flags string                 Flags to pass to prepare command. These should be space separated and will be added to the end of the command
   179        --xtrabackup_root_path string                     Directory location of the xtrabackup and xbstream executables, e.g., /usr/bin
   180        --xtrabackup_stream_mode string                   Which mode to use if streaming, valid values are tar and xbstream. Please note that tar is not supported in XtraBackup 8.0 (default "tar")
   181        --xtrabackup_stripe_block_size uint               Size in bytes of each block that gets sent to a given stripe before rotating to the next stripe (default 102400)
   182        --xtrabackup_stripes uint                         If greater than 0, use data striping across this many destination files to parallelize data transfer and decompression
   183        --xtrabackup_user string                          User that xtrabackup will use to connect to the database server. This user must have all necessary privileges. For details, please refer to xtrabackup documentation.