Mysql | Calebs Creek

Looking for the default database schemas? Download them for versions 2.6 through 3.3 here. (MySQL format.) NOTE: Much of this content is relevant only to MySQL users. Other database users may find some semblance of an elucidation, but they’ll have to hack their own scripts! Over time and multiple version upgrades of Atlassian Confluence, its database can get a bit “dirty” for various reasons and may cause an upgrade to fail or lead to confusion when contacting Atlassian support (see note). A few examples: Prior to version 2.10, the upgrade process wasn’t very “tidy”, shall we say? For example, if the newer version of Confluence didn’t need a data column that the previous version did, the upgrade would just leave the column in place — with all of [...]

Recently, my company’s corporate wiki started to sputter. It isn’t that Atlassian Confluence itself is a dog, but when you load it with over 100K+ pages, hundreds of simultaneous users, many GBs of attachments in the DB, and try to run it on Windows 2003 Std and SQL Server 2000, things get rather dicey. (Add in the fact that the same hardware is used for a half dozen other production apps, including our enterprise JIRA install, and you have a recipe for failure.) So, for various reasons, we decided to move Confluence to its own dedicated environment: Ubuntu 8.04 with a MySQL backend. I don’t intend to make this a detailed HOWTO — I can’t imagine that any two migrations will ever be identical. Instead, I’ll point out [...]

HOW-TO: Fix your Atlassian Confluence database schema

Moving Confluence from Windows to (Ubuntu) GNU/Linux

Recent Posts

Extras

Follow

Blogroll

Meta

Join the cause

Feed my kids