MySQL DBA - ASX listed company - SYD CBD -Very attractive rate

Fernando

I’m currently looking for an experienced MySQL DBA. I don’t have much luck in that particular area, and seeks your expertise and guidance.

The role is with a innovative ASX listed company based in Sydney CBD. 6 month Contract to Permanent opportunities. Very attractive rate of pay,


If you have a friend who has such experience, or who is looking for work within MySQL space, please spread the word, forward this mail and get them to contact me?



Yours Faithfully



Matt Cheng

Consultant – I.T. Contract

Robert Walters
Tel: + 61 2 8289 3100
Dir: + 61 2 8289 3171

Fax: + 61 2 8289 3200
E-mail: Matt.Cheng@robertwalters.com.au
www: www.robertwalters.com.au

maggie066

job hunter? cool....

luoyi727

你不去，南多？

Fernando

The agent sent me this email.

I don't have much experience on MySQL, although it's in my learning plan.

hoopoos

mysql基本上可以算是desktop级别的database，通常采用mysql的系统，规模和复杂程度都很有限，因此不大会用到比较高级的feature。一般来说，有一定经验的developer, qa都能胜任mysql建表、维护之类的日常工作。

goooddong

我也收到这封邮件了

Fernando

原帖由 hoopoos 于 6-5-2008 13:02 发表

                               
登录/注册后可看大图

mysql基本上可以算是desktop级别的database，通常采用mysql的系统，规模和复杂程度都很有限，因此不大会用到比较高级的feature。一般来说，有一定经验的developer, qa都能胜任mysql建表、维护之类的日常工作。

It only depends on how you use it.
Most of the web 2.0 websites use MySQL.
YouTube, Facebook, Wiki, Yahoo.... Those ones are pretty huge.

akai

use simple tools to build a complicate task / architecture. that's the principle or spirint.
简单的mysql 应用 的确不需要专门的DBA. SA可以胜任. 好比我们以前 mysql基本都归SA管.   dba focus在oracle上. 后来 mysql的架构复杂了. 用到了 cluster  . 就不得不用专门的人了. 看来楼主的这个公司 应该挺大的. 能专门雇人管mysql了.

Fernando

Notes from Scaling MySQL - Up or OutHere is the quick notes from the session Scaling MySQL - Up or Out ? moderated by Kaj Arno as part of the todays keynote.
Here is the list of panelists are ordered by Alexa ranking.

• Monty Taylor (MySQL)
• Matt Ingerenthron (Sun)
• John Allspaw (Flickr)
• Farhan Mashraqi (Fotolog)
• Domas Mituzas (Wkipedia)
• Jeff Rotheschild (Facebook)
• Paul Tuckfield (YouTube)

Here is the list of questions and answers from panelists:

Â	How many servers	Number of DBAs	How many web servers	Number of caching servers	Version of MySQL	Language, platform	Operating System
MySQL	1 M, 3 S	1/10	2	2	5.1.23	Perl,php and bash	Linux fedora
Sun	2 clustered, 2 individual	1.5	160+	8	5.0.21	Lots of stuff (java mostly)	Open Solaris
Flickr	166	At present 0	244	14	5.0.51	Php and some Java	Linux
Fotolog	140 databases on 37 instances	10 instances a DBA	70	40 ( 2 on each, 80 total)	4.11 and 4.4	Php, 90% Java	Solaris 10
Wikipedia	20	None, but everybody is kind of a  DBA	70+200	40 ( 2 on each, 80 total)	Â	Php, c++, python	Fedora / Ubuntu
Facebook	30000 databases, 1800 db servers	2	1200	805	5.0.44 with relay log corruption patch	Php, python, c++ and erlang	Fedora / RHEL
Youtube	I can not say	3	I can not say	I can not say	5.0.24	Python	SuSE 9

Few more misc questions …
Number of times re-architected ?

• My: 2 times - 1 time slave, 1 time memcached
• SN: site depend (many times over the year)
• FR: 2.5 (various clusters federated)
• FL: many cached replacements (about to do one change now)
• WK: Never (Spaghetti)
• FB: Every Tuesday, continual
• YT: Pretty continual, 2-3 times (replication, sharding, federation)

What happens if server fails ? what actions you will generally take ..

• FR: All of our servers are federated, pairs of servers, we can loose any one side of shard, we can loose boxes.. traffic goes to either side of shard, now it goes to one, and we will get another one (very transparent to user)
• WK: Users shout at them on IRC then they moderate … fixed in seconds
• FB: one of 1800-1900 will always fail, just operate well, minor impact, with data going away for a while…we restore from binlog and start the server quickly, promote slave to master and number of ways
• FL: we simply mount the snapshots to different servers and get
• YT: SAN etc, very important data.. recover the server, mirrored disk …mirrored hard drive is crucial

Any recommendation of scaling technology that you wanted to bring

• FL: UltraSPARC-T1 (excellent master, multi threaded) and UltraSPARC-T2 for slave (single threaded)
• WK: good network switch
• FB: cheap switch causes problems and learned lessons, we do not use SAN, neatly partitioned, they scale independently and fail independently
• MY: cluster very sad

Server virtualization ?

• nobody uses at this time
• FB: ETL cluster, we may run more than one in the future

Anything to worry at present ?

• FB: app design is the key to use resources, data center power supply and consumption
• FL: Google has to approve for our lab power (cut app servers by 1/2 by moving from php to java)
• YT: not at all

Any reco, lessons to DBA

• better you know what the systems are, then you can
• performance, scaling taking it serious
• nothing more permanent than temp solutions (if you don’t know when you will fail, then you will )
• architect properly in start, schema, cost of serving data

hoopoos

原帖由 Fernando 于 6-5-2008 15:09 发表

                               
登录/注册后可看大图

It only depends on how you use it.
Most of the web 2.0 websites use MySQL.
YouTube, Facebook, Wiki, Yahoo.... Those ones are pretty huge.

could u please provide some link for validation your quote? thanks a lot.

Fernando

9楼里面有些连接的

hoopoos

i'm sorry but these material from a unknown person's blog is totallly not reliable.

Fernando

why not checking more from his blog and find out who this guy is?


and why do you think this guy is not reliable?
do you think he made all these fake information just to sell MySQL?

Fernando

this is not a chinese gov website.
you don't need to assume everything is fake

akai

FB only have 2 DBA to handle 1800 database servers?
incredible.

hoopoos

i'm not saying fake, i'm saying accurancy.  These information is not adequate to support any statement. Besides, there is no link in his blog except some official website like www.sun.com. www.youtube.com, etc

it's too early to make a judgement whether mysql is so popular in these big enterprise. but obviously oracle is more popular in large scale database system.

Fernando

要做好两手准备啊，光会Oracle是不行的，找工作光会一种数据库也是比较吃亏的；现在MySql的大数据库很多了。
既然你不相信这篇文章的数据，那可以去其他地方找找MySql的使用情况。

dlcat

mysql被sun收购了,马上就复杂多了,应该应用上也强很多.