List of MySQL clients available on android. ProSql Price: 2,99€ Last update: 02.12.2012 ProSql is the newest and most complete of all the Android MySQL client and is the only client which uses the features of honeycomb showing a nice interface to both, mobile and tablets. It can export to xls, csv and create sql dumbs. [...]

Synchronous data replication over long distances has the sort of seductive appeal that often characterizes bad ideas.  Why wouldn't you want every local credit card transaction simultaneously stored on the other side of the planet far away from earthquake, storms and human foolishness?  The answer is simple: conventional SQL applications interact poorly with synchronous replication over wide area networks (WANs).

I spent a couple of years down the synchronous replication rabbit hole in an earlier Continuent product.  It was one of those experiences that make you a sadder but wiser person.  This article digs into some of the problems with synchronous replication and shows why another approach, asynchronous multi-master replication, is currently a better way to manage databases connected by long-haul networks.

Synchronous Replication between …

MySQL is a database of compromise. Compromise between running a production-ready relational database and being popular with all sorts of hackers - mostly the ones that don't really like SQL. And because they don't really like SQL, they choose MySQL, as MySQL is very forgiving. It is just as forgiving as their favourite language PHP, … Continue reading MySQL Bad Idea #384 →

Installing Apache2 With PHP5 And MySQL Support On CentOS 6.3 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 6.3 server with PHP5 support (mod_php) and MySQL support.

I am behind Peter’s opinion. I also tested semi-sync three month ago when I was using sysbench with several threads. I was excited to find that the performance of semi-sync DIDN’T dropped so much significantly. The result was NOT same as what I expected and understood before. Finally, wow…Here is key: “network group commit”. That is a cool idea,well done! The following opinion from Baron is :”semi-synchronous replication actually forces the client to be synchronized, not the replicas.” It also makes me much more clear.

Conferences
FrOSCon will be held Saturday and Sunday, August 25th - 26th at the University of Applied Sciences Bonn-Rhein-Sieg in Germany. Registration is a small fee for personal attendees, only 5 euros. It is more for corporate attendees. There will be a MySQL and friends room this year, as in years past.

MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. This is a technical conference about MySQL, bringing together MySQL engineers at Oracle and the MySQL Community, and will include sessions about the latest MySQL features and roadmaps. The …

Unit Testing in MySQL Stored procedure in MySQL are very useful in removing the database query layer from server side scripting. It is entirely possible to develop and maintain the database layer separately from the server side code. To complete this seperation Unit Testing directly in stored procedures makes just sense. The test database The [...]

The problem many MySQL/MariaDB 5.5+ users are painfully aware of:

InnoDB: Using Linux native AIO
InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
InnoDB: Warning: io_setup() attempt 1 failed.
InnoDB: Warning: io_setup() attempt 2 failed.
InnoDB: Warning: io_setup() attempt 3 failed.
InnoDB: Warning: io_setup() attempt 4 failed.
InnoDB: Warning: io_setup() attempt 5 failed.
InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
InnoDB: You can disable Linux Native AIO by setting innodb_native_aio = off in my.cnf
InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: Completed initialization of buffer pool
mysqld got signal 11 ;

There is no news that disabling InnoDB native AIO is not exactly the best possible option. It’s also not a secret that the alternative is increasing aio-max-nr if …

I’m currently figuring out how to name the MySQL Connector/Python distributions so it works well with PyPi. Source archives would be named like mysql-connector-python-X.Y.Z.tar.gz.

The ‘name’ metadata would be ‘MySQL Connector Python’, thus without any underscores or dashes. This works OK, but if people have objections, please leave a comment.

1) Store key/value cache using Memcached in a MySQL table. 2) Invalidate cache with one SQL statement.

"There are only two hard problems in Computer Science: cache invalidation and naming things." - Phil Karlton kthnxbye.