@jaredbusch
I got project in CRM SAAS development.
So they want to add custom field feature like saleforce.
I am not trying to match their scale, just want to get some information about the database engine and structure, so we can at least stay under best practice guideline for such case.
The options I have currently :
Just not sure which is the best for my case above.
I got project related to above questions and want to decide the best practice for above case.
Hi,
Anyone here know what kind of database engine & schema that salesforce use to facilitate multi-tenant SAAS and each tenant has its own custom field that they can define?
I read online, they use SQL (oracle) with EAV (Entity Attribute Value) for custom field schema.
Can anyone confirm this?
is EAV preferred compared to json native column that recently supported by mysql / maria in term of performance?
What is the down side for json column? Lack of join syntax?
Thanks 
@dafyre may i know why u change from ur owned hosting to theirs?
@fateknollogee yup CentOs normally has better wide range of support. Thats the reason i stick to it even it is less modern than fedora.
@fuznutz04 said in KVM on Fedora 26 Server edition:
openssh-askpass
try : sudo yum install openssh-askpass
@tim_g another one is because Dell always issue RHEL package which normally is compatible with centos. Never try it with fedora, so not sure it will run well. ie. Omsa dell.
Related to KVM, what fedora can offer that CentOs cant?
@tim_g said in Best practice partition & LVM for KVM:
@kuyaz said in Best practice partition & LVM for KVM:
LVG : vg_ssd_critical_vm
/vm (ssd)
LVG : vg_sata_non_critical_vm
/boot 2GB
/bootBIOS 1GB
/root (ALL remaining space)
/swap (32GB)I'd use XFS. Don't use EXT4. You're correct with using LVM.
I'd go like this:
LVG : vg_ssd_critical_vm
/DATAssdLVG : vg_sata_non_critical_vm
/DATAhdd (xfs)
/boot 2GB (xfs)
/bootBIOS 1GB
/root 50GB (xfs)
/swap 32GB (swap)
/home whatever (xfs)As @travisdh1 said, you'll need space for snapshots of the LVMs, but don't do it for the VMs. Use VM snapshots for those instead.
You're VMs should be RAW (.img) for better performance.
So i put the vmware img in the dataHDD?
Please note this is for production server running sql and web apps (it it matters).
What is the disadvantage if i dont separate the datahdd and home from root? Mine is all lumped in root.
Will redo since im not too far off.
Hi all,
If I have :
What is the best practice partition and mount point for above configuration?
I want to utilize ssd for VM that required high IOPs and the rest will be on SATA.
Is it ok if i do like this :
LVG : vg_ssd_critical_vm
/vm (ssd)
LVG : vg_sata_non_critical_vm
/boot 2GB
/bootBIOS 1GB
/root (ALL remaining space)
/swap (32GB)
I plan to install centos with KVM and ovirt on Sata Raid. Should i also separate the host on different partition / LV?
Do I need to spare some free space for LVM snapshot?
All guru please advise... thanks
Hi All,
Please share you most preferred KVM Management tools here.
Im thinking to use Proxmox. Any thought?
Thanks.
@jaredbusch I tried mklink but doesn't work with BB.
I didn't know you was referring to CP.
Thanks for the info.
hi, how do you emulate the share folder as hard disk in windows 10?
@ramblingbiped glacier restore time is very slow and quite expensive. but it is good alternative
@larsen161 this is what im talking about hahahhaa.... you must have lots of interesting video collection there 
if you know what i mean 
@scottalanmiller after trying, get to know they charge 5$ per computer license.
I thought they charge 5$ flat for 1 single account with any computer backup
still considered cheap...
@reid-cooper my synology NAS is in local network with 1 Gbps link. so it is quite fast.
@stacksofplates thanks a bunch! it shows now!
yum install cockpit-networkmanager
yum install cockpit-storaged
16TB usable. Important files, i sync it with synology cloud nas .