Highly Available MySQL database with automated provisioning, monitoring, and backups .
Latest News
TwinDB Backup is a multipurpose tool for backing up MySQL and file system. It can store backup copies on a remote SSH server or Amazon S3.
At TwinDB we are developing solutions for highly available and protected MySQL databases.
We are the best experts in MySQL data recovery. Over last ten years we’ve salvaged hundreds of companies from data and business loss. If we cannot recover – nobody can.
We know how to protect MySQL databases. Our backup service is comprehensive solution that provides backup metric monitoring and continuous verification.
MySQL server aborts when processing this archive table. Table data are still available in .ARZ
Where can I find the general log
I just imported an old version of my database on the “Import” tab of phpmyadmin
Internet is full of simple shell backup scripts. Every DBA and system administrators (including myself) has written one. Bash is a bad tool for this job and in this post I will explain why.
Some time ago, our team released a new version of TwinDB Backup Tool that contains minor fixed and some major improvements. In this article I want to highlight major features in this release. Status refactoring The tool stores backups metadata in a JSON file that I will refer further as the status. The status is […]
Monitoring MySQL backups is a vital part of any reliable backup solution. By monitoring the most common disaster recovery metrics, the Recovery Time Objective and the Recovery Point Objective, you can find out if a backup job was successful and produced a usable backup copy. The TwinDB Backup Tool along with Datadog allows monitoring both […]
If you don’t verify backups you may safely assume you don’t have them. It often happens that MySQL backups can be invalid or broken due to a software bug, or some hidden corruption. If you are lucky enough, hours and days will be needed to resurrect a database from a bad backup copy. If you […]
Our website twindb.com is built on WordPress software and has always been. A while ago we decided the website needs a better look. But not only that. Managing our old website was quite laborious and manual process which goes strongly against our culture at TwinDB to do things right. Few weeks ago we migrated to […]
Setting up a replication slave is pretty straightforward, yet cumbersome process that needs a lot of attention to detail. Even if at first glance the six steps are simple, together they constitute something that is everything but easy to grasp. What’s Our Solution We decided to fix that. As a result, our very own TwinDB […]
Recently, we have implemented a set of new commands in ProxySQL Tools to manage MySQL users. You can create, delete, and modify users from the command line. Following commands are available:
|
1 2 3 4 5 6 7 |
proxysql-tools galera user list proxysql-tools galera user create username [—-options] proxysql-tools galera user delete username proxysql-tools galera user modify username [—-options] proxysql-tools galera user set_password username |
You can set a user’s password at the time of creation with —-password option, or later on with the set_password sub-command. Create user Let’s add a […]
TwinDB LLC, 285 College Ave Apt A Palo Alto, CA 94306
support@twindb.com
@twindba
https://www.facebook.com/twindba/
+1(844) 533-0409
