Remote access MYSQL on a  WD My Cloud Mirror

Paer Toernell
Paer Toernell used Ask the Experts™
on
I have a WD My Cloud Mirror with a database i need to access remotely, so i need the IP of the router that keeps changing (the port forward is already done).  Is there any installed software i can use or perhaps is it possible to install a DynDNS client?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
I need the updater installed in the WD My Cloud Mirror, not in any other computer in the network if possible.
1)  If you are running MySQL server on the PC, you'll need remote access to the PC and the SQL pipe unless you want to risk corrupting the data.  You want access to the SQL server, not the data file.  Have you considered LogMeIn, TeamViewer, or SplashTop to simply access a PC at your place?  They all work by using an intermediary server to establish the connection so your ip changing becomes a non-issue.
2)  If you want a DynDNS setup, that usually gets done in the router; but, as a note my ip only changes about once per year, these days.

Author

Commented:
IP here (Thailand) change all the time, and for some reason my DynDNS account wont work in the router - and we have external user of our MYSQL database that we wont give access to our computers or the entire MyClod (unix) server.
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

SQL databases; though, are manipulated by the SQL server which receives requests from the clients for retrieving and changing data.  All kinds of stuff ought to hit the fan if you try to access it directly from a second PC (Its just like having two people editing the same document simultaneously; one of the will get scr*wed!)
BTW; too, that external user would have the slowest access you can imagine even if the external access would work.
I think you should add a PC to the internal network; set it up to run the software for the database, clobber internet browsing on it, and use LogMeIn, TeamViewer, or Splashtop which would also solve the ip address problem.  Heck, if its a Pro version of Windows, you could even use RDP.

Author

Commented:
Programs written in Delphi the correct way can with ease and speed use the same MYSQL database simultaneously with either optimistic or pessimistic locking. Its a "fat" client and the speed is up to 200-500 times faster that a web solution, because its more the numer of access to the MySQL that takes time more than how much data is sent. Even a slow server like MyCloud can handle 50 users in the same table with ease, most of the operations is done locally in the client, not like in a Web browser where most operations requires communication with the server. When You access a table, you normally download at least a few hundred rows at the same time, and from there on its all in the client written in compiled code.

Author

Commented:
Delphi is 50 times faster than PHP, add to that the data is in the clients RAM, not in a server.
So the local clients access the data file directly?

Author

Commented:
If the table is small you fetch it all in one "pump", if its larger you fetch perhaps 500 rows or so, that you can finetune yourself. In most cases you wont notice that the database is on the other side of the world. When a record is updated, ether the server will check if its already changed by another user (Wikipedia style) OR as soon as you start edit it it will be locked and noone else can start edit it (Filemaker style).
We may have some misunderstanding or language issue; but, that wasn't my question.  If local users can navigate to the database file and double-click to open it (just like an Excel or Word item), the answer is yes.  If local users have to run your Delphi program which then accesses the SQL server's database, the answer is no.
If the answer is no, users of your Delphi program need to have access to the SQL pipe(s) and, even if we could get that opened to the internet, I'd be scared silly about the security risks.

Author

Commented:
Delphi have a toolbox called "Firedac" that is very good and can handle most SQL databases, but i'm used to Devarts UNIDAC that i think can handle even more databases including Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, DB2, Microsoft Access, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise.

ScrennDump
So if i write an application for PostgreSQL and want to make a Oracle, all i have to do is to is a 2 seconds change the provider in a visual component or i can let the user select engine and the same code can be used.
Sunsales,
You're still missing the point.  If you chose DB2 or DBF from your own picture AND the PC was configured to open the filetype with your application, a user could go to the data file using explorer and double-click it to open.  That, I have made work for clients in the past; but, until user number one is done using the file, nobody else would be able to open it.  They would get sharing violation errors.
Almost all SQL databases; though, have the database server open the file with the users making queries or changes using "pipes" that send or receive data to the SQL server process; only the server itself opens the file which allows for multiple users doing multiple things in the same database.

Author

Commented:
Yeas i probably miss the point. I have been using technology like this for more than 20 years, and it works. I'm nor familiar with how the technology used works, but its very fast and flexible. There is also encryption available.
Opening an SQL shared database is NOT like opening an Excel spreadsheet.  The SQL server has what are called "named pipes" which are then connected to by all of the clients.  Clients then make requests for data and the server handles those requests.
The server is the only PC to actually have the database file open.
It may be possible to open the ports in the router so that the SQL data is available to remote users with the appropriate client software installed; but, just as with the local users, they would be accessing the server not the data file.
My concern with that is that then, anyone with a decent knowledge of SQL would be able to access your data.

Author

Commented:
Yes, You do access the server with SQL commands, not the data. SQL commands is sent and data is received.
So you need remote access to the SQL server rather than the data file which is what I said from the getgo.

Author

Commented:
Correct
Then your entire question is not going to get what you want:
"I have a WD My Cloud Mirror with a database i need to access remotely"

From my first post:
Have you considered LogMeIn, TeamViewer, or SplashTop to simply access a PC at your place? (Any of them would solve your problem because the host PC registers itself with their service)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial