Tag: Database

MariaDB Galera Cluster on Ubuntu 18.04

Install required packages dist-upgrade: Optional! Updates the Linux kernel if new minor updates are available. ufw: Tool for easier administration of firewall rules. mariadb-server, mariadb-client, galera-3, rsync: Required for running the Galera Cluster. sudo apt-get update && \ sudo apt-get upgrade -y && \ sudo apt-get dist-upgrade -y && \ sudo apt-get autoremove && \ sudo apt-get install mariadb-server mariadb-client...

Windows Title Updater for the RIPE NCC Database

View Script og GitHub // ==UserScript== // @name TitleFixer – RIPE Database // @namespace https://github.com/netravnen/UserJSScripts // @version 1.1.6 // @description Change the title to something meaningful // @author netravnen // @match https://apps.db.ripe.net/search/lookup.html?source=*&key=*-RIPE&type=person // @match https://apps.db.ripe.net/search/lookup.html?source=*&type=person&key=*-RIPE // // @match https://apps.db.ripe.net/search/lookup.html?source=*&key=*&type=mntner // @match https://apps.db.ripe.net/search/lookup.html?source=*&type=mntner&key=* // // @match https://apps.db.ripe.net/search/lookup.html?source=*&key=ORG-*-RIPE&type=organisation // @match https://apps.db.ripe.net/search/lookup.html?source=*&type=organisation&key=ORG-*-RIPE // @grant none // @UpdateURL https://github.com/netravnen/UserJSScripts/raw/master/TitleFixer_RIPE_Database.user.js // @homepageURL https://github.com/netravnen/UserJSScripts/raw/master/TitleFixer_RIPE_Database.user.js /** Update...

Compiled list of Acronyms in the Network Field of A LOT of Things

The list is still subject to updates and changes from time to time. Last updated: 20170121. Acronym Definition Comment Acronym Definition Comment 6PE IPv6 Provider Edge Router 6VPE IPv6 Virtual Private Network Provider Edge Router ABC Abstract Base Class ACE Access Control Entry ACID Atomicity, Consistency, Isolation, and Durability ACL Access Control List ACPI Advanced Configuration and Power Interface ADO...

Change a line across a bunch of posts in WordPress

To change a line can  in posts across many in WordPress, can manually be a “pain-in-the-ass”-task. But can actually be done quite easily with a single line of MySQL-code, executed from the db-admin-interface (phpmyadmin etc.) UPDATE wp_posts SET post_content=REPLACE(post_content, ‘text-to-be-replaced’, ‘text-to-insert’) To be more understandable, you use it like this UPDATE Table-Name SET Field-Name=REPLACE(Field-Name, ‘Text-To-Be-Replaced’, ‘Text-To-Insert’); With this one line, mysql searches the...