@kuyaz said in Database schema for user custom field in SAAS ie. salesforce:

@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 :

EAV JSON Column (Mysql / Maria recently supported this). / POSTGRESQL NOSQL

Just not sure which is the best for my case above.

Why would Salesforce's decisions indicate a best practice or an appropriate practice for you? SF does a good job, don't get me wrong. But there are a lot of things to consider:

What SF is doing and what you are doing aren't related even if it is similar data types. So what is right for them at best gives you a starting point for you. SF is old, really old. That's not to say that they've not kept up, but they are dealing with loads and loads of legacy code, data, and decisions that aren't relevant to you. Just before SF made a decision, doesn't mean it's a good one. They might be living with some very bad decisions and just feel stuck with them or haven't evaluated other options. SF's scale is one of the biggest things that dictates their decisions, so you can't look to them for guidenace if it isn't their scale that you want dictating what you perceive. NoSQL is a massive pool of options, this doesn't exactly narrow things down. This isn't a case where best practices exist. That's not something you can look for. You can, at best, look to see what others have used, what has come about since then, and attempt to extrapolate based on guesses as to their logic.

@tim_g said in Best practice partition & LVM for KVM:

@scale said in Best practice partition & LVM for KVM:

@fateknollogee said in Best practice partition & LVM for KVM:

btw, does @scale use Fedora or CentOS for their appliances?

Our distribution is officially SCEL, Scale Computing Enterprise Linux.

We start from CentOS 7, but obviously the changes are pretty significant. So it's only a reference starting point, it's not a CentOS system any longer.

Ah, so basically a fork from CentOS 7 then.

Basically, yes. It starts from there.

@fateknollogee said in What is KVM Best Management Tools in 2017?:

scale

Sys Admins don't use Scale. Its' a platform. Platform admins use it. Bit different.

@francesco-provino said in Fedora 26 + XEN + EFI = multiboot error:

@kuyaz said in Fedora 26 + XEN + EFI = multiboot error:

ok will give it a shot after i give up with fedora 😄
maybe will try centos also as i am abit more familiar with centos. I also feel there are more online reference for centos compared to fedora. maybe it is just me 😄

Fedora / CentOS removed part of the Xen compatibility in favour of KVM years ago. Of course you can still do a Xen host with CentOS, but it could be harder than with SUSE or Ubuntu.

Right, Suse, more than anyone else, embraces Xen.

H310 is not meant to be a RAID controller, it might do passthrough well.

@kuyaz said in Mangolassi framework:

Just info for bugs : When i zoom (pinch out) in safari ios. Sometimes it break the layout and can goes back to normal size.

I never have a problem with that outside of the hamburger menu.

@travisdh1 said in 2 RAID 1 or 1 RAID 10 for VM Server Host:

@scottalanmiller said in 2 RAID 1 or 1 RAID 10 for VM Server Host:

@kuyaz said in 2 RAID 1 or 1 RAID 10 for VM Server Host:

since I use raid 1 for sata hdd. Can i upgrade to raid 10 in future without losing data? Assuming i use software raid MD.

No, there is really no software or controller that will let you move from RAID 1 to RAID 10. You will need to delete and recreate to do that.

You could create another RAID1 or 10 and add that as another physical volume to the LVM. @scottalanmiller is correct, you wouldn't change the RAID level.

That ends up being a span, which sucks. You can do it when you have to, but it sucks.