Forum Topic

MySQL - how to host your local MySQL online

  • Hi mga ka tpc

    Balak ko mag gwa ng application parang registration system

    Bali there are 3 branches and dpat ang database is sync with each other

    So we plan to set our mysql to be visible online

    Paano po kaya maachieve to?
  • @chanrio

    I don\'t get what you mean na visible online. Macocompromise po yung mga data nyo if ever ganyan po yung gusto nyo i-achieve.

    You may choose any technology to have your registration developed. PHP, Java, C# etc.

    You can dedicate a server PC tapos clients na lang yung iba then duon po mag-connect yung client PC to access the same MySql database po.
  • I mean ung pinaka database kasi is local lang kaso wala sa iisang office ung mga database. Meaning po dpat pag nagupdate ung isang database dapat makita din un sa ibang site. Kung baga lets call it site A B and C, if a user register on Site A, info of the registered user must be viewed from Site B and Site C also and vise versa

    -- edited by chanrio13 on May 30 2015, 08:54 PM
  • use VPN to interconnect network resources of all the branches. set your security in VPN na lang para walang 3rd party maka snoop
  • pwede po un,ifort porward mo lang ung ip ng local server sa router.tpos ung application mo gagamitin nyang ip ung WAN ip.
  • pagisahin mo na lang kaya ang db from site abc., then host mo online.

    medyo matrabaho nga lang sa conversion
  • Pag po kasi rekta online and centralize db medyo mabagal mag querry kasi dadaan sa internet. Bale local db tapos sync
  • Pag po kasi rekta online and centralize db medyo mabagal mag querry kasi dadaan sa internet. Bale local db tapos sync


    ilan na ba size nang db?
    innodb o myisam engine?
    web gui o native gui apps?
  • Sa ngaun po gingwa ko palang ang db wala pang laman.

    Innodb po

    Windows forms po
  • try mo multi master replication, kung mablis ang connection mo.

    pero suggestion ko gawin mo na lang web app using php etc, para kahit saan pwede ma access.

    kung concern mo naman ay important db mo host mo sa isang brach ang server.

    cheap vps hosting front end <------------> rest api service (kahit self sign SSL) <----------------> branch web api service / db server
  • Bali mangyayare dun pag web app dun nadn server no bali ung db nya local lang ang nkaremote lang is ung web page mismo. Pero si web page pag access ng db local nlng no? Sorry wla pa masyado background sa php