[firebird-support] FB suitability for Consolidated Database of 15 GB.
Hello Friends, We have been using Firebird since v. 1.5 on Linux as well on windows for Delphi application running on Win and server on Lin/Win as per needs in Lan environment. Now Client wants to have centralized database with two way Replication at HO. The branch database size varies from 200MB to 1.2GB and estimated combined database will be about 10GB to 15GB. On centralized database except replication connections (which will be Batch running as per Branch convenience and not real time) there will be 10 to 15 users always connected plus a small web application may have 30 to 40 simultaneous users as a primary estimate and may be on higher side. As far as Branches are concerned we are very happy with performance and Stability of database not a single instance of any data corruptions have been noticed in last 7 to 8 years inspite of very rough usage by Branch users so client wants to stick to FB at Branches for sure. But for centralized database they have doubt that whether it will sustain the volume of 10 to 15 GB and how it will perform and have given indication that they can Try first FB and if it fails they can go for some other Commercial Database. As far as we are concerned we would like to stick to FB but our confidence level is low since we dont have any experience of FB stability and performance on such large database. To make FB successful in this scenario please guide w.r.t. Following queries. 1. Whether FB 2.1 SS / FB 2.5 ?? on 64 bit Linux (Kubuntu) will be able to handle 15GB database ? 2. What version should be selected FB 2.1, 2.5 and which architecture? 3. What precautions should we take like Processor, RAM, Linux FS selection etc. etc. so that FB will run with maximum efficiency and stability. Thanks and warm regards. R. S. Patil.
Re: [firebird-support] FB suitability for Consolidated Database of 15 GB.
08.10.2011 9:37, raja_s_patil: But for centralized database they have doubt that whether it will sustain the volume of 10 to 15 GB : One of our customers' databases (not the biggest :) - excerpt from daily report from DataGuard, pay attention to database size ==cit= Regular backup was done successfully Backup [D:\_backup\bckp_vlm_wtl_20111007_22-00.fbk] 98 Gb was created at 10:00:00 PM took 01h:45m:51s.534 to complete. Backup: [OK] Backup [D:\_backup\bckp_vlm_wtl_20111007_22-00.fbk] 98 Gb done successfully at 11:45:51 PM, taking 01h:45m:51s.534. Restore: [OK] Restore [D:\_backup\restore.fdb.tmp] 105 Gb done successfully at 1:22:48 AM, taking 01h:36m:56s.710. ==cit= 1Terabyte database - http://www.ib-aid.com/articles/item104 And also there is 700Gb beast in production - case study is coming soon :) Regards, Alexey Kovyazin IBSurgeon (www.ib-aid.com)
Re: [firebird-support] FB suitability for Consolidated Database of 15 GB.
Hello, raja_s_patil! Saturday, October 8, 2011, 9:37:06 AM, you wrote: r client wants to stick to FB at Branches for sure. But for centralized r database they have doubt that whether it will sustain the volume of 10 r to 15 GB and how it will perform and have given indication that they 10-15 GB databases now are the most average database size for Firebird. r 1. Whether FB 2.1 SS / FB 2.5 ?? on 64 bit Linux (Kubuntu) will be r able to handle 15GB database ? it will be able to handle even 1TB database with ~500 concurrent users. r 2. What version should be selected FB 2.1, 2.5 and which architecture? Of course, the newer is better, so, 2.5.1. Architecture - Classic or SuperClassic, because only these architectures supports SMP. SuperServer does not support SMP, but can be used for ~20 or more users, if applications are not mix with OLTP and DSS queries. r 3. What precautions should we take like Processor, RAM, Linux FS r selection etc. etc. so that FB will run with maximum efficiency and r stability. efficiency and stability depends on hardware. Pay attention to disks, use raid 10. At most systems hardware is very different, because of differen Firebird load, so, it's a bit hard to give exact suggestions. Since you already have Firebird with 1.5gb databases and ~10-15 users, I don't think that you need to look at hardware that, for example, 10 times faster than current. 15 users or 40 users - not a big difference, until you use 1-2 core processor and 1 hard disk (which is usually considered as a desktop computer). BTW, 1TB test, that Alexey mentioned, was intentionally made on desktop computer, not server. -- Dmitry Kuzmenko, www.ib-aid.com
[firebird-support] Re: FB suitability for Consolidated Database of 15 GB.
--- In firebird-support@yahoogroups.com, Dmitry Kuzmenko kdv@... wrote: Hello, raja_s_patil! Saturday, October 8, 2011, 9:37:06 AM, you wrote: r client wants to stick to FB at Branches for sure. But for centralized r database they have doubt that whether it will sustain the volume of 10 r to 15 GB and how it will perform and have given indication that they 10-15 GB databases now are the most average database size for Firebird. r 1. Whether FB 2.1 SS / FB 2.5 ?? on 64 bit Linux (Kubuntu) will be r able to handle 15GB database ? it will be able to handle even 1TB database with ~500 concurrent users. r 2. What version should be selected FB 2.1, 2.5 and which architecture? Of course, the newer is better, so, 2.5.1. Architecture - Classic or SuperClassic, because only these architectures supports SMP. SuperServer does not support SMP, but can be used for ~20 or more users, if applications are not mix with OLTP and DSS queries. r 3. What precautions should we take like Processor, RAM, Linux FS r selection etc. etc. so that FB will run with maximum efficiency and r stability. efficiency and stability depends on hardware. Pay attention to disks, use raid 10. At most systems hardware is very different, because of differen Firebird load, so, it's a bit hard to give exact suggestions. Since you already have Firebird with 1.5gb databases and ~10-15 users, I don't think that you need to look at hardware that, for example, 10 times faster than current. 15 users or 40 users - not a big difference, until you use 1-2 core processor and 1 hard disk (which is usually considered as a desktop computer). BTW, 1TB test, that Alexey mentioned, was intentionally made on desktop computer, not server. -- Dmitry Kuzmenko, www.ib-aid.com Thanks Dmitry for precise point to point reply, We had a meeting with Client today. I showed FB tech. specs page to client which was mentioning 980 GB production database and suggested that we will consolidate all the branches Data and run tests on that to see how it performs which was readily accepted by Client. Added to this some confidence inspiring posts I found here. So slowly our confidence is building. Regarding FB version I read some performance test data on INTERNET which indicates that FB 2.5 is slower compared to 2.1 SS. However you as a active member of FB team is suggesting I will try FB 2.5 for test data and experience the performance. Few years ago another active member Phill Shrimpton suggested me FB and I tested it and till today not only I am with it but extremely satisfied with it. I found it Most reliable and frugal on hardware/Maintenance requirements. Most of sites where even though 1GB database is there no dedicated DBA is available but both performance and stability is extra ordinary. Long Live Firebird. Is there any Memory requirement thumb rule depending upon DB size and No of concurrent users ? Any precautionary measures should I take to have brilliant performance figures to Impress the Client ? We are going to use a 64 bit Desktop with 8 GB Ram and OS is 64 bit Kubuntu as database server. A XP dektop with 4 GB RAM will be used as Client. Tests will be few frequently used queries run From IBexpert and Timings will be measured on Consolidated Database. These Timings are expected to be reasonable and practically acceptable. Thanks to all who posted and warm regards Raja
Re: [firebird-support] SQLSTATE 28000
Raymond, To connect through isql the command is: connect ''h:\KKR.FDB' user 'sysdba' password 'masterkey'; You have left out the user name and password. Thomas. On Sat, Oct 8, 2011 at 9:07 AM, raym...@ymail.com raym...@ymail.com wrote: ** Hello, This is my first time trying to use Firebird. I am required by a client to write an application that extract data from Firebird. Here is what I have done so far: 1. I copied the .FDB file from my client's live application 2. Installed Firebird 3. Tried to access the database using ISQL: connect 'h:\KKR.FDB'; And it returned: Statement failed, SQLSTATE = 28000 Your user name and password are not defined. Ask your database administrator to set up a Firebird login. What am I missing? Any help would be great. Thanks. Raymond -- Thomas Clarke Cyber Sea Incorporated #6 Kingston Terrace Flint Hall St. Michael Barbados BB11070 voice: (246) 234-9692 email: tcla...@cybersea.biz web: http://cybersea.biz [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) * To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[firebird-support] creating a database in ubuntu
OK, I use ubuntu lucid ( 10.04 ) I have got all the way to installing and running firebird 2.1 super installing and running flamerobin every time i try to create a database i get this: Engine Code: 335544344 Engine Message : I/O error for file /opt/data/firebird/blank/blank.fdb Error while trying to create file Permission denied i have no idea. Kind Regards, Robert.
Re: [firebird-support] creating a database in ubuntu
At 05:27 PM 9/10/2011, you wrote: OK, I use ubuntu lucid ( 10.04 ) I have got all the way to installing and running firebird 2.1 super installing and running flamerobin every time i try to create a database i get this: Engine Code: 335544344 Engine Message : I/O error for file /opt/data/firebird/blank/blank.fdb Error while trying to create file Permission denied i have no idea. The permission you are being denied is the write permission to /opt/data/firebird/blank/. With su privileges, make yourself a member of the firebird group and make sure to give rwx permissions to the firebird group in /opt/data/ and any subdirs beneath it where you will want to create or restore databases. ./heLen