Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #11473 > unrolled thread
| Started by | Jürgen Knauf <trotterklaus@googlemail.com> |
|---|---|
| First post | 2018-03-08 22:23 -0800 |
| Last post | 2018-03-13 23:56 -0700 |
| Articles | 17 — 7 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Jürgen Knauf <trotterklaus@googlemail.com> |
|---|---|
| Date | 2018-03-08 22:23 -0800 |
| Subject | VO and Cloud |
| Message-ID | <ae28c68e-c6b0-45a8-93b0-2321cea5105c@googlegroups.com> |
Has anybody experience with databases working in the cloud? Juergen
[toc] | [next] | [standalone]
| From | attiamxy@gmail.com |
|---|---|
| Date | 2018-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]
| From | attiamxy@gmail.com |
|---|---|
| Date | 2018-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]
| From | Arne Ortlinghaus <Arne.Ortlinghaus@acs.it> |
|---|---|
| Date | 2018-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2018-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]
| From | Jürgen Knauf <trotterklaus@googlemail.com> |
|---|---|
| Date | 2018-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2018-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]
| From | attiamxy@gmail.com |
|---|---|
| Date | 2018-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2018-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]
| From | Jürgen Knauf <trotterklaus@googlemail.com> |
|---|---|
| Date | 2018-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]
| From | D.J.W. van Kooten <vankooten@removethis.ic2.com> |
|---|---|
| Date | 2018-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2018-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]
| From | D.J.W. van Kooten <vankooten@removethis.ic2.com> |
|---|---|
| Date | 2018-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]
| From | Massimo Bighelli <info@arcasistemi.it> |
|---|---|
| Date | 2018-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]
| From | Jürgen Knauf <trotterklaus@googlemail.com> |
|---|---|
| Date | 2018-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]
| From | Lucio Chiessi <lucio@vorio.eti.br> |
|---|---|
| Date | 2018-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]
| From | Jürgen Knauf <trotterklaus@googlemail.com> |
|---|---|
| Date | 2018-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