[Level 3] Schema management tips for MySQL

{Database management tips}

[in source save]
4 files in source save.
1. schema:
=> by release version.
=> only create table/procedure, no alter, no insert, no drop ...etc.
=> use mysqldump -d.
2. schema change log:
=> by date.
=> split into two parts. one is schema(except foreign key), and put it on the top. Another is foreign key, and put it on the tail.
=> must add drop tabele before create, and must be sequencial by date.
=> modify manually.
3. data:
=> by release version.
=> only insert, no update, no delete...etc.
=> use mysqldump.
4. data change log:
=> by date.
=> could use insert/update/delete, but delete(truncate) must before update than insert, and must be sequencial by date.
=> modify manually.

[use case]
how to create patch:
a: use schema comparision.
=> takes time, but more efficacy.
b: use changelog comparision.
=> esay way, but suffer performance.
so, use a to build patch, but use b to verify result.
but how to verify?
use a, dump a schema and data,
use b, dump b schema and data,
compare two results.

[useful skill]
mysql> set foreign_key_checks=0;
mysql> set unique_checks=0;

Wish this helps.
regards,
Stanley Huang

Comments

Post a Comment

Popular posts from this blog

[Level 1] Rar tool for Solaris.

Sometimes we will got a rar compressed file from our friends, but there is no default tool in OpenSolaris to decompress the rar filess. We can got a Solaris Intel version from rarlab . The steps as the following: 1. down load the rar tools from rarlab. http://www.rarlab.com/rar_add.htm 2. uncompressed the source. # gunzip ./unrar-sol-intel.gz 3. move it to the location you used to. # mv /unrar-sol-intel.gz /usr/bin/unrar 4. try to decomprss # unrar x ./test.rar Wish this helps. regards, Stanley Huang
Read more

[Level 2] iif in Python

If you want to implement iif in Python, please refer to the following sample code: #!/bin/env python def iif(b): return 'It\'s True' if b else 'It\'s False' print iif(True) print iif(False) And the following sample, guess what will you get! #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % 'Ture' if b else 'False' Result: $ ./iif.py b: Ture False The second result is "False", not "b: False". Why??? Because the prededence of string concatenation is higher than if. Therefore you need to use () to make it correct. #!/bin/env python b = True print 'b: %s' % 'Ture' if b else 'False' b = False print 'b: %s' % ('Ture' if b else 'False') Wish this helps. regards, Stanley Huang
Read more