Subject Re: RES: SV: [firebird-support] FB on Linux installation question
Author jugglingjester
Kernel Version 2.6.32-279 at the time of testing
FileSystem is ext4.

May be useful for you: my notes on installing, we've passsed them to a customer for replicate the installation.

installation source centos 6.3 minimal iso

Language: english
Keyboard: fitting to your needs
Storage: Basic
hostname: fitting to your needs
Network
eth0
connect automatically
IPv4
Static configuration, fitting to your network
IPv6
Ignore
any other NICs are ignored

Disk
Replace all
Review and modify if necessary
BootLoader in device root
Set root password
Install Packages
reboot req'ed
login
disable selinux
in /etc/selinux/config
change
SELINUX=enforcing
to
SELINUX=disabled
disable firewall
[root@centos db]# service iptables save
iptables: Saving firewall rules to /etc/sysconfig/iptables:[ OK ]
[root@centos db]# service iptables stop
iptables: Flushing firewall rules: [ OK ]
iptables: Setting chains to policy ACCEPT: filter [ OK ]
iptables: Unloading modules: [ OK ]
[root@centos db]# chkconfig iptables off
[root@centos db]#

also for ipv6
sync, reboot

first update:
#yum check-update
#yum update, reboot as there were kernel updates
#yum install xinetd
#yum install mc
preparing for firebird installation, using no other repo, as there is the likely chance to break either yum or, in worst case the system, due to different policies, see http://wiki.centos.org/AdditionalResources/Repositories/
#yum install lynx
#mkdir /root/install
#lynx www.firebirdsql.org, look for download, fetch the FirebirdCS...tar.gz,
download and save to disk
quit lynx
#cd /root/install
#tar xvzf FirebirdCS...tar.gz
#cd Fire<tab> should bring you to the freshly created dir
#./install.sh
<enter>
.
.
Please enter new Password for SYSDBA user: masterkey<enter>

first test, local only
#/opt/firebird/bin/isql
SQL>create database "dummy.fdb";
SQL>commit;
SQL>exit;
#ls -l
-rw-rw---- 1 root root 667648 Jul 17 11:27 dummy.fdb
setting database user and file permissions
#chown firebird: dummy.fdb
#ls -l
-rw-rw---- 1 firebird firebird 667648 Jul 17 11:27 dummy.fdb

First test from external...

hth, Marcus

--- In firebird-support@yahoogroups.com, "Fabiano" <fabianoaspro@...> wrote:
>
> What are the file system used?
>
> What the kernel version of CentOS 6.3?
>
> Thanks
>
>
>
> De: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] Em nome de jugglingjester
> Enviada em: segunda-feira, 23 de julho de 2012 13:42
> Para: firebird-support@yahoogroups.com
> Assunto: Re: SV: [firebird-support] FB on Linux installation question
>
>
>
>
>
>
>
> Hej,
>
> i've done a little bit of connection and load testing the last days.
>
> Used an old HP Compaq 6910p, 2 Cores, 4 GB RAM, 4 GB SWAP as server, running
> on CEntOS 6.3. Installed with the minimal ISO, using only the CEntOS
> repository.
> Installed Firebird 2.5.1 from the .tar.gz, not the rpm.
>
> Our developers have provided me with a testing tool to open n connections
> and start a query in each connection.
>
> 500 Connections+ from 4 client, no error at all. Peaking at roundabout
> 750-800 connections the "server" wasn't able to response due to massive
> swapping. Less than 5 % RAM and 5 % swap free, left the clients and the
> server for an hour (went for lunch :-) in that condition - not an error at
> all.
>
> hth, Marcus
>
> --- In firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com> , Poul Dige <pd@> wrote:
> >
> > Hi Fabiano,
> >
> > We tried 2.5.1 SC on Ubuntu 11. We had quite strange experience with the
> FB-server constantly crashing (every 20 minutes or so) with anything from
> 40-150 connections, AFAIR. No data corruption, but lots of annoyed
> customers. We switched to W2k8 and the problem was gone. I'd love to find
> out what went wrong but we were in no position to "experiment" as it was
> production environment, so it just had to work. Unfortunately, as I'd prefer
> to run it under Linux.
> >
> > I don't say that you will experience the same, but do be aware if it
> happens!
> >
> > Best regards
> > Poul
> >
> >
> >
> > Fra: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> [mailto:firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com> ] På vegne af Fabiano
> > Sendt: 23. juli 2012 15:17
> > Til: firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>
> > Emne: [firebird-support] FB on Linux installation question
> >
> >
> >
> > Hi all.
> >
> > A new customer Will use a Linux machine to run the Firebird server.
> Actually
> > he will be the first customer to do that.
> >
> > I have read that (at last with FB 1.5 to 2.0) the linux kernel need to be
> > 2.4.x to run Classic with a lot of connections.
> >
> > This issue also occurs on FB 2.5.1 Classic?
> >
> > Another tip is that writes on ext4 file system is slower than ext3 if
> > 'barrier' was ON. I can figure out the best file system to this customer.
> > Ext4 with/without barrier or ext3? The best for me is stability, I don't
> > want to easily corrupt my database on a fast partition. (power down
> > problems, etc).
> >
> > What are the best fast/secure balanced partition type?
> >
> > And finally - forced writes. I read that this configuration works on Linux
> > with FB 2.5.x. What is the best configuration?
> >
> > It someone have any tips of software installation on linux and maybe
> > hardware please fells free to answer.
> >
> > Thanks, Fabiano.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>