In this post, we’ll use a blog poll to find out what operating system you use to run your production database servers.
As databases grow to meet more challenges and expanding application demands, they must try and get the maximum amount of performance out of available resources. How they work with an operating system can affect many variables, and help or hinder performance. The operating system you use for your database can impact consumable choices (such as hardware and memory). The operating system you use can also impact your choice of database engine as well (or vice versa).
Please let us know what operating system you use to run your database. For this poll, we’re asking which operating system you use to actually run your production database server (not the base operating system).
If you’re running virtualized Linux on Windows, please select Linux as the OS used for development. Pick up to three that apply. Add any thoughts or other options in the comments section:
[poll id=”17″]
Thanks in advance for your responses – they will help the open source community determine how database environments are being deployed.
Resources
RELATED POSTS
Gentoo. Since 2005.
How do you do upgrades?
Regularly 🙂
I must have misunderstood your question, not sure what do you mean exactly.
I’m just wondering since one would usually need to compile everything on the server, right?
Not necessarily. You can use binary packages compiled on some other box (see https://wiki.gentoo.org/wiki/Binary_package_guide). Alternatively, you can compile locally but use distcc to make compilation less stressful for other running processes (see https://wiki.gentoo.org/wiki/Distcc).
But in our case we found that compiling packages regular way (without distcc) with just MAKEOPTS=”-j1″ and PORTAGE_NICENESS=”19″ is quite acceptable. We do, however, use binary packages locally to quickly reinstall packages (into chroot, for example, or when you need to roll back a package to a previous version or previous combination of USE flags, etc.). Also, if you’re using CFQ disk scheduler you can consider using ionice (PORTAGE_IONICE_COMMAND).
All in all, compiling packages is usually not as scary as it sounds.
What would categorize AWS host OS?
Eric, good point, we’ve added AWS as an option. Thanks!
Gentoo here too, since 2012