Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread HOT BACKUP / DIFERENTIAL BACKUP / ONLINE REPLICATION
Fri, Aug 17 2018 2:29 PMPermanent Link

Jorge Ortiz

Rianxeira S.A.

Hello,

I am new with your product, we bought it short ago. We are using it for replacing some of our ADS proccess.
We start with transactions logs and goes very fine. i really like your product, and i was able to put it in production in a few days, i installed the Tokyo 10.2 version, and the server 64 in a windows 2016 server (no issues yet).

AND THE PRICE "INCREDIBLE"

Actually we are storing the operations logs for our system (100,000) or more records daily in a 24x7 system in our new ELEVATE DB.

it is very hard for us to stop the access to the database, because we generate records 24hours a day at any time.

after review all the manuals, the features that i miss from ADS are:

1) The BACKUP does not prevent the tables to be used and updated in any form.
2) You can prepare the Database for differential BACKUP, so, at the end of the day, only backup the changes of the day, BUT the backup file is only one, and is complete.
3) the replication is online, from one ADS server to another ADS server in almost real time (depending communications) so you have a database ready in minutes in case of disaster.

out of this, i really like your product, is easy to use, easy to understand, and almost 0 admin.

AND VERY FAST!

I am sorry for my english.

Best regards, and keep that very good work, i will try soon the web builder, looks terrific and a very good replacement for intraweb.

Jorge Ortiz.



Attachments: 2018-08-17 (2).png
Tue, Aug 21 2018 1:34 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jorge,

<< after review all the manuals, the features that i miss from ADS are:

1) The BACKUP does not prevent the tables to be used and updated in any form. >>

The backups in EDB are "raw", so they need to read-lock the database in order to get a correct snapshot.

<< 3) the replication is online, from one ADS server to another ADS server in almost real time (depending communications) so you have a database ready in minutes in case of disaster. >>

You can do this with EDB.  When you use the replication with EDB to perform hot backups, you effectively are amortizing the cost of the complete backups across multiple "synch" operations throughout the day.  I was supposed to write a technical article on this, so I will try to hurry that up.  In the meantime, you can find out more information here:

https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Replication

In your case, you would only need to publish the relevant tables and then create a JOB in the master EDB Server configuration that runs every X minutes and performs a SAVE UPDATES to save any outstanding updates to a local store.  You can then have a second EDB Server (or a simple Delphi application) that regularly checks this store for update files and loads them in their update timestamp order.  You can query this system information table in EDB to obtain such timestamps:

https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Updates_Table

(the CreatedOn column is the column that you want)

<< out of this, i really like your product, is easy to use, easy to understand, and almost 0 admin.

AND VERY FAST! >>

Thanks, I'm glad that you like it.

BTW, are you using the global I/O buffering with the EDB Server ?  It's new in 2.28, and I'm curious as to what kind of performance improvements you may see if you aren't using it currently, but enable it.

<< Best regards, and keep that very good work, i will try soon the web builder, looks terrific and a very good replacement for intraweb. >>

Fantastic. Smile

EWB will be a really great product once I get EWB 3 completed.  The EWB 3 web server is essentially an application server, so it serves as a great front-end to any database and relieves you of a lot of hassles like authentication, administration, and exposing databases in a structured API.

Tim Young
Elevate Software
www.elevatesoft.com
Fri, Aug 24 2018 8:02 AMPermanent Link

Adam Brett

Orixa Systems

>>EWB will be a really great product once I get EWB 3 completed.

Mild grumbling sounds in the background.
Mon, Aug 27 2018 3:36 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Adam,

<< Mild grumbling sounds in the background. >>

I can't discern the "why" here ?  Is it because you think this is at the expense of EDB ?

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Aug 29 2018 12:12 PMPermanent Link

Adam Brett

Orixa Systems

Sorry Tim,

Nothing wrong with EWB or EDB pricing, rather we are all waiting for some big updates to EWB EDB you have mentioned are "coming soon" for a while!
Thu, Aug 30 2018 2:40 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Adam,

<< Nothing wrong with EWB or EDB pricing, rather we are all waiting for some big updates to EWB EDB you have mentioned are "coming soon" for a while! >>

EWB 3 has required some pretty serious changes in the EWB IDE for dual client and server-side applications that were unanticipated, and this required a fairly significant rewrite of the IDE (an IDE that was developed over several *years* prior to that).  Plus, there have been some large stretches of time where I have been unable to work on EWB 3, such as the 2 1/2 months that I spent working on the new I/O buffering and statement/procedure caching in EDB 2.28, as well as a complete re-org of DBISAM that I worked on in the early part of the summer.  None of this includes the daily (including weekends) technical support time that I provide to customers.  For example, I just spent 4 days stress-testing EDB for a customer with Windows 2016 to resolve an issue with SMB 3 on Windows 2012 and higher.  In the late winter, I spent several *weeks* working through a performance problem for a customer, and this resulted in the EDB 2.28 improvements that, subsequently, took the 2 1/2 months of time.  I also have to manage all of our infrastructure, and recently I had to spend a week getting our web server migrated from 2008 R2 to 2016, and I'm doing the same thing with our internal server this week.  So, while it may seem like nothing is happening, there is *quite a lot* happening and it's all in preparation for the next phase for our products.  Big steps like EWB 3 require a lot of time, and there aren't any shortcuts.

At any rate, I suspect that you'll be fairly happy with the resultant EWB 3.x, and EDB will continue to get better with things like fail-safe writes and more.

Tim Young
Elevate Software
www.elevatesoft.com
Image