(Liran Zelkha) In the previous post of this series (which can be found here) I discussed how to migrate your data once you have decided how to shard your schema.
Tag: Open Source
Information on MySQL Cluster and MySQL Replication
(Andrew Morgan) There are a number of attributes of MySQL Cluster that make it ideal for lots of applications that are considering NoSQL data stores. Scaling out capacity and performance on commodity hardware, in-memory real-time performance (especially for simple access patterns), flexible schemas…
Batched Key Access Speeds Up Disk-Bound Join Queries
(Øystein Grøvlen) A new feature in MySQL 5.6.3 Development Milestone Release is Batched Key Access (BKA). BKA can be applied when an index lookup can be used to execute a join query. One example of such a query is:
Windows Native Authentication for MySQL
(Lars Thalmann) Starting with MySQL 5.5.16 it is possible to setup password-less connections from clients into the MySQL server using the Windows SSPI authentication framework.
What can I DROP?
(Mark Grennan) So you have inherited a MySQL server and no one know what applications are use what databases. Space is every tight and every night transactions logs almost fill your hard disk. The server was once used as a replication server and it seems every database the company uses is duplica
Sending and Managing Email Accounts in a MySQL Database using Perl
(Tony Darnell) A friend of mine has a small newsletter that he sends via email once a month. Initially, he was just blind-copying everyone on his list, but as the list grew, it was a pain for him to keep manually editing his BCC list. Also, some people weren’t receiving the newsletter as they had em
PECL/mysqlnd_ms compared to a classic
(Ulf Wendel) Recently I was asked if PECL/mysqlnd_ms should be used to add MySQL replication support to a yet to be developed PHP application.
How to Implement MySQL Sharding – Part 2
(Liran Zelkha) In the previous post of this series (which can be found here) I discussed how to identify tables that can serve as good candidates for sharding.
MySQL 101 – Transactions
(Adam Donnison) We’ve now come a long way since our first steps at creating our online bookshop database. Now we need to start to think about how to sell the books and store details about the sales. This is the time we need to start understanding database transactions.
Blowing up in memory
(Domas Mituzas) MySQL isn’t too concerned about table handler memory usage – it will allocate row size buffer thrice per each table invocation. There’s a few year old bug discussing UNION memory usage – for each mention in an union one can allocate nearly 200k of unaccounted memory – so a megabyte s