Tweaking is the motto - what an easy release PECL/mysqlnd_ms 1.4 will be! The first tweak for the next stable version of the mysqlnd replication and load balancing plugin solves pitfalls around charsets. String escaping now works on lazy connection handles (default) prior to establishing a connection to MySQL. A new server_charset setting has been introduced for this. The way it works also prevents you from the risk of using a different charset for escaping than used later on for your connection.

Lazy connections and server_charset

PECL/mysqlnd_ms is a load balancer. A users connection handle can point to different nodes of a replication cluster over time. For example, if using MySQL Replication, the connection handle may point to the master for running writes and, later on, to one of the slaves for reads. At the very moment a user opens a …

This week we listen to MySQL founders David Axmark and Michael "Monty" Widenius talk about all sorts of topics, from the MySQL ecosystem to "Crazy Monty", an open source restaurant. David and Monty don't always agree, so this panel is enlightening and also funny.

News/Events/Feedback
MariaDB 5.5 features - 5.5 is now GA!

IOUG podcast about MySQL Connect and the new Development Milestone Release (DMR) of MySQL 5.6.

read more

If you are using the Disk Data feature of MySQL Cluster you may find this useful. As you may know the default way of storing data in MySQL Cluster is in-memory. However, if you have tables that don't require realtime access and/or are growing larger than your available memory then you can use disk data tables. I have written a bunch of posts about disk data tables before:

• http://johanandersson.blogspot.se/2008/06/disk-data-tables.html
• http://johanandersson.blogspot.se/2008/11/disk-data-extent-deallocation-caveats.html
• …

MySQL uses different type of threads for running specific utilities like mysql_install_db, flushes MyISAM tables, Replication, TCP/IP sockets etc. All threads can run with four different priorities like Interrupt, connect, wait and query priorities. Different types of threads are: The main thread : This one is created by MySQL client normally, this will be one … Continue Reading …

There is no replacement for the documentation of the database products. There is no alternative of forums for these technologies, and also there is no alter ego for the database blogs. They add up yet another avenue to explore when the professionals need help. This Log Buffer Edition helps professional in identifying few blog posts [...]

Percona is glad to announce the release of Percona Server 5.1.62-13.3 on April 25, 2012 (Downloads are available here and from the Percona Software Repositories).

Based on MySQL 5.1.62, including all the bug fixes in it, Percona Server 5.1.62-13.3 is now the current stable release in the 5.1 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the 5.1.62-13.3 milestone at Launchpad.

New …

Percona is glad to announce the release of Percona Server 5.5.22-25.2 on April 25, 2012 (Downloads are available here and from the Percona Software Repositories).

Based on MySQL 5.5.22, including all the bug fixes in it, Percona Server 5.5.22-25.2 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the 5.5.22-25.1 milestone at Launchpad.

Bugs Fixed:

• While running the test …

[...] MySQL: An Introduction for Oracle DBAs http://patrickhurley.wordpress.com/mysql-for-oracle-dba/ [...]

To launch an app there was a tried and true process. The process in the past was to rent a server in a managed hosting facility. Get a few more as you grow, then build a model showing that it would be cheaper to get your own cage and finance servers. If the app continues to grow, build a model showing it would cost cheaper and allow for more rapid growth if you built your own datacenter after multiple requests for more power, space and moving to larger spaces with more power.  Now we have a new Step. If Step 1 is managed hosting then Step 0 is putting your application in the cloud i.e. Amazon's EC2.
When an app grows cost grows at a multiple in EC2. To offset these costs, take periodic looks at your architecture to see if there is anything you can do to reduce overall cost. Let's look at a tier that is easy to scale. Let's look at application memory caching on Memcache as an example to illustrate reducing cost.
…

The SELF 2012 Preliminary Schedule is now available.

Just 43 days left until SELF and it looks like a great MySQL Lineup! A wide array of presenters from the MySQL community will be present, including Oracle Engineers.
On top of that.... You can get in for FREE if you wanted too!
Register here

Join us and support Linux, MySQL and open source technologies over all.


SELECT COUNT(sessions) FROM self_mysql_speakers WHERE year=2012;
20+ rows