rawwellのブックマーク - はてなブックマーク

MySQL for the Oracle DBA Resources
rawwell 2009/06/01
"The announcement last month of Oracle to acquire Sun continues to warrant a lot of discussion over exactly what Oracle will do with MySQL. Only time will tell what will happen with the official product, however it is important to remember that MySQL is GPL, there will always be a free version of My

mysql

checkitout
リンク
Announcing Drizzle on EC2
I have published the very first sharable Drizzle Amazon Machine Image (AMI) for AWS EC2, based on the good feedback from my discussion at the Drizzle Developer Day on what options we should try. This first version is a 32bit Developer instance, showcasing Drizzle and all necessary developer tools to build Drizzle from source. What you will find on drizzle-ami/intrepid-dev32 – ami-b858bfd1 Ubuntu 8
rawwell 2009/06/01
"I have published the very first sharable Drizzle Amazon Machine Image (AMI) for AWS EC2, based on the good feedback from my discussion at the Drizzle Developer Day on what options we should try."

drizzle

checkitout
リンク
More Basic MySQL Security
rawwell 2009/06/01
"Never store the MySQL ‘root’ user password in a ~root/.my.cnf file."

mysql

security
リンク
Basic OS/MySQL Security
rawwell 2009/06/01
"This will stop any brute force attack on your server by automated bots and password generators."

mysql

security
リンク
Transcending Technology Specific Boundaries
rawwell 2009/06/01
"Performance is easy if you stop guessing where your code is slow. A few best practice tips are: * You have to insist on seeing where time goes for any task you think is important * You need to look at the sequence diagram of the task * What individual part takes the most time, then look

performance

checkitout
リンク
Drizzle now available on Mosso
rawwell 2009/06/01
"Mosso the Rackspace Cloud now has a Drizzle developer image much like the first Drizzle AMI on EC2."

aws

checkitout

drizzle
リンク
One advantage of Oracle/Sun/MySQL
rawwell 2009/06/01
"In addition to many years of providing MySQL for the Oracle DBA Resources I have with the recent closure of call for papers submitted two sessions for consideration."

mysql

checkitout
リンク
Compiling libdrizzle
rawwell 2009/06/01
"Compiling libdrizzle is a rather trivial task. The following are the steps I undertook on Ubuntu 8.10 Intrepid 32 bit."

drizzle

checkitout
リンク
Adding a Drizzle Plugin
rawwell 2009/06/01
"In addition to a number of presentations and various group discussions most of my individual hacking time was under the guidance of Drizzle team developer Stewart Smith were Patrick Galbraith and myself started the porting of Patrick’s memcached UDF functions for MySQL. Leveraging some existing D

memcached

drizzle

checkitout
リンク
MySQL Monitoring 101
At the 2009 MySQL Conference and Expo I presented to a full room on MySQL Monitoring 101. This presentation focused on the following four goals. Know what to monitor Know how you can monitor Learn practices to diagnose probl ems Have a foundation of historical information
rawwell 2009/06/01
"At the 2009 MySQL Conference and Expo I presented to a full room on MySQL Monitoring 101."

mysql

checkitout
リンク
Setting up MySQL on Amazon Web Services (AWS) Presentation
rawwell 2009/06/01
"On Tuesday at the MySQL Camp 2009 in Santa Clara I presented Setting up MySQL on Amazon Web Services (AWS)."

mysql

aws

checkitout
リンク
What's happening with InnoDB
rawwell 2009/06/01
"The InnoDB plugin available in 5.1 has a number of new benefits. * fast index creation * table compression * info schema tables * new row storage format * file format management"

database

mysql
リンク
Search at Craigslist
I am now sitting in on MySQL and Search at Craigslist by Jeremy Zawodny at MySQL Users Conference Some of the technical difficulties that required addressing. High churn rate half life can be very short Growth Traffic Need to archive postings, e.g. 100M but be searchable Internationalization and UTF-8 Some of the Craigslist Goals Open Source Easy and approachable be green with energy use A review
rawwell 2009/06/01
"A review of the Internals server configuration * Load Balancer (perlbal like) * Read Proxy Array (perl+memcached) * Web Read Array (apache 1.3 + mod_perl) * Object Cache (Perl + memcached) * Read DB Cluster (MySQL 5.0.x) * Search Cluster (Sphinx)"

checkitout

scalability
リンク
A beginners look at Drizzle – SQL_MODE
rawwell 2009/06/01
"A new feature to MySQL Version 5 was the introduction of SQL_MODE to support STRICT… or TRADITIONAL values. This feature enabled a closer compatibility to other RDBMS products. MySQL by default performs a number of silent data changes which do not help in providing a level of data integrity if yo

drizzle

checkitout
リンク
Identifying resource bottlenecks – Memory
rawwell 2009/06/01
"In auditing, I start with the ‘free’ command, the already used ‘vmstat’ command, the /proc/meminfo and /proc/sys/vm/swappiness files to get an indication of memory and swap resources. While we are looking at the Memory, the configuration of Swap is also very important. I will discuss this i

database

mysql

checkitout
リンク
A beginners look at Drizzle – Datatypes and Tables
rawwell 2009/06/01
"Storage Engines A key difference in Drizzle is the default storage engine. This defaults to InnoDB, rather then MyISAM. MyISAM is still currently packaged with Drizzle, however I hope that Maria becomes it’s replacement. The MERGE and FEDERATED storage engines are not supported. BLACKHOLE by defa

mysql

drizzle

checkitout
リンク
Free MySQL Book giveway – Current Progress
rawwell 2009/06/01
"I’ve decided to give people two more days for a chance to win a free MySQL Book — Sheeri Carbal’s MySQL Administrators Bible. I have had five people so far provide recommendations for a simple MySQL configuration question as stated in For MySQL DBA fame and glory. Prize included. Shlomi Noach

mysql
リンク
1