Stream

Join this community to post or comment
 
Read our latest WhitePaper DevOps Guide to Database Backups for MySQL & MariaDB
http://severalnines.com/blog/new-whitepaper-devops-guide-database-backups-mysql-and-mariadb 
Check out our free new whitepaper on database backups, which discusses in detail the two most popular backup utilities available for MySQL and MariaDB, namely mysqldump and Percona XtraBackup.
2
1
Add a comment...
 
Hey Comm, quick question.

If using a master/master replication with two nodes using a keepalived virtual IP; is it really still necessary to setup an auto increment increment/offset?

I reckon it isn't because the application only reads/writes to the virtual IP which will only be on either one of the nodes.

It would be necessary if the application reads/writes on both nodes simultaniously, which isn;t the case.

Thanks in advance!


1
Gordan Bobic's profile photo
 
Not strictly necessary, but there is no drawback to setting auto_increment_increment and auto_increment_offset regardless.
Add a comment...

Severalnines

Discussion  - 
 
High availability read-write splitting with php-mysqlnd, MySQL Replication and HAProxy: http://severalnines.com/blog/high-availability-read-write-splitting-php-mysqlnd-mysql-replication-and-haproxy
In this blog post, we explore the use of php-mysqlnd_ms with a PHP application (Wordpress) on a standard MySQL Replication backend.
1
Add a comment...

Daniel Bartholomew (dbart)
moderator

Discussion  - 
 
As expected, MariaDB scales really well.
What kind of performances could we expect from MariaDB 10.1 vs MySQL 5.7 on real world applications running on massively multithreaded hardware (IBM Power8)
9
8
Add a comment...

Severalnines

Discussion  - 
 
17th edition: Become a MySQL DBA blog series - Troubleshooting Galera cluster issues - part 1! http://severalnines.com/blog/become-mysql-dba-blog-series-troubleshooting-galera-cluster-issues-part-1
In this blog post, we are going to show you some examples of things that can go wrong in Galera - inexplicable node crashes, network splits, clusters that won't restart and inconsistent data. We'll take a look at the data stored in log files to diagnose the problems, and discuss how we can deal ...
1
1
Add a comment...

Severalnines

Discussion  - 
 
Become a ClusterControl DBA for ‪#‎MySQL‬, ‪#‎MongoDB‬ & ‪#‎PostgreSQL‬: performance monitoring and health! http://severalnines.com/blog/become-clustercontrol-dba-performance-monitoring-and-health ‪#‎mariadb‬ ‪#‎percona‬
The blog series for MySQL, MongoDB & PostgreSQL administrators. In the previous two blog posts we covered both deploying the four types of clustering/replication (MySQL/Galera, MySQL Replication, MongoDB & PostgreSQL) and managing/monitoring your existing databases and clusters.
1
Add a comment...

Wade Mac

Discussion  - 
 
I have a 14G db on MYSQL 5.5 server and I am migrating it to mariadb 10.server on different networks... i did get it to export but I can not get it to import ...another problem is this is a dev prod setup and I need to be able to update prod when needed ... wow any advice 
1
Wade Mac's profile photoChristian Rost's profile photo
6 comments
 
Usually there is no need to have a packet size that high. Try to export with 100M and see if it works.
Would be interesting to know what exactly you tried. This way it is quite hard to help out.
Add a comment...

Severalnines

Discussion  - 
 
We've been spinning up the 9s for Percona Live in Amsterdam next week! Looking forward to seeing you all there! http://severalnines.com/blog/plenty-9s-percona-live-europe-next-week
Home > Blog > Plenty of 9s for highly available MySQL, MariaDB, MongoDB & Postgres databases at Percona Live Europe next week. Plenty of 9s for highly available MySQL, MariaDB, MongoDB & Postgres databases at Percona Live Europe next week. Written by Severalnines on September 17, 2015 ...
1
Add a comment...

Csaba Kissi

Discussion  - 
 
You may experience issues running tuning-primer on MariaDB. This little trick can help.
2
1
Add a comment...

Severalnines

Discussion  - 
 
Deploy Asynchronous Replication Slave to MariaDB Galera Cluster 10.x using ClusterControl
Combining Galera and asynchronous replication in the same MariaDB setup, aka Hybrid Replication, can be useful - e.g. as a live backup node in a remote datacenter or reporting/analytics server. We already blogged about this setup for Codership/Galera or Percona XtraDB Cluster users, ...
3
2
Add a comment...

Created by

About this community

A community for users and developers of MariaDB.
 
Hi Friends,

Any of you know any tool that allows me to obfuscate my code functions and / or stored procedures y MariaDB/MySQL ? :(
1
Néstor Vicente Dávila Muñoz's profile photoArman Khalatyan's profile photo
4 comments
 
Mysql/mariadb UDFs is your key word.
Just have a look at mysqludf.org - UDF Repository for MySQL
Add a comment...
 
Hello someone could tell me how the connection between MariaDB and java is done is I have to do a project but have not been able to find as the connection is made. I'm using HeidiSQL and netbeans.
please help.
1
Kurt von Finck's profile photo
Add a comment...

Severalnines

Discussion  - 
 
Become a ClusterControl DBA: Safeguarding your Data - for MySQL, MongoDB & PostgreSQL! http://severalnines.com/blog/become-clustercontrol-dba-safeguarding-your-data
In the past four posts of the blog series, we covered deployment of clustering/replication (MySQL/Galera, MySQL Replication, MongoDB & PostgreSQL), management & monitoring of your existing databases and clusters, performance monitoring and health and in the last post, how to make your setup ...
1
1
Add a comment...

Severalnines

Discussion  - 
 
Become a ClusterControl DBA: Making your database components HA via load balancers! http://severalnines.com/blog/become-clustercontrol-dba-making-your-db-components-ha-load-balancers #haproxy #mariadb #mysql
Choosing your HA topology. There are various ways to retain high availability with databases. You can use Virtual IPs (VRRP) to manage host availability, you can use resource managers like Zookeeper and Etcd to (re)configure your applications or use load balancers/proxies to distribute the ...
2
Add a comment...

Severalnines

Discussion  - 
 
nginx as Database Load Balancer for MySQL or MariaDB Galera Cluster - in this blog post, we're playing around with nginx as a reverse-proxy for MySQL Galera Cluster services to achieve higher availability. Read more here: http://severalnines.com/blog/nginx-database-load-balancer-mysql-or-mariadb-galera-cluster
Nginx is well-known for its ability to act as a reverse-proxy with small memory footprint. It usually sits in the front-end web tier to redirect connections to available backend services, provided these passed some health checks. Using a reverse-proxy is common when you are running a critical ...
4
3
Add a comment...

Jimmy Pannier

Discussion  - 
 
I develop an application that use jta transaction (JAVA TRANSACTION API) and which is using multiple resources (databases). So i've set xa-datasources in my wildfly environnement.

The problem is that i need a clustered database (f.e :Mariadb + galera, mysql+ mysqlcluster).

BUT GALERA HAS A LIMITATION and doesn't work with xa transaction https://mariadb.com/kb/en/mariadb/mariadb-galera-cluster-known-limitations/

AND mysqlcluster but it doesn't work either because xa-transactions work only with INNODB storage engine, but mysqlcluster use NDBCluster engine. --> http://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html

Have you a database cluster environnement to recommend and that works with xa-transaction ?
Known limitations with MariaDB Galera Cluster
1
1
Add a comment...
 
+MariaDB is ready for deployment on +Cloudways Application hosting Platform.

In the beginning of this year, our CTO, +Pere Hospital committed to our customers and the blog readers that we are going to work on MariaDB and bring it on the Cloudways application hosting and management platform as MariaDB is the way forward.

So, here we are announcing the MariaDB deployment on Cloudways. Now anyone can easily use MariaDB with us. 

I am here in the official group as we are seeking feedback. Would love to hear you all whether its critique or praise. 

Cheers :)
Cloud hosting provider Cloudways expands its managed cloud hosting services by adding MariaDB as a database option.
5
Colin Charles's profile photo
 
welcome to the fold!
Add a comment...

Baron Schwartz

Discussion  - 
 
Free webinar Thursday - find out 5 ways to reduce your database TCO. https://vividcortex.com/resources/webinars/reduce-infrastructure-costs/
On July 9, Baron Schwartz will discuss how to evaluate your current efficiency and ways to reduce infrastructure costs.
1
Add a comment...