handmade.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
handmade.social is for all handmade artisans to create accounts for their Etsy and other handmade business shops.

Server stats:

36
active users

#mariadb

0 posts0 participants0 posts today
Gytis Repečka<p>Hands down the best April Fool's day prank :ablobcatrave:</p><p>New statement to <a href="https://comfy.social/notes/a614sx4f76" rel="nofollow noopener noreferrer" target="_blank">end transaction in MariaDB</a> - <code>amen</code> :blobcatcheer:</p><p>Beautifully <a href="https://github.com/MariaDB/server/pull/3937" rel="nofollow noopener noreferrer" target="_blank">crafted</a> by <span class="h-card"><a href="https://comfy.social/@sigmasternchen" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>sigmasternchen</span></a></span> :sql:</p><p><a href="https://social.gyt.is/tags/databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>databases</span></a> <a href="https://social.gyt.is/tags/mariadb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mariadb</span></a> <a href="https://social.gyt.is/tags/commit" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>commit</span></a> <a href="https://social.gyt.is/tags/aprilfoolsjoke" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>aprilfoolsjoke</span></a></p>
Pete Prodoehl 🍕<p>I got MariaDB installed on Debian which is a better replacement for MySQL, right?</p><p>I do remember using MariaDB many years ago... for what I need it should work just fine I assume.</p><p>(Some simple web site databases, WordPress, etc.)</p><p><a href="https://mastodon.social/tags/linux" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>linux</span></a> <a href="https://mastodon.social/tags/debian" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>debian</span></a> <a href="https://mastodon.social/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mysql</span></a> <a href="https://mastodon.social/tags/mariadb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mariadb</span></a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a></p>
MariaDB Foundation<p>Try RAG with MariaDB Vector on your own MariaDB data!: <a href="https://mariadb.org/rag-with-mariadb-vector/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">mariadb.org/rag-with-mariadb-v</span><span class="invisible">ector/</span></a> <a href="https://fosstodon.org/tags/mariadb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mariadb</span></a> <a href="https://fosstodon.org/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://fosstodon.org/tags/RAG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RAG</span></a> <a href="https://fosstodon.org/tags/ai" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ai</span></a></p>
Upscene Productions<p>Huge discount on database developments tool for <a href="https://mstdn.business/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLServer</span></a>, <a href="https://mstdn.business/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a>, <a href="https://mstdn.business/tags/MariaDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MariaDB</span></a>, <a href="https://mstdn.business/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a>, <a href="https://mstdn.business/tags/Oracle" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Oracle</span></a>, <a href="https://mstdn.business/tags/Firebird" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Firebird</span></a>, <a href="https://mstdn.business/tags/InterBase" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>InterBase</span></a>, <a href="https://mstdn.business/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> and <a href="https://mstdn.business/tags/NexusDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>NexusDB</span></a>. Get it now at <br><a href="https://www.upscene.com/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="">upscene.com/</span><span class="invisible"></span></a></p>
ltning<p><span class="h-card"><a class="u-url mention" href="https://justfollow.me.uk/@sborrill" rel="nofollow noopener noreferrer" target="_blank">@<span>sborrill</span></a></span> <span class="h-card"><a class="u-url mention" href="https://mstdn.ca/@mWare" rel="nofollow noopener noreferrer" target="_blank">@<span>mWare</span></a></span> (I think you may have misread Myke's post) Since you mention ZIL .. I'm syncing two(!) multi-TB databases to a new server over NFS right now. I'm filling the 10GbE link between the servers completely. The ZIL receives 1.1GB/s of writes constantly, while the storage drives only see about 1/3 of that due to compression and the fact that the ZIL prevents write amplification.</p><p>I/O load on the ZIL is about 30-40% (due to the randomness of multiple transfers at once), on the data drives about 10-15%.</p><p>It's worth (re)considering ZIL for the write amplification help alone, even if the ZIL devices are not as fast or faster than your main storage devices. It's how we can get away with massive <a class="hashtag" href="https://pleroma.anduin.net/tag/mariadb" rel="nofollow noopener noreferrer" target="_blank">#MariaDB</a> databases on "wrongly-configured" (large recordsize) ZFS and get insane performance while doing so..</p>
irgendlink<p>Kennt sich jemand prima mit mysql, bzw. MariaDB bei WordPress-Blogs aus und könnte sich ein paar Zeilen Log anschauen, nachdem der Datenbankserver abgestürzt ist?<br><a href="https://fnordon.de/tags/wordpress" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>wordpress</span></a> <a href="https://fnordon.de/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mysql</span></a> <a href="https://fnordon.de/tags/mariadb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mariadb</span></a></p>
Perry<p>More progress on the <a href="https://infosec.exchange/tags/homelab" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>homelab</span></a> renovation.. mostly software-related at the moment though. Managed to get <a href="https://infosec.exchange/tags/nomad" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>nomad</span></a> to correctly mount the NFS volumes I needed for <a href="https://infosec.exchange/tags/smokeping" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>smokeping</span></a> and <a href="https://infosec.exchange/tags/mariadb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mariadb</span></a>, and figured out how template files work for simple config files being passed in to containers.</p><p>I'm currently using my old <a href="https://infosec.exchange/tags/unraid" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>unraid</span></a> server as the storage backend.. but I'll most likely still be upgrading to a new unraid server soon so what I setup now can easily be translated to the next server. Once I have everything transferred I'll setup a backup task across the storage on unraid so that I have all application states protected.</p><p>Last thing to figure out is the load balancing for my services. I want them all accessible via IP/port on my LAN and by service under <a href="https://infosec.exchange/tags/tailscale" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tailscale</span></a>. Not sure how this will all fit together - I probably need a dedicated box for the LB.. maybe just a simple <a href="https://infosec.exchange/tags/nginx" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>nginx</span></a> proxy with <a href="https://infosec.exchange/tags/consul" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>consul</span></a> configuration so that it's somewhat dynamic. Would love to get feedback on this, and if you know of a simpler/better way!</p>
🙃 ɐıunp zsɐɯoʇ<p>🇬🇧 I just defeated such a combination after quite a battle:<br><a href="https://infosec.exchange/tags/Oracle" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Oracle</span></a> <a href="https://infosec.exchange/tags/VPS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>VPS</span></a><br><a href="https://infosec.exchange/tags/Portainer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Portainer</span></a> (<a href="https://infosec.exchange/tags/Docker" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Docker</span></a>)<br><a href="https://infosec.exchange/tags/NGINX" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>NGINX</span></a> <a href="https://infosec.exchange/tags/Proxy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Proxy</span></a> Manager<br><a href="https://infosec.exchange/tags/Nextcloud" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Nextcloud</span></a> + <a href="https://infosec.exchange/tags/MariaDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MariaDB</span></a><br><a href="https://infosec.exchange/tags/Cloudflare" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Cloudflare</span></a><br><a href="https://infosec.exchange/tags/SSL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SSL</span></a> (<a href="https://infosec.exchange/tags/HTTPS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>HTTPS</span></a>)<br>I end the day successfully 😅<br>Does anyone want a blog tutorial?</p><p>🇵🇱 Właśnie po niezłych bojach pokonałem taką kombinację:<br>VPS Oracle<br>Portainer (Docker)<br>NGINX Proxy Manager<br>Nextcloud + MariaDB<br>Cloudflare<br>SSL (HTTPS)<br>Kończę ten dzień sukcesem 😅<br>Czy ktoś chce poradnik na blogu?</p>
Karl<p>Some really, really great news about <a href="https://mastodon.bsd.cafe/tags/MariaDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MariaDB</span></a> MaxScale, the database-aware proxy, which I think the community will appreciate!</p><p>* Version 21.06 was released as GPL<br>* GPL versions will be maintained for 5 years<br>* It is now also possible to buy a licence for the newer BSL versions, and at an affordable price as well. (Previously, this was not possible - the only way to get a licence was through a MariaDB support agreement.)</p><p><a href="https://mariadb.com/resources/blog/mariadb-maxscale-21-06-now-released-as-gpl/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">mariadb.com/resources/blog/mar</span><span class="invisible">iadb-maxscale-21-06-now-released-as-gpl/</span></a></p>