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]PodcastsGeneralPerformanceRoutines
This week we continue our discussion of Common Schema by finishing up the routines and starting to look at the views it offers. Ear Candy is and At The Movies is
News
In the news, the OurSQL podcast will change to a monthly format
after episode 200. We love doing the podcast, but it is very time
consuming and production is expensive. We will still bring
quality episodes, they will just be spaced further apart.
This week we start talking about common schema by Shlomi Noach. Ear Candy is some caveats about GTIDs and replication, and At the Movies is using jQuery, AJAX and PHP to insert data into MySQL.
News
In the news, the OurSQL podcast will change to a monthly format
after episode 200. We love doing the podcast, but it is very time
consuming and production is expensive. We will still bring
quality episodes, they will just be spaced further apart.
PodcastsPerformanceQuery Optimization
This week we discuss pt-sift and pt-stalk. Ear Candy is about a new tool called Orchestrator, and At the Movies is about Trove on OpenStack to provide open source Database as a Service.
News
Gerry:
In the news, the OurSQL podcast will change to a monthly format
after episode 200. We love doing the podcast, but it is very time
consuming and production is expensive. We will still bring
quality episodes, they will just be spaced further apart.
This week we discuss advanced pt-table-sync, including bidirectional sync. Ear Candy is starting MySQL on low-memory virtual machines, and At the Movies is "What's New With MySQL and MariaDB?"
pt-table-sync
Episode 188,
where we talked about pt-table-sync basics
pt-table-sync documentation
This week we discuss pt-table-sync basics. Ear Candy is about how MyISAM can seem transaction-aware, and At the Movies is MySQL and NoSQL at Craigslist.
Events
DB Hangops -
every other Wednesay at noon Pacific time
Upcoming SkySQL events
Upcoming MySQL events