It’s a rare web hosting user that can get by without a database, so today we’re taking a closer look at how you can setup and use popular databases with WebFaction.
To start, the WebFaction control panel makes it easy to create databases, so there’s no need for any complex commands. You just pick out some details and click Add database (Check out the introduction to our new database management interface for an in-depth look):
A database created with the control panel runs on your server’s shared database process. The shared server is more convenient than configuring your own and doesn’t count toward your account’s memory usage.
Different applications have different needs, so every WebFaction server supports both MySQL and PostgreSQL. MySQL is extremely popular and is used in several of our one-click installers, including WordPress and Drupal. PostgreSQL is growing in popularity and sports some exciting features, like procedural languages PL/Perl and PL/Tcl.
Once you’ve created your database of choice, it’s easy to connect to it and start storing data. Check out these documentation sections:
- administering databases on the web with phpMyAdmin and phpPgAdmin
- running the command line clients
- using an SSH tunnel to connect remotely
- making database connections with scripts and applications
Although the shared database and the associated documentation is convenient, it’s not necessarily for everyone. That’s why we recently introduced a one-click installer for private MySQL and PostgreSQL instances. A private database is a good option if you’re facing problems with contention on the shared database or if you want to customize the database configuration.
And, of course, you can always set up and run a specialty database from your home directory on your own. For example, check out our instructions on installing MongoDB.