How to use database with CDN to improve peformance

Question

I have question something similar to this question, I am using jwplayer for playing my videos. I have saved my videos in CDN. Due to some requirements, I have to save my subtitle first in cdn and then save both video file url and associated subtitle urls [eng, chinese, japanese etc] in DB.

When I make a Ajax call to retrieve the data in my JS file from PHP file. It is taking more time and it is causing performance issue.

I was wondering if there is any DB option in CDN, so that instead of saving those detail in my db I can directly save this info (associated subtitles of one video file) in CDN. since retrieving from CDN is much faster it will surely improve the performance.

The answer to this will depend on what CDN you are using. Which one is it? — , Apr 02 '14 at 05:18
I am not sure i understand the question but i am using cloudfront cdn — Hitesh, Apr 02 '14 at 06:26
@duskwuff : does it answer your question or you are asking something else? — Hitesh, Apr 02 '14 at 11:16
Not if you can do this with CF. Looking on google for using cf with a database does not help much. — emaxsaun, Apr 02 '14 at 15:12
@EthanJWPlayer : So it means we dont have any thing in `CDN CF` which support this ? — Hitesh, Apr 02 '14 at 15:49
yea I too tried searching in google for this but could not find anything .so I posted in stackoverflow. — Hitesh, Apr 03 '14 at 09:02

score 3 · Answer 1 · answered Jun 05 '14 at 23:40

CDNs just bring static information closer to the users, caching that information in points-of-presence (PoPs) around the globe. It is mostly done by web-servers sitting within those PoPs. So whatever you can't retrieve by HTTP GET will likely be a problem. For example, legacy protocol RTMP (also video) is supported by legacy CDNs (Level3/Akamai/EdgeCast), but not by newly formed Cloudflare/Cloudfront and so on, because it requires adds-on to web-server and clutters workflows.

Technically, any static database can be stored in a file, and the file can be cached by a CDN. But then, again, it would be your code that takes care of db->file->db metamorphosis. Therefore, if something is static, you don't really want to use database for it (to be future/CDN-proof). Subtitles are just text files, so let them be files in asset folders. I appreciate that high level architecture might be beyond your control here (due to specific ingesting system for instance), but then the answer is that you won't be able to do what you try, and resulting performance will suffer.

score 0 · Answer 2 · answered Jul 16 '14 at 18:32

0

If you have the bucks you can look at Continuent.

http://www.continuent.com/solutions/pricing-and-services

answered Jul 16 '14 at 18:32

no1uknow

549
1
7
18

How to use database with CDN to improve peformance

2 Answers2