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