As Norvald wrote in his recent post:
A long time ago, libmysqlclient came in two versions: one that was thread safe and one that wasn’t. But that was a long time ago. Since MySQL 5.5, the thread safe libmysqlclient_r library has just been a symlink to the libmysqlclient library, which has been thread safe at least since then.
…
In our previous posts, we have covered different log files and how to use them to troubleshoot MySQL, but that is not all that MySQL has to offer. But what do you do when the standard approach fails to pinpoint the problem? In this post, we will take a closer look at pt-stalk - a tool which may help you understand what is going on with MySQL when the standard approach fails to catch the problem.
This is the nineteenth installment in the ‘Become a MySQL DBA’ blog series. Our previous posts in the DBA series include:
[Read more]A Productive Nine Months It’s been around 9 months since we did the first cut of our own MySQL Docker images, and it is time for a bit of an update on where we are in Dockerland these days, and also to talk about some important security related improvements we made to the images lately. […]
PGConf Silicon Valley was excellent this year: good organization, great speakers, and top-notch vibes in general. We were excited to see everybody visiting (and crowding!) our booth and the overall very positive community presence. Highlights included a presentation about Postgres' use at TripAdvisor, a look at Amazon RDS for Postgres, and consideration of system scalability and the future of relational database management systems.
Baron Schwartz, VividCortex's own founder and CEO, was at the Silicon Valley conference, and he's said that it was the best PGConf he's been to yet. On November 18th, Baron even led a breakout session, titled "Analyzing PostgreSQL Network Traffic with vc-pgsql-sniffer," in which he explained both the principles and practice that come together to result in VividCortex's powerful sniffer tools. Even the questions asked at Baron's talk were fantastic.
To watch a video of Baron's breakout session, find …
[Read more]We just announced availability of MySQL Cluster Manager 1.4.0! In this post we’ll highlight some details of the MCM 1.4.0 release.
Based on MySQL 5.6 MySQL Cluster Manager is part of the commercial MySQL Cluster offering from Oracle. MCM 1.4.0 is now based on the tried and tested MySQL 5.6 release.…
I posted earlier in the year how to configure a Fedora instance to test PHP code on a local VM. However, I’ve got a few questions on how to find those posts. Here’s a consolidation with links on those steps:
httpd
and php libraries with the yum
installer.
/var/www/html directory for
testing), connect to the yum shell and remove the
php-mysql library and then install the
mysqlnd library.
The results in the survey were very favourable to Galera Cluster providing high availability for MySQL and OpenStack components. Galera Cluster with MariaDB received second place, Galera with MySQL fifth place and Galera with Percona Server (Percona XtraDB Cluster) sixth place. Altogether Galera Cluster with three different MySQL variants is clearly the most popular database high availability solution for OpenStack users.
This survey report analyzes respondents who completed or updated the survey during a two-week window in September 2015, and questions represent some modifications from prior surveys in keeping with the evolution of the OpenStack platform. This survey represents a snapshot of 1,315 users and 352 deployments, provided voluntarily. The User Survey is not a market survey and does not express …
[Read more]When you work with complicated queries, especially ones which contain subqueries, it is easy to make a typo or misinterpret column name. While in many cases you will receive a
column not found
error, sometimes you can get strange results instead.
Like finding 4079 countries in Antarctica:
mysql> select count(*) from City where CountryCode in (select CountryCode from Country where Continent = 'Antarctica'); +----------+ | count(*) | +----------+ | 4079 | +----------+ 1 row in set (0.05 sec)
Or not finding any cities in Georgia:
mysql> select Name, Language from City join CountryLanguage using (CountryCode) where CountryCode in (select Code from Country where District='Georgia' and Continent='Asia'); Empty set (0.18 sec)
I used a standard …
[Read more]Data is the most important asset any organization has especially those who belongs to web, mobile, social, enterprise and cloud applications.
Availability refers to the ability to cope with, and if necessary recover from, failures on the host, including failures of MySQL, the operating system, or the hardware and maintenance activity that may otherwise cause downtime.
Because each application has different operational and availability requirements, MySQL offers a range of certified and supported solutions, delivering the appropriate levels of High Availability (HA).
Factors to consider for HA Solution:
UK server monitoring platform provider moves from MySQL to MariaDB with ClusterControl
Stockholm, Sweden and anywhere else in the world - 08 December 2015 – Severalnines, the provider of open source database management tools, today announced its latest customer, CloudStats.me. CloudStats.me is a cloud-based server monitoring platform capable of monitoring Linux, Windows, OS X servers and personal computers, web sites and IP addresses. Users of CloudStats.me range from system administrators to website owners and web hosting providers, such as WooServers, HudsonValleyHost and other SMEs.
CloudStats.me is a UK company which currently monitors more than 1300 servers and 1000 websites and its server monitoring platform is growing rapidly at 500-1000 new users per week, adding approximately 1.5 servers to each new user …
[Read more]
