Re: [firebird-support] Is Firebird 3 ready for Production?
Dimitry I just tested it and seems pretty good, thanks for the hint Cheers, Fabian - Original Message - From: Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] To: firebird-support@yahoogroups.com Sent: Friday, May 27, 2016 10:12 PM Subject: Re: [firebird-support] Is Firebird 3 ready for Production? 24.05.2016 18:38, Fabian Ernesto Chocron fabia...@itbizolutions.com.au [firebird-support] wrote: > And regarding the replication, any advise on what product may be the right choice? I would recommend to look at IBPhoenix Replicator. http://www.ibphoenix.com/products/software/ibreplicator Especially at version 5 which is on pre-release stage now in accompany with Avalerion. http://www.ibphoenix.com/ibpr_devel/ -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: [firebird-support] Is Firebird 3 ready for Production?
27.05.2016 15:30, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > what is Avalerion??? This is a bird that die having lied two eggs. And also a name of experimental Firebird fork that supports replication plugins. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
RE: [firebird-support] Is Firebird 3 ready for Production?
> 27.05.2016 15:26, 'Leyne, Sean' s...@broadviewsoftware.com [firebird- > support] wrote: > > Avalerion??? > >Yes. Sorry, I meant what is Avalerion??? Sean
Re: [firebird-support] Is Firebird 3 ready for Production?
27.05.2016 15:26, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > Avalerion??? Yes. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
RE: [firebird-support] Is Firebird 3 ready for Production?
>Especially at version 5 which is on pre-release stage now in accompany with > Avalerion. >http://www.ibphoenix.com/ibpr_devel/ Avalerion??? Sean
Re: [firebird-support] Is Firebird 3 ready for Production?
24.05.2016 18:38, Fabian Ernesto Chocron fabia...@itbizolutions.com.au [firebird-support] wrote: > And regarding the replication, any advise on what product may be the right > choice? I would recommend to look at IBPhoenix Replicator. http://www.ibphoenix.com/products/software/ibreplicator Especially at version 5 which is on pre-release stage now in accompany with Avalerion. http://www.ibphoenix.com/ibpr_devel/ -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Is Firebird 3 ready for Production?
Re: [firebird-support] Is Firebird 3 ready for Production?I see, will read it Cheers Fabian - Original Message - From: 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] To: fabia...@itbizolutions.com.au [firebird-support] Sent: Thursday, May 26, 2016 6:01 AM Subject: Re: [firebird-support] Is Firebird 3 ready for Production? Fabian I suggest you to read the release notes carefully. FB 3 can use different user authentication plugins. This means that you can have different users with the same name, in different plugins. There are many other conceptual changes in FB 3 that needs caution. That's why I decided to write a Migration Guide to Firebird 3. Carlos Migration Guide to Firebird 3 eBook - http://www.firebirdnews.org/migration-guide-to-firebird-3/ www.firebirdnews.org - www.FireBase.com.br Hi Alexey Thank you for the comments. So far everything has gone ok, I fixed all the fields with ASCII charset at the FB 2.54 DB (changed the domain to charset NONE), and now the backup and restore workes fine, with no errors. I've noticed the new FB3 DB has now two SYSDBA users, one seems to be disabled, and the other has the masterkey password even though the install asked me for the password, but it appears it ignored my answer, or it used the password I entered for the disabled SYSDBA users... no big deal. Other than that I have not encountered any other issues so far, I will recompile all stored procedures and views and triggers shortly, but I don't expect any issues there because the DB is operational with the Application and no errors have appeared on the APP side using the FB3 DB. Cheers, Fabian
Re: [firebird-support] Is Firebird 3 ready for Production?
Re: [firebird-support] Is Firebird 3 ready for Production?
Thanks Alexey, will try it and post back with comments - Original Message - From: Alexey Kovyazin a...@ib-aid.com [firebird-support] To: firebird-support@yahoogroups.com Sent: Thursday, May 26, 2016 6:58 AM Subject: Re: [firebird-support] Is Firebird 3 ready for Production? Hi Fabian, Also I recommend you to try our optimized configuration file for FB3: http://ib-aid.com/en/optimized-firebird-configuration/ Regards, Alexey Hi Alexey Thank you for the comments. So far everything has gone ok, I fixed all the fields with ASCII charset at the FB 2.54 DB (changed the domain to charset NONE), and now the backup and restore workes fine, with no errors. I've noticed the new FB3 DB has now two SYSDBA users, one seems to be disabled, and the other has the masterkey password even though the install asked me for the password, but it appears it ignored my answer, or it used the password I entered for the disabled SYSDBA users... no big deal. Other than that I have not encountered any other issues so far, I will recompile all stored procedures and views and triggers shortly, but I don't expect any issues there because the DB is operational with the Application and no errors have appeared on the APP side using the FB3 DB. Cheers, Fabian
Re: [firebird-support] Is Firebird 3 ready for Production?
Hi Fabian, Also I recommend you to try our optimized configuration file for FB3: http://ib-aid.com/en/optimized-firebird-configuration/ Regards, Alexey Hi Alexey Thank you for the comments. So far everything has gone ok, I fixed all the fields with ASCII charset at the FB 2.54 DB (changed the domain to charset NONE), and now the backup and restore workes fine, with no errors. I've noticed the new FB3 DB has now two SYSDBA users, one seems to be disabled, and the other has the masterkey password even though the install asked me for the password, but it appears it ignored my answer, or it used the password I entered for the disabled SYSDBA users... no big deal. Other than that I have not encountered any other issues so far, I will recompile all stored procedures and views and triggers shortly, but I don't expect any issues there because the DB is operational with the Application and no errors have appeared on the APP side using the FB3 DB. Cheers, Fabian
Re: [firebird-support] Is Firebird 3 ready for Production?
Hi Alexey Thank you for the comments. So far everything has gone ok, I fixed all the fields with ASCII charset at the FB 2.54 DB (changed the domain to charset NONE), and now the backup and restore workes fine, with no errors. I've noticed the new FB3 DB has now two SYSDBA users, one seems to be disabled, and the other has the masterkey password even though the install asked me for the password, but it appears it ignored my answer, or it used the password I entered for the disabled SYSDBA users... no big deal. Other than that I have not encountered any other issues so far, I will recompile all stored procedures and views and triggers shortly, but I don't expect any issues there because the DB is operational with the Application and no errors have appeared on the APP side using the FB3 DB. Cheers, Fabian
Re: [firebird-support] Is Firebird 3 ready for Production?
Re: [firebird-support] Is Firebird 3 ready for Production?
Hi Fabian, Is is ready for production, but migration process in not just backup/restore (it was never so in older versions, but it worked relatively well due to high backward incompatibility) - it requires thorough check of triggers, stored procedures, data itself and ad hoc queries. When we do migration for our clients, we use our automation tools which ensure that we have traced all problematic queries before going to production. I don't think it's possible to do such checking manually in case of big enough system - and comments in this thread confirm it. Regards, Alexey Kovyazin IBSurgeon http://ib-aid.com/en/firebird-database-migration/ Hi All We have a multi-user, multi-company, cloud based system running with Firebird 2.54 as the main database, with about 100 concurrent connections. We are considering migrating to FB 3.0 to take advantaje of the SMP architecture, we have a 32 core / processors server, so we are hopping to see an increased performance. We also have the need to set up online replication. Would anyone be able to advise if it it too soon to jump into FB 3.0 for production? And if the performance increase would be enough to make the upgrade worth considering 3.0 has not been around for long yet, and may be "taking too much risk" to move into it so soon? And regarding the replication, any advise on what product may be the right choice? Cheers Fabian
[firebird-support] Is Firebird 3 ready for Production?
Hi All We have a multi-user, multi-company, cloud based system running with Firebird 2.54 as the main database, with about 100 concurrent connections. We are considering migrating to FB 3.0 to take advantaje of the SMP architecture, we have a 32 core / processors server, so we are hopping to see an increased performance. We also have the need to set up online replication. Would anyone be able to advise if it it too soon to jump into FB 3.0 for production? And if the performance increase would be enough to make the upgrade worth considering 3.0 has not been around for long yet, and may be "taking too much risk" to move into it so soon? And regarding the replication, any advise on what product may be the right choice? Cheers Fabian