# MariaDB Published articles for MariaDB. This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## Keycloak 26.7.4 released DevFeed: [Keycloak 26.7.4 released]() Original publisher: [Read original article]() Author: Keycloak Team Published: 2026-09-16T00:00:00Z Content type: release Language: en Sources: [Keycloak Blog]() Topics: [Keycloak](), [Security](), [Quarkus](), [MariaDB](), [MySQL](), [saml]() Tags: [cve](), [idm](), [kerberos](), [keycloak](), [keycloak-release](), [ldap](), [mariadb](), [mysql](), [openid-connect](), [quarkus](), [release](), [saml](), [security](), [sso]() ### AI overview Keycloak 26.7.4 was released on September 16, 2026. The release includes security fixes for several CVEs, an upgrade to Quarkus 3.33.3.2, and fixes for performance, testing, documentation, administration, and UI issues. ### Source excerpt To download the release go to Keycloak downloads. Upgrading Before upgrading refer to the migration guide for a complete list of changes. All resolved issues Security fixes #52834 [CVE-2026-90997] Default MySQL/MariaDB row counts make stateless replay gates accept reused artifacts #52835 [CVE-2026-79651] Keycloak Unauthenticated Denial of Service via Unbounded Locale Caching #52836 [CVE-2026-74909] Incomplete fix: percent-encoded semicolon bypasses matrix parameter stripping in PathMatcher #52837 [CVE-2026-19607] Username Takeover Leading to Account Lockout #52838 [CVE-2026-17526] Privilege escalation: the "impersonation" role can impersonate a realm administrator #52839 [CVE-2026-18212] SAML Redirect DEFLATE helpers leak native zlib state Enhancements #52354 Upgrade to Quarkus 3.33.3.2 dist/quarkus Bugs #49635 Performance issue with 26.6.2 dist/quarkus #51102 Flaky test: org.keycloak.testsuite.oauth.AccessTokenTest#accessTokenRequest ci #52015 New links errors for https://quarkus.io/guides docs #52172 Cached `RealmAdapter.isUserManagedAccessAllowed()` returns `isEnabled()` infinispan #52173 `realm_client` is computed into a client's attributes and then persisted on save admin/api #52233 Oracle 19 full client OCI driver crashes on startup since 26.6.0 -- SQLFeatureNotSupportedException on setNetworkTimeout dist/quarkus #52241 Clicking on a sub group in the admin console throws an exception admin/ui #52283 Flaky test SessionRestServiceTest.testGetDevicesSessions testsuite #52430 Flaky test: userprofile.spec.ts fails with timeout on "no-users-found-empty-action" in serial suite testsuite ## Gitea: monta tu propio servidor Git DevFeed: [Gitea: monta tu propio servidor Git]() Original publisher: [Read original article]() Author: Antonio Pérez Published: 2026-02-08T00:00:00Z Content type: tutorial Language: es Sources: [tengoping.com]() Topics: [Gitea](), [Git](), [forgejo](), [GitLab](), [Linux](), [Go Language](), [nginx](), [PostgreSQL](), [systemd](), [let's encrypt](), [MariaDB](), [SSL]() Tags: [forgejo](), [git](), [github](), [gitlab](), [go](), [let-s-encrypt](), [linux](), [mariadb](), [nginx](), [postgresql](), [ssh](), [ssl](), [systemd]() ### AI overview A Spanish tutorial explains how to install and configure Gitea as a lightweight, self-hosted Git server. It compares Gitea with GitLab and Forgejo, then covers system setup, databases, systemd, Nginx, SSL certificates, repositories, and SSH access. ### Source excerpt Instala y configura Gitea como alternativa ligera a GitHub o GitLab para alojar repositorios Git en tu propio servidor. ## Montar tu propia nube con Nextcloud DevFeed: [Montar tu propia nube con Nextcloud]() Original publisher: [Read original article]() Author: Alois Published: 2026-01-27T00:00:00Z Content type: tutorial Language: es Sources: [tengoping.com]() Topics: [Nextcloud](), [Linux](), [LAMP](), [MariaDB](), [MySQL](), [PHP](), [Debian](), [nginx](), [Ubuntu]() Tags: [debian](), [lamp](), [linux](), [mariadb](), [mysql](), [nginx](), [notes](), [office](), [php](), [talk](), [ubuntu](), [web]() ### AI overview This Spanish tutorial explains how to install and configure Nextcloud on a Linux server for self-hosted cloud storage. It covers server requirements, database setup, web-server configuration with Apache or Nginx, PHP adjustments, initial administration, and enabling applications such as Calendar, Contacts, Notes, Talk, and Office. ### Source excerpt Guía completa para instalar Nextcloud en un servidor Linux y tener tu propio almacenamiento en la nube sin depender de terceros. ## Keycloak 26.5.2 released DevFeed: [Keycloak 26.5.2 released]() Original publisher: [Read original article]() Author: Keycloak Team Published: 2026-01-23T00:00:00Z Content type: release Language: en Sources: [Keycloak Blog]() Topics: [Keycloak](), [Security](), [OpenID connect (OIDC)](), [MariaDB](), [MySQL]() Tags: [2026](), [idm](), [kerberos](), [keycloak](), [keycloak-release](), [ldap](), [mariadb](), [mysql](), [oidc](), [openid-connect](), [release](), [saml](), [security](), [sso](), [vulnerability]() ### AI overview Keycloak 26.5.2 is a release containing security fixes, enhancements, and bug fixes. The resolved issues include vulnerabilities, SSO login problems, deadlocks, OIDC and admin API issues, database migration and collation problems, and other configuration and documentation corrections. ### Source excerpt To download the release go to Keycloak downloads. Upgrading Before upgrading refer to the migration guide for a complete list of changes. All resolved issues Security fixes #44994 CVE-2025-67735 - netty-codec-http: Request Smuggling via CRLF Injection dependencies Enhancements #43443 Keycloak should warn when ISPN or JGROUPS is running in debug level logging #45498 Ignore OpenAPI artifacts when disabled dist/quarkus Bugs #44785 Can not get through SSO login if using a custom attribute with default value user-profile #45015 Deadlock in Infinispan virtual threads infinispan #45250 IDToken contains duplicate address claims oidc #45333 User admin events don't show role, group mapping, reset password like events admin/ui #45396 Database Migration fails when updating to 26.5.0 on MS SQL core #45415 cache-remote-host becomes mandatory at build time when using clusterless feature infinispan #45417 Unmanaged Attributes Type (Only administrators can view) allows admin API to set Unmanaged Attributes user-profile #45474 Admin REST API document is not up to date docs #45526 Regression (26.5.1): Organizations domain resolution fails on MariaDB/MySQL due to ORG/ORG_DOMAIN collation mismatch organizations #45533 Keycloak should not allow matrix parameters in URLs as we don't use them dist/quarkus #45570 CVE-2025-66560 - io.quarkus/quarkus-rest: Quarkus REST Worker Thread Exhaustion Vulnerability #45584 Keycloak supported specs should list DPoP as supported oidc #45590 OIDCIdentityProviderConfig issuer configuration token-exchange #45597 Possible mismatch of charset/collation between columns on mysql/mariadb organizations #45651 CVE-2025-14559 keycloak-services: Keycloak keycloak-services: Business logic flaw allows unauthorized token issuance for disabled users ## Keycloak 26.3.5 released DevFeed: [Keycloak 26.3.5 released]() Original publisher: [Read original article]() Author: Keycloak Team Published: 2025-09-25T00:00:00Z Content type: release Language: en Sources: [Keycloak Blog]() Topics: [Keycloak](), [Quarkus](), [Netty](), [vulnerability](), [MariaDB](), [OpenID connect (OIDC)](), [Caching]() Tags: [2025](), [cache](), [http](), [idm](), [kerberos](), [keycloak](), [keycloak-release](), [ldap](), [mariadb](), [oidc](), [openid-connect](), [quarkus](), [release](), [saml](), [sso](), [upgrade](), [vulnerability]() ### AI overview Keycloak 26.3.5 is released with an upgrade to Quarkus 3.20.3 LTS, removal of the explicit MariaDB connector dependency, and fixes for administrative UI, organization, cache, OIDC, and security issues including two Netty vulnerabilities. ### Source excerpt To download the release go to Keycloak downloads. Upgrading Before upgrading refer to the migration guide for a complete list of changes. All resolved issues Enhancements #41371 Upgrade to Quarkus 3.20.3 LTS dist/quarkus #41373 Remove explicit MariaDB connector dependency dist/quarkus Bugs #41418 Access to user details for restricted admin fails after enabling organizationin realm organizations #42405 Old hmac-generated (32bit) is recreated when order is changed in realm keys ui core #42491 CVE-2025-58057 - Netty BrotliDecoder / Data Amplification vulnerability dist/quarkus #42492 CVE-2025-58056 - Netty HTTP Request Smuggling vulnerability dist/quarkus #42736 Reset password in admin UI with 'not recently used' password policy leads to error 'Device already exists with the same name' core #42769 Missing switch "ID Token as detached signature" in the admin console client settings oidc #42922 Dynamic Client Registration invalidates the realm cache core ## Keycloak 26.3.2 released DevFeed: [Keycloak 26.3.2 released]() Original publisher: [Read original article]() Author: Keycloak Team Published: 2025-07-24T00:00:00Z Content type: release Language: en Sources: [Keycloak Blog]() Topics: [Keycloak](), [OpenID connect (OIDC)](), [Databases](), [Security](), [migration]() Tags: [clustering](), [dependencies](), [idm](), [kerberos](), [keycloak](), [keycloak-release](), [ldap](), [logging](), [mariadb](), [migration](), [oidc](), [openid-connect](), [postgresql](), [release](), [saml](), [sso](), [upgrade](), [version](), [vulnerability]() ### AI overview Keycloak 26.3.2 was released on July 24, 2025. The release adds an OIDC identity-provider authentication option, improves clustering and client-session logging, upgrades dependencies, and lists resolved bugs and vulnerabilities. ### Source excerpt To download the release go to Keycloak downloads. Upgrading Before upgrading refer to the migration guide for a complete list of changes. All resolved issues New features #40237 Add option "Requires short state parameter" to OIDC IDP authentication Enhancements #40970 Run clustering compatibility tests on release/x.y branches #41034 Improve logging for client sessions load #41257 Upgrade to Infinispan 15.0.18.Final infinispan Bugs #39091 Flaky test: org.keycloak.testsuite.cluster.JGroupsCertificateRotationClusterTest#testCoordinatorHasScheduleTask ci #39634 Update MariaDB connector to 3.5.3 dist/quarkus #39854 Flaky test: org.keycloak.testsuite.cluster.PermissionTicketInvalidationClusterTest#crudWithFailover ci #40553 Upgrade org.postgresql:postgresql to version 42.7.7 to address CVE-2025-49146 dependencies #40736 CVE-2025-49574 - Exposure of Resource to Wrong Sphere vulnerability in io.vertx:vertx-core dependencies #40782 Flaky test: org.keycloak.testsuite.cluster.RealmInvalidationClusterTest#crudWithFailover ci #40784 Default jdbc-ping cluster setup for distributed caches fails in Oracle infinispan #40977 Loglevel recorded from build phase dist/quarkus #40980 Can't update security-admin-console via admin UI with volatile sessions infinispan #40995 LDAP / ModelException: At least one condition should be provided to OR query core #41018 Flaky test: org.keycloak.testsuite.cluster.ClientInvalidationClusterTest#crudWithFailover ci #41038 FIPS errors in CI #41082 Multiple primary key defined when attempting to upgrade after 26.3.0 core #41103 Service Account users now showing in the User List admin/ui #41105 Unknown relation when removing realm role with --db-schema configured storage #41152 Docs use em-dashes instead of double dashes for SPI options in regular text docs #41204 UpdateTest CI failures ci #41370 [26.3] MariaDB connector dependency is not properly overriden dist/quarkus ## Connecting to an External Database in Craft CMS DevFeed: [Connecting to an External Database in Craft CMS]() Original publisher: [Read original article]() Author: andrew@nystudio107.com (Andrew Welch) Published: 2024-08-06T14:03:00Z Content type: tutorial Language: en Sources: [nystudio107 | Articles on modern web development.]() Topics: [Databases](), [Content Management System](), [configuration](), [MySQL](), [MariaDB](), [PostgreSQL](), [SQLite](), [legacy]() Tags: [application](), [built-in](), [cms](), [components](), [configuration](), [connect](), [craft](), [database](), [external](), [flexibility](), [how-to](), [insights](), [learn](), [legacy](), [leveraging](), [mariadb](), [mysql](), [postgresql](), [sqlite](), [using]() ### AI overview A tutorial explaining how to connect Craft CMS to an external database using Twig and configuration in config/app.php, without requiring the deprecated Connect plugin. It covers Craft application components and database types supported through Yii2. ### Source excerpt Learn how to connect to an external database using Craft CMS by leveraging the built-in flexibility of application components ## Keycloak 25.0.1 released DevFeed: [Keycloak 25.0.1 released]() Original publisher: [Read original article]() Author: Keycloak Team Published: 2024-06-20T00:00:00Z Content type: release Language: en Sources: [Keycloak Blog]() Topics: [Keycloak](), [Authentication](), [LDAP](), [MariaDB](), [MySQL]() Tags: [bug](), [idm](), [kerberos](), [keycloak](), [keycloak-release](), [ldap](), [mariadb](), [mysql](), [openid-connect](), [release](), [saml](), [sso](), [upgrade]() ### AI overview Keycloak 25.0.1 is a release update containing an enhancement and a list of resolved bugs affecting areas including the admin UI, configuration, authentication, databases, LDAP testing, and session migration. ### Source excerpt To download the release go to Keycloak downloads. Upgrading Before upgrading refer to the migration guide for a complete list of changes. All resolved issues Enhancements #19750 Use a proper FreeMarker template for the new consoles account/ui #30346 Enhance masking around config-keystore dist/quarkus Bugs #25234 front channel logout to clients are not called at Identity Proxy when using front channel logout to Identity Provider( oidc #28643 Encountering `NullPointerException` - `KeycloakIdentity.getUserFromToken()` when running `admin-ui` locally admin/ui #30115 Admin v2 theme - theme.properties Custom theme scripts not loading admin/ui #30201 Keycloak CI - failure in Store IT (aurora-postgres) ci #30240 Custom attributes are removed during UPDATE PROFILE event core #30300 Upgrade to Keycloak 25 - Table 'USER_CONSENT' is specified twice on MySQL/MariaDB database core #30302 Methods of SimpleHttp are after change now too much protected core #30306 Upgrade to Keycloak 25 - Events bug in UI admin/ui #30332 Operator fails to patch ingress after update to 25.0.0 operator #30334 RESTART_AUTHENTICATION_ERROR when login in in private browser window after 25.0.0 update core #30351 Migration of sessions in KC25 should run only on migration, not on imports #30368 Documentation : label error for persistent-user-sessions feature flag docs #30417 Keycloak 25 db guide shows unevaluated "ifeval docs #30432 keycloak hostname:v2 /admin used on "hostname" instead of "hostname-admin" admin/ui #30434 Improvements for ldap test authentication ldap #30492 partial_import_test fails randomly admin/ui ## Workaround for MySQL's "can't specify target table for update in FROM clause" Error DevFeed: [Workaround for MySQL's "can't specify target table for update in FROM clause" Error]() Original publisher: [Read original article]() Author: lukaseder Published: 2023-12-20T14:20:29Z Content type: tutorial Language: en Sources: [jOOQ]() Topics: [MySQL](), [SQL](), [bug](), [rdbms]() Tags: [bug](), [for-update](), [from-clause](), [jooq-in-use](), [mariadb](), [mysql](), [rdbms](), [sql](), [table](), [target-table](), [update]() ### AI overview The article explains MySQL error 1093, which occurs when an UPDATE statement references its target table in a FROM clause. It presents a jOOQ transformation as a workaround and notes that similar workarounds appear in the MySQL documentation. ### Source excerpt In MySQL, you cannot do this: The UPDATE statement will raise an error as follows: SQL Error [1093] [HY000]: You can't specify target table 't' for update in FROM clause People have considered this to be a bug in MySQL for ages, as most other RDBMS can do this without any issues, including MySQL clones: ... Continue reading Workaround for MySQL's "can't specify target table for update in FROM clause" Error -> ## Databases in 2022: A Year in Review DevFeed: [Databases in 2022: A Year in Review]() Original publisher: [Read original article]() Author: Andy Pavlo Published: 2022-12-31T05:00:00Z Content type: opinion Language: en Sources: [Andy Pavlo - Carnegie Mellon University]() Topics: [Databases](), [data](), [Cloud](), [DuckDB](), [MariaDB](), [Query (disambiguation)](), [Streaming](), [Time Series]() Tags: [analysis](), [announcements](), [blog](), [cloud](), [database](), [databases](), [duckdb](), [funding](), [mariadb](), [postgresql](), [query](), [review](), [streaming](), [time-series](), [year-in-review]() ### AI overview A retrospective on the database world in 2022, covering quieter benchmark competition, database startup funding, and notable developments involving companies and technologies such as PostgreSQL, DuckDB, Druid, Trino, and MariaDB. It finds that large funding rounds slowed substantially in the second half of the year. ### Source excerpt Andy is back with his analysis of the database world in 2022, including VC funding, blockchains, and Larry Ellison. ## jOOQ 3.17 Supports Implicit Join also in DML DevFeed: [jOOQ 3.17 Supports Implicit Join also in DML]() Original publisher: [Read original article]() Author: lukaseder Published: 2022-08-25T08:07:00Z Content type: article Language: en Sources: [jOOQ]() Topics: [SQL](), [Databases]() Tags: [correlated-subqueries](), [delete](), [dml-join](), [implicit-join](), [join](), [jooq](), [jooq-3-17](), [jooq-development](), [mariadb](), [mysql](), [oracle](), [postgresql](), [sql](), [update]() ### AI overview The article explains that jOOQ 3.17 adds support for implicit join path expressions in DML statements. It describes correlated-subquery emulation, DML JOIN support for selected RDBMS, and planned translation using updatable views in Oracle. ### Source excerpt Since jOOQ 3.11, implicit joins have been supported. An implicit join is a JOIN (mostly a LEFT JOIN) that is generated implicitly because of the presence of a path expression. If SQL supported the syntax natively, it would look like this: All that is is convenience for a bunch of explicitly written LEFT JOIN expressions: ... Continue reading jOOQ 3.17 Supports Implicit Join also in DML -> ## The Many Ways to Return Data From SQL DML DevFeed: [The Many Ways to Return Data From SQL DML]() Original publisher: [Read original article]() Author: lukaseder Published: 2022-08-23T15:02:04Z Content type: tutorial Language: en Sources: [jOOQ]() Topics: [SQL](), [Databases](), [PostgreSQL](), [Oracle Database](), [CockroachDB]() Tags: [article](), [cockroachdb](), [data-change-delta-table](), [database](), [firebird](), [generated-keys](), [how-to](), [jdbc](), [jooq](), [mariadb](), [postgresql](), [return-generated-keys](), [returning](), [sql]() ### AI overview This article explains ways to return data from SQL DML statements using jOOQ across multiple SQL dialects and directly through JDBC. It covers RETURNING-style syntax, Oracle PL/SQL emulation, PostgreSQL support, and the SQL standard's data-change-table reference approach. ### Source excerpt Probably the hardest thing to standardise in SQL is RETURNING data from DML statements. In this article, we'll look at various ways of doing that with jOOQ, in many of jOOQ's supported dialects, and with JDBC directly. How to do it with jOOQ Assuming the usual table from the sakila database: jOOQ took syntactic inspiration ... Continue reading The Many Ways to Return Data From SQL DML -> ## Supported databases for the new Keycloak store DevFeed: [Supported databases for the new Keycloak store]() Original publisher: [Read original article]() Author: Stian Thorgersen Published: 2022-02-24T00:00:00Z Content type: article Language: en Sources: [Keycloak Blog]() Topics: [Keycloak](), [CockroachDB](), [PostgreSQL](), [Databases]() Tags: [cockroachdb](), [databases](), [idm](), [kerberos](), [keycloak](), [kubernetes](), [ldap](), [mariadb](), [mysql](), [nosql](), [open-source](), [openid-connect](), [oracle](), [postgresql](), [saml](), [sql-server](), [sso]() ### AI overview Keycloak outlines a plan to classify database support into first-class, second-class, and community levels. PostgreSQL and CockroachDB are identified as first-class candidates, while MySQL, MariaDB, SQL Server, and Oracle may be phased out over time. ### Source excerpt Maintaining a broad selection of relational database support is expensive, and also more importantly limits how well the databases can be supported. With that in mind we are looking at supporting databases at different levels; first class, second class, and community. Please fill in this survey as we'd like to gather as much feedback as we can. First class databases The aim of first class databases is to offer better levels of tuning and testing, better defaults, and better documentation. We will also be considering testing with different versions and variants of the selected first class databases, such as cloud services. First class databases will be the solutions we are looking towards when scaling and tuning database to accommodate large scale deployments with high-availability, including multi-region deployments. As first class databases we aim to support one traditional relational database, and a cloud native database. With this in mind we have selected PostgreSQL and CockroachDB as the best candidates. PostgreSQL is a high quality fully open source database, with many supported offerings such as: Azure Database for PostgreSQL Amazon RDS for PostgreSQL BigAnimal Cloud SQL for PostgreSQL Cruncy Bridge Cruncy PostgreSQL for Kubernetes EnterpriseDB CockroachDB is an cloud native open source database, with PostgreSQL compatibility. By cloud native it means that it can scale horizontally, including spanning multiple-regions. There are some competitive solutions, but not as mature, and with less streamlined PostgreSQL compatibility. There are obviously also NoSQL and other non-relational database that could in theory be a good fit for Keycloak, but would be a lot of additional effort to support. It is also worth mentioning that we are still looking towards Infinispan as our cache layer, but are also aiming to support running Keycloak without Infinspan for smaller deployments with PostgreSQL and larger deployments with CockroachDB. Second class databases The aim for s ## SQLDelight on the Server DevFeed: [SQLDelight on the Server]() Original publisher: [Read original article]() Published: 2020-08-27T16:05:00Z Content type: article Language: en Sources: [Blogs on Ryan Harter]() Topics: [Object-relational mapping](), [SQL](), [MySQL](), [Databases](), [API]() Tags: [android](), [api](), [mariadb](), [mysql](), [orm](), [postgresql](), [sql](), [sqldelight]() ### AI overview The article explains how SQLDelight evolved from an Android ORM into a multiplatform database access tool that supports server-grade dialects such as MySQL, MariaDB, PostgreSQL, and H2. It also describes using SQLDelight with MySQL in a currency conversion API called Gringotts. ### Source excerpt I've used Cashapp's SQLDelight for years in my Android apps. Unlike other ORM libraries, which create an abstraction that allows you to access databases in native code and generates the SQL to access the data for you, SQLDelight embraces SQL as a first class language, recognizing it's optimizations for defining and querying data, and allows you to write queries and data definitions and generates consuming code based on those. Over the last few years SQLDelight has been transformed from a nice Android ORM that integrates nicely with AutoValue into a mutliplatform option to access and manage your data without having to learn another query abstraction. ## Use replica database for read-only transactions DevFeed: [Use replica database for read-only transactions]() Original publisher: [Read original article]() Published: 2019-11-27T00:00:00Z Content type: tutorial Language: en Sources: [Paweł Chudzik]() Topics: [Transactions](), [Spring Boot](), [MariaDB](), [Replication](), [Docker Compose](), [Amazon Web Services]() Tags: [aws](), [docker-compose](), [mariadb](), [replication](), [spring-boot](), [transactions]() ### AI overview This tutorial shows how to configure a Spring Boot application to route read-only transactions to a replica database while continuing to write data to the master. It describes a setup using MariaDB instances, replication, Docker Compose, and AWS RDS, while noting that the example replication configuration is intended for testing rather than production. ### Source excerpt Some time ago we had a problem with performance caused by generating big reports for users. During one of the firehouse meetings, there was an idea to generate reports from the replica database. We've solved the issue differently but the idea got me interested. In this post, I'll configure spring-boot based application to use the replica database for all read-only transactions. Read more ## Dockerized dev database DevFeed: [Dockerized dev database]() Original publisher: [Read original article]() Published: 2018-01-09T00:00:00Z Content type: tutorial Language: en Sources: [Paweł Chudzik]() Topics: [Development](), [Docker](), [MariaDB](), [Dockerfile](), [Databases]() Tags: [build](), [database](), [development](), [docker](), [docker-image](), [docker-registry](), [mariadb](), [script]() ### AI overview A tutorial showing how to automate development database setup with Docker. It uses scripts to import a database dump into MariaDB, package the populated data into a Docker image, and optionally push that image to a Docker registry to reduce repeated waiting for imports. ### Source excerpt If because of reasons you have to run Maria/Postgres/Oracle on localhost for development and you often import database dumps into it you probably spend some time waiting for DB to be ready to use. In this post, I'm going to show you how you can automate the whole process and save some time doing it with docker. Read more ## Daily MySQL backups with xtrabackup DevFeed: [Daily MySQL backups with xtrabackup]() Original publisher: [Read original article]() Author: Tom Published: 2016-04-23T00:00:00Z Content type: tutorial Language: en Sources: [Tomasz Gągor]() Topics: [backups](), [MySQL](), [Percona](), [Encryption](), [MariaDB](), [passwords]() Tags: [backup](), [backups](), [config](), [credentials](), [database](), [encryption](), [files](), [local](), [mariadb](), [mysql](), [nas](), [password](), [percona](), [script](), [security]() ### AI overview A tutorial on using xtrabackup for daily MySQL backups, including backup creation, encrypted credential handling, archive storage, and restoration. It compares xtrabackup with standard MySQL dumps and discusses MariaDB, Percona, and NAS storage. ### Source excerpt I've been using standard MySQL dumps as backup technique on my VPS for few years. It works fine and backups were usable few times when I needed them. But in other places I'm using xtrabackup1. It's faster when crating backups and a lot faster when restoring them - they're binary so there is no need to reevaluate all SQL create tables/inserts/etc. Backups also include my.cnf config file so restoring on other machine should be easy. ## MySQL - reset root password DevFeed: [MySQL - reset root password]() Original publisher: [Read original article]() Author: Tom Published: 2015-12-28T00:00:00Z Content type: tutorial Language: en Sources: [Tomasz Gągor]() Topics: [MySQL](), [passwords](), [Databases](), [configuration]() Tags: [configuration](), [credentials](), [linux](), [localhost](), [mariadb](), [mysql](), [password](), [percona](), [root](), [set]() ### AI overview A tutorial explaining how to reset a MySQL user password, including the root password, by stopping MySQL, using an init file with a SET PASSWORD command, starting the server with that file, and then deleting it. ### Source excerpt It will happen from time to time, that you're on alien machine and have to brutally update things in db without knowing credentials. Example is for root (quite secure candidate to change because it shouldn't be used in app 😃 ) but will work for any user. shutdown db service mysql stop create text file with command like this (update user accordingly) ex. in /tmp/pwchange.txt SET PASSWORD FOR "root"@"localhost" = PASSWORD("HereYourNewPassword"); start mysqld with --init-file param mysqld_safe --init-file=/tmp/pwchange.txt sometimes you may require to point configuration file ex. --defaults-file=/etc/mysql/my.cnf ## Debian - Upgrade MySQL to MariaDB DevFeed: [Debian - Upgrade MySQL to MariaDB]() Original publisher: [Read original article]() Author: Tom Published: 2014-01-24T00:00:00Z Content type: tutorial Language: en Sources: [Tomasz Gągor]() Topics: [Debian](), [MariaDB](), [upgrade](), [MySQL](), [apt](), [migration]() Tags: [apt](), [debian](), [install](), [installation](), [linux](), [mariadb](), [migration](), [mysql](), [repo](), [repositories](), [upgrade]() ### AI overview A practical guide to upgrading MySQL to MariaDB on Debian. It covers adding the MariaDB repository and key, installing the relevant packages, and using repository pinning to prevent Debian packages from switching the installation back to MySQL. The author reports that blog page generation time decreased from about 650 ms to 550 ms after the migration. ### Source excerpt After reading some good opinions about MariaDB I wanted to give it a try. Upgrade looks quite straight forward but I found some issues a little tricky. Installation Add repo and key: cat > /etc/apt/sources.list <) Original publisher: [Read original article]() Author: Dimitri Fontaine PostgreSQL Major Contributor; Author Published: 2013-10-16T19:07:00Z Content type: opinion Language: en Sources: [Dimitri Fontaine]() Topics: [MariaDB](), [PostgreSQL](), [Open Source]() Tags: [drop-in](), [innovation](), [interview](), [mariadb](), [open-source](), [postgresql](), [video]() ### AI overview The article presents an Open World Forum interview about the current state of MariaDB and PostgreSQL. It describes MariaDB as a fully open-source, drop-in replacement for MySQL and notes progress and innovation around it, while characterizing PostgreSQL as "YeSQL." ### Source excerpt At the Open World Forum two weeks ago I had the pleasure to meet with Colin Charles. We had a nice talk about the current state of both MariaDB and PostgreSQL, and even were both interviewed by the Open World Forum Team. The interview is now available online. Dear French readers, it's in English. Here's the video: Executive Summary: MariaDB is a drop-in fully Open Source replacement for MySQL and sees quite some progress and innovation being made, and PostgreSQL is YeSQL! ## MySQL - Proste metody optymalizacji DevFeed: [MySQL - Proste metody optymalizacji]() Original publisher: [Read original article]() Author: Tom Published: 2011-12-29T00:00:00Z Content type: tutorial Language: pl Sources: [Tomasz Gągor]() Topics: [MySQL](), [Cache]() Tags: [backup](), [cache](), [index](), [information-schema](), [mariadb](), [mysql](), [percona](), [schema](), [var]() ### AI overview A Polish tutorial presents MySQL configuration adjustments for improving database performance, covering MyISAM key caching, InnoDB buffer pool and log file sizing, and the storage and compaction behavior of InnoDB data files. ### Source excerpt Wcześniej czy później zawsze pojawia się potrzeba zoptymalizowania naszej bazy MySQL. Przedstawię kilka zmian w konfiguracji, które powinny zwiększyć wydajność w większości przypadków. MyISAM - key_buffer_size Najprostszą optymalizacją baz/tabel z mechanizmem MyISAM jest odpowiednie dobranie bufora na cache dla kluczy i indeksów (dane nigdy nie są cachowane). Poniższe zapytanie pozwala oszacować zalecany rozmiar cache'u: SELECT CONCAT(ROUND(KBS/POWER(1024, IF(PowerOf1024<0,0,IF(PowerOf1024>3,0,PowerOf1024)))+0.4999), SUBSTR(' KMG',IF(PowerOf1024<0,0, IF(PowerOf1024>3,0,PowerOf1024))+1,1)) recommended_key_buffer_size FROM (SELECT LEAST(POWER(2,32),KBS1) KBS FROM (SELECT SUM(index_length) KBS1 FROM information_schema.tables WHERE engine='MyISAM' AND table_schema NOT IN ('information_schema','mysql')) AA ) A, (SELECT 2 PowerOf1024) B; Wynik określa zalecany rozmiar bufora (parametr key_buffer_size w pliku /etc/mysql/my.cnf) dla bieżącego stanu bazy - warto ciut dodać na zapas. Na systemach 32 bitowych parametr key_buffer_size może przyjmować maksymalnie 4GB, na 64 bitowych maksymalnie 8GB. ## MySQL - dostęp zdalny na szybko DevFeed: [MySQL - dostęp zdalny na szybko]() Original publisher: [Read original article]() Author: Tom Published: 2011-08-27T00:00:00Z Content type: tutorial Language: pl Sources: [Tomasz Gągor]() Topics: [MySQL](), [SQL](), [Databases](), [Server]() Tags: [apt](), [debian](), [flush](), [ip](), [localhost](), [mariadb](), [mysql](), [percona](), [root](), [server](), [sql]() ### AI overview A Polish tutorial explains how to install MySQL Server on Debian and configure remote access. It covers granting privileges, limiting access by IP address, changing the MySQL bind address, and restarting the server. ### Source excerpt Instalacja serwera MySQL na Debianie jest niezwykle prosta i sprowadza się do jednego polecenia: sudo apt-get install mysql-server Polecenie to zainstaluje i uruchomi usługę serwerową MySQL. W czasie instalacji będziemy proszeni o podanie hasła dla root'a (które oczywiście dobrze jest zapamiętać bądź zapisać). Tak zainstalowana baza nasłuchuje na lokalnym porcie (localhost:3306) umożliwiająć dostęp wyłącznie root'owi. Jest to bardzo bezpieczna konfiguracja... Ale jeśli nie mamy zamiaru na tej samej maszynie instalować oprogramowania zarządzającego to nie zawsze jest to wygodne, tym bardziej gdy przykładowo mamy działającego phpmyadmin'a na jakimś serwerze www. W takim przypadku pierwszą rzeczą, którą robię jest udostępnienie dostępu zdalnego dla root'a. Warto zaznaczyć że uprawnienia root'a można nadać dowolnemu użytkownikowi (np. romanowi) co jest dużo bezpieczniejszą konfiguracją niż działanie bezpośrednio na koncie root'a (którego nazwa jest powszechnie znana).