Setup in Two Easy Steps

Chartio uses the safest possible connection to your database: a reverse SSH tunnel. This means you never expose your database server to the outside world and can rest easy behind a firewall.

Requirements

The requirements for the conection wizard are:

  1. A database server with a unix-based operating system Linux, OSX or a BSD. You'll need root access on this to install the Chartio wizard.
  2. Admin access to your database. The wizard will create a read-only user to your database to ensure the highest level of security possible. It will need admin access to create this user.
  3. MySQL is listening on all interfaces. Your my.cnf bind-address should be set to bind-address=0.0.0.0

While it is not a requirement, we suggest that you create a slave database for analytics. Here is a guide to help guide you through the process of setting it up.

Step 1

$ sudo easy_install chartio

Step 2

$ chartio_setup

Don't Have Easy_Install on Your System?

Download the setup package directly. Once it's downloaded, extract it and run the setup wizard like so:

tar xvzf chartio-1.1.6.tar.gz
cd chartio-1.1.6
sudo python setup.py install
chartio_setup

Didn't Meet the Requirements?

Connect to the database directly.


Frequently Asked Questions

What does the wizard do exactly?

We designed the setup wizard to make your life easier and automate as much as possible. It automatically creates a read only user for you and sets up the reverse SSH tunnel so you can connect to Chartio securely. And the best part, it only takes a few minutes!

How does the Reverse SSH Tunnel Work?

It sets up a very secure ssh tunnel to one of our servers, which allows us to connect back to your database. SSH is an extremely secure technology. And the servers that we've set up to connect to your database are fully locked down and hardened.

Do you store my data?

Not at all. Your data is your own and we never store a copy. As your data travels to and from our servers (so we can run the analytics), it is heavily encrypted. And it never stays in our servers.

Why do I need to enter my database server user and password?

We need you to have admin access so we can create a read only user, which is the most secure way to connect to your data. And remember, since you only enter your credentials on your local machine, we never see them.