Development of the Codership Knowledge Base

The Codership Knowledge Base is composed of Troubleshooting and Best Practices articles—KB articles are grouped by these two distinctions. This is different from the Documentation, which explains how to configure and administer a Galera Cluster—not how to solve problems that occur or how best to use Galera based on particular circumstances. Previously, the Documentation included what we now define as KB articles. This was a confusing approach: when reading the Documentation, readers want to know how to install, configure, and administer Galera, not be told how to fix problems they have not yet or may never encouter.

To start the KB, we removed pages from the Documentation which were essentially KB articles and put them in the KB. Once there, we changed their structure: for troubleshooting articles, presenting a scenario and then solutions or work-arounds; for best practice articles, presenting a scenario and then recommendations. We also included in the left margin, links to related documentation and other articles.

Editorial Goals

Content: 21 Articles, 15 pages, 6,547 Words; Google Traffic, July: 3,300 Impressions, 379 Clicks

Although we now have the structure and an initial batch of KB articles, we need many more articles. We can get ideas for KB articles from our internal support tickets, as well as postings in public forums. We’ll have to write out own, generic text, but ideas of common problems is what’s needed. We can compete with other sites by providing well written and thorough text and solutions.

Before we start promoting our KB, we should have at least two-hundred KB articles, with most in the Troubleshooting section. Our first goal, though, is to get to thirty-give KB articles. Below is a list of ideas for KB articles and links to their sources. Writing articles for each of these will get us to our first goal.

Node Dropping Queries

https://stackoverflow.com/questions/31225290

Why is AUTO_INCREMENT Not Increasing by 1 per New Row?

https://stackoverflow.com/questions/23022574

MariaDB gcomm Back-End Connection Failed 110

https://stackoverflow.com/questions/37212127

MySQL Galera Node Not Starting

https://stackoverflow.com/questions/33277865

Unable to create MariaDB Galera Cluster

https://stackoverflow.com/questions/39744949

Error 1047 wsrep Hasn’t Prepared Node

https://stackoverflow.com/questions/40653238

Error wsrep Failed to Reach Primary View

https://stackoverflow.com/questions/33277865

Problem with Node Joining when Using SST:XtraBackup

https://stackoverflow.com/questions/20363540

Executing REPLACE INTO SELECT using Multiple Databases Results in Deadlock

https://stackoverflow.com/questions/30094558

How to work with MySQL temp tables in a Galera Cluster?

https://stackoverflow.com/questions/32412585

Galera Cluster Replication between Two Data Centers

https://stackoverflow.com/questions/27777134

Maxscale Lost Connection

https://stackoverflow.com/questions/33416078

What’s the Best way to Remove a Node from a Galera Cluster?

https://stackoverflow.com/questions/32454771

The galera_new_cluster Command isn’t starting the Cluster.

https://stackoverflow.com/questions/38594428

Can’t add Nodes to Galera Cluster.

https://stackoverflow.com/questions/22201348

Changing wresp_sst_method in Production Server

https://stackoverflow.com/questions/43955459