Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #11473 > unrolled thread

VO and Cloud

Started byJürgen Knauf <trotterklaus@googlemail.com>
First post2018-03-08 22:23 -0800
Last post2018-03-13 23:56 -0700
Articles 17 — 7 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  VO and Cloud Jürgen Knauf <trotterklaus@googlemail.com> - 2018-03-08 22:23 -0800
    VO and Cloud attiamxy@gmail.com - 2018-03-08 23:46 -0800
    VO and Cloud attiamxy@gmail.com - 2018-03-08 23:53 -0800
    Re: VO and Cloud Arne Ortlinghaus <Arne.Ortlinghaus@acs.it> - 2018-03-09 12:56 +0100
    Re: VO and Cloud "Wolfgang Riedmann" <wriedmann@gmail.com> - 2018-03-09 14:29 +0100
      Re: VO and Cloud Jürgen Knauf <trotterklaus@googlemail.com> - 2018-03-09 23:58 -0800
        Re: VO and Cloud "Wolfgang Riedmann" <wriedmann@gmail.com> - 2018-03-10 09:29 +0100
          Re: VO and Cloud attiamxy@gmail.com - 2018-03-10 02:28 -0800
            Re: VO and Cloud "Wolfgang Riedmann" <wriedmann@gmail.com> - 2018-03-10 12:35 +0100
          Re: VO and Cloud Jürgen Knauf <trotterklaus@googlemail.com> - 2018-03-10 03:06 -0800
      Re: VO and Cloud D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2018-03-22 12:38 +0100
        Re: VO and Cloud "Wolfgang Riedmann" <wriedmann@gmail.com> - 2018-03-22 20:56 +0100
          Re: VO and Cloud D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2018-03-25 15:27 +0200
        Re: VO and Cloud Massimo Bighelli <info@arcasistemi.it> - 2018-03-23 11:59 +0100
    Re: VO and Cloud Jürgen Knauf <trotterklaus@googlemail.com> - 2018-03-09 23:56 -0800
    Re: VO and Cloud Lucio Chiessi <lucio@vorio.eti.br> - 2018-03-13 07:04 -0700
      Re: VO and Cloud Jürgen Knauf <trotterklaus@googlemail.com> - 2018-03-13 23:56 -0700

#11473 — VO and Cloud

FromJürgen Knauf <trotterklaus@googlemail.com>
Date2018-03-08 22:23 -0800
SubjectVO and Cloud
Message-ID<ae28c68e-c6b0-45a8-93b0-2321cea5105c@googlegroups.com>
Has anybody experience with databases working in the cloud?

Juergen

[toc] | [next] | [standalone]


#11474

Fromattiamxy@gmail.com
Date2018-03-08 23:46 -0800
Message-ID<035f0454-c504-4f65-a5c1-cc647abb5342@googlegroups.com>
In reply to#11473
https://cloud.google.com/sql/docs/mysql/connect-external-app

[toc] | [prev] | [next] | [standalone]


#11475

Fromattiamxy@gmail.com
Date2018-03-08 23:53 -0800
Message-ID<ff21593b-2424-41f4-a77f-9305bc2ad642@googlegroups.com>
In reply to#11473
check the price with google before you begin...

or you can hire computer on cloud..
install on it mysql or mariadb..


after you can connect with odbc to mysql on the cloud server.

its very easy and simple.

moshe

[toc] | [prev] | [next] | [standalone]


#11478

FromArne Ortlinghaus <Arne.Ortlinghaus@acs.it>
Date2018-03-09 12:56 +0100
Message-ID<p7tsq6$1eb3$1@gioia.aioe.org>
In reply to#11473
Hi Jürgen,
I would say:
- You should never try to access a database stored directly in the cloud 
using a locally installed program.
- If you use the cloud for exchanging data between clients adding some 
replication/exchange mechanisms to your local database then it is ok. 
But in this case a standard FTP server is sufficient.
- For full cloud solution of desktop programs a terminalserver solution 
is needed. But this can be quite expensive. Otherwise Internet programs 
stored in the cloud are needed.

Arne Ortlinghaus
INFOMINDS AG


Jürgen Knauf wrote:
> Has anybody experience with databases working in the cloud?
> 
> Juergen
> 
> 

[toc] | [prev] | [next] | [standalone]


#11479

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2018-03-09 14:29 +0100
Message-ID<fgfgilFs75kU1@mid.individual.net>
In reply to#11473
Hi Jürgen,

> Has anybody experience with databases working in the cloud?

if you intend with "cloud" the real cloud (where you don't really know
where your data is) that is not ok for European law, no.

But if "cloud" can be your own or a rented server where you have
installed a real database and are talkting to it using a special
interface, yes.

I have now running a customers application for more than 10 years that
has its entire data stored on a SQL server that is installed in a
datacenter.
My program accesses the data through https calls, and receives/sends
data in encrypted and compressed XML. On the server side, I have a PHP
interface. The client is a pure VO application.

I had demonstrated such a program years ago on an Italian conference,
but it was not interesting enough, it seems.

As Arne said: the best and easiest solution is a terminalserver
solution. You can rent a virtual Windows server from a hoster and
install your program there - I use such a machine for the monitoring of
my Linux servers by a few X# programs, and I'm paying 12,60 Euro per
month for a Windows Server 2012 R2 with 4 GB of memory and 100 GB of
SSD storage. The provider is Hosteurope.

Wolfgang


-- 

[toc] | [prev] | [next] | [standalone]


#11481

FromJürgen Knauf <trotterklaus@googlemail.com>
Date2018-03-09 23:58 -0800
Message-ID<3d72db04-14ec-4746-98bf-ce0011c6c16b@googlegroups.com>
In reply to#11479
Am Freitag, 9. März 2018 14:29:59 UTC+1 schrieb Wolfgang Riedmann:
> Hi Jürgen,
> 
> > Has anybody experience with databases working in the cloud?
> 
> if you intend with "cloud" the real cloud (where you don't really know
> where your data is) that is not ok for European law, no.
> 
> But if "cloud" can be your own or a rented server where you have
> installed a real database and are talkting to it using a special
> interface, yes.
> 
> I have now running a customers application for more than 10 years that
> has its entire data stored on a SQL server that is installed in a
> datacenter.
> My program accesses the data through https calls, and receives/sends
> data in encrypted and compressed XML. On the server side, I have a PHP
> interface. The client is a pure VO application.
> 
> I had demonstrated such a program years ago on an Italian conference,
> but it was not interesting enough, it seems.
> 
> As Arne said: the best and easiest solution is a terminalserver
> solution. You can rent a virtual Windows server from a hoster and
> install your program there - I use such a machine for the monitoring of
> my Linux servers by a few X# programs, and I'm paying 12,60 Euro per
> month for a Windows Server 2012 R2 with 4 GB of memory and 100 GB of
> SSD storage. The provider is Hosteurope.
> 
> Wolfgang
> 
> 
> --

Wolfgang,
can I install my VO app on a virtual server from Hosteuropa.
How can I access to my Vo App from my Desktop?

Juergen

[toc] | [prev] | [next] | [standalone]


#11482

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2018-03-10 09:29 +0100
Message-ID<fghjafFbtd6U1@mid.individual.net>
In reply to#11481
Hi Jürgen,

> can I install my VO app on a virtual server from Hosteuropa.

of course! You need a Windows server (they offer Windows Server 2012 R2
Datacenter without additional cost):

https://www.hosteurope.de/Server/Virtual-Server/Vergleichen/

2 GB is a bit too small, therefore you will need at least the Starter
Plus. The good thing is that you can upgrade at any time to a higher
edition (needs only a restart of your machine), but not downgrade.

I had the Starter Edition first, and upgraded then to the Starter Plus.

> How can I access to my Vo App from my Desktop?

Remote Desktop is your friend. It works from nearly every machine,
included Android and iOS devices.

But since your machine is reachable from the entire world, you have to
install updates as fast as possible and make sure to use secure
passwords (and don't open ports you don't need).

Wolfgang


-- 

[toc] | [prev] | [next] | [standalone]


#11483

Fromattiamxy@gmail.com
Date2018-03-10 02:28 -0800
Message-ID<9d783bad-e0bc-4ddc-ab6b-f20772b63651@googlegroups.com>
In reply to#11482
hi..Wolfgang


The site is only in German ?

[toc] | [prev] | [next] | [standalone]


#11485

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2018-03-10 12:35 +0100
Message-ID<fghu80FeajaU1@mid.individual.net>
In reply to#11483
Hi Moshe,

> The site is only in German ?

I'm very sorry, I'm using the German language on my system.

This is the English version of the page:

https://www.hosteurope.de/en/Server/Virtual-Server/

There should be a language switch on the top of the page.

When I searched for a decent hoster that was willing to sell also in
other countries (I'm located in Italy) long ago, I found only them. In
the meantime also the other hosters have offers for not-Germans.
But they have a good customer service and I had no problems the last
years. And the prices seems to be interesting (currently I have two
Linux and one Windows server running there).

Wolfgang



-- 

[toc] | [prev] | [next] | [standalone]


#11484

FromJürgen Knauf <trotterklaus@googlemail.com>
Date2018-03-10 03:06 -0800
Message-ID<25915b1c-cb1a-4aa6-8096-1ba08a97e7b8@googlegroups.com>
In reply to#11482
Am Samstag, 10. März 2018 09:29:06 UTC+1 schrieb Wolfgang Riedmann:
> Hi Jürgen,
> 
> > can I install my VO app on a virtual server from Hosteuropa.
> 
> of course! You need a Windows server (they offer Windows Server 2012 R2
> Datacenter without additional cost):
> 
> https://www.hosteurope.de/Server/Virtual-Server/Vergleichen/
> 
> 2 GB is a bit too small, therefore you will need at least the Starter
> Plus. The good thing is that you can upgrade at any time to a higher
> edition (needs only a restart of your machine), but not downgrade.
> 
> I had the Starter Edition first, and upgraded then to the Starter Plus.
> 
> > How can I access to my Vo App from my Desktop?
> 
> Remote Desktop is your friend. It works from nearly every machine,
> included Android and iOS devices.
> 
> But since your machine is reachable from the entire world, you have to
> install updates as fast as possible and make sure to use secure
> passwords (and don't open ports you don't need).
> 
> Wolfgang
> 
> 
> --

Wolfgang, thank you very much!!!!!

[toc] | [prev] | [next] | [standalone]


#11516

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2018-03-22 12:38 +0100
Message-ID<qt47bdt48bmmspoa4oumbmblpeoe4s7kov@4ax.com>
In reply to#11479
Replying on message of Fri, 9 Mar 2018 14:29:56 +0100 from Wolfgang
Riedmann:


 Hello Wolfgang,

> I use such a machine for the monitoring of
>my Linux servers by a few X# programs, and I'm paying 12,60 Euro per
>month for a Windows Server 2012 R2 with 4 GB of memory and 100 GB of
>SSD storage. The provider is Hosteurope.
>
That's a remarkably low price. In my Microsoft Action Pack I "pay"
about 75 euro/month for an Azure server (Action Pack gives 85 euro per
month credit). 

If you use their calculator at
https://azure.microsoft.com/nl-nl/pricing/calculator/#virtual-machines337fb1a5-86d7-4d62-9cd1-347c23963e7d

and select a 2 Core machine with 3,5 Gb RAM it's 110,81 per month.
Apart from the fact that I don't understand anything from how
Microsoft configures and prices machines, they seem a lot, lot more
expensive. Why would anyone go for Azure I wonder?

What I don't understand from Azure is:

1) Why 3,5 Gb ram. How do they get servers with 3,5 Gb of RAM? Is
someone disabling 0,5 Gb from a 4 Gb standard RAM chip?

2) The price gets higher when you select more temporary storage. But
it doesn't say anything about fixed storage and that is I'd say the
only thing that counts. When I configured the Azure server I wondered
about the low amounts of storage. But when I looked, that was for
temporary storage (which we hardly ever use) while there was an
acceptable amount of SSD configured (I think it is 256 Gb currently).

Dick

[toc] | [prev] | [next] | [standalone]


#11517

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2018-03-22 20:56 +0100
Message-ID<fhig3jFp37qU1@mid.individual.net>
In reply to#11516
Hi Dick,

Cloud servers are much more expensive because you pay only the time you
need them - and you are more flexible, I think.

For my virtual server I have to pay the same amount month per month,
and I'm responsible for the machine. I can step up to a higher
performance, but not step down - a thing you can do with a cloud
servers. AFAIK cloud servers scale better, and you don't pay if you
don't need them.

For my needs (I need the server to be active 7/24) a virtual server is
the cheaper choice.
And if I need real performance (as for several projects) I have my own
servers (yes, the metal was buyed by my company) housed at a providers
datacenter in about 30 km of distance, and I can access them for
maintenance whenever I need (with several access controls).

Wolfgang

D.J.W. van Kooten wrote:

> Replying on message of Fri, 9 Mar 2018 14:29:56 +0100 from Wolfgang
> Riedmann:
> 
> 
>  Hello Wolfgang,
> 
> > I use such a machine for the monitoring of
> > my Linux servers by a few X# programs, and I'm paying 12,60 Euro per
> > month for a Windows Server 2012 R2 with 4 GB of memory and 100 GB of
> > SSD storage. The provider is Hosteurope.
> > 
> That's a remarkably low price. In my Microsoft Action Pack I "pay"
> about 75 euro/month for an Azure server (Action Pack gives 85 euro per
> month credit). 
> 
> If you use their calculator at
> https://azure.microsoft.com/nl-nl/pricing/calculator/#virtual-machines
> 337fb1a5-86d7-4d62-9cd1-347c23963e7d
> 
> and select a 2 Core machine with 3,5 Gb RAM it's 110,81 per month.
> Apart from the fact that I don't understand anything from how
> Microsoft configures and prices machines, they seem a lot, lot more
> expensive. Why would anyone go for Azure I wonder?
> 
> What I don't understand from Azure is:
> 
> 1) Why 3,5 Gb ram. How do they get servers with 3,5 Gb of RAM? Is
> someone disabling 0,5 Gb from a 4 Gb standard RAM chip?
> 
> 2) The price gets higher when you select more temporary storage. But
> it doesn't say anything about fixed storage and that is I'd say the
> only thing that counts. When I configured the Azure server I wondered
> about the low amounts of storage. But when I looked, that was for
> temporary storage (which we hardly ever use) while there was an
> acceptable amount of SSD configured (I think it is 256 Gb currently).
> 
> Dick



-- 

[toc] | [prev] | [next] | [standalone]


#11519

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2018-03-25 15:27 +0200
Message-ID<0i8fbd9v1ql6v35vqomaug70f1m84kg35r@4ax.com>
In reply to#11517
Replying on message of Thu, 22 Mar 2018 20:56:33 +0100 from Wolfgang
Riedmann:


 Hello Wolfgang,

>AFAIK cloud servers scale better, and you don't pay if you
>don't need them.


Yes, but if they cost up to 10 x as much that is only an advantage if
you need them 3 hours a day only. For the amount you mention you don't
need to bother about switching them off. I do that manually almost
every week for the Azure serer otherwise I exceed my 85 included euros
and I have not yet found a way to automate that which switch off and
again on on Monday, at least not one for which the price for that
service is clear.

For most cloud computers I think a physical system is almost always
cheaper after 1-3 years. For the one you use physical seems only
cheaper if you keep them quite a few years.

Dick

[toc] | [prev] | [next] | [standalone]


#11518

FromMassimo Bighelli <info@arcasistemi.it>
Date2018-03-23 11:59 +0100
Message-ID<p92mmq$ukt$1@gioia.aioe.org>
In reply to#11516
Il 22/03/2018 12:38, D.J.W. van Kooten ha scritto:
> Replying on message of Fri, 9 Mar 2018 14:29:56 +0100 from Wolfgang
> Riedmann:
> 
> 1) Why 3,5 Gb ram. How do they get servers with 3,5 Gb of RAM? Is
> someone disabling 0,5 Gb from a 4 Gb standard RAM chip?
> 

maybe 32 OS ?

*Massimo Bighelli* ARCA Sistemi S.r.l.

[toc] | [prev] | [next] | [standalone]


#11480

FromJürgen Knauf <trotterklaus@googlemail.com>
Date2018-03-09 23:56 -0800
Message-ID<d95da5b0-029f-42ad-8cde-b0fd5d061199@googlegroups.com>
In reply to#11473
Am Freitag, 9. März 2018 07:23:25 UTC+1 schrieb Jürgen Knauf:
> Has anybody experience with databases working in the cloud?
> 
> Juergen

Thank you for your answers.

[toc] | [prev] | [next] | [standalone]


#11487

FromLucio Chiessi <lucio@vorio.eti.br>
Date2018-03-13 07:04 -0700
Message-ID<78470698-5b5b-4f8a-81e3-5b959853e425@googlegroups.com>
In reply to#11473
Em sexta-feira, 9 de março de 2018 03:23:25 UTC-3, Jürgen Knauf  escreveu:
> Has anybody experience with databases working in the cloud?
> 
> Juergen

Hi Juergen.

Today I have VO systems installed on my Clients' computers, remotely accessing PostgreSQL databases that are in the Digital Ocean and Amazon cloud. I use the Windows ODBC layer for the connection. In this case the great paradigm shift is to place the business rules that manipulate large volumes of data in the Database, through the use of Triggers, Constraints and Stored Functions. To ensure information traffic security, PostgreSQL has native connection encryption capabilities using SSL in the latest standards. I can do this without problems and with the satisfaction of my clients. Good luck.

All my best!

Lucio Chiessi
Rio de Janeiro - Brazil

[toc] | [prev] | [next] | [standalone]


#11489

FromJürgen Knauf <trotterklaus@googlemail.com>
Date2018-03-13 23:56 -0700
Message-ID<a5ffbc0f-4eea-418a-9eaa-30db8b015a45@googlegroups.com>
In reply to#11487
Am Dienstag, 13. März 2018 15:04:30 UTC+1 schrieb Lucio Chiessi:
> Em sexta-feira, 9 de março de 2018 03:23:25 UTC-3, Jürgen Knauf  escreveu:
> > Has anybody experience with databases working in the cloud?
> > 
> > Juergen
> 
> Hi Juergen.
> 
> Today I have VO systems installed on my Clients' computers, remotely accessing PostgreSQL databases that are in the Digital Ocean and Amazon cloud. I use the Windows ODBC layer for the connection. In this case the great paradigm shift is to place the business rules that manipulate large volumes of data in the Database, through the use of Triggers, Constraints and Stored Functions. To ensure information traffic security, PostgreSQL has native connection encryption capabilities using SSL in the latest standards. I can do this without problems and with the satisfaction of my clients. Good luck.
> 
> All my best!
> 
> Lucio Chiessi
> Rio de Janeiro - Brazil

Lucio, thank you. I will have a look.
Juergen

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web