So today I happen to need to restore a MySQL database from
backups so I could recover some tables. While I left he
production database running via port 3306, I set up the backup
via port 3307.
However, when I attempted to start another version via the 3307
port in a mysql_restore directory but I ran into some
errors....
/usr/bin/mysqld_safe --defaults-file=/etc/my_3307.cnf
[Warning] Can't create test file
/var/lib/mysql_restore/localhost.lower-test
[Warning] Can't create test file
/var/lib/mysql_restore/localhost.lower-test
Can't find file: './mysql/plugin.frm' (errno: 13)
InnoDB: Completed initialization of buffer pool
InnoDB: Operating system error number 13 in a file
operation.
InnoDB: The error means mysqld does not have the access rights
to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation …
OblakSoft is pleased to announce general availability of the
Cloud Storage Engine for MySQL (ClouSE) version 1.0.
Whether you want to use ready-to-run WordPress
for Amazon Cloud / Google Cloud, configure your own WordPress
installation with WP2Cloud plugin, or use ClouSE to deploy your own
applications, ClouSE lets you tap the power of cloud storage to
store your data extremely durably and make serving the content
highly scalable.
We would like to thank more than 2,000 registered Beta users and early adopters who helped …
[Read more]Install Apache, PHP And MySQL On CentOS 7 (LAMP)
This tutorial shows how you can install an Apache2 webserver on a CentOS 7.0 server with PHP5 support (mod_php) and MySQL support. LAMP is short for Linux, Apache, MySQL, PHP.
My article on how to make the real-time processing of information from traditional transactional stores into Hadoop a reality has been published over at TDWI:
Making Real-Time Analytics a Reality — TDWI -The Data Warehousing Institute.
Filed under: Articles Tagged: analytics, big data,
data migration, databases, hadoop,
mysql, …
In my recent post, “TokuDB gotchas: slow INFORMATION_SCHEMA TABLES,” I saw a couple questions and tweets asking if we use TokuDB in production. Actually I mentioned it in that post and we also blogged about it in a couple of other recent posts:
So, yes, we are using Percona Server + TokuDB as a main storage engine in Percona Cloud Tools to store timeseries data.
And, …
[Read more]TL;DR: Priority queue optimization for filesort with small LIMIT is now visible in MariaDB: there is a status variable and you can also see it in the slow query log (KB page link).
A longer variant:
One of the new optimizations in MySQL 5.6 is ability to use a
priority queue instead of sorting for ORDER BY … LIMIT queries.
The optimization was ported into MariaDB 10.0 long ago, but we
still get questions if/when it will be ported. I guess, the
reason for this is that, besides the query speed, you can’t see
this optimization. Neither EXPLAIN, nor EXPLAIN FORMAT=JSON or
PERFORMANCE_SCHEMA or status variables give any indication
whether filesort used priority queue or the regular
quicksort+merge algorithm.
MySQL 5.6 has only one way one can …
[Read more]I had the pleasure of presenting to the PHP Users Group Philippines a few days ago about mysqlnd_ms. The mysqlnd plugin, MySQL Master Slave, is a transparent layer on top of mysqlnd extension. This allows you to do read-write splitting and slave reads load balancing without needing to change anything from your application. But do you know you can also achieve a form of high availability with this plugin? I shared 2 forms on my presentation, using async MySQL replication either in master-slave configuration or master-master configuration, while the second form is having an all primary cluster where you can write to all nodes.
This first part is to demonstrate how you can achieve a simple HA solution using the first form. First, all the sample code here can be found on my GitHub repository. So, to use the mysqlnd_ms plugin, it uses …
[Read more]On Thursday 17th July I’ll be hosting a webinar which explains what MySQL Clusrter is, what it can deliver and what the latest developments are. As always the webinar is free but please register here.
Details:
Join this technical webinar to learn how MySQL Cluster 7.3, the latest GA release, enables developer agility by making it far simpler and faster to build your products and web-based applications with MySQL Cluster. You’ll also learn how MySQL Cluster and its linear scalability, 99.999% uptime, real-time responsiveness, and ability to perform over 1 BILLION Writes per Minute can help your products and applications meet the needs of the most demanding markets. MySQL Cluster combines these …
[Read more]
The binary and source versions of MySQL Cluster 7.3.6 have now
been made available at http://www.mysql.com/downloads/cluster/.
Release notes
MySQL Cluster NDB 7.3.6 is a new release of MySQL Cluster,
based
on MySQL Server 5.6 and including features from version 7.3 of
the
NDB storage engine, as well as fixing a number of recently
discovered bugs in previous MySQL Cluster releases.
Obtaining MySQL Cluster NDB 7.3. MySQL Cluster NDB 7.3
source
code and binaries can be obtained from
http://dev.mysql.com/downloads/cluster/.
For an overview of changes made in MySQL Cluster NDB 7.3,
see
MySQL Cluster Development in MySQL Cluster …
Get the best from both worlds with bundled packages: a training course and a certification exam voucher. You save 20% when you buy training and certification in discount packages.
Training helps you acquire product expertise. Certification proves this expertise to your future employers.
There are two MySQL Discount Packages: MySQL Database Administration and MySQL Developer.
For more information about the authentic MySQL curriculum, go to …
[Read more]