MySQL Proxy
https://launchpad.net/mysql-proxy
http://forge.mysql.com/wiki/MySQL_Proxy
MySQL에 fail-over와 load balancing(round-robin)을 하기 위한 가장 쉬운 도구.
2010.03.29
2009.11.26
2008.12.15
2007.12.13
2007.03.02
어차피 영문만 들어갈 필드들... 결국 필드 character set을 latin1으로 바꿨다.CREATE TABLE identities (id INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,
account VARCHAR(255) character set latin1 NOT NULL, url TEXT character set latin1 NOT NULL,
UNIQUE (account, url(255)));CREATE TABLE sites (account VARCHAR(255) character set latin1 NOT NULL,
trust_root character set latin1 TEXT, trusted BOOLEAN,
UNIQUE (account, trust_root(255)));
If you get an error message during install beginning something like this:
# SQL=Specified key was too long; max key length is 1000 bytes:
This is probably because of your MySQL servers default character set is UTF-8 and using this encoding, every character is 16bits while others are 8bits. So, every column will have a doubled length.
You can change default character set for your tables. Open installation/sql/mambo.sql file in your favorite editor and change the string
# TYPE=MyISAM;
with exactly this:
# TYPE=MyISAM, DEFAULT CHARACTER SET latin1;
[for latin1, you may use something else]
Save the file, start mambo install again.
(Source: Mambo Forums)