One-click installers: private MySql and PostgreSQL databases

Posted in MySql by

If you’ve been following this blog for long, you know what’s about to happen: another look at one-click installers available with the WebFaction control panel. This entry covers private database instances for MySQL and PostgreSQL.

For most applications, the shared MySQL and PostgreSQL databases are appropriate and easy to use. Routine database management, like creating databases and database users, can be done with the WebFaction control panel. The shared databases are also available by way of the phpMyAdmin and phpPgAdmin web-based administration tools for running queries and exploring your data. For the vast majority of use cases, the shared databases are a sensible choice.

But in some circumstances, we recommend the use of the private database instance installers for MySQL and PostgreSQL. In particular, private database instances are known to be useful in two special cases: custom configuration and the “bad neighbor” problem.

Private databases are handy when you want to take control of your database configuration. The shared databases are managed by the system administration team, so you cannot alter their settings. With a private database instance, you can change configuration values to your own specific needs, but without the hassle of compiling up from scratch.

Private databases are also useful when the “bad neighbor” problem presents itself. A “bad neighbor” appears when one database user consumes significantly more of the shared database’s resources than others. Switching that user from a shared database to a private instance makes performance expectations more consistent for all users on the server.

Both the PostgreSQL and MySQL installers benefit from using the server’s globally installed binaries and libraries, so you don’t have to worry about updating the database after security releases. When a private instance is installed, the installer creates two cronjobs: one to make sure the database is up and running every 20 minutes, and another to dump all of the instances databases to a file once per day. For more information, check out our private database documentation, including sample usage for Django and WordPress applications.

If a private database instance sounds like it might be useful to you, give it a try, and if you have any questions or need any help, join us in the Q&A Community.

-
-

One-click installers: version control tools

Posted in Git by

It’s that time again: a closer look at the one-click installers available with the WebFaction control panel. In the fifth part of our ongoing series, we’ll scope out version control systems. Version control tools make it easier to keep your code organized, with a full history of the changes you’ve made along the way. The control panel features two version control applications: Subversion and Git.

Subversion

Subversion is a tried-and-true centralized version control system, in which clients check out portions of a central repository’s files and their history. The Subversion client software is already installed system-wide on every WebFaction server, so if you need to check out code from a repository hosted elsewhere, then you can use svn checkout right away. But if you want to host your own repository, then you’ll want to add a Subversion application to your website with the control panel.

To learn more about using Subversion, check out the official Subversion documentation and our Subversion docs.

Additionally, the Subversion one-click installer integrates with the Trac one-click installer; see our last installer blog post for more about Trac and Subversion integration.

Git

Git is a popular distributed version control system, in which every client retains a full copy of the repository and its history. Like Subversion, the Git client software is already installed system-wide on WebFaction servers, so you can git clone or git init without any intermediate steps. But if you want to publish a repository on the web, then add a Git application to a website with the control panel.

To learn more about using Git, check out the official Git documentation and our Git docs.

Again, the Git one-click installer integrates with the Trac one-click installer; see our last installer blog post for more about Trac and Git integration.

Mercurial and Bazaar

Subversion and Git aren’t the only version control options out there. Although we don’t have one-click installers available for them, we do have documentation to get you up and running with Mercurial and Bazaar.

Regardless of which specific tool you choose, version control is a great way to get organized, so give one a try. If you have any questions or need help, join us in the Q&A Community.

-
-