I need some mysql implementation suggestion [40 million+ record license server]

27/10/2007, 17h03

I need to implement an application license server for my company. Each
application will periodically update the license server with its
status via an appache server. The license server will eventually scale
up to 40million-100million records.

Here is my thought: Rather than storing everything on one mysql
server, I will spread the 40-100million records over N high end mysql
servers. I will also assign a unique UUID to each application. When
the application contacts the appache server, the appache server will
hash the UUID to a particular mysql server.

Does this sound like a scalable approach ?

Sergei

27/10/2007, 20h03

On Oct 27, 11:03 am, lavrov2...@gmail.com wrote:
> I need to implement an application license server for my company. Each
> application will periodically update the license server with its
> status via an appache server. The license server will eventually scale
> up to 40million-100million records.
>
> Here is my thought: Rather than storing everything on one mysql
> server, I will spread the 40-100million records over N high end mysql
> servers. I will also assign a unique UUID to each application. When
> the application contacts the appache server, the appache server will
> hash the UUID to a particular mysql server.
>
> Does this sound like a scalable approach ?
>
> Sergei

Why not put them all on a single server? Are you experiencing
specific performance issues or are you prematurely optimizing?

27/10/2007, 17h03	#1
lavrov2005@gmail.com Messages: n/a Hébergeur:	I need some mysql implementation suggestion [40 million+ record license server] I need to implement an application license server for my company. Each application will periodically update the license server with its status via an appache server. The license server will eventually scale up to 40million-100million records. Here is my thought: Rather than storing everything on one mysql server, I will spread the 40-100million records over N high end mysql servers. I will also assign a unique UUID to each application. When the application contacts the appache server, the appache server will hash the UUID to a particular mysql server. Does this sound like a scalable approach ? Sergei

27/10/2007, 20h03	#2
ZeldorBlat Messages: n/a Hébergeur:	Re: I need some mysql implementation suggestion [40 million+ record license server] On Oct 27, 11:03 am, lavrov2...@gmail.com wrote: > I need to implement an application license server for my company. Each > application will periodically update the license server with its > status via an appache server. The license server will eventually scale > up to 40million-100million records. > > Here is my thought: Rather than storing everything on one mysql > server, I will spread the 40-100million records over N high end mysql > servers. I will also assign a unique UUID to each application. When > the application contacts the appache server, the appache server will > hash the UUID to a particular mysql server. > > Does this sound like a scalable approach ? > > Sergei Why not put them all on a single server? Are you experiencing specific performance issues or are you prematurely optimizing?

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email