Re: [firebird-support] Scaling Firebird - Azure
On 10/6/2019 9:49 AM, Rune Horneland rune.hornel...@kravia.net [firebird-support] wrote: > > > Hi, > We are running Firebird 2 in an Azure VM. It can only take so much in > terms of concurrent connections. > What top-level advice would you give to scale this? > > We are connecting to it from a .NET core Middleware using Azure VMs. > The architecture of the middleware is quite monolithic. We are > considering rewriting it with Microservices and Azure functions or > similar architecure, but are unsure how we could scale the Firebird DB > or connections itself. > Multiple casehandlers in our company use it via a Delphi-based Windows > application at the other end, with a vendor maintaining the Firebird DB > and Windows app development, so we are locked into using Firebird. "Locked into using Firebird"...you say that like it's a bad thing! Can you provide some more details of your usage? Things like: 1. Current number of current connections 2. Desired number of connections 3. Current database size 4. Details of the virtual host - O/S, RAM, filesystem, HD type. -- Daniel
Re: [firebird-support] Scaling Firebird - Azure
Hello, Azure simply does not deliver what it promises - simple test www.ib-aid.com/dbtest gives results for Azure premium ssd in the lowest 25%, simple CrystalDiskMarks shows awful results too. Your server is yours, but Azure promises Enterprise grade performance, without worries abour RAID, ssd, etc - but what we get is far from it, as well as from money paid for it. On other side, Google Cloud shows reasonable results in these tests, so why pay for the worst option. Amazon EC2 with ssd also looks better than Azure in terms of performance, but seems to be much more expensive than Digital Ocean, Hetzner and even Google Cloud. Regards, Alexey Kovyazin IBSurgeon ср, 9 окт. 2019 г., 10:49 'Louis van Alphen' lo...@nucleo.co.za [firebird-support] : > > > I think it is unfair to say Azure sucks. I have had huge performance > issues with FB on a normal server with server grade SSDs. My desktop PC > with spindle HDD outperforms it by an order of magnitude. To date it has > not been resolved but I suspect it has to do with the RAID controller. The > same server is very fast with MSSQL. > > From: firebird-support@yahoogroups.com [mailto: > firebird-supp...@yahoogroups..com] > Sent: Wednesday, 09 October, 2019 08:17 > To: Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] < > firebird-support@yahoogroups.com> > Subject: Re: [firebird-support] Scaling Firebird - Azure > > Hello, > > In short words, Azure sucks, its so called Premium SSD is worse than the > cheapest consumer grade ssd. > > Try Google Cloud or Amazon, or Hetzner. > > Regards, > > Alexey Kovyazin > > IBSurgeon > > пн, 7 окт. 2019 г., 0:20 Rune Horneland rune.hornel...@kravia.net rune.hornel...@kravia.net> [firebird-support] < > firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com> > >: > > Hi, > > We are running Firebird 2 in an Azure VM. It can only take so much in > terms of concurrent connections. > > What top-level advice would you give to scale this? > > We are connecting to it from a .NET core Middleware using Azure VMs. > > The architecture of the middleware is quite monolithic. We are considering > rewriting it with Microservices and Azure functions or similar architecure, > but are unsure how we could scale the Firebird DB or connections itself. > > Multiple casehandlers in our company use it via a Delphi-based Windows > application at the other end, with a vendor maintaining the Firebird DB and > Windows app development, so we are locked into using Firebird. > > RUNE HORNELAND > CTO > > [Non-text portions of this message have been removed] > > >
RE: [firebird-support] Scaling Firebird - Azure
Software raid and hardware raid without BBU has a huge performace hit : https://ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/ https://ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/ EXT3, EXT4 : file system barrier property has huge performance hit https://www.firebirdnews.org/understanding-barrier-on-linux/ https://www.firebirdnews.org/understanding-barrier-on-linux/ https://www.firebirdnews.org/forced-writes-performance-impact-on-ubuntu/ https://www.firebirdnews.org/forced-writes-performance-impact-on-ubuntu/ Hyperthreading could harm performance : https://blogs.msdn.microsoft.com/slavao/2005/11/12/be-aware-to-hyper-or-not-to-hyper/ https://blogs.msdn.microsoft.com/slavao/2005/11/12/be-aware-to-hyper-or-not-to-hyper/
RE: [firebird-support] Scaling Firebird - Azure
I think it is unfair to say Azure sucks. I have had huge performance issues with FB on a normal server with server grade SSDs. My desktop PC with spindle HDD outperforms it by an order of magnitude. To date it has not been resolved but I suspect it has to do with the RAID controller. The same server is very fast with MSSQL. From: firebird-support@yahoogroups.com [mailto:firebird-supp...@yahoogroups..com] Sent: Wednesday, 09 October, 2019 08:17 To: Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] Subject: Re: [firebird-support] Scaling Firebird - Azure Hello, In short words, Azure sucks, its so called Premium SSD is worse than the cheapest consumer grade ssd. Try Google Cloud or Amazon, or Hetzner. Regards, Alexey Kovyazin IBSurgeon пн, 7 окт. 2019 г., 0:20 Rune Horneland rune.hornel...@kravia.net <mailto:rune.hornel...@kravia.net> [firebird-support] mailto:firebird-support@yahoogroups.com> >: Hi, We are running Firebird 2 in an Azure VM. It can only take so much in terms of concurrent connections. What top-level advice would you give to scale this? We are connecting to it from a .NET core Middleware using Azure VMs. The architecture of the middleware is quite monolithic. We are considering rewriting it with Microservices and Azure functions or similar architecure, but are unsure how we could scale the Firebird DB or connections itself. Multiple casehandlers in our company use it via a Delphi-based Windows application at the other end, with a vendor maintaining the Firebird DB and Windows app development, so we are locked into using Firebird. RUNE HORNELAND CTO [Non-text portions of this message have been removed]
Re: [firebird-support] Scaling Firebird - Azure
Hello, In short words, Azure sucks, its so called Premium SSD is worse than the cheapest consumer grade ssd. Try Google Cloud or Amazon, or Hetzner. Regards, Alexey Kovyazin IBSurgeon пн, 7 окт. 2019 г., 0:20 Rune Horneland rune.hornel...@kravia.net [firebird-support] : > > > Hi, > We are running Firebird 2 in an Azure VM. It can only take so much in > terms of concurrent connections. > What top-level advice would you give to scale this? > > We are connecting to it from a .NET core Middleware using Azure VMs. > The architecture of the middleware is quite monolithic. We are considering > rewriting it with Microservices and Azure functions or similar architecure, > but are unsure how we could scale the Firebird DB or connections itself. > Multiple casehandlers in our company use it via a Delphi-based Windows > application at the other end, with a vendor maintaining the Firebird DB and > Windows app development, so we are locked into using Firebird. > > > *RUNE HORNELAND*CTO > > >
Re: [firebird-support] Scaling Firebird - Azure
Using Azure is a little bit tricky with any database. Since FB doesn't have DBaaS support from any Cloud provider that I know you will need to go only for VM or containers for your deployment. If you google for "firebird performance tuning" you will find some interesting articles:https://firebirdsql.org/en/news/presentations-from-firebird-tour-2017-tuning-linux-and-windows/https://www.firebirdsql.org/en/news/45-ways-to-speed-up-firebird-database/ Regards, ___ I'm free, I use GNU/Linux. Close your Windows, Open your mind. El domingo, 6 de octubre de 2019 17:20:14 GMT-5, Rune Horneland rune.hornel...@kravia.net [firebird-support] escribió: Hi,We are running Firebird 2 in an Azure VM. It can only take so much in terms of concurrent connections.What top-level advice would you give to scale this? We are connecting to it from a .NET core Middleware using Azure VMs.The architecture of the middleware is quite monolithic. We are considering rewriting it with Microservices and Azure functions or similar architecure, but are unsure how we could scale the Firebird DB or connections itself.Multiple casehandlers in our company use it via a Delphi-based Windows application at the other end, with a vendor maintaining the Firebird DB and Windows app development, so we are locked into using Firebird. RUNEHORNELAND CTO
[firebird-support] Scaling Firebird - Azure
Hi, We are running Firebird 2 in an Azure VM. It can only take so much in terms of concurrent connections. What top-level advice would you give to scale this? We are connecting to it from a .NET core Middleware using Azure VMs. The architecture of the middleware is quite monolithic. We are considering rewriting it with Microservices and Azure functions or similar architecure, but are unsure how we could scale the Firebird DB or connections itself. Multiple casehandlers in our company use it via a Delphi-based Windows application at the other end, with a vendor maintaining the Firebird DB and Windows app development, so we are locked into using Firebird. *RUNE HORNELAND*CTO
