(Jonathan Levin) I finally finished my first data warehouse! and it only took me 3 days!

(Mark Robson) MySQL application developers have some problems with connection state. There is a lot of state which can be used associated with a single connection –Transactions (autocommit, uncommitted work, when a transaction was started, isolation level) –Temporary tables –Session variable

(Peter Zaitsev) There are interesting posts these days about future of MySQL Replication by Brian Frank and Arjen.

(Leo Hsu and Regina Obe) This is a continuation of our REST series. The following topics have already been covered 1. Showcasing REST in PostgreSQL – The PreQuel we went over what REST is and isn’t 2. REST in PostgreSQL Part 1 – The DB components we loaded the Pagila database and created a d

(Ronald) There has been some discussion recently regarding the death of MySQL Read Replication starting with Brian Aker and then Farhan, Arjen and Paul have all chimed in. Whatever you want to call it, the next generation of replication approach is clearly on the agenda of the industry leaders and p

(Peter Zaitsev) Reading Barons post about Kickfire Appliance and of course talking to them directly I learned a lot in their product is about beating data processing limitations of current systems.

(Giuseppe Maxia) In MySQL Proxy scripts you can define variables and modify them. No surprise here. If you define a variable with script wide scope, you can use such variable and modify it between queries.

(Peter Zaitsev) If you’re using Innodb tables MySQL has innodb_flush_log_at_trx_commit variable which defines how durable your transactions are. If you have high durability requirements you set it to 1 and log records are pushed directly to the disk on transaction commit. If you do not bother loosin

(Brian Prince) While MySQL may not be supplanting proprietary databases in the enterprise, the people behind the open-source database see solving the scalability problems of Web application developers as their ticket towards broader enterprise adoption.

(Vincent Danen) The more popular ways of using MySQL are to use GUI front ends, such as phpMyAdmin or the MySQL GUI administration tools. While these tools are fantastic and make managing a MySQL database easier, the mysql command-line program works quite well also, and is more flexible.