Mivasql or MySql?

[Indigo Lagoon]

We have mivasql 5.03 on Apache.
I am considering migrating to MySql mainly because I have some experience with it and for future projects.

Which do you feel is best suited for a Miva 5 site running 1,200 to 6,000 products?

How difficult would it be to change from Mivasql to MySql? Is it too late? I am not a unix whiz but I can do most basic operations.

Thank you for your thoughts & opinions.

Ross

[Vic - WolfPaw Computers]

Once you chose the database platform, you cannot switch to another. You'd have to create a new store.

One of the biggest assets of MM5 is its ability to utilize a MySQL backend. If given the choice - MySQL all the way. Definately faster and easier to work with than mivaSQL and the antiquated text dbf files.

[Indigo Lagoon]

Once you chose the database platform, you cannot switch to another. You'd have to create a new store.

One of the biggest assets of MM5 is its ability to utilize a MySQL backend. If given the choice - MySQL all the way. Definately faster and easier to work with than mivaSQL and the antiquated text dbf files.
Thanks Vic. I feel the same about MySql but unfortunately I was not part of the initial setup. Now I wear all the hats. The site is not complete so I may scratch it and go with a new store.

I appreciate your reply.
Ross

[Vic - WolfPaw Computers]

You can probably salvage some things, like product and category data by exporting it.

But you would have to redesign or re-code all the look and feel parts.

Store lots of notepad files :)

[Indigo Lagoon]

...Store lots of notepad files :)
Yeah, I'd also have to change the office decor to Modern Post-It-Notes :D

Still, I'll seriously consider it. I'm not a big fan of text dbf.
Thanks again.

[mvmarkus]

Hi Ross,

I can only double Vic's recommandation. Forget MivaSQL and go straight to MySQL, even if it means that you have to do lots of things again. It runs like a breeze, is much more robust, scalable, easier to administer, less buggy and certainly faster as well, especially on things like searches (table scans).

Markus

[Indigo Lagoon]

Thanks for your thoughts, Markus.
I first looked closely at mivasql when trying to upgrade from v5.03 to v5.04 with no success.
If I decide to do it I'm sure y'all will be seeing a lot of threads from me. :(

Regards,
Ross

[Vic - WolfPaw Computers]

mivasql has some performance issues with the new v5.04 VM.

While it did fix some bugs, it seems to be slower with mivasql stores.

[Indigo Lagoon]

mivasql has some performance issues with the new v5.04 VM.

While it did fix some bugs, it seems to be slower with mivasql stores.
I installed the 5.04 download from Miva about 2 weeks ago but it wouldn't do right for some reason. 5.03 went in clean when it was released but 5.04 claimed it was still 5.03 so I backed out and left it alone. I'll stay with 5.03 unless I decide to not go to MySql.

Is there a specific version number of MySql that will not work with Miva 5? I'm not sure what version we have but I'll find out later today or tomorrow.

Ross

[Vic - WolfPaw Computers]

MIVA Empresa 5.x requires MySQL v4.1.1 or later to run the MySQL backend.



I installed the 5.04 download from Miva about 2 weeks ago but it wouldn't do right for some reason. 5.03 went in clean when it was released but 5.04 claimed it was still 5.03 so I backed out and left it alone. I'll stay with 5.03 unless I decide to not go to MySql.

Is there a specific version number of MySql that will not work with Miva 5? I'm not sure what version we have but I'll find out later today or tomorrow.

Ross

[PicturesqueWeb]

I'm converting a store from Mivasql to MySql. A lot of work had been done so I downloaded the html and data folders and got it running locally using MivaMia. Then MM5 was nuked and a fresh install using MySql was placed on the server. Using my MivaMia version, I can now copy/paste and export/import to my heart's content. I wish there was an easy way to just move everything, but this works for now.

[Vic - WolfPaw Computers]

Unfortunately, it simply isnt practicle.

This is why it is very important to choose the backend platform wisely, based on your needs. Its just not easy at all to change database formats.

[Indigo Lagoon]

MIVA Empresa 5.x requires MySQL v4.1.1 or later to run the MySQL backend.
Bummer :(
I found out from my host we have MySql v3.23.56 - 1.7.1
By the time I am ready to migrate to MySql it should be v4.
Yes, the task will be horrendous but looking at the big picture I believe it is the way to go for the future. We have 3 domains with only 1 using Miva at the moment.

You have been a great help, Vic. Thanks again.

If it was easy, it wouldn't be fun!
Ross

[chucklasker]

So, when a new client hands over a partially complete MM5 store, how do I tell if it was set up with MivaSQL or MySQL? A previous developer set it up, and the owner doesn't know what he did.

[Indigo Lagoon]

doubleplus,

At the top of the main screen in your Miva Admin is
Database API:
It will state either mivasql or mysql as API type.

[chucklasker]

doubleplus,

At the top of the main screen in your Miva Admin is
Database API:
It will state either mivasql or mysql as API type.

Well there it is right in front of my face!! Thanks.

[Eric]

I concur with Vic 5.04 empressa has a performance degradation using MivaSQL. All Miva 5 stores should use MySQL for the backend for speed and scalability.

Especially since their is no way to migrate the UI settings from MivaSQL to MySQL if you want to change the backend from one to another.

Save yourself the heartache and use MySQL from the get go. :)

Eric