store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Tue Aug 20, 2019 11:56 am

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: mariadb 5.5.30 released
Unread postPosted: Tue Mar 19, 2013 3:45 pm 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 8329
Location: earth
This is my first stab at mariadb packages for el6-fedora 18. Some things to know in advance:

* Mariadb is a community fork of Mysql. It does everything mysql does, and even uses mysql filenames.
* While I could have written it to Obsolete mysql, I did not do that so you will need to remove mysql to install it.
* As far as I have seen so far, it is completely compatible with existing mysql dbs. I even upgraded over mysql 5.1 (when I did have obsoletes enabled) and it went through just fine.
* Allegedly it can do masterless replication. Havent tried that yet, but I want to :P
* Existing applications should not have to change to talk to mariadb


Top
 Profile  
Reply with quote  
 Post subject: Re: mariadb 5.5.30 released
Unread postPosted: Thu Mar 21, 2013 3:45 pm 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 8329
Location: earth
Im going to work this up into a blog post or something, I have gotten the masterless replication going using galera (not packaged yet, but soon) working with mariadb. Its possible to implement this in mysql as well, so I'll treat it like a feature candidate.

As this patch was only available for 5.5.29, I rolled mariadb back to that version and dropped 5.5.30 from the repo. EL5 packages were also added to this branch.


Top
 Profile  
Reply with quote  
 Post subject: Re: mariadb 5.5.30 released
Unread postPosted: Sat Mar 23, 2013 12:21 pm 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 8329
Location: earth
Masterless replication is set up between 2 project gamera servers, creating a shared bayes & awl db across nodes. No corruptions after 24 hours, so we'll continue to let this go over a few days.

Challenges so far:
1) firewall rules can get complicated
2) timing matters on intial setup (servers have to be started in order)

As I noted before, its possible to include this in the mysql packages, and its probably something I'll do. Especially given the inter-dependencies with mysql libraries and the fact that I dont (yet) want to tag MariaDB as Obsoletes on mysql.


Top
 Profile  
Reply with quote  
 Post subject: Re: mariadb 5.5.30 released
Unread postPosted: Wed Mar 27, 2013 8:34 am 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 8329
Location: earth
two other notes to add:

1) this works best with odd numbers of servers, but even if you dont have an odd number galera has an arbintration daemon to act as that 3rd party. Very briliant idea

2) I have now expanded this design with haproxy, to allow for a single IP for applictions to point to. This could be implemented two ways, the first is to run haproxy on a separate layer with IP failover (keepalived, LVS, etc) or by running haproxy locally on each mysql connecting node (an alternate here is sqlproxy, which I will also be exploring).

3) I have now set up 2 separate production environments with these designs that will make it into the final article.


Top
 Profile  
Reply with quote  
 Post subject: Re: mariadb 5.5.30 released
Unread postPosted: Wed Apr 24, 2013 5:42 pm 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 8329
Location: earth
In case anyone was watching the news the other day, Wikipedia has partially completed their migration from mysql to mariadb.


Top
 Profile  
Reply with quote  
 Post subject: Re: mariadb 5.5.30 released
Unread postPosted: Thu Apr 25, 2013 10:17 am 
Offline
Forum Regular
Forum Regular

Joined: Tue Aug 01, 2006 2:45 pm
Posts: 573
Location: Netherlands
Looks promising. I will soon try building a cluster of MariaDB servers using your packages. Are all requirements (including the MariaDB Galera Cluster packages) available in the Atomic repository? Anything out-of-the-ordinary I should take into consideration when using your packages in stead of the ones provided by MariaDB (https://kb.askmonty.org/en/installing-mariadb-with-yum/)?

_________________
Lemonbit Internet Dedicated Server Management


Top
 Profile  
Reply with quote  
 Post subject: Re: mariadb 5.5.30 released
Unread postPosted: Thu Apr 25, 2013 3:06 pm 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 8329
Location: earth
Its all in there for el6, for el5 you'll need to grab galera from the mariadb site.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group