When we went monthly at the end of 2014, did you worry that we would forget our blooper show? This month's podcast is a blooper reel just for you - about 35 minutes of put-a-smile-on-your-face fun with insight as to how things work - or don't work - behind-the-scenes.
I hope your 2015 is going well!
We have been looking at the WebScaleSQL project with great excitement. As with any new enhancements to the MySQL world, we need to test extensively to ensure we can give PSCE customers the best advice possible. Since this project is source only, we decided to add WebScaleSQL builds to our repo, so we could examine the changes being introduced by all the different collaborators.
So what is WebscaleSQL?
WebScaleSQL is a collaboration among engineers from several companies that face the same challenges in deploying MySQL at scale, and seek greater performance from a database technology tailored for their needs.
— WebScaleSQL, Frequently Asked Questions
What makes this project so special, is the level of collaboration between some of the most …
[Read more]
A customer asked whether we they could have 10 or more masters
consolidate all the data into a single central slave. After
getting a bit more information from them and seeing the
application functionality, it was clear that MySQL Labs 5.7.5
Multi Source Replication could be a good candidate. Why?:
– Each master is independent from the rest of the masters.
– One-way traffic: there is only one way to update a row, and
that’s from the master.
– All the masters use the same schema and table, but no single
master will ever need to, nor be able to update a row from
another master.
– PK determined via app & master env.
Multisource replication is still in http://labs.mysql.com, but here’s what I did to test it out.
First, I read:
…
We have gathered Galera related presentations for you to choose from (click the title for more information)
Big Transactions on Galera Cluster, 15 April 2:00PM – 2:50PM @ Ballroom B (click here for more info)
Seppo Jaakola, CEO, Codership
Big and long term transactions have traditionally not behaved well in Galera Cluster. Large replication data sets have resulted in symptoms like elevated conflict rate, increased memory consumption, even OOM kill may happen, flow control pausing, cluster freezing… To deal with these issues, Galera users have been adviced to split large transactions in “reasonable size”. There is also cluster configuration option for rejecting too large transactions, as a safe guard.
…
[Read more]January 30, 2015 By Severalnines
| In this joint webinar series with our friends from the HAProxy team, we covered the concepts around the popular open-source HAProxy load balancer, and demonstrated how to use it with SQL-based database clusters. We also discussed HA strategies for HAProxy with Keepalived and Virtual IP. |
|
Thanks to everyone who participated in these two sessions this week! Please see below for details on next week’s follow up session 'Performance Tuning for HAProxy & MySQL'.
The topics covered this week included:
Following on the heels of last week’s update to the Java client, the MariaDB project is pleased to today announce updates to both MariaDB Connector/C and Connector/ODBC. They are both Stable (GA) releases.
See the Release Notes and Changelogs for detailed information on each of these releases and contain many bug fixes and enhancements.
…
[Read more]This Log Buffer Edition covers various innovative blog posts from various fields of Oracle, MySQL and SQL Server. Enjoy!!!
Oracle:
A user reported an ORA-01114 and an ORA-27069 in a 3rd party application running against an Oracle 11.1 database.
Oracle SOA Suite 12c: Multithreaded instance purging with the Java API.
Oracle GoldenGate for Oracle Database has introduced several features in Release 12.1.2.1.0.
Upgrade to 12c and Plugin – one fast …
[Read more]Users seeking high availability, disaster recovery and zero downtime maintenance operation for business-critical MySQL applications face confusing choices. Is multi-master or master/slave clustering better? What about synchronous versus asynchronous replication? Using a plain vanilla, stock MySQL or a modified version of it? Which of these choices are right for data-driven businesses that
Download MariaDB Galera Cluster 10.0.16
Release Notes Changelog What is MariaDB Galera Cluster?
MariaDB APT and YUM Repository Configuration Generator
The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.16. This is a Stable (GA) release.
See the …
[Read more]Hi there, it’s been a few months since Percona Live London has finished, but I managed just now to get sometime to post the slides from my presentation about backups. Please, take a look and feel free to comment.
