Locate the required file, hover over it, and select Download from the context menu.Ģ. The most straightforward variant is to use the configuration file manager directly in the dashboard. There are multiple options to download a (backup) file from a Jelastic PaaS container:ġ. If the backup operation was successful, you’ll see the appropriate. Wait for the script to be executed (depends on the configured cron frequency) and navigate to the /var/lib/jelastic/backup directory. Note: Any existing data in the mount point directory will be replaced with the files from the remote directory.Īlternatively, you can create a custom backup script, run-able from the remote server (database host, user, and password details will be required to establish a connection).ĥ. – to provide access credentials for the database (access credentials can be found in the after-creation email) Open the /var/spool/cron/mysql file and provide a cron expression in the following format: To automate the script execution, we’ll use the cron scheduler available within the containers out-of-the-box. Tip: If you don’t have an environment with a MySQL or MariaDB database yet, follow the Database Hosting guide to create one.Ģ. Click the Config button next to your database to open the built-in file manager and locate the /var/lib/jelastic/bin/backup_script.sh file. The source code of the script can be viewed directly within the dashboard. Set Up Database Backupsįor this tutorial, we’ll use the default backup script provided for MySQL and MariaDB database nodes at Jelastic PaaS.ġ. Herewith, no specialized knowledge is needed – just follow the setup steps to configure the appropriate cron expression. The process is as simple as providing the required parameters and can be accomplished in a matter of minutes. Jelastic PaaS provides a convenient and straightforward script for backing up stored data on MySQL and MariaDB database nodes. In this article, we’ll examine how to create a backup schedule, and offer hints for better data scheduling and restoring. Automated backups ensures in-time refreshment of the data copies and eliminates the need for manual tracking and setup. So it is highly important to be always prepared to such situations by keeping up-to-date backups that can help with data recovery. MySQL Cluster versions are not supported.Have you ever felt a moment of panic when you realize that your data might be lost? Human errors, malicious attack, systems crash or disasters happen when least expected.Configurations with multiple MySQL installations and/or instances on the same machine are not supported.Veeam Agent for Linux supports processing of MySQL database system version 5.7 – 8.0.Requirements and Limitations for MySQL Processing To learn more about password file configuration, see Preparing Password File for MySQL Processing. Password file - Veeam Agent uses the MySQL account credentials that are stored in the.Password - Veeam Agent uses the MySQL account credentials that you specify in the backup job settings.Veeam Agent for Linux can connect to the MySQL database system using one of the following methods: To obtain information about privileges that are assigned to the account, use MySQL functionality, for example, the SHOW GRANTS statement. If the MySQL account does not have the LOCK TABLES privilege, Veeam Agent does not process tables based on the MyISAM storage engine. As a result, Veeam Agent does not process the table. If the MySQL account does not have the SELECT privilege for the table, Veeam Agent cannot access table metadata. To process the MySQL database system, the MySQL account must have the following privileges: Veeam Agent does not support tables that use other storage engines.Īfter Veeam Agent unlocks tables, Veeam Agent proceeds to the next step of the backup process. Keep in mind that Veeam Agent supports processing of tables based on the MyISAM and InnoDB storage engines only. Tables based on the InnoDB storage engine do not require locking. Veeam Agent changes the table state using the MySQL functionality. Veeam Agent locks base tables that are based on the MyISAM storage engine.When the backup job starts, Veeam Agent connects to the MySQL database system and obtains the list of tables.To process the database system, Veeam Agent performs the following operations: To ensure that the backed-up data is in the consistent state, Veeam Agent for Linux performs the MySQL database system processing. You can use Veeam Agent for Linux to create transactionally consistent backups of Veeam Agent machines that run the MySQL database system.
0 Comments
Leave a Reply. |