”生日快乐”,用多种外语表示出来,多谢了各位,越多越好.

发布网友 发布时间：2022-04-23 05:15

我来回答

共11个回答

懂视网 时间：2022-05-06 12:02

今天很高兴得知Go1 release, 其实我一只在等它正式发布,因为我用go语言自己实现了一个MySQL代理,命名为LegendBase Proxy for MySQL(LPM),等Go1 release之后,我也可以尽快release出来了. 代码摘录: case COM_STMT_EXECUTE, COM_QUERY: /* if we get a OK in t

今天很高兴得知Go1 release, 其实我一只在等它正式发布,因为我用go语言自己实现了一个MySQL代理,命名为LegendBase Proxy for MySQL(LPM),等Go1 release之后,我也可以尽快release出来了.

代码摘录:

case COM_STMT_EXECUTE, COM_QUERY:
/* if we get a OK in the first packet there will be no result-set */
switch *qStage {
case PARSE_COM_QUERY_INIT:
switch pkt[4] {
case 0xff, 0×00: // ERR, OK, NULL
/* ERR: e.g. SELECT * FROM dual -> ERROR 1096 (HY000): No tables used */
/* OK: e.g. DELETE FROM tbl */
finished = true
break
case 0xfb: // NULL
*qStage = PARSE_COM_QUERY_LOAD_DATA
finished = true
break
case 0xfe: // EOF
err = errors.New(fmt.Sprintf("COM_(0x%02x), packet should not be (NULL|EOF), got %02x", cmd, pkt[4]))
break
default:
*qStage = PARSE_COM_QUERY_FIELD
break
}
break

case PARSE_COM_QUERY_FIELD:

写这个的初衷是因为除了部分程序开发者自己实现了读写分离或者采用sharding方式之外,还有大量的程序是针对单一的MySQL数据库接口.　然而随着业务量的增加,db压力增大,单台db没法承载,需要扩展MySQL数据库为主从架构,这时候需要代理层来分发读写,因为改造程序的代价往往太大.

新开发的MySQL proxy的配置如下:

[proxy]
port = 3307
sock = /tmp/proxy.sock
fetch_schemas_interval = 10 # seconds

# For management
admin_user = admin
admin_password = 100c4e57374fc998e571d4c0453bd3a4876a58 # sha1
admin_port = 8288

# For connecting to proxy
proxy_user = ivan
proxy_password = 100c4e57374fc998e571d4c0453bd3a4876a58 # sha1

# For proxy to connect backend mysql server
mysql_user = ivan
mysql_password = 100c4e57374fc998e571d4c0453bd3a4876a58 #sha1
mysql_dbname = test # default db

# connections setting
connections_per_weight_max = 32

# master and slaves setting. ip:port:w w: weight of load
master = 127.0.0.1:3306
#slaves = 127.0.0.1:3306:1|192.168.2.200:3306:2|192.168.2.203:3306:1
slaves = 127.0.0.1:3306:1

其中配置的密码是明文密码的sha1, 防止非相关人员获取数据库的密码,安全性能得到一定的保障.
通过其他的配置也可以看出proxy实现的功能,即能够配置多个slave,并且能够指定它们的权重.

Related posts:

1. Golang 实现的 mysql-proxy
2. lbmysqlping (LegendBase MySQL Ping)
3. MySQL vs NoSQL 效率与成本之争
4. 6.0.11 will be the last release of MySQL 6.0
5. 由CSDN泄密想到的:MySQL数据库验证过程的改进、密码存储及验证方法的总结

---

? 谭俊青 发布在 MySQL性能、MySQL Cluster集群、MySQL HA高可用等研究 - MySQL实验室, 2012.
可以任意转载, 但转载时务必以超链接形式标明文章原始出处 和 作者信息。
链接: http://www.mysqlab.net/blog/2012/03/a-new-mysql-proxy-written-in-go-language/

标签: MySQL Proxy

热心网友 时间：2022-05-06 09:10

Afrikaans Veels geluk met jou verjaarsdag!
Albanian Urime ditelindjen!
Alsatian Gueter geburtsdaa!
Amharic Melkam lidet!
Arabic Eid milaad saeed! or Kul sana wa inta/i tayeb/a! (masculine/feminine)
Armenian Taredartzet shnorhavor! or Tsenund shnorhavor!
Assyrian Eida D'molakh Hawee Brikha!
Austrian-Viennese Ois guade winsch i dia zum Gbuadsdog!
Aymara (Bolivia) Suma Urupnaya Cchuru Uromankja!
Azerjani Ad gununuz mubarek! -- for people older than you
Ad gunun mubarek! -- for people younger than you
Basque Zorionak!
Belauan-Micronesian Ungil el cherellem!
Bengali (Bangladesh/India) Shuvo Jonmodin!
Bicol (Philippines) Maogmang Pagkamundag!
Bislama (Vanuatu) Hapi betde! or Yumi selebretem de blong bon blong yu!
Brazil Parab閚s a voc?
Parab閚s a voc?
nesta data querida muitas felicidades e muitos anos de vida.
Breton Deiz-ha-bloaz laouen deoc'h!
Bulgarian Chestit Rojden Den!
Cambodian Som owie nek mein aryouk yrinyu!
Catalan Per molts anys! or Bon aniversari! or Moltes Felicitats!
Chamorro Biba Kumplianos!
Chinese-Cantonese Sun Yat Fai Lok!
Chinese Fuzhou San Ni Kuai Lo!
Chiness-Hakka Sang Ngit Fai Lok!
Chinese-Mandarin qu ni sheng er kuai le
Chinese-Shanghaiese San ruit kua lok!
Chinese-Tiociu Se Jit khuai lak!
Chronia Polla NA ZHSHS
Croatian Sretan Rodendan!
Czech Vsechno nejlepsi k Tvym narozeninam!!
Danish Tillykke med fodselsdagen!
Dutch-Antwerps Ne gelukkege verjoardach!
Dutch-Bilzers Ne geleukkege verjoardoag!
Dutch-Drents Fellisiteert!
Dutch-Flemish Gelukkige verjaardag! or Prettige verjaardag!
Dutch-Frisian Fan herte lokwinske!
Dutch-Limburgs Proficiat! or Perfisia!
Dutch-Spouwers Ne geleukkege verjeurdoag!
Dutch-Twents Gefeliciteard met oen'n verjoardag!
Dutch Hartelijk gefeliciteerd! or Van harte gefeliciteerd met je verjaardag!
English Happy Birthday!
Esperanto Felichan Naskightagon!
Estonian Palju onne sunnipaevaks!
Euskera Zorionak zure urtebetetze egunean!
Faroes ( Faroe island ) Tillukku vid fodingardegnum!
Farsi Tavalodet Mobarak!
Finnish Hyvaa syntymapaivaa!
French (Canada) Bonne Fete!
French Joyeux Anniversaire!
Frisian Lokkiche jierdei!
Gaelic (Irish) L?breithe mhaith agat!
Gaelic (Scottish) Co` latha breith sona dhuibh!
Galician (Spain) Ledicia no teu cumpreanos!
Georgian Gilotcav dabadebis dges!
German-Badisch Allis Guedi zu dim Fescht!
German-Bavarian Ois Guade zu Deim Geburdstog!
German-Berlinisch Allet Jute ooch zum Jeburtstach! or Ick wuensch da allet Jute zum Jeburtstach!
German-Bernese Es Muentschi zum Geburri!
German-Camelottisch Ewllews Gewtew zewm Gewbewrtstewg. Mew!
German-Frankonian Allmecht! Iich wuensch Dir aan guuadn Gebuardsdooch!
German-Lichtenstein Haerzliche Glueckwuensche zum Geburtstag!
German-Moselfraenkisch Haezzlische Glickwunsch zem Gebordsdach!
German-Plattdeutsch Ick wuensch Di allns Gode ton Geburtsdach!
German-Rhoihessisch Ich gratelier Dir aach zum Geburtstag!
German-Ruhr Allet Gute zum Gebuatstach!
German-Saarlaendisch Alles Gudde for dei Gebordsdaach!
German-Saechsisch Herzlischen Gliggwunsch zum Geburdsdaach!
German-Schwaebisch Aelles Guade zom Gebordzdag!
German-Wienerisch Ois Guade zum Geburdsdog!
German Alles Gute zum Geburtstag!
Greek Eytyxismena Genethlia! or Chronia Pola!
Greenlandic Inuuinni pilluarit!
Gronings (Netherlands) Fielsteerd mit joen verjoardag!
Gujarati (India) Janma Divas Mubarak!
Gujrati (Pakistan) Saal Mubarak!
Guarani (Paraguay Indian)] Vy-Apave Nde Arambotyre!
Hawaiian Hau`oli la hanau!
Hebrew Yom Huledet Same'ach!
Hiligaynon (Philippines) Masadya gid nga adlaw sa imo pagkatawo!
Hindi (India) Janam Din ki badhai! or Janam Din ki shubkamnaayein!
Hungarian Boldog szuletesnapot! or Isten eltessen!
Icelandic Til hamingju med afmaelisdaginn!
Indonesian Selamat Ulang Tahun!
Irish-gaelic La-breithe mhaith agat! or Co` latha breith sona dhut! Or Breithla Shona Dhuit!
Italian Buon Compleanno!
Italian (Piedmont) Bun Cumpleani!
Italian (Romagna) At faz tent avguri ad bon cumplean!
Japanese Otanjou-bi Omedetou Gozaimasu!
Javaans-Indonesia Slamet Ulang Taunmoe!
Jerriais Bouon Anniversaithe!
Kannada (India) Huttida Habba Subashayagalu!
Kapangpangan (Philippines) Mayap a Ketan
Kashmiri (India) Voharvod Mubarak Chuy!
Kazakh (Kazakstan) Tughan kuninmen!
Klingon Quchjaj qoSlIj!
Korean Saeng il chuk ha ham ni da!
Kurdish Rojbun a te piroz be!
Kyrgyz Tulgan kunum menen!
Latin Fortuna dies natalis!
Latvian Daudz laimes dzimsanas diena!
Lithuanian Sveikinu su gimtadieniu! or Geriausi linkejimaigimtadienio progal
Luganda Nkwagaliza amazalibwa go amalungi!
Luxembourgeois Vill Gleck fir daei Geburtsdaag!
Macedonian Sreken roden den!
Malayalam (India) Pirannal Aasamsakal! or Janmadinasamsakal!
Malaysian Selamat Hari Jadi!
Maltese Nifrahlek ghal gheluq sninek!
Maori Kia huritau ki a koe!
Marathi (India) Wadhdiwasachya Shubhechha!
Mauritian Kreol mo swet u en bonlaniverser!
Mbula (Umboi Island, Papua New Guinea) Leleng am pa mbeng ku taipet i!
Mongolian Torson odriin mend hurgee!
Navajo bil hoozho bi'dizhchi-neeji' 'aneilkaah!
Niederdeutsch (North Germany) Ick gratuleer di scheun!
Nepali Janma dhin ko Subha kamana!
Norwegian Gratulerer med dagen!
Oriya (India) Janmadina Abhinandan!
Papiamento (lower Dutch Antilles) Masha Pabien I hopi aña mas!
Pashto (Afganistan) Padayish rawaz day unbaraksha!
Persian Tavalodet Mobarak!
Pinoy (Philippines) Maligayang kaarawan sa iyo!
Polish Wszystkiego Najlepszego! or Wszystkiego najlepszego zokazji urodzin!
wszystkiego najlepszego z okazji urodzin
Portuguese (Brazil) Parabens pelo seu aniversario! or Parabenspara voce! or Parabens e muitas felicidades!
Portuguese Feliz Aniversario! or Parabens!
Punjabi (India) Janam din diyan wadhayian!
Rajasthani (India) Janam ghaanth ri badhai, khoob jeeyo!
Romanian La Multi Ani!
Rosarino Basico (Argentina) Feneligiz Cunumplegeanagonos!
Russian S dniom razhdjenia! or Pazdravliayu s dniom razhdjenia!
Sami/Lappish Lihkos Riegadanbeaivvis!
Samoan Manuia lou aso fanau!
Sanskrit (India) Ravihi janmadinam aacharati!
Sardinian (Italy) Achent'annos! Achent'annos!
Schwyzeretsch (Swiss German) Vill Glück zum Geburri!
Serbian Srecan Rodjendan!
Slovak Vsetko najlepsie k narodeninam!
Slovene Vse najboljse za rojstni dan!
Sotho Masego motsatsing la psalo!
Spanish Feliz Cumplea駉s!
Sri Lankan Suba Upan dinayak vewa!
Sundanese Wilujeng Tepang Taun!
Surinamese Mi fresteri ju!
Swahili Hongera! or Heri ya Siku kuu!
Swedish Grattis p?f鰀elsedagen
Syriac Tahnyotho or brigo!
Tagalog (Philippines) Maligayang Bati Sa Iyong Kaarawan!
Taiwanese San leaz quiet lo!
Tamil (India) Piranda naal vaazhthukkal!
Telugu (India) Janmadina subha kankshalu!
Telugu Puttina Roju Shubakanksalu!
Thai Suk San Wan Keut!
Tibetan Droonkher Tashi Delek!
Tulu(Karnataka - India) Putudina dina saukhya!
Turkish Dogum gunun kutlu olsun!
Ukrainian Mnohiya lita! or Z dnem narodjennia!
Ur (India) Janam Din Mubarak
Ur (Pakistan) Saalgirah Mubarak!
Vietnamese Chuc Mung Sinh Nhat!
Visayan (Philippines) Malipayong adlaw nga natawhan!
Welsh Penblwydd Hapus i Chi!
Xhosa (South Afican) Imini emandi kuwe!
Yiddish A Freilekhn Gebortstog!
Yoruba (Nigeria) Eku Ojobi!
Zulu (South Afican) Ilanga elimndandi kuwe!

参考资料：150 kinds of happy birthday

热心网友 时间：2022-05-06 10:28

英语Happy birthday
德语Alles Gute zum Geburtstag
西班牙语feliz cumplea?os
法语joyeux anniversaire
意大利语buon compleanno
葡萄牙语feliz aniversario
日语生日おめでとう
韩语생일 축하합니다!

热心网友 时间：2022-05-06 12:02

英：Happy birthday to you!
汉：生日快乐!
台：生日快乐!
荷：Gelukkige verjaardag aan u!
法：Joyeux anniversaire!
德：Alles Gute zum Geburtstag!
希：Ευτυχή γενέθλια σε σας!
意：Buon compleanno!
日：诞生日おめでとう!
韩：너Ǵ게 축 생일!
挪：
葡：Feliz aniversario!
俄：С днем рождения к вам!
西：¡Feliz cumpleaños!

热心网友 时间：2022-05-06 13:54

生日快乐
日语: お诞生日おめでとう，ございます!
o tan jyo bi o mei dei o go za i ma si

我爱你
法 语：je t'aime,je t'adore
呀六不六几不压啊（不准）

意 大 利语：ti amo,ti vogliobene
ti amo就可以，发音就是ti a mo

日语：一般说“爱してる”就可以
发音是:a i xi te lu
如果三个字都翻过来就是：私はあなたに爱してる
发音是：wa ta xi wa a na ta ni ai i xi tei lu

热心网友 时间：2022-05-06 16:02

第一个回答的不错，我可以保证他说的蒙语答案是对的。
Mongolian： Torson odriin mend hurgee!
这是用拉丁语写的。
要是用蒙文写，是竖着写，这里没有办法写。
还有一种是用新蒙文写：
торсон одрйн менд хургее

热心网友 时间：2022-05-06 18:26

생일 축하합니다!
happy birthday !!!!!!!!!!

热心网友 时间：2022-05-06 21:08

~Happy birthday. (English)
生日快乐!

热心网友 时间：2022-05-07 00:06

생일 축하합니다!

热心网友 时间：2022-05-07 03:20

非常佩服楼上朋友的回答.

热心网友 时间：2022-05-07 06:52

厉害