zeldor.biz

Linux, programming and more

Copyright © 2023
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 *