<?xml version="1.0" encoding="UTF-8"?>
<!-- generator="FeedCreator 1.8" -->
<?xml-stylesheet href="https://wiki.csgalileo.org/lib/exe/css.php?s=feed" type="text/css"?>
<rdf:RDF
    xmlns="http://purl.org/rss/1.0/"
    xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
    xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
    xmlns:dc="http://purl.org/dc/elements/1.1/">
    <channel rdf:about="https://wiki.csgalileo.org/feed.php">
        <title>Galileo Labs</title>
        <description></description>
        <link>https://wiki.csgalileo.org/</link>
        <image rdf:resource="https://wiki.csgalileo.org/_media/wiki/logo.png" />
       <dc:date>2026-04-18T15:25:16+00:00</dc:date>
        <items>
            <rdf:Seq>
                <rdf:li rdf:resource="https://wiki.csgalileo.org/tips/db/mariadb?rev=1482000103&amp;do=diff"/>
                <rdf:li rdf:resource="https://wiki.csgalileo.org/tips/db/redis?rev=1510058672&amp;do=diff"/>
            </rdf:Seq>
        </items>
    </channel>
    <image rdf:about="https://wiki.csgalileo.org/_media/wiki/logo.png">
        <title>Galileo Labs</title>
        <link>https://wiki.csgalileo.org/</link>
        <url>https://wiki.csgalileo.org/_media/wiki/logo.png</url>
    </image>
    <item rdf:about="https://wiki.csgalileo.org/tips/db/mariadb?rev=1482000103&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2016-12-17T18:41:43+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>mariadb</title>
        <link>https://wiki.csgalileo.org/tips/db/mariadb?rev=1482000103&amp;do=diff</link>
        <description>mariadb

cluster

	* &lt;https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mariadb-10-1-on-ubuntu-16-04-servers&gt;

Three Ubuntu 16.04 servers

install on each node


apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
add-apt-repository &#039;deb [arch=amd64] http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial main&#039;
apt update
apt install mariadb-server rsync</description>
    </item>
    <item rdf:about="https://wiki.csgalileo.org/tips/db/redis?rev=1510058672&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2017-11-07T12:44:32+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>redis</title>
        <link>https://wiki.csgalileo.org/tips/db/redis?rev=1510058672&amp;do=diff</link>
        <description>redis

	* from sql to redis
	* from mysql to redis

string

type string: store a value [integer, string, ...] belong a key [string]


SET connections 10
INCR connections =&gt; 11
INCR connections =&gt; 12
DEL connections
INCR connections =&gt; 1


expiring key


SET resource:lock &quot;Redis Demo&quot;
EXPIRE resource:lock 120</description>
    </item>
</rdf:RDF>
