Remote MySQL Access

**Virgil Green** · Jul 17 '05, 06:59 AM

Re: Remote MySQL Access

"filesitegu y" <abuse@127.0.0. 1> wrote in message
news:coloe0hrq6 pelrm75m2hjvr49 j1d6epuao@4ax.c om...[color=blue]
> 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
>[/color]

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** · Jul 17 '05, 06:59 AM

Re: Remote MySQL Access

filesiteguy <abuse@127.0.0. 1> wrote in
news:coloe0hrq6 pelrm75m2hjvr49 j1d6epuao@4ax.c om:
[color=blue]
> 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.ne t
>[/color]

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** · Jul 17 '05, 06:59 AM

Re: Remote MySQL Access

In article <coloe0hrq6pelr m75m2hjvr49j1d6 epuao@4ax.com>, abuse@127.0.0.1
says...[color=blue]
> 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.[/color]

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

--
--
spamfree999@rro hio.com
(Remove 999 to reply to me)

**Tim Van Wassenhove** · Jul 17 '05, 06:59 AM

Re: Remote MySQL Access

In article <coloe0hrq6pelr m75m2hjvr49j1d6 epuao@4ax.com>, filesiteguy wrote:[color=blue]
> 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.[/color]

Meaby have a look at a better/more flexible rdbms that supports
replication?
[color=blue]
> 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[/color]

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** · Jul 17 '05, 07:00 AM

Re: Remote MySQL Access

Tim Van Wassenhove <euki@pi.be> wrote:[color=blue][color=green]
>> Unfortunately, this requires a centralized (or duplicated) MySQL
>> database which can be accessed via several web hosting providers.[/color]
>
> Meaby have a look at a better/more flexible rdbms that supports
> replication?[/color]

What are you trying to say?

BTW mysql 4.x supports replication.

--

Daniel Tryba

**Alex Shi** · Jul 17 '05, 07:00 AM

Re: Remote MySQL Access

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

[color=blue]
> 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.ne t[/color]

**Jeppe Uhd** · Jul 17 '05, 07:00 AM

Re: Remote MySQL Access

Daniel Tryba wrote:[color=blue]
> Tim Van Wassenhove <euki@pi.be> wrote:[color=green][color=darkred]
>>> Unfortunately, this requires a centralized (or duplicated) MySQL
>>> database which can be accessed via several web hosting providers.[/color]
>>
>> Meaby have a look at a better/more flexible rdbms that supports
>> replication?[/color]
>
> What are you trying to say?
>
> BTW mysql 4.x supports replication.[/color]

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** · Jul 17 '05, 07:00 AM

Re: Remote MySQL Access

Jeppe Uhd wrote:
[color=blue]
> Daniel Tryba wrote:[color=green]
>> Tim Van Wassenhove <euki@pi.be> wrote:[color=darkred]
>>>> 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?[/color]
>>
>> What are you trying to say?
>>
>> BTW mysql 4.x supports replication.[/color]
>
> Actually all the way back to 3.23.15
>[/color]

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** · Jul 17 '05, 07:00 AM

Re: Remote MySQL Access

Colin McKinnon <colin.deleteth is@andthis.mms3 .com> wrote:[color=blue][color=green][color=darkred]
>>> BTW mysql 4.x supports replication.[/color]
>>
>> Actually all the way back to 3.23.15
>>[/color]
>
> Yes but AFAICS its not a distributed database which I suspect is what K
> needs.[/color]

Master/master replication is in 4.1.x (which is not for production last
time I took al ook).
[color=blue]
> 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.[/color]

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

--

Daniel Tryba

**Leythos** · Jul 17 '05, 07:00 AM

Re: Remote MySQL Access

In article <ccj13r$rku$1@n ews.tue.nl>, news_comp.lang. php@canopus.nl
says...[color=blue]
> Master/master replication is in 4.1.x (which is not for production last
> time I took al ook).[/color]

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.

--
--
spamfree999@rro hio.com
(Remove 999 to reply to me)

**filesiteguy** · Jul 17 '05, 07:01 AM

Re: Remote MySQL Access

On Thu, 08 Jul 2004 09:22:35 +0100, Colin McKinnon
<colin.deleteth is@andthis.mms3 .com> wrote:
[color=blue]
>Jeppe Uhd wrote:
>[color=green]
>> Daniel Tryba wrote:[color=darkred]
>>> Tim Van Wassenhove <euki@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.[/color]
>>
>> Actually all the way back to 3.23.15
>>[/color]
>
>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.[/color]

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.ne t

**filesiteguy** · Jul 17 '05, 07:01 AM

Re: Remote MySQL Access

On Thu, 8 Jul 2004 08:29:20 +0200, "Jeppe Uhd" <lnewsnospam@nx .dk>
wrote:
[color=blue]
>Daniel Tryba wrote:[color=green]
>> Tim Van Wassenhove <euki@pi.be> wrote:[color=darkred]
>>>> 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?[/color]
>>
>> What are you trying to say?
>>
>> BTW mysql 4.x supports replication.[/color]
>
>Actually all the way back to 3.23.15[/color]

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.ne t

Remote MySQL Access

Remote MySQL Access

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment