(Dathan Pattishall) If you have chosen to split your data across boxes, and architected your app to not query across boxes there is still a case where you will need to. Data mining, reports and data health checks require hitting all servers at some point.
Tag: Open Source
JSON Support in PostgreSQL, MySQL, MongoDB, and SQL Server
Baron Schwartz) Unless you’ve been hiding under a rock for a few years, you probably know that JSON is quickly gaining support in major database servers. Due to its use in the web front-end, JSON has overtaken XML in APIs, and it’s spreading through all the layers in the stack one step at a time.
New PERFORMANCE_SCHEMA defaults in MySQL 5.7.7
(Robert Barabas) I thought it was worth a moment to reiterate on the new Performance Schema related defaults that MySQL 5.7.7 brings to the table, for various reasons.
MySQL High Available with MHA
(Moll) Providing a suitable High Availability (HA) solution for each database system is one of the challenging tasks for a DBA and here we have to answer some questions like the following ones:
Performance Schema … How to (Part1)
(Marco Tusa) Performance Schema (PS) has been the subject of many, many recent discussions, presentations, and articles. After its release in MySQL 5.7, PS has become the main actor for people who want to take the further steps in MySQL monitoring.
MySQL Incremental Backup – Point In Time Backup and Recovery of InnoDB and MyIsam Databases
Doing incremental backups is an important requirement for large production databases. Without a safe incremental backup, you can not tell yourself that you have a reliable production database.
Using Perl to Send Tweets Stored in a MySQL Database to Twitter
(Tony Darnell) Using twitter can sometimes feel like driving downtown, screaming what you want to say out the window, and hoping someone hears you. There might be tens of thousands of people downtown, but your message will only be heard by a few. Because of this, your best bet is to repeat your mess
Optimizer Trace and EXPLAIN FORMAT=JSON in 5.7
(Morgan Tocker) I accidentally stumbled upon this Stack Overflow question this morning:
Decrypt .mylogin.cnf
(Peter Gulutzan) General-purpose MySQL applications should read MySQL option files like /etc/my.cnf, ~/.my.cnf, … and ~/.mylogin.cnf. But ~/.mylogin.cnf is encrypted. That’s a problem for our ocelotgui GUI application, and I suppose other writers of Linux applications could face the same problem,
Building MySQL Crosstab and Subreports
(Rob Gravelle) Unlike MS Access, which has the TRANSFORM…PIVOT statement, most relational databases – MySQL included – do not offer a mechanism for easily generating crosstab queries.