Read the original article at Active-active replication reduces operational flexibility

Among the myriad data integrity and corruption risks associated with active-active replication, you also lose out on configurability and operational flexibility. Reason 7 – Can’t add nodes easily The often touted solution to use auto_increment_increment and auto_increment_offset fixes you to a given setup forever. You can set it up with a discrete two nodes, all [...]

For more articles like these go to Sean Hull's Scalable Startups

Related posts:

1. 10 reaons active-active is hard and how to solve it
2. …

Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 12.3 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an OpenSUSE 12.3 server with PHP5 support (mod_php) and MySQL support.

The Percona Live: MySQL User Conference is just around the corner! Before we begin our trek to San Jose, we want to provide you with one last announcement about our upcoming activities. First of all, as we’ve previously mentioned, Andrew Aksyonoff (Sphinx’s founder) is going to be delivering a Sphinx tutorial on the 22nd of April [...]

While coding, every second counts. And when the complexity of the database increases, you need to find new ways of speeding up your coding workflow. Let us admit it, we developers prefer to get all our work done using keyboard shortcuts, without having to switch to the mouse.

To streamline your entire coding experience and to speed up database navigation, here are a couple of useful keyboard shortcuts to make the most out of object browser filter in SQLyog.

Keyboard shortcuts:

1. Ctrl + B – sets focus on object browser for operations related to Object Browser.
2. Ctrl + [Up arrow] – brings focus to server/top-most element in Object Browser.
3. Ctrl + E – sets focus to Query Editor to write queries.
4. Ctrl + Shift + B – brings cursor focus on Object Browser filter.
5. Right Arrow – Expand treeview element
6. Left Arrow – Collapse treeview element
…

The Bulgarian Oracle Users Group is holding its spring conference on 17-19 May. I'll be speaking about MySQL 5.6 and MySQL security on it.

There's still time to register (registration ends on 7 May). And the venue is great during this time of the year !

The MariaDB Foundation have just issued press release about the new Governance in the Foundation.  A lot of the new things that is happening in the MariaDB adoption comes thanks to the work we have done in the Foundation.

The Foundation is also happy to announce that is has now 2 senior MySQL (now MariaDB) developers on board, Alexander Barkov and Sergey Vojtovich and a documentation writer, Ian Gilfillan.

The foundation is also helping founding the new Connect engine, which allows you to use MariaDB with a lot of different formats (XML, CVS, DBF,...), and connections, including ODBC. (Documentation will appear shortly …

This blog post is part two of two. Like part one, published Wednesday, this is a cross-post from Groupon’s engineering blog. Thanks again to Kyle Oppenheim at Groupon. And one more reminder that I’ll be at the Percona Live MySQL Conference and Expo next week in Santa Clara, California so look for me there. You can checkout the sessions I’ll be leading here.

In my last post, I described a solution for keeping the caches of a MySQL standby server hot using MySQL slow logs with …

Adzuna is a fast growing search engine for classified ads specialized in jobs, properties and cars. Headquartered in the UK and launched in 2011, Adzuna searches thousands of sites and tens of millions of ads to make it very easy to find the perfect job, home or car locally. It furthermore provides a wealth of statistics such as salaries trends graphs and comparisons, geographic jobs maps, house prices...and more. Additionally, Adzuna is integrated with Facebook and LinkedIn and shows open vacancies one is connected to through his/her own network. The search engine powers a number of government applications and is integrated into the UK's Prime Minister economic dashboard.

Challenges

• When Adzuna's founders were selecting the database powering the search engine's architecture, they were planning for scalability and reliability. Not only did they expect fast …

The MariaDB Foundation, stewards of the community-maintained open source MariaDB database that is sweeping the Internet, announced today the next steps towards a community-managed governance structure. With the appointment of a new, enlarged Board of Directors and a new interim chief executive, the MariaDB Foundation is now on track to a fully member-led governance in the second half of 2013.

The Board members are now Rasmus Johansson, Andrew Katz, Simon Phipps, Michael “Monty” Widenius, and Jeremy Zawodny. The first act of the new interim Board was to appoint Johansson as Chair and Phipps as Secretary and Chief Executive Officer.

The Board bring together a wealth of experience. Johansson is an experienced leader within the MariaDB developer community. Katz is a well-known expert in open source legal matters and has been acting as COO of the Foundation until now. Phipps brings experience of IBM and Sun Microsystems as well as …

There was once a big hooplah about the MySQL Storage Engine Architecture and how it was easy to just slot in some other method of storage instead of the provided ones. Over the years I’ve repeatedly mentioned how this wasn’t really …