MySQL MariaDB version 10.0.10 Installation
I needed to test the new SkySQL server audit plug-in 1.1.7 on latest MariaDB 10.0.10 More info about that handy plug in you may find here : http://www.skysql.com/downloads/mariadb-audit-plugin Take a moment to read the info, along with that nice…
How to connect Python programs to MariaDB
You can use the popular programming language Python to manage data stored in MariaDB. Here is everything you need to know about connecting to MariaDB from Python for retrieving, updating, and inserting information. Preparation and installation If you don’t…
Replace Oracle RAC with MariaDB Galera Cluster?
If you want to avoid downtimes in your business, High Availabilty (HA) is a strong requirement which, by definition, makes it possible to access your data all the time without losing (any) data. In this blog we compare two alternatives: Oracle RAC and MariaDB…
[MariaDB]: Managing MariaDB with Puppet
Puppet is a powerful automation tool that helps administrators manage complex server setups centrally. You can use Puppet to manage MariaDB — let’s see how. With Puppet, you describe system states that you want the Puppet master server [to enforce]…
![[MariaDB]: e-books from Packt just for $5](http://dbversity.com/wp-content/uploads/2014/12/p-150x150.png)
[MariaDB]: e-books from Packt just for $5
All MariaDB ebooks from Packt are on sale for $5 each from now until 6 Jan. https://www.packtpub.com/all/?search=mariadb #packt5dollar
[ RDBMS to MongoDB ] Best practices for Migration
Relational databases are being pushed beyond their limits because of the way we build and run applications today, coupled with growth in data sources and user loads. To address these challenges, many companies, such as MTV and Cisco have migrated…
Amazon RDS for AuroraDB
Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora provides up to five times better performance than MySQL at a…
![[MariaDB]: Overview & Installation](http://dbversity.com/wp-content/uploads/2014/12/mariadb_enterprise_architecture_MySQL_Friendly_v5-150x150.png)
[MariaDB]: Overview & Installation
MariaDB is a drop-in replacement for MySQL. MariaDB strives to be the logical choice for database professionals looking for a robust, scalable, and reliable SQL server. To accomplish this, the MariaDB Foundation work closely and cooperatively with the larger community…
[MySQL]: Load data infile
[root@dbversity tmp]# ll -lhtr CSV_* -rw-r–r– 1 oracle dba 298K Nov 26 02:39 CSV_DBV_HLDNGS.csv -rw-r–r– 1 oracle dba 489K Nov 26 02:40 CSV_DBV_DATA.csv -rw-r–r– 1 oracle dba 86K Nov 26 02:40 CSV_PS_RELN_BSNL.csv [root@dbversity tmp]# [root@dbversity tmp]# dos2unix CSV_* dos2unix: converting…
SQL Converter
Database and SQL Migration Tools : ========================= This site really worked for me and it can convert a bunch of different DDL commands from Oracle, MySql, MS-SQL Server, Sybase and others. http://www.sqlines.com/online SQLines provides database migration tools: Database Schema (DDL) Conversion…