Daily Bitekletas

Following emerging development in online/offline computing like Adobe’s Apollo platform or Microsoft’s Silverlight platform, Google releases Gears which will allow developers to create applications using JavaScript that will run in offline mode and could synchronize to a remote application (e.g. server application) when available.

Google Gears group writes:

Google Gears allows developers to enhance their AJAX applications to be able to run even when their users are offline. This is the official discussion group for web developers interested in using Google Gears in their applications.

Google Gears provides application programming interface (APIs) for offline application access and data storage (using SQLlite). Licensed: BSD

More on Google Gears

• Google Gears Lets Developers Take Apps Offline
• Official Google Gears Site, groups and API documentation

The patches includes a few significant features and many enhancement on the manageability and reliability of MySQL database server.

The features are:

• SemiSyncReplication - block commit on a master until at least one slave acknowledges receipt of all replication events.
• MirroredBinlogs - maintain a copy of the master’s binlog on a slave
• TransactionalReplication - make InnoDB and slave replication state consistent during crash recovery
• UserTableMonitoring - monitor and report database activity per account and table
• InnodbAsyncIo - support multiple background IO threads for InnoDB
• FastMasterPromotion - promote a slave to a master without restart

Enhancements include:

• LosslessFloatDump - support dump and restore of float/double without loss of precision
• Use 8X less memory for account and table privileges
• Use fastest compression rather than the default level for client/mysqld networking
• InnodbSampling - control the number of leaf blocks sampled for optimizer statistics
• InnodbStatus - display more statistics in show innodb status
• Reduced number of calls to fsync when the InnoDB background IO thread is active
• Changed InnoDB to recover when InnoDB and MySQL data dictionaries are inconsistent
• NewSqlFunctions - functions for checksums and floating point to string conversion
• Backported START SLAVE UNTIL
• Sort float columns with the order: -INF < negative < 0 < positive < +INF < NaN
• Change long_query_time to be dynamic and log all queries that run for greater than or equal this number of seconds rather than greater than.
• Count connection attempts tha are denied because of max_connections and display the count as denied_connections
• MoreLogging - log actions done on specified tables and SUPER users
• rpl_always_enter_innodb boosts the priority of the slave SQL thread (for replication) in InnoDB by making it ignore the InnoDB concurrency limits
• rpl_event_buffer_size sets the fixed size buffer that is allocated in the master for each connected slave. The buffer is used for replication events smaller than the buffer. This reduces memory allocation done to copy replication events from the master.
• Backported sync-binlog
• Added reserved_super_connections to reserve the final N connections for users with the SUPER privilege
• NewShowStatus - many new variables in SHOW STATUS

More details here..