Firebird: choosing an owner for database deployment

Like most users when I started using Firebird I connected using the SYSDBA username. That is the default username for server administration: every server has it.

It looked like a good idea because I did not have to care with users management, but I have now realized that using SYSDBA for database development can cause problems when the database is deployed to the customer’s computer.

Read the rest on Accounting++ blog

Firebird on Large Big Iron servers : 512G-2TB of ram 100.000 concurrent users

Nikolay Samofatov wrote about his Large Iron production systems that he maintains :

We run Firebird to power larger systems (for 12 government agencies and 3 banks).

It has approximately 100000 end users multiplexed through 2500 (max) pooled connections.

Here is the snapshot of nearly idle system at night:

top - 03:20:39 up 10 days,  8:39,  7 users,  load average: 2.08, 1.87, 2.15
Tasks: 1732 total,   1 running, 1730 sleeping,   1 stopped,   0 zombie
Cpu(s): 11.9%us,  4.0%sy,  0.0%ni, 83.5%id,  0.0%wa,  0.0%hi,  0.6%si,  0.0%st
Mem: 529177288k total, 378587600k used, 150589688k free, 761532k buffers Swap: 1073741816k total, 130612k used, 1073611204k free, 333281232k cached

[root  mvv bin]# ps aux | grep -c rdb_inet_server

Database is on a small FusionIO drive:

/dev/fiob on /mnt/db type ext2 (rw,noatime)
df -h:
/dev/fiob             587G  423G  135G  76% /mnt/db

Also later he mentions that he uses 2TB of RAM machines

Chipsets that can handle 2 TB of RAM and 8 CPU sockets (<=80 cores, <=160 threads) are the largest “commodity” type hardware available now. These are the largest systems we worked on. 8 GB of lock manager space per database should be just enough for them. With the allocation error check in place we’ll have this problem solved for the next year or two until larger systems become common.

Phacil is seeking a Project Manager that has experience with Firebird in Arlington, VA for an important US Government customer

Shirin Lee posted a job: Phacil is seeking a Project Manager that has experience with Firebird in Arlington, VA. To learn more and  check this job post:

I almost wanted to say that this is spam on the group but at a second look saw  the list of  interesting customers for The Company also with a little help from google i found the job post

Phacil has an anticipated need for a Project Manager (Senior) for an important government customer in Sterling or Arlington, VA.

Clearance Requirements
Must have at least a Secret clearance

Experience project managing large IT projects including cost, schedule and performance management is required. Experience managing the  execution of project tasks, Risk Management, Quality Control (QCP) and communication management are required.

Must have previous Task Manager/Project Manager experience of at least 5 years
Bachelor’s Degree with Masters Preferred in Computer Science or Information Technology
PMP highly preferred
Experience managing the system administration, training and support for the Firebird database management system is required. Conducted trainings on FIREBIRD system with users.
Experience with PMP PMBOK/PDCA, ITIL v3 foundations service delivery a plus
Firebird database software and tools technology experience required

Episode 1: Fishbowl Database Security Basics (application that uses Firebird)

Here are the security notes for an application that uses Firebird:

Another thing to keep in mind while securing your database: sometimes when we release new versions of Fishbowl, it upgrades your database to a new version, as well. When this happens, Fishbowl makes two different backups. One is a copy of the database; the other is a Firebird database dump. I like to call these the “Murphy’s Law backups” because you shouldn’t need them, and you won’t need them – until you don’t have them. They are created for rollback purposes during the upgrade. Leaving these unprotected is just as bad as leaving your main database unprotected. You can find these files in C:\Program Files (x86)\Fishbowl\database\data – inside the “old” and “backup” directories.

1 2 3 4 5 32