Mga guru pahinge naman ng idea baka meron kayong ma i a advice.
need kong i connect yung 2 sites , main office at 1 branch locally lang naman,
eto siste,
mysql data ang back end, sa local network palang medyo gapang na yung paglabas ng report,
sa workbench ang traffic nag a average ng 1mb to 4 mbps traffic.
kung lease line may kamahalan
let say 50k ang isang site times 2 = 100k na
if vpn naman ang worry ko dito baka di kayanin yung laki ng data.
microwave ? tower?
or ilagay ko yung database server sa cloud then 10mbps dsl connection ng main office at ng branch then connect nalang sa cloud?
baka meron kayong ma i se share, before nung nag aaply ako sa alabang, nabanggit ng I.T nila naka site to site sila using cisco catalyst , pero walang akong idea dito.
thanks
-- edited by dsmjr on Aug 19 2014, 02:50 PM
Forum Topic
site to site connection
-
microwave ? tower?
Gaano kalayo? -
If local connection palang mabagal na then I think the problem lies between the database itself and the client that generate the report or both.
Do this first para maiwasan mo gumastos sa mga bagay na di mo naman talaga kailangan.
-- edited by NUTC24CK322 on Aug 20 2014, 02:05 PM -
di naman kalayuan, kasi kung sa byahe 45 to 1 hr lang or sigiuro less than 50km
@NUTC24CK322
on going yung optimization ng DB at ng front end para mapabilis, but still
mas maganda parin o hinahanap ko parin yung kayang mag transmit ng malaking data, para long term solution na.
manufacturing kasi kaya madaming transaction. -
Ah ok yun naman pala.
I think it\'s much better kung sa cloud nalang for less maintenance on your part. -
Is there a clear line of sight in between the sites?
It is very possible to make a point-to-point 40km link using off-the-shelf WiFi hardware and two 24dB DIY antennae, assuming there is a clear line of sight. -
pwede yan sir wireless radio, ala isp setup pero kaya ng dalawang antenna/radio yan point to point. how about your budget sir?
we have a wireless device na pwede mag connect ng 75km. with line of sight. -
No need for special wireless devices; two old Linksys WRT54GLs can reach 40km with simple handmade antennae (shortened 3D corner reflectors, http://www.qsl.net/yu1aw/ANT_VHF/3d_corner_reflector_antenna.htm)
-
^^ Mimosa > The new kid on the block at fiber speed and it is real.
http://www.mimosa.co/ -
thank sa mga nag share,
mukhang hindi question ang budget kay boss, iniisip nga nila paranc cellsite para may return daw ng investment.
kung sa line of sight naman mukhang malabo ito unless gagawan ng tower para magkita yung 2 area considering may mga building na tatamaan
before naka pag setup narin ako na point to point yon nga lang kahit malayo sya kitang kita naman 2 area, mula sa bundok ng san mateo rizal katapat sa pbcom sa makati using CODAN at disc. Dito naman kasi internet lang ang binabato since walang internet sa itaas ng bundok ng san mateo
but this time malaking data ang ibabato kaya napapaisip ako,
if i cloud ko naman ( ec2 ng amazon) if bitin i iops ko pa, kaso hindi pa tiwala si boss sa security sa cloud, ang laman kasi ng database list ng mga customer + AR in short mga confi.
Baka may iba pa kayong idea, -
The simplest solution will be a PPTP vpn. Very lightweight, but not that secured.
OpenVPN will be an alternative but requires installation of some program in both ends.
I had the same setup where my SQL server does around 50Mbps of data on average, worked like a charm up to this date.
I think the performance bottleneck - assuming both sides have good upload - will be the SQL server\'s capacity.
Localizing the app on both sites and point them to a central sql will do the job easy. -
kahit walang line of site pwede yan sa micro wave at kahit hindi gaanu kataasan ng tower. san po ba location nyo?
-
nagawa ko na same problem as yours more than 50km, no line of site. from bulacan to nueva ecija. 1ms ping, 150mbps.
-- edited by techsufort on Sep 02 2014, 11:47 AM -
@mitsurugi
Mukhang same tayo 50mbps average din kami,
Pano set up mo ng pptp vpn mo?pano yan dsl lang tas nag setup ka lang ng vpn server both side?ilan ang bandwith ng dsl mo?
May way naman siguro para i secure itong pptp vpn.
Sa server nmn tingin ko wala akong problem, meron akong hp proliant dito at ibm x3500 m3
Thats the idea at ito rin ang request ni boss, install lang yung application sa kabilang side, pero dito sa main office yung database server. Ayaw nya ng master slave or master-master replication sa sql.
@techsufort
Pano setup nyan need paba ng isp?kakayanin bang mag trasmit/receive ng 50mbps?
Next year pa naman ito, on going pa kasi yung construction ng site, gusto ko lang i handa na habang maaga at maka pag conduct muna ng mga test
-- edited by dawinsm on Sep 02 2014, 12:06 PM
-- edited by dawinsm on Sep 02 2014, 12:11 PM -
walang isp. direktahan lang parang naka lan ka lang. chicken lang ang 50mbps. sinakyan ko pa ng cctv at voip ang setup. para bawas communication cost.
-
Sir pa pm, or kahit dito nlng,
Pwede ba malaman kung ano yung ginamit mo,price, specs or kaw ba mismo ang nag be benta?
-- edited by dawinsm on Sep 02 2014, 01:08 PM -
Pano set up mo ng pptp vpn mo?
Main Office <==> PPTP Server <==> Satellite Office
pano yan dsl lang tas nag setup ka lang ng vpn server both side?
Yep.
ilan ang bandwith ng dsl mo?
I have 100Mbps connection in both offices.
walang isp. direktahan lang parang naka lan ka lang. chicken lang ang 50mbps. sinakyan ko pa ng cctv at voip ang setup. para bawas communication cost.
Puede mo gawin ito granting you have a good line of site using today\'s networking gear. If not, you will have to build your antenna mast. Depends on your purpose, it can be costly, it can economical. I currently have 5 120-foot antenna masts doing the similar job but of a different purpose. Each of the five cost me around 80k to build, kailangan ko pa kasi bilhin yung piece of land. -
100mbps? Wow ano yan sir DLL? Magkano monthly per site?
Kung antena kasi at ang cost ay 80k per site, mukhang mas tipid ito kasi one time fee lang ito unlike sa DLL? Tingin mo? Ang isa pang question dito pano i secure yung data.
-- edited by dawinsm on Sep 04 2014, 09:46 AM -
100mbps? Wow ano yan sir DLL? Magkano monthly per site?
Nope, just PLDT Fiber. Though, not reliable yung 100Mbps nila...based on my experience, once in a blue moon lang sumisipa sa 100Mbps. Most of the time, 55-60Mbps lang ang kaya, and not even sustained.
Kung antena kasi at ang cost ay 80k per site, mukhang mas tipid ito kasi one time fee lang ito unlike sa DLL? Tingin mo?
You will also have to factor in the costs for the National Telecommunications COMMISSION. ;)
Ang isa pang question dito pano i secure yung data.
Sa tingin ko, maganda ang security ng OpenVPN. You can use its blowfish encryption. Of course, I could be wrong.
Yung sa PPtP ko, nag iptables lang kami. Block lahat ng di namin kilala, only allow yung intended na magconnect. -
Magkano montly nyo sa pldt ?yung sa eastern DLL namin before 10mbps lang ang mahal na.
Secure naman ang iptables,ganyan din gawa namin, blocked lahat ng di kilalang ip.
Nabanggit mo iptables ibig sabihin naka linux ka?
Pano ginawa mong setup dyan?
Router -> linux vpn?
Or after ng modem ni pldt naka linux ka na?
Ang ginawa namin dati don sa vpn: isp modem -cyberoam-vpn server (windows+naka ipsec din)
Don kami nag blocked ng mga port/ip sa cyberoam,bago pumasok sa vpn server.
-- edited by dawinsm on Sep 04 2014, 11:10 PM -
Magkano montly nyo sa pldt ?
I guess I can keep that \"personal\" ^_^
Nabanggit mo iptables ibig sabihin naka linux ka?
Yep. Ubuntu was the flavor that we worked with. The iptables are in the PPtP server.
I am not good in making sketches/diagrams but I will try to post something by tomorrow if not a bit later. (may tinatapos lang muna) -
IMHO, your 100mbps dsl will suffice (sobra-sobra pa nga yan sa tingin ko). I would suggest you at least have 2 ISPs for redundancy then use PEPLink Balance to take care of everything (VPN, Failover, Load Balance etc.). You may also use a Cisco ASA on your setup if you\'re really concerned about security (integrated na yung IPS and VPN). That should take care of everything for you.
I have a similar setup... 2 sites on 20Mbps (bandwidth-on-demand / combined 2 ISPs) hooked to a PEPLink Balance. We\'re doing heavy routines and queries sa SQL servers over the circuit without any issues. :)
-- edited by carl_sysad on Sep 05 2014, 02:48 AM -
IMHO, your 100mbps dsl will suffice (sobra-sobra pa nga yan sa tingin ko). I would suggest you at least have 2 ISPs for redundancy then use PEPLink Balance to take care of everything (VPN, Failover, Load Balance etc.). You may also use a Cisco ASA on your setup if you\'re really concerned about security (integrated na yung IPS and VPN). That should take care of everything for you.
PEPLink is good if money is not a problem. (I dream to have one those). PEPLink\'s load balancing can be easily done using an open-source distro. Even linux nic bonding, although crude, can do it.
PEPLink\'s current seller is their link aggregation. When I took a look into it, it is actually a vpn-like if not a vpn tunnel to one of their servers and they do the bonding there. This can be done using ZeroShell. -
You will also have to factor in the costs for the National Telecommunications COMMISSION. ;)
hindi ako nagbayad nito hehehe.
anyway, gears and mast would cost around 100k per site. 150mbps would be easy. better kesa sa pldt kasi in the long run mas makaaktipid kayo parang nasa 40k/month ang fee ng pldt pag pinataasan mo pa ang upload plus 20k. not really sure kung ganito pa ang pricing nila. -
So far 2 na yung posible setup
1. Vpn via DLL then ubuntu for pptp server
2. At yung microwave ni techsufort
For backup connection
Siguro 20mbps dsl connection nalang per site, using diff isp provider.
-- edited by dawinsm on Sep 05 2014, 01:15 PM -
Afaik, PEPlink runs on Linux. I recommended it because TS doesn\'t appear to have any budget constraint since they can afford 2 x 100mbps circuit. I also use HA proxy on a linux box for my analytics servers somewhat like a 2 tier setup on top of PEPlink for load balancing. To your point, Linux can do just about anything and I agree.
-- edited by carl_sysad on Sep 05 2014, 07:28 PM -
Mukhang di ko gusto itong PEPlink base sa demo vid nila link aggregation/load balancing ang function nya which is pwedeng gawing sa linux or sa router na support ang link aggregation
-- edited by dawinsm on Sep 06 2014, 08:13 AM -
up ko lang yung thread na ito.
May project ako ngayon kaso from Manila (Head Office) to Cebu (Remote site) naman kelangan ng site to site. Ang objective is to monitor yung attendance ng mga employees sa mga construction sites na tatakbo lang ng 6 to 12 months. Kelangan lang i-transfer yung mga extracted payroll reports papunta sa manila head office na parang naka LAN ka lang.
Anong possible na gagamatin dito? Pfsense OpenVPN or Cisco Catalyst routers? Kaya ba ng wireless broadband connection para sa pag-transfer ng files upto 100 mb papunta kay head office? Maraming salamat. -
Anong possible na gagamatin dito? Pfsense OpenVPN or Cisco Catalyst routers? Kaya ba ng wireless broadband connection para sa pag-transfer ng files upto 100 mb papunta kay head office? Maraming salamat.
Get MikroTik for both sites, madali lang i-setup and my built-in DDNS siya.