Remote MySQL Access

[filesiteguy]

Some partners of mine and I are writing a host-based application,
which would greatly benefit if we could take advantage of a web
services-like function we are formulating.

Unfortunately, this requires a centralized (or duplicated) MySQL
database which can be accessed via several web hosting providers.

In my experience, typically web hosting providers only allow localhost
access to MySQL databases.

Are there any providers who either allow remote access or does anyone
know of providers specifically designed for this function? I did find
one, but it is a "giveaway" when their product is purchased:
http://www.navicat.com

So far, I'm on page 8 of my 110,000-item result from a Google search.
kai
www.perfectreign.com || www.filesite.org
g2004 at g3prod.cotse.net

[Virgil Green]

"filesiteguy" <ab***@127.0.0.1> wrote in message
news:co********************************@4ax.com...

Some partners of mine and I are writing a host-based application,
which would greatly benefit if we could take advantage of a web
services-like function we are formulating.

Unfortunately, this requires a centralized (or duplicated) MySQL
database which can be accessed via several web hosting providers.

In my experience, typically web hosting providers only allow localhost
access to MySQL databases.

Are there any providers who either allow remote access or does anyone
know of providers specifically designed for this function? I did find
one, but it is a "giveaway" when their product is purchased:
http://www.navicat.com

My host, www.lunarpages.com (use this link:
http://secure.lunarpages.com/trackin...cgi?id=obsydi2) if
you want to sign up and give me affiliate credit), allows you to add as many
valid external hosts as you would like for remote access to the database. I
use that all the time to access my hosted database from my home test server.

For that matter, just about any host that uses a cPanel control panel will
probably do the same.

- Virgil

[Edward Alfert]

filesiteguy <ab***@127.0.0.1> wrote in
news:co********************************@4ax.com:

Some partners of mine and I are writing a host-based application,
which would greatly benefit if we could take advantage of a web
services-like function we are formulating.

Unfortunately, this requires a centralized (or duplicated) MySQL
database which can be accessed via several web hosting providers.

In my experience, typically web hosting providers only allow localhost
access to MySQL databases.

Are there any providers who either allow remote access or does anyone
know of providers specifically designed for this function? I did find
one, but it is a "giveaway" when their product is purchased:
http://www.navicat.com

So far, I'm on page 8 of my 110,000-item result from a Google search.
kai
www.perfectreign.com || www.filesite.org
g2004 at g3prod.cotse.net

I don't know what your budget is, but you might consider renting a
dedicated server then you can do whatever you like. You will have root
access (full control). Now a days, you can find dedicated servers for less
than $60 per month. Granted, these are low end servers, but you would not
be sharing with other customers and the net effect might be better
performance than a shared hosting solution.
--
Edward Alfert
http://www.rootmode.com/
Multiple Domain Hosting and Reseller Hosting Plans
Coupon Code (Recurring $5/month Discount): newsgroup

[Leythos]

In article <co********************************@4ax.com>, ab***@127.0.0.1
says...

Some partners of mine and I are writing a host-based application,
which would greatly benefit if we could take advantage of a web
services-like function we are formulating.

Unfortunately, this requires a centralized (or duplicated) MySQL
database which can be accessed via several web hosting providers.

In my experience, typically web hosting providers only allow localhost
access to MySQL databases.

Are there any providers who either allow remote access or does anyone
know of providers specifically designed for this function? I did find
one, but it is a "giveaway" when their product is purchased:
http://www.navicat.com

So far, I'm on page 8 of my 110,000-item result from a Google search.

Why not run a web service that has one web site query the other web site
for information - use some non-standard port.

--
--
sp*********@rrohio.com
(Remove 999 to reply to me)

[Tim Van Wassenhove]

In article <co********************************@4ax.com>, filesiteguy wrote:

Some partners of mine and I are writing a host-based application,
which would greatly benefit if we could take advantage of a web
services-like function we are formulating.

Unfortunately, this requires a centralized (or duplicated) MySQL
database which can be accessed via several web hosting providers.
Meaby have a look at a better/more flexible rdbms that supports
replication?
Are there any providers who either allow remote access or does anyone
know of providers specifically designed for this function? I did find
one, but it is a "giveaway" when their product is purchased:
http://www.navicat.com

You could do it yourself. But instead of using some obscure portnumber
do it the right way: set up a SSL tunnel between the mysql server and
the client and send all traffic through that tunnel.
--
Tim Van Wassenhove <http://home.mysth.be/~timvw>

[Daniel Tryba]

Tim Van Wassenhove <eu**@pi.be> wrote:

Unfortunately, this requires a centralized (or duplicated) MySQL
database which can be accessed via several web hosting providers.

Meaby have a look at a better/more flexible rdbms that supports
replication?

What are you trying to say?

BTW mysql 4.x supports replication.

--

Daniel Tryba

[Alex Shi]

I would suggest two solutions:

1. on the host where MySQL running you deploy a web based query
service. This can be fully implemented by php script, and can be
accessed from remote host.

2. I can provide you with a hosting plan at $240/year with following
features:
600M space, 10G bandwidth, unlimited pop account, unlimited
databases, and allow remote access (at your own risk:).
Alex Shi

Some partners of mine and I are writing a host-based application,
which would greatly benefit if we could take advantage of a web
services-like function we are formulating.

Unfortunately, this requires a centralized (or duplicated) MySQL
database which can be accessed via several web hosting providers.

In my experience, typically web hosting providers only allow localhost
access to MySQL databases.

Are there any providers who either allow remote access or does anyone
know of providers specifically designed for this function? I did find
one, but it is a "giveaway" when their product is purchased:
http://www.navicat.com

So far, I'm on page 8 of my 110,000-item result from a Google search.
kai
www.perfectreign.com || www.filesite.org
g2004 at g3prod.cotse.net

[Jeppe Uhd]

Daniel Tryba wrote:

Tim Van Wassenhove <eu**@pi.be> wrote:

Unfortunately, this requires a centralized (or duplicated) MySQL
database which can be accessed via several web hosting providers.

Meaby have a look at a better/more flexible rdbms that supports
replication?

What are you trying to say?

BTW mysql 4.x supports replication.

Actually all the way back to 3.23.15

--
MVH Jeppe Uhd - NX http://nx.dk
Webhosting for nørder og andet godtfolk

[Colin McKinnon]

Jeppe Uhd wrote:

Daniel Tryba wrote:

Tim Van Wassenhove <eu**@pi.be> wrote:

Unfortunately, this requires a centralized (or duplicated) MySQL
database which can be accessed via several web hosting providers.

Meaby have a look at a better/more flexible rdbms that supports
replication?

What are you trying to say?

BTW mysql 4.x supports replication.

Actually all the way back to 3.23.15

Yes but AFAICS its not a distributed database which I suspect is what K
needs.

The sugestion of using a php protocol wrapper to run the queries as if local
could be implemented fairly easily (I reckon about 60 lines of code) and
would be my bet as the easiest solution.

HTH

C.

[Daniel Tryba]

Colin McKinnon <co**************@andthis.mms3.com> wrote:

BTW mysql 4.x supports replication.
Actually all the way back to 3.23.15

Yes but AFAICS its not a distributed database which I suspect is what K
needs.

Master/master replication is in 4.1.x (which is not for production last
time I took al ook).
The sugestion of using a php protocol wrapper to run the queries as if local
could be implemented fairly easily (I reckon about 60 lines of code) and
would be my bet as the easiest solution.

Fastest and safest (networkwise, like http is almost always open or
available by proxy) solution indeed.

--

Daniel Tryba

[Leythos]

In article <cc**********@news.tue.nl>, ne****************@canopus.nl
says...

Master/master replication is in 4.1.x (which is not for production last
time I took al ook).

It wouldn't matter - if they don't allow remote access then they won't
allow a connection for replication.

If he's going to be stuck with no-remote connections to it, the easiest
method would be to write a couple pages that let him pull the raw data
over some for of web page query and automate the process.

--
--
sp*********@rrohio.com
(Remove 999 to reply to me)

[filesiteguy]

On Thu, 08 Jul 2004 09:22:35 +0100, Colin McKinnon
<co**************@andthis.mms3.com> wrote:

Jeppe Uhd wrote:

Daniel Tryba wrote:

Tim Van Wassenhove <eu**@pi.be> wrote:
> Unfortunately, this requires a centralized (or duplicated) MySQL
> database which can be accessed via several web hosting providers.

Meaby have a look at a better/more flexible rdbms that supports
replication?

What are you trying to say?

BTW mysql 4.x supports replication.

Actually all the way back to 3.23.15

Yes but AFAICS its not a distributed database which I suspect is what K
needs.

The sugestion of using a php protocol wrapper to run the queries as if local
could be implemented fairly easily (I reckon about 60 lines of code) and
would be my bet as the easiest solution.

Sorry for stepping back in so late - that's kind of what we decided
on. We'll host a database on siteX with various PHP scripts running.
An applicaiton on siteY will call the PHP scripts on siteX which will
return the neccesary encrypted data to siteY for siteY to consume/use.
We've got it pretty much worked out already. (Caffeine is a wonderful
thing!)

K
kai
www.perfectreign.com || www.filesite.org
g2004 at g3prod.cotse.net

[filesiteguy]

On Thu, 8 Jul 2004 08:29:20 +0200, "Jeppe Uhd" <ln*********@nx.dk>
wrote:

Daniel Tryba wrote:

Tim Van Wassenhove <eu**@pi.be> wrote:

Unfortunately, this requires a centralized (or duplicated) MySQL
database which can be accessed via several web hosting providers.

Meaby have a look at a better/more flexible rdbms that supports
replication?

What are you trying to say?

BTW mysql 4.x supports replication.

Actually all the way back to 3.23.15

Now if we could only get the stored procedures to work as I assume
stored procedures should work (ie - like DB2 or MSSQL/Sybase)

K
kai
www.perfectreign.com || www.filesite.org
g2004 at g3prod.cotse.net