Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?

2014-10-29 Thread Zbigniew
I'm going to establish a large database (ISAM) of simple structure, say the table with only 3 columns: - VARCHAR(80) - VARCHAR(40) - DATE The number of rows can be quite large, about hundred million or so. The first column, containing actual information, will contain unique values, unlike the two

Re: Which replication solution should I choose?

2014-10-29 Thread Heck, Walter
Hi Rafal, On Wed, Oct 29, 2014 at 3:16 PM, Rafał Radecki wrote: > Thanks for the info, Walter. > I checked some basic info about Galera and it looks very promising. Can > you tell what is preferable for loadbalancing of requests? HAProxy/Galera > loadbalancer or maybe something else? > We use haP

Re: Which replication solution should I choose?

2014-10-29 Thread Rafał Radecki
Thanks for the info, Walter. I checked some basic info about Galera and it looks very promising. Can you tell what is preferable for loadbalancing of requests? HAProxy/Galera loadbalancer or maybe something else? Can you tell me also how much does MHA differ from MMM? Functionality looks quite sim

Re: Which replication solution should I choose?

2014-10-29 Thread Heck, Walter
Hi Rafael, On Wed, Oct 29, 2014 at 10:15 AM, Rafał Radecki wrote: > I am creating an environment based on about 15 hardware nodes. 6 of them > will be for mysql databases. They will be divided into three pairs (3x2 > nodes). Nodes in every pair will be configured with replication. > > I done simi

Which replication solution should I choose?

2014-10-29 Thread Rafał Radecki
Hi All :) I am creating an environment based on about 15 hardware nodes. 6 of them will be for mysql databases. They will be divided into three pairs (3x2 nodes). Nodes in every pair will be configured with replication. I done similar configuration about an year ago. I used than: - percona 5.5 wi