On 19 May 2022, at 00:48, Morgan Jones <morgan(a)morganjones.org>
wrote:
Hello Everyone,
We are merging our student directory (about 200,000 entries) into our existing employee
directory (about 25,000 entries).
They're a pair of multi-master replicas on virtual hardware that can easily be
expanded if needed though hardware performance hasn't been an issue.
Does this justify creating separate database for students? Aside from basic tuning are
here any big pitfalls we should look out for?
I think extra databases creates more administration overhead than benefit. The benefit to
extra databases is "improved write performance" generally speaking. But the
trade is subtree queries are more complex to eval for the server.
It's far easier for you the admin, and also support staff if you keep it as a single
db. We have done huge amounts to improve parallel reads in recent years, so you should see
large gains when you change from 1.3 to 1.4 or 2.0 :)
We're still on CentOS 7 for the time being:
[root@prdds21 morgan]# rpm -qa|grep 389
389-admin-1.1.46-4.el7.x86_64
389-console-1.1.19-6.el7.noarch
389-dsgw-1.1.11-5.el7.x86_64
389-admin-console-1.1.12-1.el7.noarch
389-ds-1.2.2-6.el7.noarch
389-ds-base-libs-1.3.10.2-13.el7_9.x86_64
389-ds-base-1.3.10.2-13.el7_9.x86_64
389-adminutil-1.1.22-2.el7.x86_64
389-admin-console-doc-1.1.12-1.el7.noarch
389-ds-console-doc-1.2.16-1.el7.noarch
389-ds-console-1.2.16-1.el7.noarch
[root@prdds21 morgan]#
thank you,
-morgan
_______________________________________________
389-users mailing list -- 389-users(a)lists.fedoraproject.org
To unsubscribe send an email to 389-users-leave(a)lists.fedoraproject.org
Fedora Code of Conduct:
https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines:
https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives:
https://lists.fedoraproject.org/archives/list/389-users@lists.fedoraproje...
Do not reply to spam on the list, report it:
https://pagure.io/fedora-infrastructure
--
Sincerely,
William Brown
Senior Software Engineer,
Identity and Access Management
SUSE Labs, Australia