mihok

There always seems to be talk about some SSL cert service (VeriSign) that has been hacked or gone under. I'm trying to buy my first SSL certificate and there are so many options out there that its hard to know which one, what are the risks? Is any certificate authority okay? Will self signed certs be good enough?

Clearly the issue is the man-in-the-middle attack, which I have a high level understanding of, and makes every CA susceptible to the same attack if they are compromised.. but are there good CA's that people have had experience with? Is it less safe to get a wildcard cert than individual certs for each domain?

Thanks HN

Myself and a few buddies have been working on a project that seems to have started taking off. Currently I'm in charge of building our dashboard analytic platform for our client base, and suffice to say the amount of data is beyond what I've been used to dealing with. We're upwards of 31+ million rows as of yesterday and it seems to be rising at a insane pace (almost even exponentially) while our client base increases. We're using a Apache/PHP/MySQL system, no frameworks on the server side but Backbone on the front end. It looks like currently we'll hit 50 million rows in a week, but that pace will increase as we add more clients.

My question for everyone here is what (if any) experiences, insights, or resources did you find really helpful when you started having to deal with querying 1+, 10+, 100+ million rows? Any advice? I'm currently scouring the net for any sort of past experiences or alternative solutions to issues we're facing now and problems we may encounter in the future.