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
Jul 17 '05
12 2858
In article <cc**********@n ews.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*********@rro hio.com
(Remove 999 to reply to me)
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.ne t
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.ne t This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mary Grace |
last post by:
I have been using MySQL for awhile, and for the first time someone from
outside our portable /16 needs access to some tables. We have given them
the server IP address, the dB name, the port 3306, the root username, and
the password, but they still can't get access. Of course, no firewalls or
other things in the way.
Is it true that MySQL defaults to local access only, and to enable remote
access you must do something unusual with...
|
by: Fred |
last post by:
I just started using MySQL, and cannot find how to
configure host access in the my.cnf file. I want
to be able to allow access to a MySQL database
from a remote host, and also from a particular
network. How do you configure access of this sort?
-Thanks
|
by: Ian Davies |
last post by:
Hello all
The following code allows me to connect to a local MySQL database on my pc
from a VB6 project.
****************************************************************************
**
Dim conn As ADODB.Connection
Dim cs As String
Dim MyServer As String
|
by: Greg Gursky |
last post by:
Hello:
I'm doing some planning on a potential project with which I need
some help. The database at the focus of this question is a
MS Access database that is currently accessed by DAO from a local
webserver. I need to access the same database remotely through
TCP/IP. There will be potentially many transactions coming from
both the web server and remotely, so the solution needs to keep
the data safe in such an environment. However,...
|
by: Ike |
last post by:
Let's say I have a MySQL 4.12 database, opened to the internet on
111.111.111.111 allowing all incoming and outgoing ports. I have a username
and password setup, which CAN connect to this database, from
222.222.222.222.
Also on 222.222.222.222, which is running Tomcat, I have a Java servlet,
called, say, servlet.class in WEB-INF/classes. servlet.class has permissions
755, as does WEB-INF/classes.
Additionally, I have on...
| |
by: Martin |
last post by:
Hi all.
I have a fully functional page hosted on my PC that uses PHP and
connects to MySQL on my PC to generate it's code.
I now have some web hosting available which includes both PHP and MySQL
support, however the webhost is still in the process of getting the
MySQL support activated and functional.
I therefore have uploaded my webpage to the host and edited the webpage
|
by: Jerim |
last post by:
I have a script on one server, trying to access the MySQL database on
another server. The server with the script is on an outside network,
hosted with another company. The MySQL server is here in the
office;behind a firewall. Script works fine when it is on the local
machine, but when I moved it to the offsite webserver it gives me:
Warning: mysql_connect() : Lost connection to
MySQL server during query in...
|
by: Kurt Jakobsen |
last post by:
Hello,
I have a client program that I use to access a MySql 5.0 community server. The client can be on the machine where the MySql server is installed or from a remote machine.
The client has worked fine for 1/2 a year from both the local machine and from remote. I installed the server in january. After returning from vacation in july, I cannot access the server from a remote machine anymore. But the client that is locally on the same...
|
by: Pseudonyme |
last post by:
A Paris
Le 14 Nv MMVII
Dear Madam and Sir,
Do you know how to access a MYSQL DB from an external server ?
We read the information and studied :
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |