Blog
Some MySQL pairs terminology
In response to a number of comments, I thought I would clarify the scope of my discussion regarding Options using MySQL pairs before I begin. As mentioned their is no one way or type of configuration for MySQL in a HA solution, however the simplest progression from a single Master/Slave environment is the concept of a pair of servers, configured to support a fail over and fail back via MySQL Replication.
Options using MySQL Pairs
Configuring a production environment using a pair of MySQL servers in a Master/Fail Over Master situation is a common process to provide many benefits including supporting failover, backup/recovery, higher availability for software & database upgrades.
Where is the innovation?
The 2009 MySQL Conference has closed it’s submissions for papers. This year the motto is “Innovation Everywhere”. Last weekend’s Open SQL Camp in Charlottesville, Virginia, we had the chance to talk about the movements in the MySQL ecosystem.
When mysqldump –no-set-names matters
I had this perplexing problem yesterday where a mysql dump and restore was producing different results when using MaatKit mk-table-checksum. mk-table-checksum --algorithm=BIT_XOR h=192.168.X.XX,u=user,p=password --databases=db1 --tables=c DATABASE TABLE CHUNK HOST ENGINE COUNT CHECKSUM TIME WAIT STAT LAG db1 c 0 192.
ORDER BY (the lesser known way)
We all know with MySQL you can use ORDER BY with a list of columns to return an ordered set, e.g. ORDER BY name, type, state; I often use the syntax ORDER BY 1,2; which I’m surprised that some people do not know about.
Javascript Helpers
Combined with my old favorites of Dynamic Drive , DHTML Goodies and Brain Jar , I’ve added the following to my list of Javascript sources. Mochikit JQuery
It begins, the downfall of current Web 2.0 sites
The current US financial situation has claimed a victim in the Web 2.0 world — Uber . I’m not sure if this is the first significant name, but it will not be the last site running MySQL where investors will be quick to cut losses and move on.
Improving your web site compatibility with browsers
Every website page content uses two basic elements, HyperText Markup Language (HTML) and Cascading Style Sheets (CSS) . Each of these has various standards, HTML has versions such as 3.2, 4.
Selecting wise indexes
Indexes are a great way to improve performed in a MySQL database, when used appropriately. When used in-appropriately the impact can be a degradation of performance. The following example from Movable Type shows how when reviewing the slow query log I found numerous occurrences of Inserts take 3 or more seconds, with no reported lock contention time for this insert.
Brand identity with undesirable domain names
Choosing a domain name for your brand identity is the start. Protecting your domain name by registering for example .net, .org, and the many more extensions is one step in brand identity.
Why you do not use GRANT ALL ON .?
Why you do not use GRANT ALL ON *.*? I was with a client today, and after rebooting a MySQL 5.0.22 instance cleanly with /etc/init.d/mysqld service, I observed the following error, because you always check the log file after starting MySQL.
To www or not www
Domain names historically have been www.example.com , written also with the protocol prefix http://www.example.com , but in reality www. is optional, only example.com is actually needed. www. is technically a sub-domain and sub-domains incur a small penalty in search engine optimization.
Patience and Passion at Web 2.0 NY
Gary Vaynerchuk spoke next at Web 2.0 NY on Building Personal Brand Within the Social Media Landscape . He was hilarious. His video presentation is available online , to share with others.
Integrity, clarity and responsibility – Web 2.0 NY Keynote
Next on the Web 2.0 keynote speaker list was Maria Thomas of www.etsy.com with her talk The DIY Guide to Growing a Company . If never heard of Etsy before – Your place to buy & sell all things handmade, interesting site.