Tutorial Videos Technical Support Data Migration Guide Release Notes Tips & Best Practices Federated Data Source Configuration PDF Generation SQL/REST
Books & Presentations
Your private dedicated server uses MariaDB as its SQL engine (with various enhancements added, like AppSynergy's Federated features). MariaDB is largely compatible with MySQL so most tools that support MySQL will generally work with MariaDB. This includes MySQL GUI and command line tools for various operating systems including Windows.
To learn more about connecting to your dedicated server, see the Database API documentation.
If you create or modify database schema outside of the AppSynergy user interface, beware of the following:
AppSynergy automatically performs nightly backups of your entire database server. You can also create a backup at any time on demand to your own local computer.
Note that in the example below the options --master-data --single-transaction acquire a global read lock on all tables at the beginning of the dump for only a short period of time. This allows a dump to run against a live database and still deliver a consistent snapshot without blocking reads and write.
Recommended way to create a local backup of your database:
NOTE: AppSynergy has an integrated SQL Console which eliminates much of the need for MySQL Workbench. See Tools > SQL Console... for details.
You can connect directly to your AppSynergy database with MySQL Workbench. Workbench allows you to issue any SQL command as root, which has slightly more permissions than a AppSynergy Administrator.
To copy files to or from your bucket you will need gsutil. The gsutil program is a free Google utility. You can download it here. When you configure gsutil be sure you are logged in with the same Google account you used to create your AppSynergy account (we can add additional users to your bucket upon request). When gsutil config asks you for a project id, please specify: parasql-app
Example: copy a local file to your AppSynergy cloud bucket using gsutil: