its not a bad idea. let me look into it. i am pretty sure its going to be about a man month to do the work.
Sent from my iPhone > On Jul 2, 2016, at 5:49 AM, Humberto Ramirez <[email protected]> wrote: > > Garrett, have you consider setting up a kickstarter? Given your track record > and contributions to illumos, I'm sure there will be plenty us backing you > up. > >> On Jul 1, 2016 11:12 PM, "Garrett D'Amore" <[email protected]> wrote: >> its probably past time that i invest effort in the usb3 stack. sadly my >> current employer has not expressed any interest in that effort. anyone want >> to help subsidize the effort ? >> >> Sent from my iPhone >> >>> On Jul 1, 2016, at 8:09 PM, Dave Finster <[email protected]> wrote: >>> >>> You might find that your better off investing in standard spinning SAS >>> disks but a very good SLOG like the HGST SSD800MH.B, which cost around $800 >>> AUD. The reason being that in a well built SmartOS box, you’ll have ZFS ARC >>> occupying RAM from which a good portion of your database reads should be >>> sourced from and when sync writes do need to be done, the SLOG will help >>> make them more performant. ARC makes read performance exceptional for a >>> cache hit. As for zpool layout, for database workloads your better off with >>> a multi-way mirror (i.e. a pool full of mirror vdevs) as when there is an >>> ARC miss it should be performant (at least won’t incur parity penalties in >>> RAIDZ). >>> >>> The only things to watch out for if your acquiring new hardware is NIC, HBA >>> and USB compatibility. The best NICs you can have for SmartOS are Intel >>> based ones (be they integrated onto the motherboard or as an add-in card), >>> I’ve not had any issues at all with LSI (now Avago) HBA cards whereas >>> on-board SATA/SAS can be hit and miss unless they are also LSI based (but >>> can be painful to reflesh if needed). The USB compatibility aspect is >>> becoming more important as Illumos doesn’t yet have an appropriate driver >>> which can cause boot issues and rules out keyboard interactions - some >>> boards have the ability to emulate USB2, but some work and some don’t. >>> >>>> On 2 Jul 2016, at 8:45 AM, [email protected] wrote: >>>> >>>> the vendor stated this: >>>> >>>> "Believe me, my programmers all were extremely frustrated when Linux and >>>> Sybase ADS were unreliable." >>>> >>>> i hope that was badly worded; though linux has never been the most >>>> reliable of the unix-like systems, i believe it's on a whole different >>>> level from any version of windows. i was once an MCSE but defected (back) >>>> to *nix because i wanted to get real work done instead of fighting the >>>> operating system and related products. >>>> >>>> thanks for the suggestions thus far - all good stuff, and i really >>>> appreciate the insight and recommendations. i didn't realize joyent >>>> provided virtio drivers - i've been using the ones from fedora for several >>>> years on the windows terminal server (sitting on joyent_20140221T042147Z). >>>> >>>> i have often wondered about running an all-ssd zones pool. the devs all >>>> poo-poo the use of consumer-grade disks, and sata in general. and they >>>> have made great cases for doing so. but for most of my uses, the price and >>>> potential performance looks extremely attractive. i don't usually have the >>>> ability to drop a couple of thousand dollars into a disk subsystem for >>>> these small installations. the customers typically already have enough >>>> hardware to run everything bare-metal, but i've tried hard to virtualize >>>> everything for the many benefits provided by doing so (plus of course the >>>> ones specific to using smartos/zfs). >>>> >>>> ----- On Jul 1, 2016, at 3:23 PM, Humberto Ramirez <[email protected]> >>>> wrote: >>>> Ideally it should sit on a SmartOS zone but... I understand he wants to >>>> run the database on top of NTFS...(Vendor requirement) however Sybase ADS >>>> its also available for linux. >>>> >>>>> On Jul 1, 2016 2:56 PM, "Joerg Sonnenberger" <[email protected]> wrote: >>>>> On Fri, Jul 01, 2016 at 11:15:21AM -0400, Humberto Ramirez wrote: >>>>> > - Set "compression": "lz4" "block_size": 131072 (This one can >>>>> > only be set at creation) >>>>> >>>>> I would be careful with setting compression, since it can easily be a >>>>> waste of time, depending on the database. >>>>> >>>>> Joerg >>>>> >>>>> >>>>> http://www.listbox.com > > smartos-discuss | Archives | Modify Your Subscription ------------------------------------------- smartos-discuss Archives: https://www.listbox.com/member/archive/184463/=now RSS Feed: https://www.listbox.com/member/archive/rss/184463/25769125-55cfbc00 Modify Your Subscription: https://www.listbox.com/member/?member_id=25769125&id_secret=25769125-7688e9fb Powered by Listbox: http://www.listbox.com
