Remote MySQL Access
filesiteguy
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
news:coloe0hrq6pelrm75...@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/tracking/cgi-bin/clickthru.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
news:coloe0hrq6pelrm75...@4ax.com:
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
Tim Van Wassenhove
> 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
>> 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
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
Jeppe Uhd
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
> 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
>>> 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
filesiteguy
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
filesiteguy
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