<div dir="ltr"><div dir="ltr">Thanks, Enrico.<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jun 12, 2019 at 2:34 PM <<a href="mailto:herddb-dev-request@lists.herddb.org">herddb-dev-request@lists.herddb.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Send herddb-dev mailing list submissions to<br>
<a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.herddb.org/mailman/listinfo/herddb-dev" rel="noreferrer" target="_blank">http://lists.herddb.org/mailman/listinfo/herddb-dev</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:herddb-dev-request@lists.herddb.org" target="_blank">herddb-dev-request@lists.herddb.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:herddb-dev-owner@lists.herddb.org" target="_blank">herddb-dev-owner@lists.herddb.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of herddb-dev digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: Question file storage. (Amit Chavan)<br>
2. Re: Question file storage. (Enrico Olivelli)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Wed, 12 Jun 2019 13:03:02 -0700<br>
From: Amit Chavan <<a href="mailto:achavan1@gmail.com" target="_blank">achavan1@gmail.com</a>><br>
To: <a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a><br>
Subject: Re: [Herddb-dev] Question file storage.<br>
Message-ID:<br>
<CADsOBjNQEi7_RvW+iLNLPHj40GS8gtvns=<a href="mailto:7UXEbHRX58F%2Ba5mw@mail.gmail.com" target="_blank">7UXEbHRX58F+a5mw@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Thanks. Followup question. How do I replay the transaction log to recreate<br>
the data?<br>
In order for the data to be replayed on a new server, you will also require<br>
the table metadata(schema)? Is there a command line tool to do that?<br>
<br>
On Wed, Jun 12, 2019 at 3:00 AM <<a href="mailto:herddb-dev-request@lists.herddb.org" target="_blank">herddb-dev-request@lists.herddb.org</a>> wrote:<br>
<br>
> Send herddb-dev mailing list submissions to<br>
> <a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a><br>
><br>
> To subscribe or unsubscribe via the World Wide Web, visit<br>
> <a href="http://lists.herddb.org/mailman/listinfo/herddb-dev" rel="noreferrer" target="_blank">http://lists.herddb.org/mailman/listinfo/herddb-dev</a><br>
> or, via email, send a message with subject or body 'help' to<br>
> <a href="mailto:herddb-dev-request@lists.herddb.org" target="_blank">herddb-dev-request@lists.herddb.org</a><br>
><br>
> You can reach the person managing the list at<br>
> <a href="mailto:herddb-dev-owner@lists.herddb.org" target="_blank">herddb-dev-owner@lists.herddb.org</a><br>
><br>
> When replying, please edit your Subject line so it is more specific<br>
> than "Re: Contents of herddb-dev digest..."<br>
><br>
><br>
> Today's Topics:<br>
><br>
> 1. Question file storage. (Amit Chavan)<br>
> 2. Re: Question file storage. (Enrico Olivelli)<br>
><br>
><br>
> ----------------------------------------------------------------------<br>
><br>
> Message: 1<br>
> Date: Tue, 11 Jun 2019 21:19:19 -0700<br>
> From: Amit Chavan <<a href="mailto:achavan1@gmail.com" target="_blank">achavan1@gmail.com</a>><br>
> To: <a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a><br>
> Subject: [Herddb-dev] Question file storage.<br>
> Message-ID:<br>
> <CADsOBjM-WjEZms1-ddY9RHs=8fy9GkNcXY=bP64sG-bTdsV2=<br>
> <a href="mailto:Q@mail.gmail.com" target="_blank">Q@mail.gmail.com</a>><br>
> Content-Type: text/plain; charset="utf-8"<br>
><br>
> Hello,<br>
><br>
> I was playing around with herddb to do some testing today. I create a very<br>
> simple table ./herddb-cli.sh -q "CREATE TABLE amit(id int primary key, name<br>
> string)". I see table meta data file, txlog file etc created for this<br>
> table. I also inserted 2 to 3 rows into this table and I am able to see the<br>
> txlog being appended by the transaction. What I don't see is the data<br>
> actually being written to the disk for the table. The directory<br>
><br>
> *dbdata/data/20017d0222784757b504d0a157c59333.tablespace/fa077872-98c2-495d-8891-75936baa3a40.table<br>
> *is empty. When does the in-memory data get written to the disk? Is there a<br>
> setting or does it occur during checkpoint ?<br>
><br>
> Thanks,<br>
> Amit<br>
> -------------- next part --------------<br>
> An HTML attachment was scrubbed...<br>
> URL: <<br>
> <a href="http://lists.herddb.org/pipermail/herddb-dev/attachments/20190611/49f63e50/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.herddb.org/pipermail/herddb-dev/attachments/20190611/49f63e50/attachment-0001.html</a><br>
> ><br>
><br>
> ------------------------------<br>
><br>
> Message: 2<br>
> Date: Wed, 12 Jun 2019 08:45:42 +0200<br>
> From: Enrico Olivelli <<a href="mailto:eolivelli@gmail.com" target="_blank">eolivelli@gmail.com</a>><br>
> To: Herddb developers <<a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a>><br>
> Subject: Re: [Herddb-dev] Question file storage.<br>
> Message-ID:<br>
> <CACcefgdw2eeLEANSeb=<br>
> <a href="mailto:x-_A-COF7MhwZoD2cMunSJwzv3RxVSA@mail.gmail.com" target="_blank">x-_A-COF7MhwZoD2cMunSJwzv3RxVSA@mail.gmail.com</a>><br>
> Content-Type: text/plain; charset="utf-8"<br>
><br>
> Amit,<br>
><br>
> Il mer 12 giu 2019, 06:20 Amit Chavan <<a href="mailto:achavan1@gmail.com" target="_blank">achavan1@gmail.com</a>> ha scritto:<br>
><br>
> > Hello,<br>
> ><br>
> > I was playing around with herddb to do some testing today. I create a<br>
> very<br>
> > simple table ./herddb-cli.sh -q "CREATE TABLE amit(id int primary key,<br>
> name<br>
> > string)". I see table meta data file, txlog file etc created for this<br>
> > table. I also inserted 2 to 3 rows into this table and I am able to see<br>
> the<br>
> > txlog being appended by the transaction. What I don't see is the data<br>
> > actually being written to the disk for the table. The directory<br>
> *dbdata/data/20017d0222784757b504d0a157c59333.tablespace/fa077872-98c2-495d-8891-75936baa3a40.table<br>
> > *is empty. When does the in-memory data get written to the disk? Is there<br>
> > a setting or does it occur during checkpoint ?<br>
> ><br>
><br>
> Data is written to the journal/commit log.<br>
> Data pages are swapped to disk:<br>
> - at checkpoint<br>
> - when the system is out of memory<br>
><br>
> Enrico<br>
><br>
> ><br>
> > Thanks,<br>
> > Amit<br>
> > _______________________________________________<br>
> > herddb-dev mailing list<br>
> > <a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a><br>
> > <a href="http://lists.herddb.org/mailman/listinfo/herddb-dev" rel="noreferrer" target="_blank">http://lists.herddb.org/mailman/listinfo/herddb-dev</a><br>
> ><br>
> -------------- next part --------------<br>
> An HTML attachment was scrubbed...<br>
> URL: <<br>
> <a href="http://lists.herddb.org/pipermail/herddb-dev/attachments/20190612/77148ed2/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.herddb.org/pipermail/herddb-dev/attachments/20190612/77148ed2/attachment-0001.html</a><br>
> ><br>
><br>
> ------------------------------<br>
><br>
> _______________________________________________<br>
> herddb-dev mailing list<br>
> <a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a><br>
> <a href="http://lists.herddb.org/mailman/listinfo/herddb-dev" rel="noreferrer" target="_blank">http://lists.herddb.org/mailman/listinfo/herddb-dev</a><br>
><br>
><br>
> End of herddb-dev Digest, Vol 12, Issue 1<br>
> *****************************************<br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.herddb.org/pipermail/herddb-dev/attachments/20190612/e944642b/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.herddb.org/pipermail/herddb-dev/attachments/20190612/e944642b/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Wed, 12 Jun 2019 23:34:17 +0200<br>
From: Enrico Olivelli <<a href="mailto:eolivelli@gmail.com" target="_blank">eolivelli@gmail.com</a>><br>
To: Herddb developers <<a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a>><br>
Subject: Re: [Herddb-dev] Question file storage.<br>
Message-ID:<br>
<<a href="mailto:CACcefgerXaGF7km0079kN9G5z%2B2s29ZQgy1tac%2BsV43zMHBgyQ@mail.gmail.com" target="_blank">CACcefgerXaGF7km0079kN9G5z+2s29ZQgy1tac+sV43zMHBgyQ@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Il giorno mer 12 giu 2019 alle ore 22:04 Amit Chavan <<a href="mailto:achavan1@gmail.com" target="_blank">achavan1@gmail.com</a>><br>
ha scritto:<br>
<br>
> Thanks. Followup question. How do I replay the transaction log to recreate<br>
> the data?<br>
> In order for the data to be replayed on a new server, you will also<br>
> require the table metadata(schema)? Is there a command line tool to do<br>
> that?<br>
><br>
<br>
I am not sure I undestand.<br>
<br>
If you want to clone a database and you can stop the server just:<br>
- stop the server<br>
- copy server data to another machine<br>
- start the server<br>
<br>
<br>
If you want to perform a backup/restore of a tablespace you have to use<br>
herddb-cli.sh, I can't recall the options but you will find it easily.<br>
<br>
If you want to have more copies of the data, realtime synced, you have to<br>
use the cluster mode, in which you have a cluster of servers and you assign<br>
one or more "replicas" to a tablespace, and this is of course the most cool<br>
feature of HerdDB.<br>
<br>
hope that helps<br>
Enrico<br>
<br>
<br>
<br>
<br>
<br>
<br>
><br>
> On Wed, Jun 12, 2019 at 3:00 AM <<a href="mailto:herddb-dev-request@lists.herddb.org" target="_blank">herddb-dev-request@lists.herddb.org</a>><br>
> wrote:<br>
><br>
>> Send herddb-dev mailing list submissions to<br>
>> <a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a><br>
>><br>
>> To subscribe or unsubscribe via the World Wide Web, visit<br>
>> <a href="http://lists.herddb.org/mailman/listinfo/herddb-dev" rel="noreferrer" target="_blank">http://lists.herddb.org/mailman/listinfo/herddb-dev</a><br>
>> or, via email, send a message with subject or body 'help' to<br>
>> <a href="mailto:herddb-dev-request@lists.herddb.org" target="_blank">herddb-dev-request@lists.herddb.org</a><br>
>><br>
>> You can reach the person managing the list at<br>
>> <a href="mailto:herddb-dev-owner@lists.herddb.org" target="_blank">herddb-dev-owner@lists.herddb.org</a><br>
>><br>
>> When replying, please edit your Subject line so it is more specific<br>
>> than "Re: Contents of herddb-dev digest..."<br>
>><br>
>><br>
>> Today's Topics:<br>
>><br>
>> 1. Question file storage. (Amit Chavan)<br>
>> 2. Re: Question file storage. (Enrico Olivelli)<br>
>><br>
>><br>
>> ----------------------------------------------------------------------<br>
>><br>
>> Message: 1<br>
>> Date: Tue, 11 Jun 2019 21:19:19 -0700<br>
>> From: Amit Chavan <<a href="mailto:achavan1@gmail.com" target="_blank">achavan1@gmail.com</a>><br>
>> To: <a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a><br>
>> Subject: [Herddb-dev] Question file storage.<br>
>> Message-ID:<br>
>> <CADsOBjM-WjEZms1-ddY9RHs=8fy9GkNcXY=bP64sG-bTdsV2=<br>
>> <a href="mailto:Q@mail.gmail.com" target="_blank">Q@mail.gmail.com</a>><br>
>> Content-Type: text/plain; charset="utf-8"<br>
>><br>
>> Hello,<br>
>><br>
>> I was playing around with herddb to do some testing today. I create a very<br>
>> simple table ./herddb-cli.sh -q "CREATE TABLE amit(id int primary key,<br>
>> name<br>
>> string)". I see table meta data file, txlog file etc created for this<br>
>> table. I also inserted 2 to 3 rows into this table and I am able to see<br>
>> the<br>
>> txlog being appended by the transaction. What I don't see is the data<br>
>> actually being written to the disk for the table. The directory<br>
>><br>
>> *dbdata/data/20017d0222784757b504d0a157c59333.tablespace/fa077872-98c2-495d-8891-75936baa3a40.table<br>
>> *is empty. When does the in-memory data get written to the disk? Is there<br>
>> a<br>
>> setting or does it occur during checkpoint ?<br>
>><br>
>> Thanks,<br>
>> Amit<br>
>> -------------- next part --------------<br>
>> An HTML attachment was scrubbed...<br>
>> URL: <<br>
>> <a href="http://lists.herddb.org/pipermail/herddb-dev/attachments/20190611/49f63e50/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.herddb.org/pipermail/herddb-dev/attachments/20190611/49f63e50/attachment-0001.html</a><br>
>> ><br>
>><br>
>> ------------------------------<br>
>><br>
>> Message: 2<br>
>> Date: Wed, 12 Jun 2019 08:45:42 +0200<br>
>> From: Enrico Olivelli <<a href="mailto:eolivelli@gmail.com" target="_blank">eolivelli@gmail.com</a>><br>
>> To: Herddb developers <<a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a>><br>
>> Subject: Re: [Herddb-dev] Question file storage.<br>
>> Message-ID:<br>
>> <CACcefgdw2eeLEANSeb=<br>
>> <a href="mailto:x-_A-COF7MhwZoD2cMunSJwzv3RxVSA@mail.gmail.com" target="_blank">x-_A-COF7MhwZoD2cMunSJwzv3RxVSA@mail.gmail.com</a>><br>
>> Content-Type: text/plain; charset="utf-8"<br>
>><br>
>> Amit,<br>
>><br>
>> Il mer 12 giu 2019, 06:20 Amit Chavan <<a href="mailto:achavan1@gmail.com" target="_blank">achavan1@gmail.com</a>> ha scritto:<br>
>><br>
>> > Hello,<br>
>> ><br>
>> > I was playing around with herddb to do some testing today. I create a<br>
>> very<br>
>> > simple table ./herddb-cli.sh -q "CREATE TABLE amit(id int primary key,<br>
>> name<br>
>> > string)". I see table meta data file, txlog file etc created for this<br>
>> > table. I also inserted 2 to 3 rows into this table and I am able to see<br>
>> the<br>
>> > txlog being appended by the transaction. What I don't see is the data<br>
>> > actually being written to the disk for the table. The directory<br>
>> *dbdata/data/20017d0222784757b504d0a157c59333.tablespace/fa077872-98c2-495d-8891-75936baa3a40.table<br>
>> > *is empty. When does the in-memory data get written to the disk? Is<br>
>> there<br>
>> > a setting or does it occur during checkpoint ?<br>
>> ><br>
>><br>
>> Data is written to the journal/commit log.<br>
>> Data pages are swapped to disk:<br>
>> - at checkpoint<br>
>> - when the system is out of memory<br>
>><br>
>> Enrico<br>
>><br>
>> ><br>
>> > Thanks,<br>
>> > Amit<br>
>> > _______________________________________________<br>
>> > herddb-dev mailing list<br>
>> > <a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a><br>
>> > <a href="http://lists.herddb.org/mailman/listinfo/herddb-dev" rel="noreferrer" target="_blank">http://lists.herddb.org/mailman/listinfo/herddb-dev</a><br>
>> ><br>
>> -------------- next part --------------<br>
>> An HTML attachment was scrubbed...<br>
>> URL: <<br>
>> <a href="http://lists.herddb.org/pipermail/herddb-dev/attachments/20190612/77148ed2/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.herddb.org/pipermail/herddb-dev/attachments/20190612/77148ed2/attachment-0001.html</a><br>
>> ><br>
>><br>
>> ------------------------------<br>
>><br>
>> _______________________________________________<br>
>> herddb-dev mailing list<br>
>> <a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a><br>
>> <a href="http://lists.herddb.org/mailman/listinfo/herddb-dev" rel="noreferrer" target="_blank">http://lists.herddb.org/mailman/listinfo/herddb-dev</a><br>
>><br>
>><br>
>> End of herddb-dev Digest, Vol 12, Issue 1<br>
>> *****************************************<br>
>><br>
> _______________________________________________<br>
> herddb-dev mailing list<br>
> <a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a><br>
> <a href="http://lists.herddb.org/mailman/listinfo/herddb-dev" rel="noreferrer" target="_blank">http://lists.herddb.org/mailman/listinfo/herddb-dev</a><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.herddb.org/pipermail/herddb-dev/attachments/20190612/02908c35/attachment.html" rel="noreferrer" target="_blank">http://lists.herddb.org/pipermail/herddb-dev/attachments/20190612/02908c35/attachment.html</a>><br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
herddb-dev mailing list<br>
<a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a><br>
<a href="http://lists.herddb.org/mailman/listinfo/herddb-dev" rel="noreferrer" target="_blank">http://lists.herddb.org/mailman/listinfo/herddb-dev</a><br>
<br>
<br>
End of herddb-dev Digest, Vol 12, Issue 2<br>
*****************************************<br>
</blockquote></div></div>