(Arjun Panwar) In MySQL, a cursor allows row-by-row processing of the result sets. A cursor is used for the result set and returned from a query. By using a cursor, you can iterate, or by step through the results of a query and perform certain operations on each row.
Tag: Open Source
PECL/mysqlnd_ms: quality of service filter
(Ulf Wendel) What if your PHP application could tell the mysqlnd library what service quality you need when using a MySQL replication cluster? If you wanted read-your-writes, the driver would select replication nodes for you which can offer it.
MySQL Cluster to MySQL Server … Part 2
(Keith Larson) I previously posted blog about the topic of a MySQL Cluster set up and replication to a MySQL Server. The first blog was just the installation, now lets test the cluster and get replication started. Both are extremely easy.
on MySQL replication prefetching
(domas mituzas) Our database environment is quite busy – there’re millions of row changes a second, millions of I/O operations a second and impact of that can be felt at each shard. Especially, as we also have to replicate to other datacenters, single threaded replication on MySQL becomes a real bot
Migrating from MySQL Master-Master Replication to Galera Multi-Master Replication
(Shinguz) Galera is a synchronous Multi-Master Replication for MySQL. It is therefore in competition with several other MySQL architectures:
Performance schema or COM_ status counters ?
(Marc Alff) In MySQL 5.6.3, that is, a while ago already, the performance schema added instrumentation for statements.
More MySQL foreach()
(Shlomi Noach) In my previous post I’ve shown several generic use cases for foreach(), a new scripting functionality introduced in common_schema.
How To Sort Columns of MySQL Data on a Web Page With Perl
(Tony Darnell) A friend of mine was building a web site so his customers could view his current inventory of transportation containers, and he asked me for help on how to sort the rows of information that appeared on his site. So, in this post, I will give you a quick example on how to sort columns
MySQL foreach()
(Shlomi Noach) A new routine is now available in common_schema, which makes for an easier execution syntax for some operations:
Using HAProxy for MySQL failovers
(Mike Taluc) There are a number of solutions available for MySQL architecture that provide automatic failover, but the vast majority involve potentially significant and complex changes to existing configurations.
