MySQL
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.
Read moreWhere 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.
Read moreWhen 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.
Read moreORDER 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.
Read moreIt 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.
Read moreSelecting 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.
Read moreWhy 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.
Read moreA neat trick for a row number in a MySQL recordset
While working for a client, I had need to produce canned results of certain different criteria, recording the result in a table for later usage, and keep the position within each result.
Read moreSecuring your OS for MySQL with JeOS
Do you have a full time System Administrator? Do you have only a part-time SA, or none at all? Packet General’s Data Security and PCI Compliance solutions run on a dedicated appliance, based on a “Just Enough Operating System” (JeOS) to minimize exposure.
Read moreHow to secure MySQL data and achieve PCI compliance
This week I will be the moderator for a MySQL Webinar How to secure MySQL data and achieve PCI compliance being held Thursday, September 11, 2008, 10:00 am PST, 1:00 pm EST, 18:00 GMT.
Read moreNaming standards? Singular or Plural
It’s important that for any software application good standards exist. Standards ensure a number of key considerations. Standards are necessary to enforce and provide reproducible software and to provide a level of quality in a team environment, ease of readability and consistency.
Read moreA 5.1 QEP nicety – Using join buffer
I was surprised to find yesterday when using MySQL 5.1.26-rc with a client I’m recommending 5.1 to, some information not seen in the EXPLAIN plan before while reviewing SQL Statements.
Read moreAn intestesting approach to free hosting
I came across the OStatic Free hosting service that provide Solaris + Glassfish (Java Container) + MySQL. They offer “Now you can get free Web hosting on Cloud Computing environment free of charge for up to 12 months.
Read moreGet linked to Drizzle
We are always looking at different ways to help promote, inform and identify contributers, users and supports for Drizzle . One way is to join the Linked In Drizzle group (click here when logged in).
Read more