A great place to be!
Chris's Blog (30)
Ning Tech Talk on MySqL - Date Correction
Apologies for the scheduling conflict but the date has moved to the 20th of July.
Save the date: July 20, 2011
RSVP here: Ning-Tech-Talks
There have been many database infrastructure changes through Ning’s history since the company began in 2004. Our most recent, and hopefully final, database iteration is running on MySQL. Over…
Added by Chris on June 28, 2011 at 11:36am — No Comments
How We Implemented & Currently Maintain MySQL on the Ning Platform
MySQL Ning Meetup Coming Soon
Save the date: July 20, 2011
RSVP here: Ning-Tech-Talks
There have been many database infrastructure changes through Ning’s history since the company began in 2004. Our most recent, and hopefully final, database iteration is running on MySQL. Over the past year we’ve designed and implemented a stable and highly…
ContinueAdded by Chris on June 20, 2011 at 10:00am — No Comments
Comparing MySQL Statement-Based and Row-Based Replication
There are many ways you can replicate MySQL data, whether it be a simple two-node cluster, chain or master/master. This article explains the two types of data replication (Statement-Based Replication and Row-Based Replication) available in MySQL.…
Added by Chris on February 9, 2011 at 3:15pm — 2 Comments
MySQL Workbench - Top 13 things you should know
MySQL Workbench has come a long way and keeps getting better! I honestly don't think that millage may vary on this one as it is one of the best no-cost GUI tools created for MySQL.
I've always been pro command line for MySQL administration; however, there have always been powerful GUI tools that can aid administration,…
Added by Chris on January 5, 2011 at 1:30pm — No Comments
Call for Participation - OSCON 2011
Added by Chris on December 27, 2010 at 8:00am — No Comments
KSCOPE11 - ODTUG Conference June 2011
Hey everyone,
I always attend the O'REILLY MySQL Conference in April every year, but this year found another interesting conference that brings both Oracle and MySQL users together, KSCOPE11. This will be the second year with a dedicated MySQL track at Kscope11. There will be a clear focus on providing both developers and DBAs the right information,…
ContinueAdded by Chris on December 20, 2010 at 8:30am — No Comments
Simple Automation - Examining your MySQL Index Usage
I have a new article posted on the Database Journal...
- Abstract -
In the majority of MySQL systems, the schema is always updated and changed based on the needs and focus of the application, making it somewhat difficult to keep up with all of the changes that come down the pipe.…
Added by Chris on December 14, 2010 at 11:19am — No Comments
Ning is looking for Talented People
I wanted to let you know that my employer Ning is Hiring! Ning is the largest platform in the world for creating your own custom social network. It's an exciting time to be a part of Ning since we recently decided to focus 100% of the energy of the company on our… Continue
Added by Chris on October 27, 2010 at 2:01pm — No Comments
Call for participation - MySQL Conference 2011
Gear up for the 2011 MySQL Conference!
Get your presentations submitted soon, Call closes 11:59pm 10/25/2010 PDT. …
Added by Chris on October 11, 2010 at 8:00am — No Comments
MySQL Enterprise Dashboard - It's Cool!
I've been using MySQL Enterprise Monitor for some time now and have seen it grow from a somewhat clunky (ALPHA version) to a scalable and robust monitoring system. The MySQL Enterprise Monitor makes my job easier in a… Continue
Added by Chris on October 7, 2010 at 3:17pm — No Comments
MySQL HA Presentation from Oracle's MySQL Sunday
Just added a video to the site for MySQL High Availability. Check it out here if you missed it at MySQL Sunday, also, you can get the slides in PDF format… Continue
Added by Chris on September 28, 2010 at 2:00pm — No Comments
MySQL Sunday - Oracle Open World
This is going to be a great event that you don't want to miss!
Have a great day and see you there.
Chris
Added by Chris on July 14, 2010 at 11:00am — No Comments
Chris is speaking at the MySQL 2010 Conference
Faster Than Alter - Less Downtime
"This will be a informative talk about real world problem solving and the powerful yet sometimes overlooked LOAD DATA INFILE command. This talk is for MySQL DBAs who want to expand their
knowledge, improve performance and decrease customer facing downtime"…
Continue
Added by Chris on March 8, 2010 at 2:21pm — No Comments
Grant check for query analyzer
GRANT USAGE ON *.* TO 'test_user'@'10.18.%' IDENTIFIED BY PASSWORD 'HASHNOTGIVEN';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, SHOW VIEW, TRIGGER ON `canoe`.* TO 'test_user'@'10.18.%';
GRANT SELECT on `mysql`.`proc` TO… Continue
Added by Chris on February 15, 2010 at 12:44pm — 2 Comments
MySQL Meetup Group - Back in the Bay!
During our first meetup we went over basic MySQL topics including configuration, performance tuning, locking, along with running MySQL in the cloud. All in all it was a well done… Continue
ORACLE won't kill MySQL!
"MySQL co-founder David Axmark says "Oracle has no real reason to support" the open-source database it's trying to acquire as part of Sun, but he also says "I doubt they'd 'kill' anything." Rather, the real intrigue will center on what happens when Oracle's database customers want to migrate downstream to MySQL.
From a cbronline.com article quoting Axmark:"
-- FULL Article…
Continue
Added by Chris on January 15, 2010 at 4:56pm — No Comments
MySQL UC 2010?
Added by Chris on November 24, 2009 at 3:36pm — 2 Comments
Broken Index from InnoDB Hot Backup
mysql> show create table… Continue
Added by Chris on November 9, 2009 at 1:44pm — No Comments
Secure Your Server – Tips for DBAs
-- The List
1. Make sure that ALL root accounts (ALL PRIVILEGED accounts) have strong passwords and apply them using hashes not plain text. If you leave the password blank anyone can connect as root without a password and be granted all privileges.
2. For ALL other accounts use passwords and apply them using hashes not plain text.
A good… Continue
Added by Chris on October 22, 2009 at 2:30pm — 2 Comments
Security Sensitive Grants
-- GRANT OPTION
"The GRANT OPTION privilege enables you to give to other users or remove from other users those privileges that you yourself possess." (http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_grant-option)
-- RELOAD
"The RELOAD privilege enables use of the… Continue
Added by Chris on October 21, 2009 at 6:00pm — No Comments
Latest Blog Posts
- Ning Tech Talk on MySqL - Date Correction
- How We Implemented & Currently Maintain MySQL on the Ning Platform
- Comparing MySQL Statement-Based and Row-Based Replication
- MySQL Workbench - Top 13 things you should know
- Call for Participation - OSCON 2011
- KSCOPE11 - ODTUG Conference June 2011
- Simple Automation - Examining your MySQL Index Usage
Most Popular Blog Posts
© 2024 Created by Chris.
Powered by
