Search Postgresql Archives

Database access over the Internet...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



************************************************************************
*       Do not Cc: me, because I READ THIS LIST, if I write here       *
*    Keine Cc: am mich, ich LESE DIESE LISTE wenn ich hier schreibe    *
************************************************************************

...because using 2-3 differnet databases sucks!

Hello *,

After IRC'ing with some peoples and discusing about  PostgreSQL,  MySQL,
SQlite, Oracle Informix and others I like to know, if you use a database
access over the Internet what your experience is with...

My problem is, that I am using PostgreSQL since version 6.4 (March 1999)
and most Hosting-Provides offer only MySQL which let me run into trouble
with my nicely designed database.

So my idea is now, to install a small 19"/1U (maybe 2U) RackServer which
hold (at least for the data) four SAS drives of 76/147 GByte  in  Raid-1
with 2 Hotfix (and maybe 3-4 smaller 36 GByte drives for the OS+Logs.

It seems, I can have 1U racks with 4 drives and hardware Raid-1 for less
then 1400 Euro and the 2U ones for arround 1800 Euro.

Of course, without the SAS drives...

Now the problem is availability...  Installing 3-4 Racks  all  over  the
world and clustering it?  The database would have only the  data  of  my
OnlineStore (with  data  of  currently  arround  140.000  customers  and
increasing) and my website.  So, for  this  Base-Database  I  need  only
arround 1-2 GByte for now but if my website is entirely online, the data
volume increase rapidely.

How do you manage such case?

Are there Hosting-Provider where I can  cluster  my  Database  with  the
Database on another ISP?  E.g. One in the USA, one in Germany and one in
Swiss?

How do you manage Backups for the Database?

Note 1: I live in a MobilHome (generaly two and a MobilOffice) and  have
        no ADSL availlable here.  Only GSM/UMTS/HSDPA (up to  3.6 MBit).
        Maybe I will install Astra2connect which give me a bidirectional
        satelit connection but this is currently future for me  even  if
        it cost only 20 Euro per month prepayed for 2 years.

Note 2: I am working 95% mobil, which is WHY I use GSM/UMTS/HSDPA. (cost
        only 25 Euro/month with unlimited traffic at "O2" in Germany)

Thanks, Greetings and nice Day/Evening
    Michelle Konzack
    Systemadministrator
    24V Electronic Engineer
    Tamay Dogan Network
    Debian GNU/Linux Consultant


-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
+49/177/9351947    50, rue de Soultz         MSN LinuxMichi
+33/6/61925193     67100 Strasbourg/France   IRC #Debian (irc.icq.com)

<<attachment: signature.pgp>>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux