zeldor.biz

Linux, programming and more

Copyright © 2025
Log in

Nextcloud meets MariaDB

August 8, 2018 by Igor Drobot Leave a Comment

nextcloud

SQLite is good for testing and simple single-user Nextcloud instance,
but it does not scale for multiple-user production cases. For the first Installation its quiet simple and reliable.

After some years of usage my SQLite-database reached a size of 130MB and the performance was not more the same as after the first days.

You can convert a SQLite database to a more performing MariaDB database with the Nextcloud command line tool:

1
sudo -u www-data php occ db:convert-type --all-apps mysql db_username dbserver.example.com nextcloud_db

sudo -u www-data php occ db:convert-type --all-apps mysql db_username dbserver.example.com nextcloud_db

Before you go on with the command,
create a databases user with database-specific permissions to increase the usage to the nextlocud database.

Troubleshooting:
If you are using a database replication you have to change the binlog format in your mysql-configuration – my.cnf.

1
binlog_format = MIXED

binlog_format = MIXED

Filed Under: Networking Tagged With: MariaDB, MySQL, Nextcloud, sqlite

Categories

Archives

Tags

apache2 Apple arduino ARM Automation backup bash Cisco Cluster Corosync Database Debian Debian squeeze DIY DNS Fedora FTP Fun Icinga Ipv6 KVM Linux LVM MAC OS X Monitoring MySQL Nagios Nginx openSUSE OpenVPN PHP Proxy Python python3 qemu RAID rsync Samba security ssh Ubuntu virtualization Windows Windows 7 Wordpress

Leave a Reply

Your email address will not be published. Required fields are marked *

Yeaaah Cookie! We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok