RE: Mysql BestPractices

RE: Mysql BestPractices

am 16.08.2010 07:58:14 von kranthi

------=_NextPart_000_0008_01CB3D36.1E7A4910
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi all,

Please send sample mysql best practice document.



Thanks & Regards,

Kranthi kiran




------=_NextPart_000_0008_01CB3D36.1E7A4910--

Re: Mysql BestPractices

am 16.08.2010 14:32:47 von Johan De Meersman

--000e0cd25af0ae138f048df00700
Content-Type: text/plain; charset=ISO-8859-1

1. Make sure it works
2. Make sure it's secure
3. Make sure you have backups


On Mon, Aug 16, 2010 at 7:58 AM, Kranthi wrote:

> Hi all,
>
> Please send sample mysql best practice document.
>
>
>
> Thanks & Regards,
>
> Kranthi kiran
>
>
>
>


--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--000e0cd25af0ae138f048df00700--

Re: Mysql BestPractices

am 16.08.2010 15:53:11 von John Daisley

--00163630f35f369e6e048df12798
Content-Type: text/plain; charset=ISO-8859-1

>> 1. Make sure it works

Change this to
1. Make sure it works efficiently and is correctly configured!

Meaning - Just because it works now doesn't mean its going to work when you
put the system live and 2000 users hit the system ;) Don't just accept the
defaults in the sample my.cnf/my.ini files, they are rarely suitable for any
system without modification. If you don't know what you are doing read the
manual, ask questions, test, test and test again. (or hire a
MySQL professional)!

Regards
John

On 16 August 2010 13:32, Johan De Meersman wrote:

> 1. Make sure it works
> 2. Make sure it's secure
> 3. Make sure you have backups
>
>
> On Mon, Aug 16, 2010 at 7:58 AM, Kranthi > >wrote:
>
> > Hi all,
> >
> > Please send sample mysql best practice document.
> >
> >
> >
> > Thanks & Regards,
> >
> > Kranthi kiran
> >
> >
> >
> >
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>



--
John Daisley

Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer

Telephone: +44 (0)7918 621621
Email: john.daisley@butterflysystems.co.uk

--00163630f35f369e6e048df12798--