Continuent is proud to sponsor The OpenStack Summit, November 5-8, at the AsiaWorld Expo in Hong Kong! Don't miss this presentation by Edward Archibald:
Deploying a Highly-Available Database-as-a-Service in OpenStack
In his talk, Edward Archibald, CTO at Continuent, will demonstrate the ease of deploying a multi-site, highly-available, scalable Database-as-a-Service across two OpenStack
Due to disk space constraints, many times compressed sql dump file restoration is required. Mostly, where the uncompressed sql dump size is too big. The options available is show below.
Option 1:
[root@localhost sakila-db]# ls -ltrh total 660K -rw-r--r-- 1 root root 5.3K Dec 15 2011 sakila-schema.sql.gz -rw-r--r-- 1 root root 650K Dec 15 2011 sakila-data.sql.gz [root@localhost sakila-db]# [root@localhost sakila-db]# gunzip < sakila-schema.sql.gz | mysql [root@localhost sakila-db]# gunzip < sakila-data.sql.gz | mysql [root@localhost sakila-db]#
Option 2:
[root@localhost sakila-db]# ls -ltrh total 660K -rw-r--r-- 1 root root 5.3K Dec 15 2011 sakila-schema.sql.gz -rw-r--r-- 1 root root 650K Dec 15 2011 sakila-data.sql.gz [root@localhost sakila-db]# zcat sakila-schema.sql.gz | mysql [root@localhost sakila-db]# zcat sakila-data.sql.gz | mysql [root@localhost …[Read more]
MySQL Fabric is a very promising sharding framework. If I take Ulf Wendel definition of MySQL Fabric :
MySQL Fabric is an administration tool to build large “farms” of MySQL servers. In its most basic form, a farm is a collection of MySQL Replication clusters. In its most advanced form, a farm is a collection of [...]
Hi,
Very interesting. Could you give me the memory consumption on your raspberry’s with the cluster up and running?
You will understand why I am asking that by looking at my page: http://wiki.ryayon.com/doku.php?id=mysql:howto:how_i_installed_mysql_cluster_on_my_raspberry_pi
Regards,
Rudy
Emphasis on clustering solutions comes up quite a lot when talking to customers about High Availability. The reason is because clustering is supposed to provide an easier solution for maintaining high availability and so that you do not have to rely on other tools and techniques outside of the database server.
I thought it would be good to share the gist of many of my discussions around clustering, in the form of a blog post.
People usually tend to compare MySQL NDB Cluster and Percona XtraDB Cluster but both of them really are very different solutions.
For one NDB Cluster would mean a complete rethink of how data is accessed by the application. You also get to have to deal with a storage engine that works and behaves differently from InnoDB storage engine. The key point with NDB Cluster is data partitioning between different nodes. Not all applications are built with partitioning in mind specifically. And such you would …
[Read more]Since our initial release last summer, TokuMX has supported fully ACID and MVCC multi-statement transactions. I’d like to take this post to explain exactly what we’ve done and what features are now available to the user.
But before beginning, an important note: we have implemented this for non-sharded clusters only. We do not support distributed transactions across different shards.
At a high level, what have we done?
We have taken MongoDB’s basic transactional behavior, and extended it. MongoDB is transactional with respect to one, and only one, document. MongoDB guarantees single document atomicity. Journaling provides durability for that document. The database …
[Read more]InnoDB page compression is a feature that really interests me. I wrote this about it recently when describing how to improve the performance of large tables in MySQL:
“Use innodb page compression. For some workloads (particularly those with lots of char/varchar/text data types) compression will allow the data to be more compact, stretching out that performance curve for longer. It may also allow you to more easily justify SSDs which are typically smaller in capacity. InnoDB page compression was improved a lot in MySQL 5.6, courtesy of Facebook providing a series of patches.”
After writing that, I decided to setup an experiment.
The Experiment
I wanted to find data that was typical to be stored in a database, but would also compress well. There is a huge potential for skew here, since if I used …
[Read more]One key success factor in a great leadership is to gather great people around you. Bloggers are people, and this Log Buffer Edition enables you to gather them around you through their blog posts.
Oracle:
The PHP OCI8 2.0.6 extension for Oracle Database is now “production” status.
Oracle GoldenGate 12c released on October 17th and includes several new cutting edge features that firmly establishes GoldenGate’s leader position in the data replication space.
Best Practices Generating WebService Proxies for Oracle Sales Cloud (Fusion CRM).
What the …
[Read more]The Percona Monitoring Plugins (PMP) provide some free tools to make it easier to monitor PXC/Galera nodes. Monitoring broadly falls into two categories: alerting and historical graphing, and the plugins support Nagios and Cacti, respectively, for those purposes.
Graphing
An update to the PMP this summer (thanks to our Remote DBA team for supporting this!) added a Galera-specific host template that includes a variety of Galera-related stats, including:
Emphasis on clustering solutions comes up quite a lot when talking to customers about High Availability. The reason is because clustering is supposed to provide an easier solution for maintaining high availability and so that you do not have to rely on other tools and techniques outside of the database server. I thought it would be good to share the gist of many of my discussions around clustering, in the form of a blog post. So here I will be doing a high-level comparison between MySQL NDB Cluster and Percona XtraDB Cluster.
The post Percona XtraDB Cluster – A Drop-in-place Clustering Solution for MySQL appeared first on ovais.tariq.