PlanetMysql.ru — информация о СУБД MySQL

For those who missed my presentations at Oracle OpenWorld (or if you caught it but want the slides) - PDF slide decks are online:

 

Securing MySQL (IOUG)  - http://technocation.org/files/doc/MySQLSecurity2011_09.pdf

How to Be a Rockstar MySQL DBA - http://technocation.org/files/doc/2011_09_RockStar.pdf

PlanetMySQL Voting: Vote UP / Vote DOWN

A short while ago I posted about the Oracle OpenWorld Schedule Matrix of MySQL sessions (in PDF and HTML formats).  We have printed up a (small) number of schedules to have on hand at the MySQL Community kiosk at the User Group Pavillion in Moscone West.

Yes, you read that correctly -- the User Group Pavillion will include a MySQL Community kiosk this year!  Sarah and I have been coordinating the effort to staff the kiosk and figure out what we need to provide.

Sadly, it's just a kiosk (same as all the other User Group organizations get), so we cannot have a ton of flyers there.  To that end, we have created a QR code that resolves to www.kimtag.com/MySQL, which is where we are putting many links.  

To that end, we'd like your help figuring out what we have missed.  In order to keep the list of links as short and relevant as possible we have put as many aggregate links as we could, for example we link to planet.mysql.com instead of individual blogs, and we are only listing the major conferences with over 500 attendees expected.  The links at www.kimtag.com/MySQL as of the time of this blog writing are:

- MySQL sessions at OOW

- Planet MySQL

- dev.mysql.com (docs, etc)

- mysql.com

- MySQL User Groups (forge.mysql.com list) - so if you have a user group, make sure to update the forge page!

- Percona Live 2012 Conference & Expo

- MySQL videos on YouTube

- IOUG MySQL Council

- OurSQL Podcast Blog

- OurSQL iTunes link

- MySQL Experts podcast

- Book: MySQL Administrator's bible*

- Book: High Performance MySQL

- Book: Expert PHP/MySQL

- Book: MySQL High Availability

 

If you think of a link we should put on there, please comment below.

 

For what it's worth, the paper we will have will be:

- The current day's schedule

- A flyer about Percona Live 2012 MySQL Conference & Expo

- A poster of the QR code and a few small paper slips with the QR code

- IOUG MySQL Council business cards

PlanetMySQL Voting: Vote UP / Vote DOWN

There are 28 videos, all linked below, on the OSCon and OSCon data 2011 playlist that I have put online for free (with permission from the presenters and O'Reilly).  O'Reilly videos are available from the conference proceedings website.  Probably the best way to find all the videos in one place is to search for the 'oscon' tag on YouTube.

PlanetMySQL Voting: Vote UP / Vote DOWN

The final videos from Open DB Camp back in May in Sardinia, Italy are now online.  The full matrix of sessions, videos and slides can be found on the schedule page.

Hands on JDBC by Sandro Pinna - video

"MySQL Plugins, What are They? How you can use them to do wonders" by Sergei Golubchek of MariaDB - video

The State of Open Source Databases by Kaj Arnö of SkySQL - video

Coming soon, videos from OSCon Data!

PlanetMySQL Voting: Vote UP / Vote DOWN

Next week I will give a free IOUG webinar on Securing MySQL on Wednesday, August 10, 2011 from 11:00 AM - 12:00 PM CDT (17:00 GMT):

To register for this webinar, visit https://www1.gotomeeting.com/register/979260992.  

PlanetMySQL Voting: Vote UP / Vote DOWN

I have gotten to uploading more of the videos from Open DB camp in Sardinia, Italy back in May:

Henrik Ingo speaks about Xtrabackup Manager - video

Linas Virbalas speaks about "Flexible Replication: MySQL -> PostgreSQL, PostgreSQL to MySQL, PostgreSQL to PostgreSQL" - video - slideshare slides

MySQL to MongoDB replication (hackfest results) - video 

Robert Hodges of Continuent speaks about Multi-Master Replication: Problems, Solutions and Arguments - video

There are a few more videos from Open DB Camp to put up, then I start to put up the content from OSCon Data!

PlanetMySQL Voting: Vote UP / Vote DOWN

And another video from OpenDBCamp is online....Today it is from Henrik Ingo - "Buildbot & EC2: how to qa and package your db product".

I cannot seem to find the slides Henrik used, but the video is now online at http://www.youtube.com/watch?v=07tsdSvR5C0.

By the way, there are plans to video *all* of the sessions at OSCon Data next week (MySQL and otherwise), which is what made me look in my "video to do" folder earlier this week and realize that I had not yet put up all the OpenDBCamp videos yet!

PlanetMySQL Voting: Vote UP / Vote DOWN

I realized yesterday that I never did finish putting up the videos from this year's Open Database Camp back in May, so I'm working on finishing that in the next few weeks.

Today I put up High Performance Search with BlackRay Data Engine - Felix Schupp.  The slides are on the web at http://www.slideshare.net/fschupp/blackray-the-open-source-data-engine-2011683, and the video is on YouTube at http://www.youtube.com/watch?v=oCB3ZXfc8Rs YouTube video

PlanetMySQL Voting: Vote UP / Vote DOWN

If you're in the Los Angeles area on Feb 15, come hear my talk at LAMySQL inspired by learnings from real-life experiences. In addition to hearing a very unique and interesting talk, you can win an AppleTV thanks to awesome folks at @NoodleYard.

Real-Life Use Cases From Data Administration Hell

Data is the most valuable asset of an organization because it's irreplaceable.

Yet, we hear about f**k ups related to data administration every day by startups and organizations of all sizes. Sometimes it's no one's fault. Sometimes it's the fault of a drunk friend who shouldn't have been [wherever he was] at the first place.

Yet, at other times, the disaster could have been prevented. Sometimes, these f**k ups are caused by bad design. Sometimes, it's a bad query that made it into the production branch. Sometimes, it's a human error that ruins the day.

Ever had a bad query slip through QA? Or a configuration option that you thought would help the situation? Sometimes, the resulting disaster could have been prevented if those operating had simply followed the rules. Sometimes it's the lack of presence of rules that leads to a disaster. Sometimes, the "acts of prevention" worsen the impact of the disaster. Sometimes it's over confidence of those administering data.

Imagine deletion of a wrong record or from a wrong server. Or not treating the only SAN as a SPOF. Sometimes, the f**k up has been happening for years, yet no one realized or fixed it.

Sometimes, the f**k up is created intentionally. By focusing on things other than operational and capacity requirements. Sometimes, a small error threatens the very existence of a company.

At least once of a $100M company.

These f**k ups happen everywhere. At organizations of all sizes.

In this talk, Frank Mashraqi will explore real-life inspired, breath-taking (anonymized) use cases that created data administration hell for an organization. He will also explore how, if at all, these f**k ups could have been avoided.

This session presents an opportunity to learn from the real-life costly data administration mistakes of others and what strategies can help you with not getting caught off guard.

Bio

With more than a decade of scalability, disaster recovery and engineering management experience under his belt, Frank specializes in building and scaling NoSQL and SQL based platforms for graph processing and big data deployments using low concurrencies.

He is an expert in audience acquisition through organic search engine optimization and audience monetization through cutting edge technologies as re-targeting, social targeting and influencer targeting.

His past experience includes co-founding a graph processing company that applies advanced sociological theories to online advertising, scaling Fotolog to help it become the 13th most visited site on the Internet, and advising companies like Betaworks, Bitly, TwitterFeed, Chartbeat and ShermansTravel.

He holds a BBA in Accounting and a BS in Computer Information Systems.

---

PS: Many thanks to JoeDevon for inviting me to speak

PS: I'll be driving from the Bay Area so if anyone is interested in riding with me from SF to LA and back, let me know :)
PlanetMySQL Voting: Vote UP / Vote DOWN

At the November 2010 Boston User Group, Jacob Nikom presented his solution for database change management using MySQL. This system is designed to keep a repository of tables and data that an application needs to function. For example, an application might need at least one administrative user, or a table with a list of countries.  This is NOT a tool for database configuration management.

The slides are available at http://technocation.org/files/doc/CatalogVersionTool_MySQL_User_Group_02.ppt

 

Watch the video on YouTube at http://www.youtube.com/watch?v=RmGtsKXdVko

 

 

PlanetMySQL Voting: Vote UP / Vote DOWN