Skip Navigation

Posts
57
Comments
32
Joined
2 yr. ago

  • What do you mean a default user? You can just run 'mariadb' to access to console with the same user that had permissions to run 'apt install'.

    For your actual application you need to plan what database name to use, what user, what permissions it needs, potentially remote connection and TLS etc. This indeed is some work and could perhaps be automated a bit, but it also needs sysadmin to make some decisions.

  • Yes, increasing the InnoDB buffer pool to use all available memory is the most important configuration change a sysadmin can do. But in order to do it, you need to know if the host is dedicated to one MariaDB instance or if there are multiple servers on the same host. Otherwise you would just have processes each hogging more memory when they can and not giving it up to others.

    I could think about having a dialog during the installation that asks something like "Is host dedicated to this MariaDB instance? If yes, automatically configure it to use most of the system RAM available."

  • MariaDB supports Galera clustering out-of-the-box, and also traditional primary/replica setups. But you need to have something that spans multiple hosts to monitor and manage it, and that is outside of what a single-host OS package management system can do.

  • MariaDB / MySQL @lemmy.ml

    What do users of MariaDB in Debian/Ubuntu want to see in future versions?

  • You mean ollama? There are so many options, any favorites?

  • Ubuntu @programming.dev

    What do users of MariaDB in Ubuntu want to see in future versions?

  • Ubuntu Linux @lemmy.ml

    What do users of MariaDB in Ubuntu want to see in future versions?

  • Database @lemmy.ml

    What to do when a MySQL/MariaDB database gets too large for a single host?

  • I just prefix all my git aliases with g-. So for status I type g-s<tab>.

  • You need bisect only as a last resort. Effective use of git blame, git log -p -S <keyword> etc has always been enough for me. Also, the projects I work with take 10+ minutes to compile even when cached, so doing tens of builds to bisect is much slower than just hunting for strings in git commits and code.

  • I had the same feeling until I started using gitk. I always have a gitk window open and press F5 to reload, so it shows me the state of everything after I've run git commands. Now I grasp everything much better.

  • Only product from Microsoft I actually like using and trust. Quality from 1998, and still going :)

  • One is enough if it is very big

  • Try again tomorrow, seems it got popular today