MySQL Forums
Forum List  »  Newbie

Re: create mysql on cloud
Posted by: Phillip Ward
Date: November 19, 2021 06:13AM

Quote

Is it ok to set up the db in a cloud, like what you do in the local?

Probably not.

Quote

... with the my.ini file setting the basedir and datadir in the cloud, and access from other computer with the cloud linked in?
... if the cloud is synced to the computer

Absolutely not.

Database != File

Please, please, stop thinking of your Database as a File.

Your Database is a running process, most of which exists only in memory, not on disk at all. No file synchronising program is going to be able to reliably transfer changes from one set of database files to another.
Every DBMS has its own way of replicating [logical] changes between databases, and trying to unpick changes flying around at the data file level is not one of them.

If you have a hosting company, then get them to host the entire Database and simply connect to that Database from applications running on your [many] computers.

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
November 17, 2021 08:46AM
November 17, 2021 09:47AM
Re: create mysql on cloud
November 19, 2021 06:13AM
November 19, 2021 09:08AM
November 22, 2021 06:28AM
November 17, 2021 11:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.