Change MariaDB for PostgreSQL

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Change MariaDB for PostgreSQL

Postby macaruchi » Thu Nov 17, 2016 12:55 pm

Hi!
I am newbie using Vicidial and it is so cool but a question that I always have had is why dont change to Postgres?
I know maybe will be a huge work change the whole schema to another DB but really I think to use PG will be better. I am thinking to do this job, maybe just as exercise because I dont know , the integration level but will be interesting .

I have a few problems with lock table in MariaDB using MyISAM

Nobody has thought about this ?
*------------------
ViciBox 11 | Version:2.14b | SVN Version: 3764| DB Schema Version:1697| BUILD: 230927-0857 | 2 Processors 8 Core | 32 GB Ram | 1 Tera HD
macaruchi
 
Posts: 138
Joined: Wed Sep 21, 2016 8:11 pm

Re: Change MariaDB for PostgreSQL

Postby mflorell » Thu Nov 17, 2016 2:36 pm

Yes, it has been thought about, but Vicidial is a real-time application, not transaction-based like most other applications, which is why we use the MyISAM engine. PostgreSQL is not a viable alternative for the way VICIdial is built. If you properly configure MariaDB on proper hardware, you can have very large VICIdial call centers handling millions of calls per day across hundreds of agents on dozens of servers with no problems.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 104 guests